1377: and event_class_code = 'REQUISITION'
1378: and application_id =201;
1379:
1380: l_progress := '180';
1381: delete from PO_REQ_HEADERS_EXT_B where REQUISITION_HEADER_ID =p_origHeaderId;
1382:
1383: l_progress := '190';
1384:
1385: update PO_REQ_HEADERS_EXT_B set REQUISITION_HEADER_ID= p_origHeaderId
1381: delete from PO_REQ_HEADERS_EXT_B where REQUISITION_HEADER_ID =p_origHeaderId;
1382:
1383: l_progress := '190';
1384:
1385: update PO_REQ_HEADERS_EXT_B set REQUISITION_HEADER_ID= p_origHeaderId
1386: WHERE requisition_header_id = p_tempHeaderId;
1387:
1388: UPDATE PO_REQ_HEADERS_EXT_B ext set ext.C_EXT_ATTR40 = LTrim(ext.C_EXT_ATTR40,'##')
1389: WHERE ext.requisition_header_id = p_origHeaderId AND
1384:
1385: update PO_REQ_HEADERS_EXT_B set REQUISITION_HEADER_ID= p_origHeaderId
1386: WHERE requisition_header_id = p_tempHeaderId;
1387:
1388: UPDATE PO_REQ_HEADERS_EXT_B ext set ext.C_EXT_ATTR40 = LTrim(ext.C_EXT_ATTR40,'##')
1389: WHERE ext.requisition_header_id = p_origHeaderId AND
1390:
1391: EXISTS (SELECT 1 FROM
1392: