APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_AUCTION_HEADERS_EXT_TL

Line 3171: from UDA tables (PON_AUCTION_HEADERS_EXT_B, PON_AUCTION_HEADERS_EXT_TL) because these addresses should

3167: STEP 3) If all the above values are present, then call PON_UDA_PKG.DEFAULT_NON_RENDER_UDA procedure
3168: to copy addresses from user preferences. This procedure copies Requesting Office,
3169: Suggested COTR Office, Suggested Property Administration Office, and Issuing Office from User Preferences.
3170: STEP 4) Delete Requesting Office, Suggested COTR Office, and Suggested Property Administration Office addresses
3171: from UDA tables (PON_AUCTION_HEADERS_EXT_B, PON_AUCTION_HEADERS_EXT_TL) because these addresses should
3172: come from Requisition.
3173: STEP 5) If the Issuing Office copied from User Preferences has null data then delete that record, else take the
3174: backup of the record by updating it to ISSUING_OFFICE_BACKUP.
3175: STEP 6) Call PON_COPY_UDAS_GRP.COPY_REQ_HEADER_UDA procedure to copy addresses (Requesting Office,

Line 3264: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;

3260: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3261: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id : '||l_extn_id);
3262: END IF;
3263:
3264: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3265:
3266: END LOOP;
3267: CLOSE l_extn_id_csr;
3268:

Line 3303: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;

3299: WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3300:
3301: DELETE FROM PON_AUCTION_HEADERS_EXT_B WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3302:
3303: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3304: EXCEPTION WHEN OTHERS THEN
3305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3306: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 4 : '||SQLERRM);
3307: END IF;

Line 3344: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;

3340: WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3341:
3342: DELETE FROM PON_AUCTION_HEADERS_EXT_B WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3343:
3344: DELETE FROM PON_AUCTION_HEADERS_EXT_TL WHERE EXTENSION_ID = l_extn_id;
3345: EXCEPTION WHEN OTHERS THEN
3346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3347: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception 5 : '||SQLERRM);
3348: END IF;