DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on PAY_SE_ARCHIVE_CWCA

Line 1: PACKAGE BODY PAY_SE_ARCHIVE_CWCA AS

1: PACKAGE BODY PAY_SE_ARCHIVE_CWCA AS
2: /* $Header: pysecwca.pkb 120.0.12010000.2 2008/08/06 08:17:14 ubhat ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: g_index NUMBER := -1;

Line 8: g_package VARCHAR2 (240) := 'PAY_SE_ARCHIVE_CWCA.';

4:
5: g_index NUMBER := -1;
6: g_index_assact NUMBER := -1;
7: g_index_bal NUMBER := -1;
8: g_package VARCHAR2 (240) := 'PAY_SE_ARCHIVE_CWCA.';
9: g_payroll_action_id NUMBER;
10: g_arc_payroll_action_id NUMBER;
11:
12: -- Globals to pick up all th parameter

Line 105: SELECT (PAY_SE_ARCHIVE_CWCA.get_parameter

101: )
102: IS
103: CURSOR csr_parameter_info (p_payroll_action_id NUMBER)
104: IS
105: SELECT (PAY_SE_ARCHIVE_CWCA.get_parameter
106: (legislative_parameters
107: ,'PERSON_ID'
108: )
109: ) person_id

Line 110: , (PAY_SE_ARCHIVE_CWCA.get_parameter

106: (legislative_parameters
107: ,'PERSON_ID'
108: )
109: ) person_id
110: , (PAY_SE_ARCHIVE_CWCA.get_parameter
111: (legislative_parameters
112: ,'ASSIGNMENT_ID'
113: )
114: ) assignment_id

Line 115: , (PAY_SE_ARCHIVE_CWCA.get_parameter

111: (legislative_parameters
112: ,'ASSIGNMENT_ID'
113: )
114: ) assignment_id
115: , (PAY_SE_ARCHIVE_CWCA.get_parameter
116: (legislative_parameters
117: ,'STILL_EMPLOYED'
118: )
119: ) still_employed

Line 120: , (PAY_SE_ARCHIVE_CWCA.get_parameter

116: (legislative_parameters
117: ,'STILL_EMPLOYED'
118: )
119: ) still_employed
120: , (PAY_SE_ARCHIVE_CWCA.get_parameter
121: (legislative_parameters
122: ,'REPORT_YEAR'
123: )
124: ) report_year

Line 125: , (PAY_SE_ARCHIVE_CWCA.get_parameter

121: (legislative_parameters
122: ,'REPORT_YEAR'
123: )
124: ) report_year
125: , (PAY_SE_ARCHIVE_CWCA.get_parameter
126: (legislative_parameters
127: ,'REPORT_MONTH'
128: )
129: ) report_month

Line 462: PAY_SE_ARCHIVE_CWCA.get_all_parameters (p_payroll_action_id

458: g_effective_date := NULL;
459: g_person_id := NULL;
460: g_assignment_id := NULL;
461:
462: PAY_SE_ARCHIVE_CWCA.get_all_parameters (p_payroll_action_id
463: ,g_business_group_id
464: ,g_effective_date
465: ,g_person_id
466: ,g_assignment_id

Line 1260: END PAY_SE_ARCHIVE_CWCA;

1256: END if;
1257: RAISE;
1258: END;
1259:
1260: END PAY_SE_ARCHIVE_CWCA;