DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_REQ_HEADERS_EXT_B

Line 1381: delete from PO_REQ_HEADERS_EXT_B where REQUISITION_HEADER_ID =p_origHeaderId;

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

Line 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

Line 1388: UPDATE PO_REQ_HEADERS_EXT_B ext set ext.C_EXT_ATTR40 = LTrim(ext.C_EXT_ATTR40,'##')

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: