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.AP_VENDOR_PUB_PKG dependencies on IBY_TEMP_EXT_BANK_ACCTS

Line 15767: FROM IBY_TEMP_EXT_BANK_ACCTS

15763: l_bank_acct_id NUMBER;
15764:
15765: CURSOR IBY_EXT_ACCTS_CUR (p_unique_ref IN NUMBER) IS
15766: SELECT temp_ext_bank_acct_id
15767: FROM IBY_TEMP_EXT_BANK_ACCTS
15768: WHERE calling_app_unique_ref1 = p_unique_ref
15769: --Bug 7412849 (Base Bug 7387700) As status can be NULL, this where condition always resolves to FALSE.
15770: --Added NVL around 'status'.
15771: --AND status <> 'PROCESSED';

Line 16263: UPDATE IBY_TEMP_EXT_BANK_ACCTS

16259: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
16260: --bug 5568861
16261: l_ext_payee_id := ext_payee_id_tab(1).ext_payee_id;
16262:
16263: UPDATE IBY_TEMP_EXT_BANK_ACCTS
16264: SET ext_payee_id = l_ext_payee_id
16265: ,account_owner_party_id = l_party_id -- bug 6753331
16266: WHERE calling_app_unique_ref1 = vendor_rec.vendor_interface_id;
16267:

Line 16296: UPDATE iby_temp_ext_bank_accts

16292: x_bank_acc_id => l_bank_acct_id,
16293: x_response => ext_response_rec);
16294:
16295: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
16296: UPDATE iby_temp_ext_bank_accts
16297: SET status = 'PROCESSED'
16298: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
16299:
16300: ELSE

Line 16323: UPDATE iby_temp_ext_bank_accts

16319: UPDATE Ap_Suppliers_Int
16320: SET status = 'REJECTED'
16321: WHERE vendor_interface_id = vendor_rec.vendor_interface_id;
16322:
16323: UPDATE iby_temp_ext_bank_accts
16324: SET status = 'REJECTED'
16325: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
16326:
16327: -- Bug 9259355 Start

Line 16368: --'IBY_TEMP_EXT_BANK_ACCTS',

16364: END IF;
16365: -- Bug 9259355 End
16366:
16367: IF (Insert_Rejections(
16368: --'IBY_TEMP_EXT_BANK_ACCTS',
16369: 'AP_SUPPLIERS_INT', --bug 8275512
16370: vendor_rec.vendor_interface_id,
16371: 'AP_INVALID_BANK_ACCT_INFO',
16372: g_user_id,

Line 16635: FROM IBY_TEMP_EXT_BANK_ACCTS

16631: l_bank_acct_id NUMBER;
16632:
16633: CURSOR IBY_EXT_ACCTS_CUR (p_unique_ref IN NUMBER) IS
16634: SELECT temp_ext_bank_acct_id
16635: FROM IBY_TEMP_EXT_BANK_ACCTS
16636: WHERE calling_app_unique_ref2 = p_unique_ref
16637: --Bug 7412849 (Base Bug 7387700) As status can be NULL, this where condition always resolves to FALSE.
16638: --Added NVL around 'status'.
16639: --AND status <> 'PROCESSED';

Line 17089: UPDATE IBY_TEMP_EXT_BANK_ACCTS

17085: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
17086: --bug 5568861 l_ext_payee_id := ext_payee_id_tab(ext_payee_id_tab.first).ext_payee_id;
17087: l_ext_payee_id := ext_payee_id_tab(1).ext_payee_id;
17088:
17089: UPDATE IBY_TEMP_EXT_BANK_ACCTS
17090: SET ext_payee_id = l_ext_payee_id
17091: ,account_owner_party_id = ext_payee_rec.payee_party_id --bug 6753331
17092: WHERE calling_app_unique_ref2 = site_rec.vendor_site_interface_id;
17093:

Line 17133: UPDATE iby_temp_ext_bank_accts

17129: x_bank_acc_id => l_bank_acct_id,
17130: x_response => ext_response_rec);
17131:
17132: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
17133: UPDATE iby_temp_ext_bank_accts
17134: SET status = 'PROCESSED'
17135: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17136:
17137: ELSE -- Bank Account Creation API

Line 17139: /*UPDATE iby_temp_ext_bank_accts

17135: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17136:
17137: ELSE -- Bank Account Creation API
17138: --bug 8275512 moved the below code after cursor iby_ext_accts_cur close
17139: /*UPDATE iby_temp_ext_bank_accts
17140: SET status = 'REJECTED'
17141: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17142:
17143: IF (Insert_Rejections(

Line 17144: 'IBY_TEMP_EXT_BANK_ACCTS',

17140: SET status = 'REJECTED'
17141: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17142:
17143: IF (Insert_Rejections(
17144: 'IBY_TEMP_EXT_BANK_ACCTS',
17145: site_rec.vendor_site_interface_id,
17146: 'AP_BANK_ACCT_CREATION',
17147: g_user_id,
17148: g_login_id,

Line 17173: /*UPDATE iby_temp_ext_bank_accts

17169: --Commented for Bug 9012321
17170: /* ELSE -- Bank Account Validation API
17171: --bug 8275512 moved the below code after cursor iby_ext_accts_cur close
17172:
17173: /*UPDATE iby_temp_ext_bank_accts
17174: SET status = 'REJECTED'
17175: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17176:
17177: IF (Insert_Rejections(

Line 17178: --'IBY_TEMP_EXT_BANK_ACCTS',

17174: SET status = 'REJECTED'
17175: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17176:
17177: IF (Insert_Rejections(
17178: --'IBY_TEMP_EXT_BANK_ACCTS',
17179: 'AP_SUPPLIER_SITES_INT', --bug 8275512
17180: site_rec.vendor_site_interface_id,
17181: 'AP_INVALID_BANK_ACCT_INFO',
17182: g_user_id,

Line 17221: UPDATE iby_temp_ext_bank_accts

17217: AND mo_global.check_access(org_id)= 'Y' --bug13989575
17218: ;
17219:
17220:
17221: UPDATE iby_temp_ext_bank_accts
17222: SET status = 'REJECTED'
17223: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
17224:
17225: -- Bug 9259355 Start

Line 17266: --'IBY_TEMP_EXT_BANK_ACCTS',

17262: END IF;
17263: -- Bug 9259355 End
17264:
17265: IF (Insert_Rejections(
17266: --'IBY_TEMP_EXT_BANK_ACCTS',
17267: 'AP_SUPPLIER_SITES_INT', --bug 8275512
17268: site_rec.vendor_site_interface_id,
17269: 'AP_INVALID_BANK_ACCT_INFO',
17270: g_user_id,