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

Line 449: cid := dbms_sql.open_cursor;

445: --dbms_output.put_line(substr(sql_str,1,255));
446: --dbms_output.put_line(substr(sql_str,256,255));
447: --dbms_output.put_line(substr(sql_str,513,255));
448:
449: cid := dbms_sql.open_cursor;
450:
451: dbms_sql.parse(cid, sql_str , dbms_sql.native);
452:
453: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);

Line 451: dbms_sql.parse(cid, sql_str , dbms_sql.native);

447: --dbms_output.put_line(substr(sql_str,513,255));
448:
449: cid := dbms_sql.open_cursor;
450:
451: dbms_sql.parse(cid, sql_str , dbms_sql.native);
452:
453: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);
454: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
455:

Line 453: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);

449: cid := dbms_sql.open_cursor;
450:
451: dbms_sql.parse(cid, sql_str , dbms_sql.native);
452:
453: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);
454: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
455:
456: IF NOT emp_name_null THEN
457:

Line 454: dbms_sql.define_column(cid,2,p_emp_record.employee_id);

450:
451: dbms_sql.parse(cid, sql_str , dbms_sql.native);
452:
453: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);
454: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
455:
456: IF NOT emp_name_null THEN
457:
458: dbms_sql.bind_variable(cid,'v_emp_name',p_emp_record.employee_name);

Line 458: dbms_sql.bind_variable(cid,'v_emp_name',p_emp_record.employee_name);

454: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
455:
456: IF NOT emp_name_null THEN
457:
458: dbms_sql.bind_variable(cid,'v_emp_name',p_emp_record.employee_name);
459:
460: END IF;
461:
462: IF NOT emp_id_null THEN

Line 464: dbms_sql.bind_variable(cid,'v_emp_id',p_emp_record.employee_id);

460: END IF;
461:
462: IF NOT emp_id_null THEN
463:
464: dbms_sql.bind_variable(cid,'v_emp_id',p_emp_record.employee_id);
465:
466: END IF;
467:
468: rows_processed := dbms_sql.execute_and_fetch(cid);

Line 468: rows_processed := dbms_sql.execute_and_fetch(cid);

464: dbms_sql.bind_variable(cid,'v_emp_id',p_emp_record.employee_id);
465:
466: END IF;
467:
468: rows_processed := dbms_sql.execute_and_fetch(cid);
469:
470: IF rows_processed = 1 THEN
471:
472: IF emp_name_null THEN

Line 473: dbms_sql.column_value(cid,1,p_emp_record.employee_name);

469:
470: IF rows_processed = 1 THEN
471:
472: IF emp_name_null THEN
473: dbms_sql.column_value(cid,1,p_emp_record.employee_name);
474: END IF;
475:
476: IF emp_id_null THEN
477: dbms_sql.column_value(cid,2,p_emp_record.employee_id);

Line 477: dbms_sql.column_value(cid,2,p_emp_record.employee_id);

473: dbms_sql.column_value(cid,1,p_emp_record.employee_name);
474: END IF;
475:
476: IF emp_id_null THEN
477: dbms_sql.column_value(cid,2,p_emp_record.employee_id);
478: END IF;
479:
480: p_emp_record.error_record.error_status := 'S';
481:

Line 492: IF dbms_sql.is_open(cid) THEN

488: p_emp_record.error_record.error_status := 'W';
489:
490: END IF;
491:
492: IF dbms_sql.is_open(cid) THEN
493: dbms_sql.close_cursor(cid);
494: END IF;
495:
496: EXCEPTION

Line 493: dbms_sql.close_cursor(cid);

489:
490: END IF;
491:
492: IF dbms_sql.is_open(cid) THEN
493: dbms_sql.close_cursor(cid);
494: END IF;
495:
496: EXCEPTION
497: WHEN others THEN

Line 499: IF dbms_sql.is_open(cid) THEN

495:
496: EXCEPTION
497: WHEN others THEN
498:
499: IF dbms_sql.is_open(cid) THEN
500: dbms_sql.close_cursor(cid);
501: END IF;
502:
503: p_emp_record.error_record.error_status := 'U';

Line 500: dbms_sql.close_cursor(cid);

496: EXCEPTION
497: WHEN others THEN
498:
499: IF dbms_sql.is_open(cid) THEN
500: dbms_sql.close_cursor(cid);
501: END IF;
502:
503: p_emp_record.error_record.error_status := 'U';
504: p_emp_record.error_record.error_message := sqlerrm;

Line 563: X_cid := dbms_sql.open_cursor;

559: --dbms_output.put_line(substr(X_sql_str,1,255));
560: --dbms_output.put_line(substr(X_sql_str,256,255));
561: --dbms_output.put_line(substr(X_sql_str,513,255));
562:
563: X_cid := dbms_sql.open_cursor;
564:
565: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
566:
567: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);

Line 565: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);

