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 988: from IBY_TEMP_EXT_BANK_ACCTS temp

984: l_step number;
985:
986: CURSOR l_temp_account_cur is
987: select temp.ext_bank_account_id, temp.account_owner_party_id
988: from IBY_TEMP_EXT_BANK_ACCTS temp
989: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
990:
991: l_temp_account_rec l_temp_account_cur%ROWTYPE;
992: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 993: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;

989: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id;
990:
991: l_temp_account_rec l_temp_account_cur%ROWTYPE;
992: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
993: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
994: l_payee_rec IBY_DISBURSEMENT_SETUP_PUB.PayeeContext_Rec_Type;
995: l_pay_instr_rec IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type;
996: l_pay_assign_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;
997: l_party_id number;

Line 1251: from IBY_TEMP_EXT_BANK_ACCTS temp, pos_acnt_gen_req req

1247: temp.bank_account_name_alt, temp.bank_account_type,
1248: temp.description, temp.end_date, temp.start_date, temp.agency_location_code,
1249: temp.status, temp.note, temp.note_alt, temp.account_suffix, temp.exchange_rate,
1250: temp.exchange_rate_agreement_num, temp.exchange_rate_agreement_type, temp.payment_factor_flag
1251: from IBY_TEMP_EXT_BANK_ACCTS temp, pos_acnt_gen_req req
1252: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id
1253: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1254: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1255:

Line 1264: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;

1260: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1261: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1262: l_joint_acct_owner_id NUMBER;
1263:
1264: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1267: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;

Line 1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;

1261: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1262: l_joint_acct_owner_id NUMBER;
1263:
1264: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1267: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1269: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;

Line 1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;

1262: l_joint_acct_owner_id NUMBER;
1263:
1264: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1267: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1269: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1270: l_bank_party_site_id number;

Line 1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;

1264: l_bank_id IBY_TEMP_EXT_BANK_ACCTS.bank_id%TYPE;
1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1267: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1269: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1270: l_bank_party_site_id number;
1271: l_bank_party_site_number varchar2(2000);
1272: l_branch_party_site_id number;

Line 1269: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;

1265: l_branch_id IBY_TEMP_EXT_BANK_ACCTS.branch_id%TYPE;
1266: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.ext_bank_account_id%TYPE;
1267: l_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
1268: l_bank_address_id IBY_TEMP_EXT_BANK_ACCTS.bank_address_id%TYPE;
1269: l_branch_address_id IBY_TEMP_EXT_BANK_ACCTS.branch_address_id%TYPE;
1270: l_bank_party_site_id number;
1271: l_bank_party_site_number varchar2(2000);
1272: l_branch_party_site_id number;
1273: l_branch_party_site_number varchar2(2000);

Line 1723: update iby_temp_ext_bank_accts

1719: object_version_number = object_version_number + 1
1720: where account_request_id = p_account_request_id;
1721:
1722: l_step := 3;
1723: update iby_temp_ext_bank_accts
1724: set bank_id = p_bank_id,
1725: branch_id = p_branch_id,
1726: last_update_date = sysdate,
1727: last_updated_by = fnd_global.user_id,

Line 1766: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;

1762:
1763: l_step number;
1764: l_bank_id HZ_PARTIES.party_id%TYPE;
1765: l_branch_id HZ_PARTIES.party_id%TYPE;
1766: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
1767: l_record_type IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1768: l_end_date DATE;
1769: l_start_date DATE;
1770: l_msg_count NUMBER;

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

1771: l_count NUMBER;
1772: l_msg_data varchar(2000);
1773:
1774: cursor dup_temp_act_cur is
1775: select count(*) from iby_temp_ext_bank_accts iby, pos_acnt_gen_req pos
1776: where pos.mapping_id = p_mapping_id
1777: and pos.temp_ext_bank_acct_id = iby.temp_ext_bank_acct_id
1778: and (
1779: (iby.currency_code = p_currency_code

Line 1831: select 1 from IBY_TEMP_EXT_BANK_ACCTS temp

1827: OR p_EXT_BANK_ACCOUNT_ID is null)
1828: and act.country_code = p_country_code
1829: and not exists
1830: (
1831: select 1 from IBY_TEMP_EXT_BANK_ACCTS temp
1832: where temp.EXT_BANK_ACCOUNT_ID = act.ext_bank_account_id
1833: and temp.status in ('CORRECTED', 'NEW', 'IN_VERIFICATION', 'VERIFICATION_FAILED', 'CHANGE_PENDING')
1834: and temp.account_owner_party_id = o.account_owner_party_id
1835: )