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 12743: FROM IBY_TEMP_EXT_BANK_ACCTS

12739: l_bank_acct_id NUMBER;
12740:
12741: CURSOR IBY_EXT_ACCTS_CUR (p_unique_ref IN NUMBER) IS
12742: SELECT temp_ext_bank_acct_id
12743: FROM IBY_TEMP_EXT_BANK_ACCTS
12744: WHERE calling_app_unique_ref1 = p_unique_ref
12745: --Bug 7412849 (Base Bug 7387700) As status can be NULL, this where condition always resolves to FALSE.
12746: --Added NVL around 'status'.
12747: --AND status <> 'PROCESSED';

Line 13034: UPDATE IBY_TEMP_EXT_BANK_ACCTS

13030: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13031: --bug 5568861
13032: l_ext_payee_id := ext_payee_id_tab(1).ext_payee_id;
13033:
13034: UPDATE IBY_TEMP_EXT_BANK_ACCTS
13035: SET ext_payee_id = l_ext_payee_id
13036: ,account_owner_party_id = l_party_id -- bug 6753331
13037: WHERE calling_app_unique_ref1 = vendor_rec.vendor_interface_id;
13038:

Line 13077: UPDATE iby_temp_ext_bank_accts

13073: x_bank_acc_id => l_bank_acct_id,
13074: x_response => ext_response_rec);
13075:
13076: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13077: UPDATE iby_temp_ext_bank_accts
13078: SET status = 'PROCESSED'
13079: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13080:
13081: ELSE

Line 13082: UPDATE iby_temp_ext_bank_accts

13078: SET status = 'PROCESSED'
13079: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13080:
13081: ELSE
13082: UPDATE iby_temp_ext_bank_accts
13083: SET status = 'REJECTED'
13084: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13085:
13086: IF (Insert_Rejections(

Line 13087: 'IBY_TEMP_EXT_BANK_ACCTS',

13083: SET status = 'REJECTED'
13084: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13085:
13086: IF (Insert_Rejections(
13087: 'IBY_TEMP_EXT_BANK_ACCTS',
13088: vendor_rec.vendor_interface_id,
13089: 'AP_BANK_ACCT_CREATION',
13090: g_user_id,
13091: g_login_id,

Line 13112: UPDATE iby_temp_ext_bank_accts

13108: -- Bug 5491139 hkaniven end --
13109: END IF; -- Bank Account Creation API
13110:
13111: ELSE
13112: UPDATE iby_temp_ext_bank_accts
13113: SET status = 'REJECTED'
13114: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13115:
13116: IF (Insert_Rejections(

Line 13117: 'IBY_TEMP_EXT_BANK_ACCTS',

13113: SET status = 'REJECTED'
13114: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13115:
13116: IF (Insert_Rejections(
13117: 'IBY_TEMP_EXT_BANK_ACCTS',
13118: vendor_rec.vendor_interface_id,
13119: 'AP_INVALID_BANK_ACCT_INFO',
13120: g_user_id,
13121: g_login_id,

Line 13310: FROM IBY_TEMP_EXT_BANK_ACCTS

13306: l_bank_acct_id NUMBER;
13307:
13308: CURSOR IBY_EXT_ACCTS_CUR (p_unique_ref IN NUMBER) IS
13309: SELECT temp_ext_bank_acct_id
13310: FROM IBY_TEMP_EXT_BANK_ACCTS
13311: WHERE calling_app_unique_ref2 = p_unique_ref
13312: --Bug 7412849 (Base Bug 7387700) As status can be NULL, this where condition always resolves to FALSE.
13313: --Added NVL around 'status'.
13314: --AND status <> 'PROCESSED';

Line 13664: UPDATE IBY_TEMP_EXT_BANK_ACCTS

13660: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13661: --bug 5568861 l_ext_payee_id := ext_payee_id_tab(ext_payee_id_tab.first).ext_payee_id;
13662: l_ext_payee_id := ext_payee_id_tab(1).ext_payee_id;
13663:
13664: UPDATE IBY_TEMP_EXT_BANK_ACCTS
13665: SET ext_payee_id = l_ext_payee_id
13666: ,account_owner_party_id = ext_payee_rec.payee_party_id --bug 6753331
13667: WHERE calling_app_unique_ref2 = site_rec.vendor_site_interface_id;
13668:

Line 13707: UPDATE iby_temp_ext_bank_accts

13703: x_bank_acc_id => l_bank_acct_id,
13704: x_response => ext_response_rec);
13705:
13706: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
13707: UPDATE iby_temp_ext_bank_accts
13708: SET status = 'PROCESSED'
13709: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13710:
13711: ELSE -- Bank Account Creation API

Line 13712: UPDATE iby_temp_ext_bank_accts

13708: SET status = 'PROCESSED'
13709: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13710:
13711: ELSE -- Bank Account Creation API
13712: UPDATE iby_temp_ext_bank_accts
13713: SET status = 'REJECTED'
13714: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13715:
13716: IF (Insert_Rejections(

Line 13717: 'IBY_TEMP_EXT_BANK_ACCTS',

13713: SET status = 'REJECTED'
13714: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13715:
13716: IF (Insert_Rejections(
13717: 'IBY_TEMP_EXT_BANK_ACCTS',
13718: site_rec.vendor_site_interface_id,
13719: 'AP_BANK_ACCT_CREATION',
13720: g_user_id,
13721: g_login_id,

Line 13742: UPDATE iby_temp_ext_bank_accts

13738: -- Bug 5491139 hkaniven end --
13739: END IF; -- Bank Account Creation API
13740:
13741: ELSE -- Bank Account Validation API
13742: UPDATE iby_temp_ext_bank_accts
13743: SET status = 'REJECTED'
13744: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13745:
13746: IF (Insert_Rejections(

Line 13747: 'IBY_TEMP_EXT_BANK_ACCTS',

13743: SET status = 'REJECTED'
13744: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
13745:
13746: IF (Insert_Rejections(
13747: 'IBY_TEMP_EXT_BANK_ACCTS',
13748: site_rec.vendor_site_interface_id,
13749: 'AP_INVALID_BANK_ACCT_INFO',
13750: g_user_id,
13751: g_login_id,