DBA Data[Home] [Help]

APPS.ICX_REQ_COPY_REQ dependencies on PO_UNIQUE_IDENTIFIER_CONTROL

Line 552: FROM po_unique_identifier_control

548:
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

Line 556: UPDATE po_unique_identifier_control

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
558: WHERE table_name = 'PO_REQUISITION_HEADERS';
559:
560: COMMIT; /* avoid locking problem (?!) */