APPS.ICX_REQ_COPY_REQ dependencies on PO_REQUISITION_HEADERS

Line 553: WHERE table_name = 'PO_REQUISITION_HEADERS'

549: -- Get a new Requisition number
550: SELECT to_char(current_max_unique_identifier + 1)
551: INTO v_requisition_num
552: FROM po_unique_identifier_control
553: WHERE table_name = 'PO_REQUISITION_HEADERS'
554: FOR UPDATE OF current_max_unique_identifier;
555:
556: UPDATE po_unique_identifier_control
557: SET current_max_unique_identifier = current_max_unique_identifier + 1

Line 558: WHERE table_name = 'PO_REQUISITION_HEADERS';

554: FOR UPDATE OF current_max_unique_identifier;
555:
556: UPDATE po_unique_identifier_control
557: SET current_max_unique_identifier = current_max_unique_identifier + 1
558: WHERE table_name = 'PO_REQUISITION_HEADERS';
559:
560: COMMIT; /* avoid locking problem (?!) */
561:
562: --changed by alex for attachment

Line 567: SELECT PO_REQUISITION_HEADERS_S.NEXTVAL

563: -- SELECT icx_shopping_carts_s.NEXTVAL
564: -- INTO v_cart_id
565: -- FROM SYS.DUAL;
566: --new code:
567: SELECT PO_REQUISITION_HEADERS_S.NEXTVAL
568: INTO v_cart_id
569: FROM SYS.DUAL;
570:
571: -- The reserve_po_num column is now updated to NULL from the earlier

Line 652: FROM po_requisition_headers

648: attribute15,
649: v_deliver_to_location,
650: v_int_contact_name,
651: v_org_id
652: FROM po_requisition_headers
653: WHERE requisition_header_id = l_req_header_id;
654:
655: --add by alex
656: --copy attachment for the header