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

Line 22: delete from iby_temp_ext_bank_accts

18: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
19: ' p_iby_temp_ext_bank_account_id ' || p_iby_temp_ext_bank_account_id);
20: END IF;
21:
22: delete from iby_temp_ext_bank_accts
23: where temp_ext_bank_acct_id = p_iby_temp_ext_bank_account_id;
24:
25:
26: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 171: select IBY_TEMP_EXT_BANK_ACCTS_S.nextval into x_temp_ext_bank_account_id from dual;

167: end if;
168:
169: l_step := 2;
170:
171: select IBY_TEMP_EXT_BANK_ACCTS_S.nextval into x_temp_ext_bank_account_id from dual;
172:
173: insert into iby_temp_ext_bank_accts
174: (
175: temp_ext_bank_acct_id

Line 173: insert into iby_temp_ext_bank_accts

169: l_step := 2;
170:
171: select IBY_TEMP_EXT_BANK_ACCTS_S.nextval into x_temp_ext_bank_account_id from dual;
172:
173: insert into iby_temp_ext_bank_accts
174: (
175: temp_ext_bank_acct_id
176: , status
177: , account_owner_party_id

Line 368: from iby_temp_ext_bank_accts iby

364:
365: cursor l_bank_branch_loc_cur is
366: select iby.bank_address_id, iby.branch_address_id
367: into l_bank_location_id, l_branch_location_id
368: from iby_temp_ext_bank_accts iby
369: where temp_ext_bank_acct_id = p_temp_ext_bank_acct_id;
370:
371: BEGIN
372: l_step := 0;

Line 504: update iby_temp_ext_bank_accts set

500: end if;
501:
502: l_step := 3;
503:
504: update iby_temp_ext_bank_accts set
505: status = p_status
506: , account_owner_party_id = p_party_id
507: , owner_primary_flag = p_owner_primary_flag
508: , payment_factor_flag = p_payment_factor_flag

Line 1006: from IBY_TEMP_EXT_BANK_ACCTS temp

1002: l_step number;
1003:
1004: CURSOR l_temp_account_cur is
1005: select temp.ext_bank_account_id, temp.account_owner_party_id
1006: from IBY_TEMP_EXT_BANK_ACCTS temp
1007: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
1008:
1009: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1010: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 1011: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;

1007: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
1008:
1009: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1010: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1011: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1012: l_payee_rec IBY_DISBURSEMENT_SETUP_PUB.PayeeContext_Rec_Type;
1013: l_pay_instr_rec IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
1014: l_pay_assign_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
1015: l_party_id number;

Line 1270: from IBY_TEMP_EXT_BANK_ACCTS temp, pos_acnt_gen_req req

1266: temp.bank_account_name_alt, temp.bank_account_type,
1267: temp.description, temp.end_date, temp.start_date, temp.agency_location_code,
1268: temp.status, temp.note, temp.note_alt, temp.account_suffix, temp.exchange_rate,
1269: temp.exchange_rate_agreement_num, temp.exchange_rate_agreement_type, temp.payment_factor_flag
1270: from IBY_TEMP_EXT_BANK_ACCTS temp, pos_acnt_gen_req req
1271: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id
1272: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1273: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1274:

Line 1283: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;

1279: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1280: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1281: l_joint_acct_owner_id NUMBER;
1282:
1283: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1286: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;

Line 1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;

1280: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1281: l_joint_acct_owner_id NUMBER;
1282:
1283: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1286: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1288: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;

Line 1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;

1281: l_joint_acct_owner_id NUMBER;
1282:
1283: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1286: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1288: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1289: l_bank_party_site_id number;

Line 1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;

1283: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1286: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1288: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1289: l_bank_party_site_id number;
1290: l_bank_party_site_number varchar2(2000);
1291: l_branch_party_site_id number;

Line 1288: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;

1284: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1285: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1286: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1287: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1288: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1289: l_bank_party_site_id number;
1290: l_bank_party_site_number varchar2(2000);
1291: l_branch_party_site_id number;
1292: l_branch_party_site_number varchar2(2000);

Line 1758: update iby_temp_ext_bank_accts

1754: object_version_number = object_version_number + 1
1755: where account_request_id = p_account_request_id;
1756:
1757: l_step := 3;
1758: update iby_temp_ext_bank_accts
1759: set bank_id = p_bank_id,
1760: branch_id = p_branch_id,
1761: last_update_date = sysdate,
1762: last_updated_by = fnd_global.user_id,

Line 1801: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;

1797:
1798: l_step number;
1799: l_bank_id HZ_PARTIES.party_id%TYPE;
1800: l_branch_id HZ_PARTIES.party_id%TYPE;
1801: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
1802: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1803: l_end_date DATE;
1804: l_start_date DATE;
1805: l_msg_count NUMBER;

Line 1810: select count(*) from iby_temp_ext_bank_accts iby, pos_acnt_gen_req pos

1806: l_count NUMBER;
1807: l_msg_data varchar(2000);
1808:
1809: cursor dup_temp_act_cur is
1810: select count(*) from iby_temp_ext_bank_accts iby, pos_acnt_gen_req pos
1811: where pos.mapping_id = p_mapping_id
1812: and pos.temp_ext_bank_acct_id = iby.temp_ext_bank_acct_id
1813: and (
1814: (iby.currency_code = p_currency_code

Line 1866: select 1 from IBY_TEMP_EXT_BANK_ACCTS temp

1862: OR p_EXT_BANK_ACCOUNT_ID is null)
1863: and act.country_code = p_country_code
1864: and not exists
1865: (
1866: select 1 from IBY_TEMP_EXT_BANK_ACCTS temp
1867: where temp.EXT_BANK_ACCOUNT_ID = act.ext_bank_account_id
1868: and temp.status in ('CORRECTED', 'NEW', 'IN_VERIFICATION', 'VERIFICATION_FAILED', 'CHANGE_PENDING')
1869: and temp.account_owner_party_id = o.account_owner_party_id
1870: )