561: --dbms_output.put_line(substr(X_sql_str,513,255));
562:
563: X_cid := dbms_sql.open_cursor;
564:
565: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
566:
567: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);
568: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
569:

Line 567: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);

563: X_cid := dbms_sql.open_cursor;
564:
565: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
566:
567: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);
568: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
569:
570: IF NOT X_emp_name_null THEN
571:

Line 568: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);

564:
565: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
566:
567: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);
568: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
569:
570: IF NOT X_emp_name_null THEN
571:
572: dbms_sql.bind_variable(X_cid,'v_emp_name',p_emp_record.employee_name);

Line 572: dbms_sql.bind_variable(X_cid,'v_emp_name',p_emp_record.employee_name);

568: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
569:
570: IF NOT X_emp_name_null THEN
571:
572: dbms_sql.bind_variable(X_cid,'v_emp_name',p_emp_record.employee_name);
573:
574: END IF;
575:
576: IF NOT X_emp_id_null THEN

Line 578: dbms_sql.bind_variable(X_cid,'v_emp_id',p_emp_record.employee_id);

574: END IF;
575:
576: IF NOT X_emp_id_null THEN
577:
578: dbms_sql.bind_variable(X_cid,'v_emp_id',p_emp_record.employee_id);
579:
580: END IF;
581:
582: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);

Line 582: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);

578: dbms_sql.bind_variable(X_cid,'v_emp_id',p_emp_record.employee_id);
579:
580: END IF;
581:
582: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);
583:
584: IF X_rows_processed = 1 THEN
585:
586: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);

Line 586: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);

582: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);
583:
584: IF X_rows_processed = 1 THEN
585:
586: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);
587: dbms_sql.column_value(X_cid,2,p_emp_record.employee_id);
588:
589: p_emp_record.error_record.error_status := 'S';
590: p_emp_record.error_record.error_message := NULL;

Line 587: dbms_sql.column_value(X_cid,2,p_emp_record.employee_id);

583:
584: IF X_rows_processed = 1 THEN
585:
586: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);
587: dbms_sql.column_value(X_cid,2,p_emp_record.employee_id);
588:
589: p_emp_record.error_record.error_status := 'S';
590: p_emp_record.error_record.error_message := NULL;
591:

Line 597: IF dbms_sql.is_open(X_cid) THEN

593:
594: p_emp_record.error_record.error_status := 'E';
595: p_emp_record.error_record.error_message := 'RECEIVER_ID';
596:
597: IF dbms_sql.is_open(X_cid) THEN
598: dbms_sql.close_cursor(X_cid);
599: END IF;
600: RETURN;
601:

Line 598: dbms_sql.close_cursor(X_cid);

594: p_emp_record.error_record.error_status := 'E';
595: p_emp_record.error_record.error_message := 'RECEIVER_ID';
596:
597: IF dbms_sql.is_open(X_cid) THEN
598: dbms_sql.close_cursor(X_cid);
599: END IF;
600: RETURN;
601:
602: ELSE

Line 607: IF dbms_sql.is_open(X_cid) THEN

603:
604: p_emp_record.error_record.error_status := 'E';
605: p_emp_record.error_record.error_message := 'TOOMANYROWS';
606:
607: IF dbms_sql.is_open(X_cid) THEN
608: dbms_sql.close_cursor(X_cid);
609: END IF;
610: RETURN;
611:

Line 608: dbms_sql.close_cursor(X_cid);

604: p_emp_record.error_record.error_status := 'E';
605: p_emp_record.error_record.error_message := 'TOOMANYROWS';
606:
607: IF dbms_sql.is_open(X_cid) THEN
608: dbms_sql.close_cursor(X_cid);
609: END IF;
610: RETURN;
611:
612: END IF;

Line 614: IF dbms_sql.is_open(X_cid) THEN

610: RETURN;
611:
612: END IF;
613:
614: IF dbms_sql.is_open(X_cid) THEN
615: dbms_sql.close_cursor(X_cid);
616: END IF;
617:
618: EXCEPTION

Line 615: dbms_sql.close_cursor(X_cid);

611:
612: END IF;
613:
614: IF dbms_sql.is_open(X_cid) THEN
615: dbms_sql.close_cursor(X_cid);
616: END IF;
617:
618: EXCEPTION
619: WHEN others THEN

Line 621: IF dbms_sql.is_open(X_cid) THEN

617:
618: EXCEPTION
619: WHEN others THEN
620:
621: IF dbms_sql.is_open(X_cid) THEN
622: dbms_sql.close_cursor(X_cid);
623: END IF;
624:
625: p_emp_record.error_record.error_status := 'U';

Line 622: dbms_sql.close_cursor(X_cid);

618: EXCEPTION
619: WHEN others THEN
620:
621: IF dbms_sql.is_open(X_cid) THEN
622: dbms_sql.close_cursor(X_cid);
623: END IF;
624:
625: p_emp_record.error_record.error_status := 'U';
626: p_emp_record.error_record.error_message := sqlerrm;