APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on PO_HEADERS_GT

Line 497: delete from po_headers_gt;

493: END LOOP;
494:
495: l_progress := '020';
496:
497: delete from po_headers_gt;
498:
499: -- For all the entities , get Requisition Header status fields into
500: -- global temprary table while storing sequence into po_headers_gt.PO_HEADER_ID column
501: l_progress := '030';

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

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

Line 504: INTO po_headers_gt

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

Line 522: UPDATE po_headers_gt gt

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

Line 542: FROM po_headers_gt

538: cancel_flag
539: BULK COLLECT INTO
540: x_req_status_rec.authorization_status, x_req_status_rec.closed_code,
541: x_req_status_rec.cancel_flag
542: FROM po_headers_gt
543: ORDER BY PO_HEADER_ID;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546: