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 1313: sql_cur := dbms_sql.open_cursor;

1309: DECLARE
1310: BEGIN
1311: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1312: --hr_utility.trace(statem);
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);

Line 1314: dbms_sql.parse(sql_cur

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

Line 1316: ,dbms_sql.v7);

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

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

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

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

Line 1328: IF dbms_sql.IS_OPEN(sql_cur) THEN

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;
1331: END;
1332: --

Line 1329: dbms_sql.close_cursor(sql_cur);

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;
1331: END;
1332: --
1333: --