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.PYCADAR_PKG dependencies on DBMS_SQL

Line 1421: sql_cur := dbms_sql.open_cursor;

1417: DECLARE
1418: BEGIN
1419: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1420: --hr_utility.trace(statem);
1421: sql_cur := dbms_sql.open_cursor;
1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);

Line 1422: dbms_sql.parse(sql_cur

1418: BEGIN
1419: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
1420: --hr_utility.trace(statem);
1421: sql_cur := dbms_sql.open_cursor;
1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);

Line 1424: ,dbms_sql.v7);

1420: --hr_utility.trace(statem);
1421: sql_cur := dbms_sql.open_cursor;
1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);

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

1421: sql_cur := dbms_sql.open_cursor;
1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

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

1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);

Line 1427: l_rows := dbms_sql.execute(sql_cur);

1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception

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

1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN

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

1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN
1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

Line 1430: dbms_sql.close_cursor(sql_cur);

1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN
1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1434: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');

Line 1436: IF dbms_sql.IS_OPEN(sql_cur) THEN

1432: WHEN OTHERS THEN
1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1434: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1435: --
1436: IF dbms_sql.IS_OPEN(sql_cur) THEN
1437: dbms_sql.close_cursor(sql_cur);
1438: END IF;
1439: END;
1440: --

Line 1437: dbms_sql.close_cursor(sql_cur);

1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1434: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1435: --
1436: IF dbms_sql.IS_OPEN(sql_cur) THEN
1437: dbms_sql.close_cursor(sql_cur);
1438: END IF;
1439: END;
1440: --
1441: --