APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on PO_HEADERS_GT

Line 502: delete from po_headers_gt;

498: END LOOP;
499:
500: l_progress := '020';
501:
502: delete from po_headers_gt;
503:
504: -- For all the entities , get Requisition Header status fields into
505: -- global temprary table while storing sequence into po_headers_gt.PO_HEADER_ID column
506: l_progress := '030';

Line 505: -- global temprary table while storing sequence into po_headers_gt.PO_HEADER_ID column

501:
502: delete from po_headers_gt;
503:
504: -- For all the entities , get Requisition Header status fields into
505: -- global temprary table while storing sequence into po_headers_gt.PO_HEADER_ID column
506: l_progress := '030';
507: FORALL i IN 1..p_count
508: INSERT
509: INTO po_headers_gt

Line 509: INTO po_headers_gt

505: -- global temprary table while storing sequence into po_headers_gt.PO_HEADER_ID column
506: l_progress := '030';
507: FORALL i IN 1..p_count
508: INSERT
509: INTO po_headers_gt
510: ( AGENT_ID, TYPE_LOOKUP_CODE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
511: SEGMENT1, SUMMARY_FLAG, ENABLED_FLAG,
512: authorization_status, closed_code,
513: cancel_flag, PO_HEADER_ID)

Line 527: UPDATE po_headers_gt gt

523:
524: --IF line ID present at an index, overwrite the status fields with Line Level status
525: l_progress := '040';
526: FORALL i IN 1..p_count
527: UPDATE po_headers_gt gt
528: SET (closed_code, cancel_flag)
529: =
530: (SELECT nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N')
531: FROM po_requisition_lines s

Line 547: FROM po_headers_gt

543: cancel_flag
544: BULK COLLECT INTO
545: x_req_status_rec.authorization_status, x_req_status_rec.closed_code,
546: x_req_status_rec.cancel_flag
547: FROM po_headers_gt
548: ORDER BY PO_HEADER_ID;
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: