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_ASG_PROCESS_GRP_PKG dependencies on DBMS_SQL

Line 339: sql_cursor := dbms_sql.open_cursor;

335: :group_name);
336: end;
337: ';
338: --
339: sql_cursor := dbms_sql.open_cursor;
340: --
341: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
342: --
343: --

Line 341: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);

337: ';
338: --
339: sql_cursor := dbms_sql.open_cursor;
340: --
341: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
342: --
343: --
344: dbms_sql.bind_variable(sql_cursor, 'assignment_id', p_assignment_id);
345: --

Line 344: dbms_sql.bind_variable(sql_cursor, 'assignment_id', p_assignment_id);

340: --
341: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
342: --
343: --
344: dbms_sql.bind_variable(sql_cursor, 'assignment_id', p_assignment_id);
345: --
346: dbms_sql.bind_variable(sql_cursor, 'effective_start_date', p_effective_start_date);
347: --
348: dbms_sql.bind_variable(sql_cursor, 'effective_end_date', p_effective_end_date);

Line 346: dbms_sql.bind_variable(sql_cursor, 'effective_start_date', p_effective_start_date);

342: --
343: --
344: dbms_sql.bind_variable(sql_cursor, 'assignment_id', p_assignment_id);
345: --
346: dbms_sql.bind_variable(sql_cursor, 'effective_start_date', p_effective_start_date);
347: --
348: dbms_sql.bind_variable(sql_cursor, 'effective_end_date', p_effective_end_date);
349: --
350: dbms_sql.bind_variable(sql_cursor, 'group_name', p_group_name, 30);

Line 348: dbms_sql.bind_variable(sql_cursor, 'effective_end_date', p_effective_end_date);

344: dbms_sql.bind_variable(sql_cursor, 'assignment_id', p_assignment_id);
345: --
346: dbms_sql.bind_variable(sql_cursor, 'effective_start_date', p_effective_start_date);
347: --
348: dbms_sql.bind_variable(sql_cursor, 'effective_end_date', p_effective_end_date);
349: --
350: dbms_sql.bind_variable(sql_cursor, 'group_name', p_group_name, 30);
351: --
352: l_rows := dbms_sql.execute (sql_cursor);

Line 350: dbms_sql.bind_variable(sql_cursor, 'group_name', p_group_name, 30);

346: dbms_sql.bind_variable(sql_cursor, 'effective_start_date', p_effective_start_date);
347: --
348: dbms_sql.bind_variable(sql_cursor, 'effective_end_date', p_effective_end_date);
349: --
350: dbms_sql.bind_variable(sql_cursor, 'group_name', p_group_name, 30);
351: --
352: l_rows := dbms_sql.execute (sql_cursor);
353: --
354: if (l_rows = 1) then

Line 352: l_rows := dbms_sql.execute (sql_cursor);

348: dbms_sql.bind_variable(sql_cursor, 'effective_end_date', p_effective_end_date);
349: --
350: dbms_sql.bind_variable(sql_cursor, 'group_name', p_group_name, 30);
351: --
352: l_rows := dbms_sql.execute (sql_cursor);
353: --
354: if (l_rows = 1) then
355: dbms_sql.variable_value(sql_cursor, 'group_name',
356: p_group_name);

Line 355: dbms_sql.variable_value(sql_cursor, 'group_name',

351: --
352: l_rows := dbms_sql.execute (sql_cursor);
353: --
354: if (l_rows = 1) then
355: dbms_sql.variable_value(sql_cursor, 'group_name',
356: p_group_name);
357: dbms_sql.close_cursor(sql_cursor);
358: --
359: else

Line 357: dbms_sql.close_cursor(sql_cursor);

353: --
354: if (l_rows = 1) then
355: dbms_sql.variable_value(sql_cursor, 'group_name',
356: p_group_name);
357: dbms_sql.close_cursor(sql_cursor);
358: --
359: else
360: dbms_sql.close_cursor(sql_cursor);
361: pay_core_utils.assert_condition

Line 360: dbms_sql.close_cursor(sql_cursor);

356: p_group_name);
357: dbms_sql.close_cursor(sql_cursor);
358: --
359: else
360: dbms_sql.close_cursor(sql_cursor);
361: pay_core_utils.assert_condition
362: ('pay_asg_process_grp_pkg.evaluate_asg_group:1',
363: 1 = 2);
364: end if;