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 560: cid := dbms_sql.open_cursor;

556: --dbms_output.put_line(substr(sql_str,1,255));
557: --dbms_output.put_line(substr(sql_str,256,255));
558: --dbms_output.put_line(substr(sql_str,513,255));
559:
560: cid := dbms_sql.open_cursor;
561:
562: dbms_sql.parse(cid, sql_str , dbms_sql.native);
563:
564: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);

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

558: --dbms_output.put_line(substr(sql_str,513,255));
559:
560: cid := dbms_sql.open_cursor;
561:
562: dbms_sql.parse(cid, sql_str , dbms_sql.native);
563:
564: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);
565: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
566:

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

560: cid := dbms_sql.open_cursor;
561:
562: dbms_sql.parse(cid, sql_str , dbms_sql.native);
563:
564: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);
565: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
566:
567: IF NOT emp_name_null THEN
568:

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

561:
562: dbms_sql.parse(cid, sql_str , dbms_sql.native);
563:
564: dbms_sql.define_column(cid,1,p_emp_record.employee_name,255);
565: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
566:
567: IF NOT emp_name_null THEN
568:
569: dbms_sql.bind_variable(cid,'v_emp_name',p_emp_record.employee_name);

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

565: dbms_sql.define_column(cid,2,p_emp_record.employee_id);
566:
567: IF NOT emp_name_null THEN
568:
569: dbms_sql.bind_variable(cid,'v_emp_name',p_emp_record.employee_name);
570:
571: END IF;
572:
573: IF NOT emp_id_null THEN

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

571: END IF;
572:
573: IF NOT emp_id_null THEN
574:
575: dbms_sql.bind_variable(cid,'v_emp_id',p_emp_record.employee_id);
576:
577: END IF;
578:
579: rows_processed := dbms_sql.execute_and_fetch(cid);

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

575: dbms_sql.bind_variable(cid,'v_emp_id',p_emp_record.employee_id);
576:
577: END IF;
578:
579: rows_processed := dbms_sql.execute_and_fetch(cid);
580:
581: IF rows_processed = 1 THEN
582:
583: IF emp_name_null THEN

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

580:
581: IF rows_processed = 1 THEN
582:
583: IF emp_name_null THEN
584: dbms_sql.column_value(cid,1,p_emp_record.employee_name);
585: END IF;
586:
587: IF emp_id_null THEN
588: dbms_sql.column_value(cid,2,p_emp_record.employee_id);

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

584: dbms_sql.column_value(cid,1,p_emp_record.employee_name);
585: END IF;
586:
587: IF emp_id_null THEN
588: dbms_sql.column_value(cid,2,p_emp_record.employee_id);
589: END IF;
590:
591: p_emp_record.error_record.error_status := 'S';
592:

Line 603: IF dbms_sql.is_open(cid) THEN

599: p_emp_record.error_record.error_status := 'W';
600:
601: END IF;
602:
603: IF dbms_sql.is_open(cid) THEN
604: dbms_sql.close_cursor(cid);
605: END IF;
606:
607: EXCEPTION

Line 604: dbms_sql.close_cursor(cid);

600:
601: END IF;
602:
603: IF dbms_sql.is_open(cid) THEN
604: dbms_sql.close_cursor(cid);
605: END IF;
606:
607: EXCEPTION
608: WHEN others THEN

Line 610: IF dbms_sql.is_open(cid) THEN

606:
607: EXCEPTION
608: WHEN others THEN
609:
610: IF dbms_sql.is_open(cid) THEN
611: dbms_sql.close_cursor(cid);
612: END IF;
613:
614: p_emp_record.error_record.error_status := 'U';

Line 611: dbms_sql.close_cursor(cid);

607: EXCEPTION
608: WHEN others THEN
609:
610: IF dbms_sql.is_open(cid) THEN
611: dbms_sql.close_cursor(cid);
612: END IF;
613:
614: p_emp_record.error_record.error_status := 'U';
615: p_emp_record.error_record.error_message := sqlerrm;

Line 674: X_cid := dbms_sql.open_cursor;

670: --dbms_output.put_line(substr(X_sql_str,1,255));
671: --dbms_output.put_line(substr(X_sql_str,256,255));
672: --dbms_output.put_line(substr(X_sql_str,513,255));
673:
674: X_cid := dbms_sql.open_cursor;
675:
676: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
677:
678: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);

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

672: --dbms_output.put_line(substr(X_sql_str,513,255));
673:
674: X_cid := dbms_sql.open_cursor;
675:
676: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
677:
678: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);
679: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
680:

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

674: X_cid := dbms_sql.open_cursor;
675:
676: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
677:
678: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);
679: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
680:
681: IF NOT X_emp_name_null THEN
682:

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

