1: PACKAGE BODY pay_se_income_statement AS
2: /* $Header: pyseinsr.pkb 120.8 2010/10/28 08:57:20 vijranga ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
13: g_index NUMBER := -1;
14: g_index_assact NUMBER := -1;
15: g_index_bal NUMBER := -1;
16: g_package VARCHAR2 (100)
17: := 'PAY_SE_INCOME_STATEMENT.';
18: g_payroll_action_id NUMBER;
19: g_arc_payroll_action_id NUMBER;
20: -- Globals to pick up all the parameter
21: g_business_group_id NUMBER;
116: )
117: IS
118: CURSOR csr_parameter_info (p_payroll_action_id NUMBER)
119: IS
120: SELECT (pay_se_income_statement.get_parameter
121: (legislative_parameters
122: ,'INCOME_STATEMENT_PROVIDER'
123: )
124: ) income_statement_provider
121: (legislative_parameters
122: ,'INCOME_STATEMENT_PROVIDER'
123: )
124: ) income_statement_provider
125: , (pay_se_income_statement.get_parameter
126: (legislative_parameters
127: ,'REQUEST_FOR'
128: )
129: ) request_for
126: (legislative_parameters
127: ,'REQUEST_FOR'
128: )
129: ) request_for
130: , (pay_se_income_statement.get_parameter
131: (legislative_parameters
132: ,'LEGAL_EMPLOYER'
133: )
134: ) legal_employer
131: (legislative_parameters
132: ,'LEGAL_EMPLOYER'
133: )
134: ) legal_employer
135: , (pay_se_income_statement.get_parameter
136: (legislative_parameters
137: ,'INCOME_YEAR'
138: )
139: ) income_year
136: (legislative_parameters
137: ,'INCOME_YEAR'
138: )
139: ) income_year
140: , (pay_se_income_statement.get_parameter
141: (legislative_parameters
142: ,'PERSON_REQUEST'
143: )
144: ) person_for
141: (legislative_parameters
142: ,'PERSON_REQUEST'
143: )
144: ) person_for
145: , (pay_se_income_statement.get_parameter
146: (legislative_parameters
147: ,'REQUESTING_PERSON'
148: )
149: ) person_number
146: (legislative_parameters
147: ,'REQUESTING_PERSON'
148: )
149: ) person_number
150: , (pay_se_income_statement.get_parameter
151: (legislative_parameters
152: ,'TEST_PRODUCTION'
153: )
154: ) test_production
151: (legislative_parameters
152: ,'TEST_PRODUCTION'
153: )
154: ) test_production
155: , (pay_se_income_statement.get_parameter
156: (legislative_parameters
157: ,'SORT_ORDER'
158: )
159: ) sort_order
441: g_local_unit_id := NULL;
442: g_income_year := NULL;
443: g_person_for := NULL;
444: g_person_number := NULL;
445: pay_se_income_statement.get_all_parameters
446: (p_payroll_action_id
447: ,g_business_group_id
448: ,g_effective_date
449: ,g_income_statement_provider_id
1107:
1108:
1109: --logger ('ASSIGNMENT_ACTION_CODE ', '--------------------------------- Started');
1110:
1111: pay_se_income_statement.get_all_parameters (p_payroll_action_id
1112: , g_business_group_id
1113: , g_effective_date
1114: , g_income_statement_provider_id
1115: , g_request_for
1506: g_payroll_action_id := p_payroll_action_id;
1507: g_business_group_id := NULL;
1508: g_effective_date := NULL;
1509: g_legal_employer_id := NULL;
1510: pay_se_income_statement.get_all_parameters
1511: (p_payroll_action_id
1512: ,g_business_group_id
1513: ,g_effective_date
1514: ,g_income_statement_provider_id
5419: return l_country_name;
5420: END get_country;
5421: /* End of Proc to Add the tag value and Name */
5422: -- *****************************************************************************
5423: END pay_se_income_statement;