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 414: sql_curs := dbms_sql.open_cursor;

410: statem := statem || ' order by assignment_id, effective_start_date';
411: statem := statem || ' for update';
412: --
413: --
414: sql_curs := dbms_sql.open_cursor;
415: --
416: dbms_sql.parse(sql_curs,
417: statem,
418: dbms_sql.v7);

Line 416: dbms_sql.parse(sql_curs,

412: --
413: --
414: sql_curs := dbms_sql.open_cursor;
415: --
416: dbms_sql.parse(sql_curs,
417: statem,
418: dbms_sql.v7);
419: --
420: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);

Line 418: dbms_sql.v7);

414: sql_curs := dbms_sql.open_cursor;
415: --
416: dbms_sql.parse(sql_curs,
417: statem,
418: dbms_sql.v7);
419: --
420: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
421: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
422: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);

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

416: dbms_sql.parse(sql_curs,
417: statem,
418: dbms_sql.v7);
419: --
420: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
421: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
422: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
423: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
424: --

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

417: statem,
418: dbms_sql.v7);
419: --
420: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
421: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
422: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
423: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
424: --
425: for i in 1..30 loop

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

418: dbms_sql.v7);
419: --
420: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
421: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
422: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
423: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
424: --
425: for i in 1..30 loop
426: if segment(i) is not null then

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

419: --
420: dbms_sql.bind_variable(sql_curs, 'p_business_group_id', p_business_group_id);
421: dbms_sql.bind_variable(sql_curs, 'p_effective_start_date', p_effective_start_date);
422: dbms_sql.bind_variable(sql_curs, 'p_effective_end_date', p_effective_end_date);
423: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
424: --
425: for i in 1..30 loop
426: if segment(i) is not null then
427: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));

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

423: dbms_sql.bind_variable(sql_curs, 'p_id_flex_num', lpg.id_flex_num);
424: --
425: for i in 1..30 loop
426: if segment(i) is not null then
427: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
428: end if;
429: end loop;
430: if l_lnk_org_id is not null then
431: dbms_sql.bind_variable(sql_curs, 'p_org_id', l_lnk_org_id);

Line 431: dbms_sql.bind_variable(sql_curs, 'p_org_id', l_lnk_org_id);

427: dbms_sql.bind_variable(sql_curs, 'p_segment'||i, segment(i));
428: end if;
429: end loop;
430: if l_lnk_org_id is not null then
431: dbms_sql.bind_variable(sql_curs, 'p_org_id', l_lnk_org_id);
432: end if;
433: if l_lnk_emp_cat is not null then
434: dbms_sql.bind_variable(sql_curs, 'p_emp_cat', l_lnk_emp_cat);
435: end if;

Line 434: dbms_sql.bind_variable(sql_curs, 'p_emp_cat', l_lnk_emp_cat);

430: if l_lnk_org_id is not null then
431: dbms_sql.bind_variable(sql_curs, 'p_org_id', l_lnk_org_id);
432: end if;
433: if l_lnk_emp_cat is not null then
434: dbms_sql.bind_variable(sql_curs, 'p_emp_cat', l_lnk_emp_cat);
435: end if;
436: if l_lnk_payroll_id is not null then
437: dbms_sql.bind_variable(sql_curs, 'p_payroll_id', l_lnk_payroll_id);
438: end if;

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

433: if l_lnk_emp_cat is not null then
434: dbms_sql.bind_variable(sql_curs, 'p_emp_cat', l_lnk_emp_cat);
435: end if;
436: if l_lnk_payroll_id is not null then
437: dbms_sql.bind_variable(sql_curs, 'p_payroll_id', l_lnk_payroll_id);
438: end if;
439: --
440: dbms_sql.define_column(sql_curs,1,l_assignment_id);
441: dbms_sql.define_column(sql_curs,2,l_effective_start_date);

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

436: if l_lnk_payroll_id is not null then
437: dbms_sql.bind_variable(sql_curs, 'p_payroll_id', l_lnk_payroll_id);
438: end if;
439: --
440: dbms_sql.define_column(sql_curs,1,l_assignment_id);
441: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
442: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
443: --
444: rows_processed := dbms_sql.execute(sql_curs);

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

437: dbms_sql.bind_variable(sql_curs, 'p_payroll_id', l_lnk_payroll_id);
438: end if;
439: --
440: dbms_sql.define_column(sql_curs,1,l_assignment_id);
441: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
442: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
443: --
444: rows_processed := dbms_sql.execute(sql_curs);
445: --

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

438: end if;
439: --
440: dbms_sql.define_column(sql_curs,1,l_assignment_id);
441: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
442: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
443: --
444: rows_processed := dbms_sql.execute(sql_curs);
445: --
446: loop

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

440: dbms_sql.define_column(sql_curs,1,l_assignment_id);
441: dbms_sql.define_column(sql_curs,2,l_effective_start_date);
442: dbms_sql.define_column(sql_curs,3,l_effective_end_date);
443: --
444: rows_processed := dbms_sql.execute(sql_curs);
445: --
446: loop
447: if dbms_sql.fetch_rows(sql_curs) > 0 then
448: --

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

443: --
444: rows_processed := dbms_sql.execute(sql_curs);
445: --
446: loop
447: if dbms_sql.fetch_rows(sql_curs) > 0 then
448: --
449: row_count := row_count + 1;
450: --
451: dbms_sql.column_value(sql_curs,1,l_assignment_id);

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

447: if dbms_sql.fetch_rows(sql_curs) > 0 then
448: --
449: row_count := row_count + 1;
450: --
451: dbms_sql.column_value(sql_curs,1,l_assignment_id);
452: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
453: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
454: --
455: if g_debug then

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

448: --
449: row_count := row_count + 1;
450: --
451: dbms_sql.column_value(sql_curs,1,l_assignment_id);
452: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
453: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
454: --
455: if g_debug then
456: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);

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

449: row_count := row_count + 1;
450: --
451: dbms_sql.column_value(sql_curs,1,l_assignment_id);
452: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
453: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
454: --
455: if g_debug then
456: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);
457: hr_utility.trace('l_assignment_id:'||l_assignment_id||

Line 512: dbms_sql.close_cursor(sql_curs);

508: exit;
509: end if;
510: end loop;
511: --
512: dbms_sql.close_cursor(sql_curs);
513: --
514: end loop;
515: --
516: -- Handle the last row in the cursor (loop exits before checking it)