675:
676: dbms_sql.parse(X_cid, X_sql_str , dbms_sql.native);
677:
678: dbms_sql.define_column(X_cid,1,p_emp_record.employee_name,255);
679: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
680:
681: IF NOT X_emp_name_null THEN
682:
683: dbms_sql.bind_variable(X_cid,'v_emp_name',p_emp_record.employee_name);

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

679: dbms_sql.define_column(X_cid,2,p_emp_record.employee_id);
680:
681: IF NOT X_emp_name_null THEN
682:
683: dbms_sql.bind_variable(X_cid,'v_emp_name',p_emp_record.employee_name);
684:
685: END IF;
686:
687: IF NOT X_emp_id_null THEN

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

685: END IF;
686:
687: IF NOT X_emp_id_null THEN
688:
689: dbms_sql.bind_variable(X_cid,'v_emp_id',p_emp_record.employee_id);
690:
691: END IF;
692:
693: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);

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

689: dbms_sql.bind_variable(X_cid,'v_emp_id',p_emp_record.employee_id);
690:
691: END IF;
692:
693: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);
694:
695: IF X_rows_processed = 1 THEN
696:
697: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);

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

693: X_rows_processed := dbms_sql.execute_and_fetch(X_cid);
694:
695: IF X_rows_processed = 1 THEN
696:
697: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);
698: dbms_sql.column_value(X_cid,2,p_emp_record.employee_id);
699:
700: p_emp_record.error_record.error_status := 'S';
701: p_emp_record.error_record.error_message := NULL;

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

694:
695: IF X_rows_processed = 1 THEN
696:
697: dbms_sql.column_value(X_cid,1,p_emp_record.employee_name);
698: dbms_sql.column_value(X_cid,2,p_emp_record.employee_id);
699:
700: p_emp_record.error_record.error_status := 'S';
701: p_emp_record.error_record.error_message := NULL;
702:

Line 708: IF dbms_sql.is_open(X_cid) THEN

704:
705: p_emp_record.error_record.error_status := 'E';
706: p_emp_record.error_record.error_message := 'RECEIVER_ID';
707:
708: IF dbms_sql.is_open(X_cid) THEN
709: dbms_sql.close_cursor(X_cid);
710: END IF;
711: RETURN;
712:

Line 709: dbms_sql.close_cursor(X_cid);

705: p_emp_record.error_record.error_status := 'E';
706: p_emp_record.error_record.error_message := 'RECEIVER_ID';
707:
708: IF dbms_sql.is_open(X_cid) THEN
709: dbms_sql.close_cursor(X_cid);
710: END IF;
711: RETURN;
712:
713: ELSE

Line 718: IF dbms_sql.is_open(X_cid) THEN

714:
715: p_emp_record.error_record.error_status := 'E';
716: p_emp_record.error_record.error_message := 'TOOMANYROWS';
717:
718: IF dbms_sql.is_open(X_cid) THEN
719: dbms_sql.close_cursor(X_cid);
720: END IF;
721: RETURN;
722:

Line 719: dbms_sql.close_cursor(X_cid);

715: p_emp_record.error_record.error_status := 'E';
716: p_emp_record.error_record.error_message := 'TOOMANYROWS';
717:
718: IF dbms_sql.is_open(X_cid) THEN
719: dbms_sql.close_cursor(X_cid);
720: END IF;
721: RETURN;
722:
723: END IF;

Line 725: IF dbms_sql.is_open(X_cid) THEN

721: RETURN;
722:
723: END IF;
724:
725: IF dbms_sql.is_open(X_cid) THEN
726: dbms_sql.close_cursor(X_cid);
727: END IF;
728:
729: EXCEPTION

Line 726: dbms_sql.close_cursor(X_cid);

722:
723: END IF;
724:
725: IF dbms_sql.is_open(X_cid) THEN
726: dbms_sql.close_cursor(X_cid);
727: END IF;
728:
729: EXCEPTION
730: WHEN others THEN

Line 732: IF dbms_sql.is_open(X_cid) THEN

728:
729: EXCEPTION
730: WHEN others THEN
731:
732: IF dbms_sql.is_open(X_cid) THEN
733: dbms_sql.close_cursor(X_cid);
734: END IF;
735:
736: p_emp_record.error_record.error_status := 'U';

Line 733: dbms_sql.close_cursor(X_cid);

729: EXCEPTION
730: WHEN others THEN
731:
732: IF dbms_sql.is_open(X_cid) THEN
733: dbms_sql.close_cursor(X_cid);
734: END IF;
735:
736: p_emp_record.error_record.error_status := 'U';
737: p_emp_record.error_record.error_message := sqlerrm;