APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PAY_SE_WORK_TIME_CERTIFICATE

Line 1: PACKAGE BODY pay_se_work_time_certificate AS

1: PACKAGE BODY pay_se_work_time_certificate AS
2: /* $Header: pysewtcr.pkb 120.0.12010000.5 2010/02/02 17:52:58 vijranga ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (

Line 16: g_package VARCHAR2 (240) := 'PAY_SE_WORK_TIME_CERTIFICATE.';

12: g_lock_table lock_table;
13: g_index NUMBER := -1;
14: g_index_assact NUMBER := -1;
15: g_index_bal NUMBER := -1;
16: g_package VARCHAR2 (240) := 'PAY_SE_WORK_TIME_CERTIFICATE.';
17: g_payroll_action_id NUMBER;
18: g_arc_payroll_action_id NUMBER;
19:
20: -- TYPE Month_value IS TABLE OF NUMBER INDEX BY VARCHAR2(64);

Line 127: SELECT (pay_se_work_time_certificate.get_parameter

123: )
124: IS
125: CURSOR csr_parameter_info (p_payroll_action_id NUMBER)
126: IS
127: SELECT (pay_se_work_time_certificate.get_parameter
128: (legislative_parameters
129: ,'PERSON_ID'
130: )
131: ) person_id

Line 132: , (pay_se_work_time_certificate.get_parameter

128: (legislative_parameters
129: ,'PERSON_ID'
130: )
131: ) person_id
132: , (pay_se_work_time_certificate.get_parameter
133: (legislative_parameters
134: ,'ASSIGNMENT_ID'
135: )
136: ) assignment_id

Line 137: , (pay_se_work_time_certificate.get_parameter

133: (legislative_parameters
134: ,'ASSIGNMENT_ID'
135: )
136: ) assignment_id
137: , (pay_se_work_time_certificate.get_parameter
138: (legislative_parameters
139: ,'STILL_EMPLOYED'
140: )
141: ) still_employed

Line 142: , (pay_se_work_time_certificate.get_parameter

138: (legislative_parameters
139: ,'STILL_EMPLOYED'
140: )
141: ) still_employed
142: , (pay_se_work_time_certificate.get_parameter
143: (legislative_parameters
144: ,'SALARY_YEAR'
145: )
146: ) income_salary_year

Line 618: pay_se_work_time_certificate.get_all_parameters (p_payroll_action_id

614: g_business_group_id := NULL;
615: g_effective_date := NULL;
616: g_person_id := NULL;
617: g_assignment_id := NULL;
618: pay_se_work_time_certificate.get_all_parameters (p_payroll_action_id
619: ,g_business_group_id
620: ,g_effective_date
621: ,g_person_id
622: ,g_assignment_id

Line 2339: pay_se_work_time_certificate.get_all_parameters (p_payroll_action_id

2335: g_business_group_id := NULL;
2336: g_effective_date := NULL;
2337: g_person_id := NULL;
2338: g_assignment_id := NULL;
2339: pay_se_work_time_certificate.get_all_parameters (p_payroll_action_id
2340: ,g_business_group_id
2341: ,g_effective_date
2342: ,g_person_id
2343: ,g_assignment_id

Line 4469: END pay_se_work_time_certificate;

4465: );
4466: END logger;
4467: /* End of Proc to Add the tag value and Name */
4468: -- *****************************************************************************
4469: END pay_se_work_time_certificate;