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 100: pay_payrg_pkg.get_parameter('P_P_TY', ppa.legislative_parameters),

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1354: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'QP' then
1355: sqlstr := sqlstr || ' and ppa1.action_type = ''Q''';
1356: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then
1357: sqlstr := sqlstr || ' and (ppa1.action_type = ''R'' or ppa1.action_type = ''Q'')';
1358: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then
1359: sqlstr := sqlstr || ' and ppa1.action_type = ''V''';
1360: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'ALL' then
1361: 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'')';
1362: END IF;

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

1356: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'PRQP' then
1357: sqlstr := sqlstr || ' and (ppa1.action_type = ''R'' or ppa1.action_type = ''Q'')';
1358: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'REV' then
1359: sqlstr := sqlstr || ' and ppa1.action_type = ''V''';
1360: ELSIF pay_payrg_pkg.get_parameter('P_P_TY',leg_params)= 'ALL' then
1361: 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'')';
1362: END IF;
1363: close cur_leg_params;
1364:

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

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

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

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

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

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