SQL-047: Pk82029 titan delete employee leave

This document describes SQL-047, the pk82029 titan delete employee leave statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-047
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsEmployeeLeave
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
:employee_leave_SEQ_NUM_in	Input	Decimal	N/A	Employee leave delete key

Tables

Table	Access	Columns used
EMPLOYEE_LEAVE	DELETE	See sample SQL and source implementation.

Sample SQL

pk82029_titan.delete_employee_leave(:employee_leave_SEQ_NUM_in)

Operations and processes

• Employee leave persistence

Business rules

• BR-SB-014: Employee leave deletes expect single-row success

Sources

• Business\SAIF.Business\clsEmployeeLeave.vb