APPS.PAY_PAYRG_PKG dependencies on PAY_PAYRG_PKG

Line 1: PACKAGE BODY pay_payrg_pkg AS

1: PACKAGE BODY pay_payrg_pkg AS
2: /* $Header: pypayreg.pkb 120.3 2007/07/05 05:33:27 vmkulkar noship $ */
3: /*
4: ******************************************************************
5: * *

Line 134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),

130: from pay_payroll_actions ppa
131: where ppa.payroll_action_id = pactid;
132:
133: select ppa.legislative_parameters,
134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
135: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
136: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
137: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
138: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),

Line 135: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),

131: where ppa.payroll_action_id = pactid;
132:
133: select ppa.legislative_parameters,
134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
135: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
136: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
137: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
138: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
139: ppa.start_date,

Line 136: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),

132:
133: select ppa.legislative_parameters,
134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
135: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
136: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
137: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
138: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
139: ppa.start_date,
140: ppa.effective_date,

Line 137: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),

133: select ppa.legislative_parameters,
134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
135: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
136: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
137: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
138: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
139: ppa.start_date,
140: ppa.effective_date,
141: ppa.business_group_id

Line 138: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),

134: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
135: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
136: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
137: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
138: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
139: ppa.start_date,
140: ppa.effective_date,
141: ppa.business_group_id
142: into leg_param,

Line 226: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,

222: chunk in number)
223: IS
224:
225: cursor c_inputs(pactid number) is -- Bug 3372747
226: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,

Line 227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,

223: IS
224:
225: cursor c_inputs(pactid number) is -- Bug 3372747
226: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,

Line 228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,

224:
225: cursor c_inputs(pactid number) is -- Bug 3372747
226: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,

Line 229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,

225: cursor c_inputs(pactid number) is -- Bug 3372747
226: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,

Line 230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,

226: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
234: ppa.start_date start_date,

Line 231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,

227: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
234: ppa.start_date start_date,
235: ppa.effective_date effective_date

Line 232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,

228: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
234: ppa.start_date start_date,
235: ppa.effective_date effective_date
236: from pay_payroll_actions ppa

Line 233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,

229: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
230: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
231: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
232: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
233: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
234: ppa.start_date start_date,
235: ppa.effective_date effective_date
236: from pay_payroll_actions ppa
237: where ppa.payroll_action_id = pactid;

Line 639: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);

635: end if;
636:
637:
638:
639: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
640:
641: num := 0;
642: loop
643: hr_utility.set_location('procpyr',2);

Line 1280: select pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters),

1276:
1277:
1278: BEGIN
1279:
1280: select pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters),
1281: pay_payrg_pkg.get_parameter('P_S2', ppa.legislative_parameters),
1282: pay_payrg_pkg.get_parameter('P_S3', ppa.legislative_parameters)
1283: into l_sort_1,
1284: l_sort_2,

Line 1281: pay_payrg_pkg.get_parameter('P_S2', ppa.legislative_parameters),

1277:
1278: BEGIN
1279:
1280: select pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters),
1281: pay_payrg_pkg.get_parameter('P_S2', ppa.legislative_parameters),
1282: pay_payrg_pkg.get_parameter('P_S3', ppa.legislative_parameters)
1283: into l_sort_1,
1284: l_sort_2,
1285: l_sort_3

Line 1282: pay_payrg_pkg.get_parameter('P_S3', ppa.legislative_parameters)

1278: BEGIN
1279:
1280: select pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters),
1281: pay_payrg_pkg.get_parameter('P_S2', ppa.legislative_parameters),
1282: pay_payrg_pkg.get_parameter('P_S3', ppa.legislative_parameters)
1283: into l_sort_1,
1284: l_sort_2,
1285: l_sort_3
1286: from pay_payroll_actions ppa

Line 1299: pay_payrg_pkg.sort_option (

1295: and paa.payroll_action_id = ppa.payroll_action_id
1296: order by
1297: (decode('''||l_sort_1||''',
1298: null, null,
1299: pay_payrg_pkg.sort_option (
1300: '''||l_sort_1||''',
1301: paa.assignment_id,
1302: ppa.effective_date,
1303: paa.tax_unit_id))),

Line 1306: pay_payrg_pkg.sort_option (

1302: ppa.effective_date,
1303: paa.tax_unit_id))),
1304: (decode('''||l_sort_2||''',
1305: null, null,
1306: pay_payrg_pkg.sort_option (
1307: '''||l_sort_2||''',
1308: paa.assignment_id,
1309: ppa.effective_date,
1310: paa.tax_unit_id))),

Line 1313: pay_payrg_pkg.sort_option (

1309: ppa.effective_date,
1310: paa.tax_unit_id))),
1311: (decode('''||l_sort_3||''',
1312: null, null,
1313: pay_payrg_pkg.sort_option (
1314: '''||l_sort_3||''',
1315: paa.assignment_id,
1316: ppa.effective_date,
1317: paa.tax_unit_id))),

Line 1430: end pay_payrg_pkg;

1426:
1427: END sort_option;
1428:
1429:
1430: end pay_payrg_pkg;