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

Line 251: sql_curs := dbms_sql.open_cursor;

247: statem := statem || ' order by assignment_id, effective_start_date';
248: statem := statem || ' for update';
249: --
250: --
251: sql_curs := dbms_sql.open_cursor;
252: --
253: dbms_sql.parse(sql_curs,
254: statem,
255: dbms_sql.v7);

Line 253: dbms_sql.parse(sql_curs,

249: --
250: --
251: sql_curs := dbms_sql.open_cursor;
252: --
253: dbms_sql.parse(sql_curs,
254: statem,
255: dbms_sql.v7);
256: --
257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);

Line 255: dbms_sql.v7);

251: sql_curs := dbms_sql.open_cursor;
252: --
253: dbms_sql.parse(sql_curs,
254: statem,
255: dbms_sql.v7);
256: --
257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
258: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
259: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);

Line 257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);

253: dbms_sql.parse(sql_curs,
254: statem,
255: dbms_sql.v7);
256: --
257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
258: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
259: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
260: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
261: --

Line 258: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);

254: statem,
255: dbms_sql.v7);
256: --
257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
258: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
259: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
260: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
261: --
262: for i in 1..30 loop

Line 259: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);

255: dbms_sql.v7);
256: --
257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
258: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
259: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
260: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
261: --
262: for i in 1..30 loop
263: if segment(i) is not null then

Line 260: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);

256: --
257: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
258: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
259: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
260: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
261: --
262: for i in 1..30 loop
263: if segment(i) is not null then
264: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));

Line 264: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));

260: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
261: --
262: for i in 1..30 loop
263: if segment(i) is not null then
264: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
265: end if;
266: end loop;
267: --
268: dbms_sql.define_column(sql_curs,1,l_assignment_id);

Line 268: dbms_sql.define_column(sql_curs,1,l_assignment_id);

264: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
265: end if;
266: end loop;
267: --
268: dbms_sql.define_column(sql_curs,1,l_assignment_id);
269: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
270: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
271: --
272: rows_processed := dbms_sql.execute(sql_curs);

Line 269: dbms_sql.define_column(sql_curs,2,l_effective_start_date);

265: end if;
266: end loop;
267: --
268: dbms_sql.define_column(sql_curs,1,l_assignment_id);
269: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
270: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
271: --
272: rows_processed := dbms_sql.execute(sql_curs);
273: --

Line 270: dbms_sql.define_column(sql_curs,3,l_effective_end_date);

266: end loop;
267: --
268: dbms_sql.define_column(sql_curs,1,l_assignment_id);
269: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
270: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
271: --
272: rows_processed := dbms_sql.execute(sql_curs);
273: --
274: loop

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

268: dbms_sql.define_column(sql_curs,1,l_assignment_id);
269: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
270: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
271: --
272: rows_processed := dbms_sql.execute(sql_curs);
273: --
274: loop
275: if dbms_sql.fetch_rows(sql_curs) > 0 then
276: --

Line 275: if dbms_sql.fetch_rows(sql_curs) > 0 then

271: --
272: rows_processed := dbms_sql.execute(sql_curs);
273: --
274: loop
275: if dbms_sql.fetch_rows(sql_curs) > 0 then
276: --
277: row_count := row_count + 1;
278: --
279: dbms_sql.column_value(sql_curs,1,l_assignment_id);

Line 279: dbms_sql.column_value(sql_curs,1,l_assignment_id);

275: if dbms_sql.fetch_rows(sql_curs) > 0 then
276: --
277: row_count := row_count + 1;
278: --
279: dbms_sql.column_value(sql_curs,1,l_assignment_id);
280: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
282: --
283: hr_utility.trace('l_assignment_id '||l_assignment_id);

Line 280: dbms_sql.column_value(sql_curs,2,l_effective_start_date);

276: --
277: row_count := row_count + 1;
278: --
279: dbms_sql.column_value(sql_curs,1,l_assignment_id);
280: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
282: --
283: hr_utility.trace('l_assignment_id '||l_assignment_id);
284: hr_utility.trace('l_effective_start_date '||l_effective_start_date);

Line 281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);

277: row_count := row_count + 1;
278: --
279: dbms_sql.column_value(sql_curs,1,l_assignment_id);
280: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
282: --
283: hr_utility.trace('l_assignment_id '||l_assignment_id);
284: hr_utility.trace('l_effective_start_date '||l_effective_start_date);
285: hr_utility.trace('l_effective_end_date '||l_effective_end_date);

Line 334: dbms_sql.close_cursor(sql_curs);

330: exit;
331: end if;
332: end loop;
333: --
334: dbms_sql.close_cursor(sql_curs);
335: --
336: end loop;
337: --
338: -- Handle the last row in the cursor (loop exits before checking it)