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_PAYACT_PKG dependencies on PAY_PAYRG_PKG

Line 98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),

94:
95: -- pay_process := pay_payact_pkg.get_parameter('P_P_TY',leg_param);
96:
97: select ppa.legislative_parameters,
98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
100: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
102: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),

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

95: -- pay_process := pay_payact_pkg.get_parameter('P_P_TY',leg_param);
96:
97: select ppa.legislative_parameters,
98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
100: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
102: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
103: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),

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

96:
97: select ppa.legislative_parameters,
98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
100: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
102: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
103: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
104: ppa.start_date,

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

97: select ppa.legislative_parameters,
98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
100: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
102: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
103: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
104: ppa.start_date,
105: ppa.effective_date,

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

98: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),
99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
100: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
102: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
103: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
104: ppa.start_date,
105: ppa.effective_date,
106: ppa.business_group_id

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

99: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
100: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
101: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),
102: pay_payrg_pkg.get_parameter('L_ID', ppa.legislative_parameters),
103: pay_payrg_pkg.get_parameter('P_ID', ppa.legislative_parameters),
104: ppa.start_date,
105: ppa.effective_date,
106: ppa.business_group_id
107: into leg_param,

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

205: -- Payroll Activity generated Payroll Action
206: -- All the values will be passed to cursors below
207:
208: CURSOR c_inputs(pactid number) is -- Bug 3372732
209: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
210: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,

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

206: -- All the values will be passed to cursors below
207:
208: CURSOR c_inputs(pactid number) is -- Bug 3372732
209: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
210: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,

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

207:
208: CURSOR c_inputs(pactid number) is -- Bug 3372732
209: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
210: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
215: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,

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

208: CURSOR c_inputs(pactid number) is -- Bug 3372732
209: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
210: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
215: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
216: ppa.start_date start_date,

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

209: select pay_payrg_pkg.get_parameter('PY_ID',ppa.legislative_parameters) payroll_id,
210: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
215: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
216: ppa.start_date start_date,
217: ppa.effective_date effective_date

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

210: pay_payrg_pkg.get_parameter('C_ST_ID',ppa.legislative_parameters) consolidation_set_id,
211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
215: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
216: ppa.start_date start_date,
217: ppa.effective_date effective_date
218: from pay_payroll_actions ppa

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

211: pay_payrg_pkg.get_parameter('T_U_ID',ppa.legislative_parameters) tax_unit_id,
212: pay_payrg_pkg.get_parameter('L_ID',ppa.legislative_parameters) location_id,
213: pay_payrg_pkg.get_parameter('O_ID',ppa.legislative_parameters) organization_id,
214: pay_payrg_pkg.get_parameter('P_ID',ppa.legislative_parameters) person_id,
215: pay_payrg_pkg.get_parameter('B_G_ID',ppa.legislative_parameters) business_group_id,
216: ppa.start_date start_date,
217: ppa.effective_date effective_date
218: from pay_payroll_actions ppa
219: where ppa.payroll_action_id = pactid;

Line 1343: IF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BA' then

1339: /* Bug 3037633 : The SQL query string is prepared on the basis of the legislative parameters
1340: string obtained from the cursor 'cur_leg_params'. This string is passed
1341: to the get_parameter function to obtain the actual value. */
1342:
1343: IF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BA' then
1344: sqlstr := sqlstr || ' and ppa1.action_type = ''B'' ';
1345: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BI' then
1346: sqlstr := sqlstr || ' and ppa1.action_type = ''I'' ';
1347: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BAI' then

Line 1345: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BI' then

1341: to the get_parameter function to obtain the actual value. */
1342:
1343: IF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BA' then
1344: sqlstr := sqlstr || ' and ppa1.action_type = ''B'' ';
1345: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BI' then
1346: sqlstr := sqlstr || ' and ppa1.action_type = ''I'' ';
1347: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BAI' then
1348: sqlstr := sqlstr || ' and (ppa1.action_type = ''B'' or ppa1.action_type = ''I'')';
1349: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PR' then

Line 1347: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BAI' then

1343: IF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BA' then
1344: sqlstr := sqlstr || ' and ppa1.action_type = ''B'' ';
1345: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BI' then
1346: sqlstr := sqlstr || ' and ppa1.action_type = ''I'' ';
1347: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BAI' then
1348: sqlstr := sqlstr || ' and (ppa1.action_type = ''B'' or ppa1.action_type = ''I'')';
1349: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PR' then
1350: sqlstr := sqlstr || ' and ppa1.action_type = ''R''';
1351: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then

