APPS.POS_AP_SUPPLIER_SITE_BO_PKG dependencies on IBY_TEMP_EXT_BANK_ACCTS

Line 54: FROM iby_temp_ext_bank_accts

50: l_bank_acct_id NUMBER;
51:
52: CURSOR iby_ext_accts_cur(p_unique_ref IN NUMBER) IS
53: SELECT temp_ext_bank_acct_id
54: FROM iby_temp_ext_bank_accts
55: WHERE calling_app_unique_ref2 = p_unique_ref
56: AND nvl(status, 'NEW') <> 'PROCESSED';
57:
58: l_debug_info VARCHAR2(500);

Line 128: UPDATE iby_temp_ext_bank_accts

124:
125: IF l_return_status = fnd_api.g_ret_sts_success THEN
126: l_ext_payee_id := ext_payee_id_tab(1).ext_payee_id;
127:
128: UPDATE iby_temp_ext_bank_accts
129: SET ext_payee_id = l_ext_payee_id,
130: account_owner_party_id = ext_payee_rec.payee_party_id --bug 6753331
131: WHERE calling_app_unique_ref2 =
132: p_site_rec.vendor_site_interface_id;

Line 168: UPDATE iby_temp_ext_bank_accts

164: x_bank_acc_id => l_bank_acct_id,
165: x_response => ext_response_rec);
166:
167: IF l_return_status = fnd_api.g_ret_sts_success THEN
168: UPDATE iby_temp_ext_bank_accts
169: SET status = 'PROCESSED'
170: WHERE temp_ext_bank_acct_id = l_temp_ext_acct_id;
171:
172: ELSE