APPS.PO_CLM_CAR_UTIL dependencies on PO_HEADERS_MERGE_V

Line 74: FROM PO_HEADERS_MERGE_V

70: --CLM Controls Project Changes
71: BEGIN
72: SELECT ORG_ID
73: INTO l_org_id
74: FROM PO_HEADERS_MERGE_V
75: WHERE PO_HEADER_ID = p_clm_car_row.po_header_id
76: AND DRAFT_ID = l_po_draft_id;
77: EXCEPTION
78: WHEN No_Data_Found THEN

Line 535: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH

531: l_car_number VARCHAR2(60);
532: BEGIN
533: SELECT DECODE(POH.draft_id, -1, POH.clm_document_number, POD.modification_number)
534: INTO l_car_number
535: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH
536: WHERE POH.DRAFT_ID = POD.DRAFT_ID(+)
537: AND POH.po_header_id = p_po_header_id
538: AND poh.draft_id = NVL(p_draft_id, -1);
539:

Line 552: from PO_HEADERS_MERGE_V

548: l_PIID VARCHAR2(60);
549: BEGIN
550: SELECT replace(CLM_DOCUMENT_NUMBER, PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (po_header_id, draft_id), '')
551: INTO l_piid
552: from PO_HEADERS_MERGE_V
553: WHERE po_header_id = p_po_header_id
554: AND draft_id = NVL(p_draft_id, -1);
555:
556: RETURN l_piid;

Line 568: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH

564: l_modification_segment VARCHAR2(60);
565: BEGIN
566: SELECT REPLACE(MODIFICATION_NUMBER, CLM_DOCUMENT_NUMBER||PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (POH.po_header_id, POH.draft_id), '')
567: INTO l_modification_segment
568: FROM PO_DRAFTS POD, PO_HEADERS_MERGE_V POH
569: WHERE POH.DRAFT_ID = POD.DRAFT_ID(+)
570: AND POH.po_header_id = p_po_header_id
571: AND poh.draft_id = NVL(p_draft_id, -1);
572:

Line 682: FROM PO_HEADERS_MERGE_V

678: --CLM Controls Project Changes
679: BEGIN
680: SELECT ORG_ID
681: INTO l_org_id
682: FROM PO_HEADERS_MERGE_V
683: WHERE PO_HEADER_ID = p_po_header_id
684: AND DRAFT_ID = p_draft_id;
685: EXCEPTION
686: WHEN No_Data_Found THEN

Line 716: PO_HEADERS_MERGE_V POH

712:
713: select ATM.FPDS_AWARD_TYPE INTO l_award_idv_type
714: from
715: PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,
716: PO_HEADERS_MERGE_V POH
717: WHERE
718: POH.PO_HEADER_ID = p_po_header_id AND
719: POH.DRAFT_ID = p_draft_id AND
720: ATM.REPORT_TYPE(+) = l_report_type AND

Line 945: FROM po_headers_merge_v

941: AND l_fpds_reason IS NOT NULL THEN
942: -- getting org_id
943: SELECT org_id
944: INTO l_org_id
945: FROM po_headers_merge_v
946: WHERE po_header_id = p_po_header_id
947: AND NVL(draft_id, -1) = p_draft_id;
948: -- if car exists already, then update the car. Else create new car.
949: -- Update car only if special contract type is changed.

Line 999: PO_HEADERS_MERGE_V POH

995: l_report_type := po_clm_car_util.get_report_type(p_po_header_id);
996: SELECT ATM.FPDS_AWARD_TYPE
997: INTO l_award_idv_type
998: FROM PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,
999: PO_HEADERS_MERGE_V POH
1000: WHERE POH.PO_HEADER_ID = p_po_header_id
1001: AND NVL(POH.DRAFT_ID,-1) = p_draft_id
1002: AND ATM.REPORT_TYPE(+) = l_report_type
1003: AND ATM.CLM_AWARD_TYPE(+) = POH.CLM_AWARD_TYPE;