eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_AUCTION_HEADERS_EXT_B

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 3201: FROM PON_AUCTION_HEADERS_EXT_B

3197: l_msg_data VARCHAR2(2000);
3198:
3199: CURSOR l_extn_id_csr ( auc_hdr_id NUMBER ) IS
3200: SELECT EXTENSION_ID
3201: FROM PON_AUCTION_HEADERS_EXT_B
3202: WHERE C_EXT_ATTR1 IN ('PRO_ADMIN_OFFICE','COTR_OFFICE','REQ_OFFICE') AND
3203: AUCTION_HEADER_ID = auc_hdr_id;
3204: BEGIN
3205:

Line 3269: DELETE FROM PON_AUCTION_HEADERS_EXT_B

3265:
3266: END LOOP;
3267: CLOSE l_extn_id_csr;
3268:
3269: DELETE FROM PON_AUCTION_HEADERS_EXT_B
3270: WHERE C_EXT_ATTR1 IN ('PRO_ADMIN_OFFICE','COTR_OFFICE','REQ_OFFICE') AND
3271: AUCTION_HEADER_ID = p_auction_header_id;
3272:
3273: EXCEPTION WHEN OTHERS THEN

Line 3283: SELECT Count(*) INTO l_user_pref_addr_cnt FROM PON_AUCTION_HEADERS_EXT_B

3279: /* STEP 4 - END */
3280:
3281: /* STEP 5 - START */
3282:
3283: SELECT Count(*) INTO l_user_pref_addr_cnt FROM PON_AUCTION_HEADERS_EXT_B
3284: WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3285:
3286: IF l_user_pref_addr_cnt > 0 THEN
3287: SELECT EXTENSION_ID, C_EXT_ATTR5 INTO l_iss_off_extn_id, l_address_val FROM PON_AUCTION_HEADERS_EXT_B

Line 3287: SELECT EXTENSION_ID, C_EXT_ATTR5 INTO l_iss_off_extn_id, l_address_val FROM PON_AUCTION_HEADERS_EXT_B

3283: SELECT Count(*) INTO l_user_pref_addr_cnt FROM PON_AUCTION_HEADERS_EXT_B
3284: WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3285:
3286: IF l_user_pref_addr_cnt > 0 THEN
3287: SELECT EXTENSION_ID, C_EXT_ATTR5 INTO l_iss_off_extn_id, l_address_val FROM PON_AUCTION_HEADERS_EXT_B
3288: WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3289:
3290: IF l_address_val IS NOT NULL THEN
3291: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE_BACKUP' WHERE EXTENSION_ID = l_iss_off_extn_id;

Line 3291: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE_BACKUP' WHERE EXTENSION_ID = l_iss_off_extn_id;

3287: SELECT EXTENSION_ID, C_EXT_ATTR5 INTO l_iss_off_extn_id, l_address_val FROM PON_AUCTION_HEADERS_EXT_B
3288: WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;
3289:
3290: IF l_address_val IS NOT NULL THEN
3291: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE_BACKUP' WHERE EXTENSION_ID = l_iss_off_extn_id;
3292:
3293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3294: fnd_log.string(fnd_log.level_statement,g_log_head,'Taking backup of Issuing Office Record');
3295: END IF;

Line 3298: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B

3294: fnd_log.string(fnd_log.level_statement,g_log_head,'Taking backup of Issuing Office Record');
3295: END IF;
3296: ELSE
3297: BEGIN
3298: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B
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:

Line 3301: DELETE FROM PON_AUCTION_HEADERS_EXT_B WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;

3297: BEGIN
3298: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B
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

Line 3339: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B

3335: /* STEP 7,8 - START */
3336:
3337: IF l_user_pref_addr_cnt > 0 THEN
3338: BEGIN
3339: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B
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:

Line 3342: DELETE FROM PON_AUCTION_HEADERS_EXT_B WHERE C_EXT_ATTR1 = 'ISSUING_OFFICE' AND AUCTION_HEADER_ID = p_auction_header_id;

3338: BEGIN
3339: SELECT EXTENSION_ID INTO l_extn_id FROM PON_AUCTION_HEADERS_EXT_B
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

Line 3356: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE' WHERE EXTENSION_ID = l_iss_off_extn_id;

3352: fnd_log.string(fnd_log.level_statement,g_log_head,'l_extn_id 4 : '||l_extn_id);
3353: fnd_log.string(fnd_log.level_statement,g_log_head,'l_iss_off_extn_id 2 : '||l_iss_off_extn_id);
3354: END IF;
3355:
3356: UPDATE PON_AUCTION_HEADERS_EXT_B SET C_EXT_ATTR1='ISSUING_OFFICE' WHERE EXTENSION_ID = l_iss_off_extn_id;
3357: END IF;
3358:
3359: /* STEP 7,8 - END */
3360: