APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_EXHIBIT_DETAILS

Line 874: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS when coming from Sourcing

870: -- END IF;
871:
872: --CLM Phase4 Changes
873: l_progress := '165';
874: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS when coming from Sourcing
875: IF (po_autocreate_params.g_interface_source_code = 'SOURCING')
876: THEN
877: copy_exhibit_from_sol(l_contract_doc_type, po_autocreate_params.g_purchasing_ou_id);
878: END IF;

Line 2821: -- This procedure is used to copy exhibits from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS

2817:
2818:
2819: --CLM Phase4 Changes
2820:
2821: -- This procedure is used to copy exhibits from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS
2822: -- and delete the deliverables that were linked to lins in Sol but not awarded.
2823:
2824: PROCEDURE copy_exhibit_from_sol( p_contract_doc_type IN VARCHAR2, p_org_id IN NUMBER)
2825: IS

Line 2852: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS

2848: l_elins_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);
2850:
2851: IF(l_cdrls_enabled = 'Y' OR l_elins_enabled = 'Y') THEN
2852: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS
2853: INSERT INTO po_exhibit_details
2854: (
2855: PO_EXHIBIT_DETAILS_ID
2856: ,EXHIBIT_NAME

Line 2853: INSERT INTO po_exhibit_details

2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);
2850:
2851: IF(l_cdrls_enabled = 'Y' OR l_elins_enabled = 'Y') THEN
2852: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS
2853: INSERT INTO po_exhibit_details
2854: (
2855: PO_EXHIBIT_DETAILS_ID
2856: ,EXHIBIT_NAME
2857: ,EXHIBIT_DESCRIPTION

Line 2855: PO_EXHIBIT_DETAILS_ID

2851: IF(l_cdrls_enabled = 'Y' OR l_elins_enabled = 'Y') THEN
2852: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS
2853: INSERT INTO po_exhibit_details
2854: (
2855: PO_EXHIBIT_DETAILS_ID
2856: ,EXHIBIT_NAME
2857: ,EXHIBIT_DESCRIPTION
2858: ,IS_CDRL
2859: ,PO_HEADER_ID

Line 2867: SELECT po_exhibit_details_s.NEXTVAL --PO_EXHIBIT_DETAILS_ID

2863: ,CREATION_DATE
2864: ,CREATED_BY
2865: ,LAST_UPDATE_LOGIN
2866: )
2867: SELECT po_exhibit_details_s.NEXTVAL --PO_EXHIBIT_DETAILS_ID
2868: ,EXHIBIT_NUMBER --EXHIBIT_NAME
2869: ,EXHIBIT_DESCRIPTION --EXHIBIT_DESCRIPTION
2870: ,IS_CDRL --IS_CDRL
2871: ,po_autocreate_params.g_po_header_id --PO_HEADER_ID

Line 2905: FROM po_exhibit_details

2901:
2902: -- Delete the deliverables whose referenced lines are not awarded.
2903: SELECT exhibit_name
2904: BULK COLLECT INTO l_exhibit_tbl
2905: FROM po_exhibit_details
2906: WHERE po_header_id = po_autocreate_params.g_po_header_id
2907: AND is_cdrl = 'Y';
2908:
2909: IF(l_exhibit_tbl IS NOT NULL) THEN