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_PKG dependencies on POS_ACNT_GEN_REQ

Line 97: FROM iby_temp_ext_bank_accts iby, pos_acnt_gen_req req

93:
94: -- Account Request details
95: CURSOR l_acct_status_cur IS
96: SELECT iby.status, iby.temp_ext_bank_acct_id, req.object_version_number
97: FROM iby_temp_ext_bank_accts iby, pos_acnt_gen_req req
98: WHERE req.account_request_id = p_account_request_id
99: AND iby.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id for update nowait;
100:
101: -- Assignments Impacted

Line 290: POS_SBD_TBL_PKG.del_row_pos_acnt_gen_req (

286: end loop;
287:
288: l_step := 10;
289:
290: POS_SBD_TBL_PKG.del_row_pos_acnt_gen_req (
291: p_account_request_id => p_account_request_id
292: , x_status => x_status
293: , x_exception_msg => x_exception_msg
294: );

Line 374: select account_request_id from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby

370:
371: l_party_id HZ_PARTIES.party_id%TYPE;
372:
373: CURSOR l_dup_account_req_cur is
374: select account_request_id from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby
375: WHERE iby.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id
376: AND req.mapping_id = p_mapping_id
377: AND ( (iby.bank_id = p_bank_id and p_bank_id is not null and iby.bank_id is not null) OR
378: (iby.bank_number = p_bank_number and p_bank_number is not null and iby.bank_number is not null)

Line 388: l_dup_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;

384: AND (iby.bank_account_num = p_bank_account_number OR iby.bank_account_name = p_bank_account_name)
385: AND iby.currency_code = p_currency_code
386: AND iby.country_code = p_country_code;
387:
388: l_dup_account_request_id POS_ACNT_GEN_REQ.account_request_id%TYPE;
389:
390: CURSOR l_party_id_cur is
391: select party_id, vendor_id from pos_supplier_mappings
392: where mapping_id = p_mapping_id;

Line 526: -- Create a row in POS_ACNT_GEN_REQ

522: );
523:
524: l_step := 3;
525:
526: -- Create a row in POS_ACNT_GEN_REQ
527: POS_SBD_TBL_PKG.insert_row_pos_acnt_gen_req (
528: p_mapping_id => p_mapping_id
529: , p_temp_ext_bank_account_id => l_temp_ext_bank_account_id
530: , p_ext_bank_account_id => p_ext_bank_account_id

Line 527: POS_SBD_TBL_PKG.insert_row_pos_acnt_gen_req (

523:
524: l_step := 3;
525:
526: -- Create a row in POS_ACNT_GEN_REQ
527: POS_SBD_TBL_PKG.insert_row_pos_acnt_gen_req (
528: p_mapping_id => p_mapping_id
529: , p_temp_ext_bank_account_id => l_temp_ext_bank_account_id
530: , p_ext_bank_account_id => p_ext_bank_account_id
531: , x_account_request_id => x_account_request_id

Line 652: l_temp_ext_bank_account_id pos_acnt_gen_req.temp_ext_bank_acct_id%TYPE;

648: CURSOR l_party_id_cur is
649: select party_id, vendor_id from pos_supplier_mappings
650: where mapping_id = p_mapping_id;
651:
652: l_temp_ext_bank_account_id pos_acnt_gen_req.temp_ext_bank_acct_id%TYPE;
653: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;
654:
655: CURSOR l_account_request_id_cur is
656: select req.temp_ext_bank_acct_id, iby.note_alt, req.object_version_number, iby.status

Line 653: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;

649: select party_id, vendor_id from pos_supplier_mappings
650: where mapping_id = p_mapping_id;
651:
652: l_temp_ext_bank_account_id pos_acnt_gen_req.temp_ext_bank_acct_id%TYPE;
653: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;
654:
655: CURSOR l_account_request_id_cur is
656: select req.temp_ext_bank_acct_id, iby.note_alt, req.object_version_number, iby.status
657: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby

Line 657: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby

653: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;
654:
655: CURSOR l_account_request_id_cur is
656: select req.temp_ext_bank_acct_id, iby.note_alt, req.object_version_number, iby.status
657: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby
658: where req.account_request_id = p_account_request_id
659: and req.temp_ext_bank_acct_id = iby.temp_ext_bank_acct_id for update nowait;
660:
661: l_itemtype wf_items.item_type%TYPE;

Line 877: -- Create a row in POS_ACNT_GEN_REQ

873: );
874:
875: l_step := 5;
876:
877: -- Create a row in POS_ACNT_GEN_REQ
878: POS_SBD_TBL_PKG.insert_row_pos_acnt_gen_req (
879: p_mapping_id => p_mapping_id
880: , p_temp_ext_bank_account_id => l_temp_ext_bank_account_id
881: , p_ext_bank_account_id => p_ext_bank_account_id

Line 878: POS_SBD_TBL_PKG.insert_row_pos_acnt_gen_req (

874:
875: l_step := 5;
876:
877: -- Create a row in POS_ACNT_GEN_REQ
878: POS_SBD_TBL_PKG.insert_row_pos_acnt_gen_req (
879: p_mapping_id => p_mapping_id
880: , p_temp_ext_bank_account_id => l_temp_ext_bank_account_id
881: , p_ext_bank_account_id => p_ext_bank_account_id
882: , x_account_request_id => x_account_request_id

Line 990: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby

986: l_notes_from_supplier iby_temp_ext_bank_accts.note%TYPE;
987: CURSOR l_account_request_cur is
988: select req.temp_ext_bank_acct_id, req.object_version_number, iby.note, iby.status,
989: iby.ext_bank_account_id, iby.bank_id, iby.branch_id
990: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby
991: where account_request_id = p_account_request_id
992: and iby.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id;
993: l_account_request_rec l_account_request_cur%ROWTYPE;
994:

Line 995: l_object_version_number POS_ACNT_GEN_REQ.object_version_number%TYPE;

991: where account_request_id = p_account_request_id
992: and iby.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id;
993: l_account_request_rec l_account_request_cur%ROWTYPE;
994:
995: l_object_version_number POS_ACNT_GEN_REQ.object_version_number%TYPE;
996: l_step number;
997: l_account_status iby_temp_ext_bank_accts.status%TYPE;
998: l_bank_id iby_temp_ext_bank_accts.bank_id%TYPE;
999: l_branch_id iby_temp_ext_bank_accts.branch_id%TYPE;

Line 1239: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby

1235:
1236: l_notes_from_supplier iby_temp_ext_bank_accts.note%TYPE;
1237: CURSOR l_account_request_id_cur is
1238: select req.temp_ext_bank_acct_id, req.object_version_number, iby.note
1239: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby
1240: where account_request_id = p_account_request_id
1241: and iby.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id for update nowait;
1242:
1243: l_object_version_number POS_ACNT_GEN_REQ.object_version_number%TYPE;

Line 1243: l_object_version_number POS_ACNT_GEN_REQ.object_version_number%TYPE;

1239: from pos_acnt_gen_req req, iby_temp_ext_bank_accts iby
1240: where account_request_id = p_account_request_id
1241: and iby.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id for update nowait;
1242:
1243: l_object_version_number POS_ACNT_GEN_REQ.object_version_number%TYPE;
1244:
1245: l_step number;
1246:
1247: l_itemtype wf_items.item_type%TYPE;

Line 1387: POS_SBD_TBL_PKG.del_row_pos_acnt_gen_req (

1383: , x_exception_msg => x_exception_msg
1384: );
1385:
1386: l_step := 5;
1387: POS_SBD_TBL_PKG.del_row_pos_acnt_gen_req (
1388: p_account_request_id => p_account_request_id
1389: , x_status => x_status
1390: , x_exception_msg => x_exception_msg
1391: );

Line 1925: iby_ext_bank_accounts act, pos_supplier_mappings pmap, pos_acnt_gen_req req

1921:
1922: cursor l_assign_iby_cur is
1923: select uses.order_of_preference, uses.start_date, uses.end_date, uses.instrument_id, req.account_request_id
1924: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee,
1925: iby_ext_bank_accounts act, pos_supplier_mappings pmap, pos_acnt_gen_req req
1926: where uses.instrument_type = 'BANKACCOUNT'
1927: and payee.ext_payee_id = uses.ext_pmt_party_id
1928: and payee.org_id is null
1929: and ((payee.party_site_id = p_party_site_id

Line 2236: from pos_acnt_gen_req req, iby_temp_ext_bank_accts temp, pos_supplier_mappings pmap

2232:
2233: cursor l_account_request_cur is
2234: select temp.status, req.object_version_number, req.temp_ext_bank_acct_id, pmap.vendor_id,
2235: temp.bank_account_num, temp.bank_name
2236: from pos_acnt_gen_req req, iby_temp_ext_bank_accts temp, pos_supplier_mappings pmap
2237: where req.account_request_id = p_account_request_id
2238: and temp.temp_ext_bank_acct_id = req.temp_ext_bank_acct_id
2239: and pmap.mapping_id = req.mapping_id;
2240:

Line 2245: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;

2241: l_account_request_rec l_account_request_cur%ROWTYPE;
2242:
2243: l_step number;
2244: l_status iby_temp_ext_bank_accts.status%TYPE;
2245: l_object_version_number pos_acnt_gen_req.object_version_number%TYPE;
2246: l_temp_ext_bank_acct_id iby_temp_ext_bank_accts.temp_ext_bank_acct_id%TYPE;
2247:
2248:
2249: l_itemtype wf_items.item_type%TYPE;

Line 2324: POS_SBD_TBL_PKG.del_row_pos_acnt_gen_req (

2320: , x_exception_msg => x_exception_msg
2321: );
2322:
2323: l_step := 5;
2324: POS_SBD_TBL_PKG.del_row_pos_acnt_gen_req (
2325: p_account_request_id => p_account_request_id
2326: , x_status => x_status
2327: , x_exception_msg => x_exception_msg
2328: );