DBA Data[Home] [Help]

APPS.PAY_SE_EMPLOYMENT_STATISTICS dependencies on PAY_SE_EMPLOYMENT_STATISTICS

Line 1: PACKAGE BODY PAY_SE_EMPLOYMENT_STATISTICS AS

1: PACKAGE BODY PAY_SE_EMPLOYMENT_STATISTICS AS
2: /* $Header: pysestsr.pkb 120.0.12000000.1 2007/04/20 09:27:37 abhgangu noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (

Line 16: g_package VARCHAR2 (33) := 'PAY_SE_EMPLOYMENT_STATISTICS.';

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 (33) := 'PAY_SE_EMPLOYMENT_STATISTICS.';
17: g_payroll_action_id NUMBER;
18: g_arc_payroll_action_id NUMBER;
19: -- Globals to pick up all the parameter
20: g_business_group_id NUMBER;

Line 121: SELECT (PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

117: )
118: IS
119: CURSOR csr_parameter_info (p_payroll_action_id NUMBER)
120: IS
121: SELECT (PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
122: (legislative_parameters
123: , 'LE_REQUEST'
124: )
125: ) LE_REQUEST

Line 126: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

122: (legislative_parameters
123: , 'LE_REQUEST'
124: )
125: ) LE_REQUEST
126: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
127: (legislative_parameters
128: , 'LEGAL_EMPLOYER_ID'
129: )
130: ) LEGAL_EMPLOYER_ID

Line 131: , (PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

127: (legislative_parameters
128: , 'LEGAL_EMPLOYER_ID'
129: )
130: ) LEGAL_EMPLOYER_ID
131: , (PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
132: (legislative_parameters
133: , 'LU_REQUEST'
134: )
135: ) LU_REQUEST

Line 136: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

132: (legislative_parameters
133: , 'LU_REQUEST'
134: )
135: ) LU_REQUEST
136: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
137: (legislative_parameters
138: , 'LOCAL_UNIT_ID'
139: )
140: ) LOCAL_UNIT_ID

Line 141: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

137: (legislative_parameters
138: , 'LOCAL_UNIT_ID'
139: )
140: ) LOCAL_UNIT_ID
141: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
142: (legislative_parameters
143: , 'ACCOUNT_DATE'
144: )
145: ) ACCOUNT_DATE

Line 146: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

142: (legislative_parameters
143: , 'ACCOUNT_DATE'
144: )
145: ) ACCOUNT_DATE
146: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
147: (legislative_parameters
148: , 'POSTING_DATE'
149: )
150: ) POSTING_DATE

Line 151: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter

147: (legislative_parameters
148: , 'POSTING_DATE'
149: )
150: ) POSTING_DATE
151: ,(PAY_SE_EMPLOYMENT_STATISTICS.get_parameter
152: (legislative_parameters
153: , 'REPORTING_DATE'
154: )
155: )REPORTING_DATE

Line 579: PAY_SE_EMPLOYMENT_STATISTICS.get_all_parameters (p_payroll_action_id

575: g_legal_employer_id := NULL;
576: g_local_unit_id := NULL;
577: g_account_date :=null;
578: g_posting_date :=null;
579: PAY_SE_EMPLOYMENT_STATISTICS.get_all_parameters (p_payroll_action_id
580: , g_business_group_id
581: , g_effective_date
582: , g_legal_employer_id
583: , g_LE_request

Line 1708: PAY_SE_EMPLOYMENT_STATISTICS.get_all_parameters (p_payroll_action_id

1704: g_legal_employer_id := NULL;
1705: g_local_unit_id := NULL;
1706: g_account_date :=null;
1707: g_posting_date :=null;
1708: PAY_SE_EMPLOYMENT_STATISTICS.get_all_parameters (p_payroll_action_id
1709: , g_business_group_id
1710: , g_effective_date
1711: , g_legal_employer_id
1712: , g_LE_request

Line 2633: END PAY_SE_EMPLOYMENT_STATISTICS;

2629:
2630:
2631: END POPULATE_DATA_DETAIL;
2632:
2633: END PAY_SE_EMPLOYMENT_STATISTICS;
2634: