eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_PAYREG_PKG dependencies on PAY_PAYRG_PKG

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

77: WHERE ppa.payroll_action_id = pactid;
78:
79: hr_utility.set_location(l_proc_name,10);
80: SELECT ppa.legislative_parameters,
81: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
82: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
83: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
84: ppa.start_date,
85: ppa.effective_date,

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

78:
79: hr_utility.set_location(l_proc_name,10);
80: SELECT ppa.legislative_parameters,
81: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
82: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
83: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
84: ppa.start_date,
85: ppa.effective_date,
86: ppa.business_group_id

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

79: hr_utility.set_location(l_proc_name,10);
80: SELECT ppa.legislative_parameters,
81: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
82: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
83: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
84: ppa.start_date,
85: ppa.effective_date,
86: ppa.business_group_id
87: INTO leg_param,

Line 159: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id

155: IS
156:
157: CURSOR c_inputs(pactid NUMBER)
158: IS
159: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id
160: ,pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id
161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id

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

156:
157: CURSOR c_inputs(pactid NUMBER)
158: IS
159: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id
160: ,pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id
161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id
164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id

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

157: CURSOR c_inputs(pactid NUMBER)
158: IS
159: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id
160: ,pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id
161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id
164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id
165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id

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

158: IS
159: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id
160: ,pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id
161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id
164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id
165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id
166: ,ppa.start_date start_date

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

159: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id
160: ,pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id
161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id
164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id
165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id
166: ,ppa.start_date start_date
167: ,ppa.effective_date effective_date

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

160: ,pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id
161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id
164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id
165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id
166: ,ppa.start_date start_date
167: ,ppa.effective_date effective_date
168: FROM pay_payroll_actions ppa

Line 165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id

161: ,pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id
162: ,pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id
163: ,pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id
164: ,pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id
165: ,pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id
166: ,ppa.start_date start_date
167: ,ppa.effective_date effective_date
168: FROM pay_payroll_actions ppa
169: WHERE ppa.payroll_action_id = pactid;

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

553:
554: END IF;
555:
556: hr_utility.set_location(l_proc_name,25);
557: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
558: num := 0;
559:
560: LOOP
561: hr_utility.set_location(l_proc_name,30);

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

866: ---------------------------------- generate_xml ---------------------------------
867: PROCEDURE generate_xml IS
868:
869: CURSOR c_inputs(pactid number) is
870: SELECT pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
871: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
872: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
873: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id
874: FROM pay_payroll_actions ppa

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

867: PROCEDURE generate_xml IS
868:
869: CURSOR c_inputs(pactid number) is
870: SELECT pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
871: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
872: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
873: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id
874: FROM pay_payroll_actions ppa
875: WHERE ppa.payroll_action_id = pactid;

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

868:
869: CURSOR c_inputs(pactid number) is
870: SELECT pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
871: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
872: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
873: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id
874: FROM pay_payroll_actions ppa
875: WHERE ppa.payroll_action_id = pactid;
876:

Line 873: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id

869: CURSOR c_inputs(pactid number) is
870: SELECT pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
871: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
872: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
873: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id
874: FROM pay_payroll_actions ppa
875: WHERE ppa.payroll_action_id = pactid;
876:
877: CURSOR c_get_balance_dimensions (dimtype varchar2)is

Line 1195: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,

1191: ---------------------------------- generate_xml_header -------------------------------
1192: PROCEDURE generate_xml_header AS
1193:
1194: CURSOR c_inputs(pactid NUMBER) IS
1195: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
1196: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,

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

1192: PROCEDURE generate_xml_header AS
1193:
1194: CURSOR c_inputs(pactid NUMBER) IS
1195: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
1196: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,

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

1193:
1194: CURSOR c_inputs(pactid NUMBER) IS
1195: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
1196: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,

Line 1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,

1194: CURSOR c_inputs(pactid NUMBER) IS
1195: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
1196: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,
1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,

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

1195: SELECT pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
1196: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,
1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,
1203: ppa.start_date start_date,

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

1196: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,
1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,
1203: ppa.start_date start_date,
1204: ppa.effective_date effective_date

Line 1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,

1197: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,
1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,
1203: ppa.start_date start_date,
1204: ppa.effective_date effective_date
1205: FROM pay_payroll_actions ppa

Line 1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,

1198: pay_payrg_pkg.get_parameter('L_E_ID',ppa.legislative_parameters) legal_employer_id,
1199: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
1200: pay_payrg_pkg.get_parameter('PASID',ppa.legislative_parameters) assignment_set_id,
1201: pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters) sort1,
1202: pay_payrg_pkg.get_parameter('RP_DM',ppa.legislative_parameters) dimension_id,
1203: ppa.start_date start_date,
1204: ppa.effective_date effective_date
1205: FROM pay_payroll_actions ppa
1206: WHERE ppa.payroll_action_id = pactid;

Line 1527: SELECT pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters)

1523:
1524: BEGIN
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.sort_action ');
1526: hr_utility.set_location ('Entering'||l_proc_name ,10);
1527: SELECT pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters)
1528: INTO l_sort_1
1529: FROM pay_payroll_actions ppa
1530: WHERE ppa.payroll_action_id = payactid;
1531: --Modified the sort query for sorting by employee name and payroll name