Line 1349: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PR' then

1345: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BI' then
1346: sqlstr := sqlstr || ' and ppa1.action_type = ''I'' ';
1347: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BAI' then
1348: sqlstr := sqlstr || ' and (ppa1.action_type = ''B'' or ppa1.action_type = ''I'')';
1349: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PR' then
1350: sqlstr := sqlstr || ' and ppa1.action_type = ''R''';
1351: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then
1352: sqlstr := sqlstr || ' and ppa1.action_type = ''Q''';
1353: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then

Line 1351: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then

1347: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'BAI' then
1348: sqlstr := sqlstr || ' and (ppa1.action_type = ''B'' or ppa1.action_type = ''I'')';
1349: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PR' then
1350: sqlstr := sqlstr || ' and ppa1.action_type = ''R''';
1351: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then
1352: sqlstr := sqlstr || ' and ppa1.action_type = ''Q''';
1353: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then
1354: sqlstr := sqlstr || ' and (ppa1.action_type = ''R'' or ppa1.action_type = ''Q'')';
1355: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then

Line 1353: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then

1349: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PR' then
1350: sqlstr := sqlstr || ' and ppa1.action_type = ''R''';
1351: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then
1352: sqlstr := sqlstr || ' and ppa1.action_type = ''Q''';
1353: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then
1354: sqlstr := sqlstr || ' and (ppa1.action_type = ''R'' or ppa1.action_type = ''Q'')';
1355: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then
1356: sqlstr := sqlstr || ' and ppa1.action_type = ''V''';
1357: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'ALL' then

Line 1355: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then

1351: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then
1352: sqlstr := sqlstr || ' and ppa1.action_type = ''Q''';
1353: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then
1354: sqlstr := sqlstr || ' and (ppa1.action_type = ''R'' or ppa1.action_type = ''Q'')';
1355: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then
1356: sqlstr := sqlstr || ' and ppa1.action_type = ''V''';
1357: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'ALL' then
1358: sqlstr := sqlstr || ' and (ppa1.action_type = ''B'' or ppa1.action_type = ''D'' or ppa1.action_type = ''I'' or ppa1.action_type = ''Q'' or ppa1.action_type = ''R'' or ppa1.action_type = ''V'')';
1359: END IF;

Line 1357: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'ALL' then

1353: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then
1354: sqlstr := sqlstr || ' and (ppa1.action_type = ''R'' or ppa1.action_type = ''Q'')';
1355: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then
1356: sqlstr := sqlstr || ' and ppa1.action_type = ''V''';
1357: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'ALL' then
1358: sqlstr := sqlstr || ' and (ppa1.action_type = ''B'' or ppa1.action_type = ''D'' or ppa1.action_type = ''I'' or ppa1.action_type = ''Q'' or ppa1.action_type = ''R'' or ppa1.action_type = ''V'')';
1359: END IF;
1360: close cur_leg_params;
1361:

Line 1366: decode(pay_payrg_pkg.get_parameter(''P_S1'',

1362: /* Bug 3037633 : Order By clause changed to include the effective_date after sort options
1363: choosen by the user. */
1364:
1365: sqlstr := sqlstr||'order by
1366: decode(pay_payrg_pkg.get_parameter(''P_S1'',
1367: ppa.legislative_parameters),
1368: ''GRE'',hou1.name,
1369: ''Organization'',hou.name,
1370: ''Location'',loc.location_code,null),

Line 1371: decode(pay_payrg_pkg.get_parameter(''P_S2'',

1367: ppa.legislative_parameters),
1368: ''GRE'',hou1.name,
1369: ''Organization'',hou.name,
1370: ''Location'',loc.location_code,null),
1371: decode(pay_payrg_pkg.get_parameter(''P_S2'',
1372: ppa.legislative_parameters),
1373: ''GRE'',hou1.name,
1374: ''Organization'',hou.name,
1375: ''Location'',loc.location_code,null),

Line 1376: decode(pay_payrg_pkg.get_parameter(''P_S3'',

1372: ppa.legislative_parameters),
1373: ''GRE'',hou1.name,
1374: ''Organization'',hou.name,
1375: ''Location'',loc.location_code,null),
1376: decode(pay_payrg_pkg.get_parameter(''P_S3'',
1377: ppa.legislative_parameters),
1378: ''GRE'',hou1.name,
1379: ''Organization'',hou.name,
1380: ''Location'',loc.location_code,null),