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_US_DEPOSIT_ADVICE_PKG dependencies on PAY_PAYSLIP_REPORT

Line 1183: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))

1179: AND c_end_date
1180: AND ppa.report_type = hrl.meaning
1181: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1182: AND hrl.lookup_code = c_legislation_code
1183: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1184: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1185: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1186:
1187: --

Line 1184: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)

1180: AND ppa.report_type = hrl.meaning
1181: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1182: AND hrl.lookup_code = c_legislation_code
1183: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1184: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1185: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1186:
1187: --
1188: --

Line 1185: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)

1181: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1182: AND hrl.lookup_code = c_legislation_code
1183: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1184: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1185: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1186:
1187: --
1188: --
1189: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1228: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))

1224: AND c_end_date
1225: AND ppa.report_type = hrl.meaning
1226: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1227: AND hrl.lookup_code = c_legislation_code
1228: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1229: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1230: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1231: AND ppa.payroll_action_id = paa.payroll_action_id
1232: --AND paa.source_action_id IS NULL --RLN P1 894102

Line 1229: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)

1225: AND ppa.report_type = hrl.meaning
1226: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1227: AND hrl.lookup_code = c_legislation_code
1228: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1229: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1230: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1231: AND ppa.payroll_action_id = paa.payroll_action_id
1232: --AND paa.source_action_id IS NULL --RLN P1 894102
1233: AND paa.assignment_id = hasa.assignment_id

Line 1230: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)

1226: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1227: AND hrl.lookup_code = c_legislation_code
1228: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1229: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1230: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1231: AND ppa.payroll_action_id = paa.payroll_action_id
1232: --AND paa.source_action_id IS NULL --RLN P1 894102
1233: AND paa.assignment_id = hasa.assignment_id
1234: AND hasa.assignment_set_id = c_assignment_set_id

Line 1274: pay_payslip_report.get_all_parameters(l_actid

1270:
1271: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1272: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1273:
1274: pay_payslip_report.get_all_parameters(l_actid
1275: ,l_payroll_id
1276: ,l_consolidation_set_id
1277: ,l_start_date
1278: ,l_end_date

Line 1327: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);

1323: sql_cur := dbms_sql.open_cursor;
1324: dbms_sql.parse(sql_cur
1325: ,statem
1326: ,dbms_sql.v7);
1327: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1328: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1329: l_rows := dbms_sql.execute(sql_cur);
1330: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1331: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

Line 1328: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);

1324: dbms_sql.parse(sql_cur
1325: ,statem
1326: ,dbms_sql.v7);
1327: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1328: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1329: l_rows := dbms_sql.execute(sql_cur);
1330: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1331: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1332: dbms_sql.close_cursor(sql_cur);

Line 1330: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);

1326: ,dbms_sql.v7);
1327: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1328: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1329: l_rows := dbms_sql.execute(sql_cur);
1330: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1331: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1332: dbms_sql.close_cursor(sql_cur);
1333: Exception
1334: WHEN OTHERS THEN

Line 1331: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

1327: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1328: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1329: l_rows := dbms_sql.execute(sql_cur);
1330: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1331: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1332: dbms_sql.close_cursor(sql_cur);
1333: Exception
1334: WHEN OTHERS THEN
1335: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

Line 1335: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

1331: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1332: dbms_sql.close_cursor(sql_cur);
1333: Exception
1334: WHEN OTHERS THEN
1335: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1336: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1337: --
1338: IF dbms_sql.IS_OPEN(sql_cur) THEN
1339: dbms_sql.close_cursor(sql_cur);

Line 1336: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');

1332: dbms_sql.close_cursor(sql_cur);
1333: Exception
1334: WHEN OTHERS THEN
1335: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1336: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1337: --
1338: IF dbms_sql.IS_OPEN(sql_cur) THEN
1339: dbms_sql.close_cursor(sql_cur);
1340: END IF;

Line 1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);

1340: END IF;
1341: END;
1342: --
1343: --
1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id

Line 1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);

1341: END;
1342: --
1343: --
1344: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1345: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1346:
1347: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

Line 1352: ,pay_payslip_report.g_pa_token

1348: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token
1353: ,pay_payslip_report.g_cs_token
1354: ,pay_us_deposit_advice_pkg.g_legislation_code);
1355: LOOP
1356:

Line 1353: ,pay_payslip_report.g_cs_token

1349: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1350: ,pay_us_deposit_advice_pkg.g_start_dt
1351: ,pay_us_deposit_advice_pkg.g_end_dt
1352: ,pay_payslip_report.g_pa_token
1353: ,pay_payslip_report.g_cs_token
1354: ,pay_us_deposit_advice_pkg.g_legislation_code);
1355: LOOP
1356:
1357: ln_assignment_id := -1;

Line 1385: ,pay_payslip_report.g_pa_token

1381: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token
1387: ,pay_us_deposit_advice_pkg.g_legislation_code
1388: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1389: LOOP

Line 1386: ,pay_payslip_report.g_cs_token

1382: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1383: ,pay_us_deposit_advice_pkg.g_start_dt
1384: ,pay_us_deposit_advice_pkg.g_end_dt
1385: ,pay_payslip_report.g_pa_token
1386: ,pay_payslip_report.g_cs_token
1387: ,pay_us_deposit_advice_pkg.g_legislation_code
1388: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1389: LOOP
1390: