APPS.PO_EDA_IDX_FILE_GEN dependencies on PO_HEADERS_ALL

Line 24: FROM po_headers_all

20: AND d.draft_id = h.draft_id;
21:
22: CURSOR c_getdocdetails IS
23: SELECT po_header_id documentId
24: FROM po_headers_all
25: WHERE clm_document_number = p_clm_document_number;
26:
27: TransactionCode VARCHAR2(1) := 'A';
28: SystemName VARCHAR2(8):= p_system_name;

Line 46: FROM po_headers_all

42:
43:
44: CURSOR c_isorderoffidv IS
45: SELECT 'Y'
46: FROM po_headers_all
47: WHERE clm_award_type IN ('BPA_CALL','DELIVERY_ORD')
48: AND po_header_id = p_doc_id;
49:
50: CURSOR c_issuedate IS

Line 52: FROM PO_HEADERS_ALL

48: AND po_header_id = p_doc_id;
49:
50: CURSOR c_issuedate IS
51: SELECT CLM_EFFECTIVE_DATE
52: FROM PO_HEADERS_ALL
53: WHERE po_header_id = p_doc_id;
54:
55: l_isorderoffidv VARCHAR2(100):='N';
56: l_modiftype VARCHAR2(100);

Line 383: TYPE ARRAY IS TABLE OF po_headers_all.clm_document_number%TYPE;

379: req_data VARCHAR2(32767);
380:
381: startpos NUMBER:=1;
382:
383: TYPE ARRAY IS TABLE OF po_headers_all.clm_document_number%TYPE;
384: l_doc_numbers ARRAY;
385:
386: l_approved_date DATE := to_date(p_approved_date,'YYYY/MM/DD HH24:MI:SS');
387: l_approved_date2 DATE := to_date(p_approved_date2,'YYYY/MM/DD HH24:MI:SS');

Line 397: FROM po_headers_all

393: SELECT
394: clm_document_number
395: FROM
396: (SELECT CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER, 'N' ismod,CLM_EFFECTIVE_DATE effdate,APPROVED_DATE APPROVED_DATE,CLM_EDAGEN_DATE
397: FROM po_headers_all
398: WHERE uda_template_id IS NOT NULL
399: UNION
400: SELECT modification_number CLM_DOCUMENT_NUMBER, 'Y' ismod,MOD_EFFECTIVE_DATE effdate,(select APPROVED_DATE from po_headers_merge_v where
401: po_header_id = a.DOCUMENT_ID and draft_id = a.DRAFT_ID) APPROVED_DATE,CLM_EDAGEN_DATE

Line 831: UPDATE po_headers_all SET CLM_EDAGEN_DATE = l_timestamp WHERE CLM_DOCUMENT_NUMBER = l_doc_number;

827: LOOP
828: FETCH csr_req_stats INTO l_doc_type,l_doc_number,l_timestamp;
829: EXIT WHEN csr_req_stats%NOTFOUND;
830: IF(l_doc_type = 'N') THEN
831: UPDATE po_headers_all SET CLM_EDAGEN_DATE = l_timestamp WHERE CLM_DOCUMENT_NUMBER = l_doc_number;
832: ELSE
833: UPDATE po_drafts SET CLM_EDAGEN_DATE = l_timestamp WHERE MODIFICATION_NUMBER = l_doc_number;
834: END IF;
835: END LOOP;