DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on PAY_SE_ALECTA

Line 1: PACKAGE BODY pay_se_alecta AS

1: PACKAGE BODY pay_se_alecta AS
2: /* $Header: pysealer.pkb 120.5 2010/10/28 09:04:28 vijranga ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (

Line 16: g_package VARCHAR2 (100) := 'PAY_SE_ALECTA.';

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 (100) := 'PAY_SE_ALECTA.';
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: (pay_se_alecta.get_parameter (legislative_parameters

117: IS
118: CURSOR csr_parameter_info (p_payroll_action_id NUMBER)
119: IS
120: SELECT TO_NUMBER
121: (pay_se_alecta.get_parameter (legislative_parameters
122: ,'LEGAL_EMPLOYER'
123: )
124: ) legal
125: , (pay_se_alecta.get_parameter (legislative_parameters

Line 125: , (pay_se_alecta.get_parameter (legislative_parameters

121: (pay_se_alecta.get_parameter (legislative_parameters
122: ,'LEGAL_EMPLOYER'
123: )
124: ) legal
125: , (pay_se_alecta.get_parameter (legislative_parameters
126: ,'REQUEST_FOR'
127: )
128: ) request_for
129: , (pay_se_alecta.get_parameter (legislative_parameters, 'YEAR')

Line 129: , (pay_se_alecta.get_parameter (legislative_parameters, 'YEAR')

125: , (pay_se_alecta.get_parameter (legislative_parameters
126: ,'REQUEST_FOR'
127: )
128: ) request_for
129: , (pay_se_alecta.get_parameter (legislative_parameters, 'YEAR')
130: ) report_year
131: , (pay_se_alecta.get_parameter (legislative_parameters
132: ,'MONTH')
133: ) report_month

Line 131: , (pay_se_alecta.get_parameter (legislative_parameters

127: )
128: ) request_for
129: , (pay_se_alecta.get_parameter (legislative_parameters, 'YEAR')
130: ) report_year
131: , (pay_se_alecta.get_parameter (legislative_parameters
132: ,'MONTH')
133: ) report_month
134: , (pay_se_alecta.get_parameter (legislative_parameters
135: ,'SENT_FROM'

Line 134: , (pay_se_alecta.get_parameter (legislative_parameters

130: ) report_year
131: , (pay_se_alecta.get_parameter (legislative_parameters
132: ,'MONTH')
133: ) report_month
134: , (pay_se_alecta.get_parameter (legislative_parameters
135: ,'SENT_FROM'
136: )
137: ) sent_from
138: , (pay_se_alecta.get_parameter (legislative_parameters

Line 138: , (pay_se_alecta.get_parameter (legislative_parameters

134: , (pay_se_alecta.get_parameter (legislative_parameters
135: ,'SENT_FROM'
136: )
137: ) sent_from
138: , (pay_se_alecta.get_parameter (legislative_parameters
139: ,'SENT_TO'
140: )
141: ) sent_to
142: , (pay_se_alecta.get_parameter (legislative_parameters

Line 142: , (pay_se_alecta.get_parameter (legislative_parameters

138: , (pay_se_alecta.get_parameter (legislative_parameters
139: ,'SENT_TO'
140: )
141: ) sent_to
142: , (pay_se_alecta.get_parameter (legislative_parameters
143: ,'PRODUCTION'
144: )
145: ) production
146: ,effective_date effective_date

Line 346: pay_se_alecta.get_all_parameters (p_payroll_action_id

342: g_effective_date := NULL;
343: g_pension_provider_id := NULL;
344: g_legal_employer_id := NULL;
345: g_local_unit_id := NULL;
346: pay_se_alecta.get_all_parameters (p_payroll_action_id
347: ,g_business_group_id
348: ,g_effective_date
349: ,g_legal_employer_id
350: ,g_request_for

Line 567: pay_se_alecta.get_all_parameters (p_payroll_action_id

563: l_archive VARCHAR2 (10);
564: -- End of User pARAMETERS needed
565: BEGIN
566: -- fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');
567: pay_se_alecta.get_all_parameters (p_payroll_action_id
568: ,g_business_group_id
569: ,g_effective_date
570: ,g_legal_employer_id
571: ,g_request_for

Line 766: pay_se_alecta.get_all_parameters (p_payroll_action_id

762: g_payroll_action_id := p_payroll_action_id;
763: g_business_group_id := NULL;
764: g_effective_date := NULL;
765: g_legal_employer_id := NULL;
766: pay_se_alecta.get_all_parameters (p_payroll_action_id
767: ,g_business_group_id
768: ,g_effective_date
769: ,g_legal_employer_id
770: ,g_request_for

Line 3664: END pay_se_alecta;

3660:
3661: END;
3662: --
3663: --
3664: END pay_se_alecta;