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 1173: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))

1169: AND c_end_date
1170: AND ppa.report_type = hrl.meaning
1171: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1172: AND hrl.lookup_code = c_legislation_code
1173: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1174: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1175: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1176:
1177: --

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

1170: AND ppa.report_type = hrl.meaning
1171: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1172: AND hrl.lookup_code = c_legislation_code
1173: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1174: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1175: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1176:
1177: --
1178: --

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

1171: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1172: AND hrl.lookup_code = c_legislation_code
1173: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1174: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1175: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1176:
1177: --
1178: --
1179: AND ppa.payroll_action_id = paa.payroll_action_id

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

1214: AND c_end_date
1215: AND ppa.report_type = hrl.meaning
1216: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1217: AND hrl.lookup_code = c_legislation_code
1218: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1219: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1220: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1221: AND ppa.payroll_action_id = paa.payroll_action_id
1222: AND paa.source_action_id IS NULL

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

1215: AND ppa.report_type = hrl.meaning
1216: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1217: AND hrl.lookup_code = c_legislation_code
1218: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1219: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1220: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1221: AND ppa.payroll_action_id = paa.payroll_action_id
1222: AND paa.source_action_id IS NULL
1223: AND paa.assignment_id = hasa.assignment_id

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

1216: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1217: AND hrl.lookup_code = c_legislation_code
1218: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1219: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1220: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1221: AND ppa.payroll_action_id = paa.payroll_action_id
1222: AND paa.source_action_id IS NULL
1223: AND paa.assignment_id = hasa.assignment_id
1224: AND hasa.assignment_set_id = c_assignment_set_id

Line 1264: pay_payslip_report.get_all_parameters(l_actid

1260:
1261: IF pay_us_deposit_advice_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1262: pay_us_deposit_advice_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1263:
1264: pay_payslip_report.get_all_parameters(l_actid
1265: ,l_payroll_id
1266: ,l_consolidation_set_id
1267: ,l_start_date
1268: ,l_end_date

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

1313: sql_cur := dbms_sql.open_cursor;
1314: dbms_sql.parse(sql_cur
1315: ,statem
1316: ,dbms_sql.v7);
1317: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1318: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1319: l_rows := dbms_sql.execute(sql_cur);
1320: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1321: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

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

1314: dbms_sql.parse(sql_cur
1315: ,statem
1316: ,dbms_sql.v7);
1317: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1318: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1319: l_rows := dbms_sql.execute(sql_cur);
1320: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1321: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1322: dbms_sql.close_cursor(sql_cur);

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

1316: ,dbms_sql.v7);
1317: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1318: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1319: l_rows := dbms_sql.execute(sql_cur);
1320: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1321: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1322: dbms_sql.close_cursor(sql_cur);
1323: Exception
1324: WHEN OTHERS THEN

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

1317: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1318: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1319: l_rows := dbms_sql.execute(sql_cur);
1320: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1321: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1322: dbms_sql.close_cursor(sql_cur);
1323: Exception
1324: WHEN OTHERS THEN
1325: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

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

1321: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1322: dbms_sql.close_cursor(sql_cur);
1323: Exception
1324: WHEN OTHERS THEN
1325: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1326: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1327: --
1328: IF dbms_sql.IS_OPEN(sql_cur) THEN
1329: dbms_sql.close_cursor(sql_cur);

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

1322: dbms_sql.close_cursor(sql_cur);
1323: Exception
1324: WHEN OTHERS THEN
1325: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1326: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1327: --
1328: IF dbms_sql.IS_OPEN(sql_cur) THEN
1329: dbms_sql.close_cursor(sql_cur);
1330: END IF;

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

1330: END IF;
1331: END;
1332: --
1333: --
1334: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id

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

1331: END;
1332: --
1333: --
1334: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1335: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1336:
1337: IF pay_us_deposit_advice_pkg.g_assignment_set_id IS NULL THEN
1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id

Line 1342: ,pay_payslip_report.g_pa_token

1338: OPEN csr_asg(pay_us_deposit_advice_pkg.g_payroll_id
1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token
1343: ,pay_payslip_report.g_cs_token
1344: ,pay_us_deposit_advice_pkg.g_legislation_code);
1345: LOOP
1346:

Line 1343: ,pay_payslip_report.g_cs_token

1339: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1340: ,pay_us_deposit_advice_pkg.g_start_dt
1341: ,pay_us_deposit_advice_pkg.g_end_dt
1342: ,pay_payslip_report.g_pa_token
1343: ,pay_payslip_report.g_cs_token
1344: ,pay_us_deposit_advice_pkg.g_legislation_code);
1345: LOOP
1346:
1347: ln_assignment_id := -1;

Line 1375: ,pay_payslip_report.g_pa_token

1371: OPEN csr_inc_asg(pay_us_deposit_advice_pkg.g_payroll_id
1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token
1377: ,pay_us_deposit_advice_pkg.g_legislation_code
1378: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1379: LOOP

Line 1376: ,pay_payslip_report.g_cs_token

1372: ,pay_us_deposit_advice_pkg.g_consolidation_set_id
1373: ,pay_us_deposit_advice_pkg.g_start_dt
1374: ,pay_us_deposit_advice_pkg.g_end_dt
1375: ,pay_payslip_report.g_pa_token
1376: ,pay_payslip_report.g_cs_token
1377: ,pay_us_deposit_advice_pkg.g_legislation_code
1378: ,pay_us_deposit_advice_pkg.g_assignment_set_id);
1379: LOOP
1380: