APPS.ICX_REQ_ORDER dependencies on PO_UNIQUE_IDENTIFIER_CONTROL

Line 2546: FROM po_unique_identifier_control

2542: procedure reserve_po_num(reserved_po_num IN OUT varchar2,n_cart_id number,n_org number) is
2543: ------------------------------------------------
2544:
2545: CURSOR C3 IS SELECT to_char(current_max_unique_identifier + 1)
2546: FROM po_unique_identifier_control
2547: WHERE table_name = 'PO_HEADERS'
2548: FOR UPDATE OF current_max_unique_identifier;
2549:
2550: l_po_num varchar2(1000);

Line 2562: UPDATE po_unique_identifier_control

2558: -- if icx_sec.validatesession then
2559: if reserved_po_num is null OR reserved_po_num = '' then
2560: OPEN C3;
2561: FETCH C3 into reserved_po_num;
2562: UPDATE po_unique_identifier_control
2563: SET current_max_unique_identifier =
2564: current_max_unique_identifier + 1
2565: WHERE CURRENT of C3;
2566: CLOSE C3;