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 DBMS_SQL

Line 1323: sql_cur := dbms_sql.open_cursor;

1319: DECLARE
1320: BEGIN
1321: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1322: --hr_utility.trace(statem);
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);

Line 1324: dbms_sql.parse(sql_cur

1320: BEGIN
1321: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1322: --hr_utility.trace(statem);
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);

Line 1326: ,dbms_sql.v7);

1322: --hr_utility.trace(statem);
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);

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 1329: l_rows := dbms_sql.execute(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);
1333: Exception

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 1332: dbms_sql.close_cursor(sql_cur);

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');
1336: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');

Line 1338: IF dbms_sql.IS_OPEN(sql_cur) THEN

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;
1341: END;
1342: --

Line 1339: dbms_sql.close_cursor(sql_cur);

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;
1341: END;
1342: --
1343: --