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

Line 1178: sql_curs := dbms_sql.open_cursor;

1174: :p_base_period_type,
1175: :p_multiple,
1176: :p_first_period_end); END;';
1177: --
1178: sql_curs := dbms_sql.open_cursor;
1179: --
1180: dbms_sql.parse(sql_curs,
1181: statem,
1182: dbms_sql.v7);

Line 1180: dbms_sql.parse(sql_curs,

1176: :p_first_period_end); END;';
1177: --
1178: sql_curs := dbms_sql.open_cursor;
1179: --
1180: dbms_sql.parse(sql_curs,
1181: statem,
1182: dbms_sql.v7);
1183: --
1184: -- Bind all the variables for the dynamic call

Line 1182: dbms_sql.v7);

1178: sql_curs := dbms_sql.open_cursor;
1179: --
1180: dbms_sql.parse(sql_curs,
1181: statem,
1182: dbms_sql.v7);
1183: --
1184: -- Bind all the variables for the dynamic call
1185: --
1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);

Line 1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);

1182: dbms_sql.v7);
1183: --
1184: -- Bind all the variables for the dynamic call
1185: --
1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);
1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);
1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);

Line 1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);

1183: --
1184: -- Bind all the variables for the dynamic call
1185: --
1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);
1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);
1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);
1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);

Line 1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);

1184: -- Bind all the variables for the dynamic call
1185: --
1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);
1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);
1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);
1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);
1192: dbms_sql.bind_variable(sql_curs,'p_first_period_end',p_first_period_end);

Line 1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);

1185: --
1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);
1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);
1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);
1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);
1192: dbms_sql.bind_variable(sql_curs,'p_first_period_end',p_first_period_end);
1193: --

Line 1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);

1186: dbms_sql.bind_variable(sql_curs,'p_payroll_id',p_payroll_id);
1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);
1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);
1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);
1192: dbms_sql.bind_variable(sql_curs,'p_first_period_end',p_first_period_end);
1193: --
1194: -- Execute the dyn cursor for the procedure call, then close.

Line 1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);

1187: dbms_sql.bind_variable(sql_curs,'p_first_end_date',p_first_gen_date);
1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);
1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);
1192: dbms_sql.bind_variable(sql_curs,'p_first_period_end',p_first_period_end);
1193: --
1194: -- Execute the dyn cursor for the procedure call, then close.
1195: --

Line 1192: dbms_sql.bind_variable(sql_curs,'p_first_period_end',p_first_period_end);

1188: dbms_sql.bind_variable(sql_curs,'p_last_end_date',l_tp_last_end_date);
1189: dbms_sql.bind_variable(sql_curs,'p_period_type',p_period_type);
1190: dbms_sql.bind_variable(sql_curs,'p_base_period_type',p_base_period_type);
1191: dbms_sql.bind_variable(sql_curs,'p_multiple',p_multiple);
1192: dbms_sql.bind_variable(sql_curs,'p_first_period_end',p_first_period_end);
1193: --
1194: -- Execute the dyn cursor for the procedure call, then close.
1195: --
1196: BEGIN

Line 1198: rows_processed := dbms_sql.execute(sql_curs);

1194: -- Execute the dyn cursor for the procedure call, then close.
1195: --
1196: BEGIN
1197: --
1198: rows_processed := dbms_sql.execute(sql_curs);
1199: --
1200: -- If one of the user-defined exceptions are raised,
1201: -- do nothing as it means that the legislation does not
1202: -- have a package procedure defined for the localization, in which

Line 1213: dbms_sql.close_cursor(sql_curs);

1209: WHEN NO_PACKAGE_BODY OR NO_PACKAGE_PROCEDURE THEN
1210: NULL;
1211: --
1212: END;
1213: dbms_sql.close_cursor(sql_curs);
1214: --
1215: --
1216: end create_dynamic_local_cal;
1217: --