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 IBY_TEMP_EXT_BANK_ACCTS

Line 91: l_status IBY_TEMP_EXT_BANK_ACCTS.status%TYPE;

87: , x_exception_msg out nocopy VARCHAR2
88: )
89: IS
90: l_step NUMBER;
91: l_status IBY_TEMP_EXT_BANK_ACCTS.status%TYPE;
92: l_temp_ext_bank_account_id NUMBER;
93:
94: -- Account Request details
95: CURSOR l_acct_status_cur IS

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 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 461: -- Create a row in IBY_TEMP_EXT_BANK_ACCTS

457: close l_party_id_cur;
458:
459: l_step := 2;
460:
461: -- Create a row in IBY_TEMP_EXT_BANK_ACCTS
462: POS_SBD_IBY_PKG.create_iby_temp_account (
463: p_party_id => l_party_id
464: , p_status => 'NEW'
465: , p_owner_primary_flag => 'Y'

Line 645: l_status iby_temp_ext_bank_accts.status%TYPE;

641: )
642: IS
643: l_step number;
644: l_party_id HZ_PARTIES.party_id%TYPE;
645: l_status iby_temp_ext_bank_accts.status%TYPE;
646: l_vendor_id po_vendors.vendor_id%TYPE;
647:
648: CURSOR l_party_id_cur is
649: select party_id, vendor_id from pos_supplier_mappings

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 738: -- Update the row in IBY_TEMP_EXT_BANK_ACCTS

734: end if;
735:
736: l_step := 3;
737:
738: -- Update the row in IBY_TEMP_EXT_BANK_ACCTS
739: POS_SBD_IBY_PKG.update_iby_temp_account (
740: p_temp_ext_bank_acct_id => l_account_request_id_rec.temp_ext_bank_acct_id
741: , p_party_id => l_party_id
742: , p_status => l_status

Line 812: -- Create a row in IBY_TEMP_EXT_BANK_ACCTS

808: else
809: l_status := 'NEW';
810: end if;
811:
812: -- Create a row in IBY_TEMP_EXT_BANK_ACCTS
813: POS_SBD_IBY_PKG.create_iby_temp_account (
814: p_party_id => l_party_id
815: , p_status => l_status
816: , p_owner_primary_flag => 'Y'

Line 986: l_notes_from_supplier iby_temp_ext_bank_accts.note%TYPE;

982: IS
983:
984: l_temp_ext_bank_account_id number;
985:
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

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 997: l_account_status iby_temp_ext_bank_accts.status%TYPE;

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;
1000: l_ext_bank_account_id iby_temp_ext_bank_accts.ext_bank_account_id%TYPE;
1001:

Line 998: l_bank_id iby_temp_ext_bank_accts.bank_id%TYPE;

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;
1000: l_ext_bank_account_id iby_temp_ext_bank_accts.ext_bank_account_id%TYPE;
1001:
1002: l_itemtype wf_items.item_type%TYPE;

Line 999: l_branch_id iby_temp_ext_bank_accts.branch_id%TYPE;

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;
1000: l_ext_bank_account_id iby_temp_ext_bank_accts.ext_bank_account_id%TYPE;
1001:
1002: l_itemtype wf_items.item_type%TYPE;
1003: l_itemkey wf_items.item_key%TYPE;

Line 1000: l_ext_bank_account_id iby_temp_ext_bank_accts.ext_bank_account_id%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;
1000: l_ext_bank_account_id iby_temp_ext_bank_accts.ext_bank_account_id%TYPE;
1001:
1002: l_itemtype wf_items.item_type%TYPE;
1003: l_itemkey wf_items.item_key%TYPE;
1004: CURSOR l_vendor_cur is

Line 1074: -- Update the row in IBY_TEMP_EXT_BANK_ACCTS

1070: if (l_object_version_number = p_object_version_number) then
1071:
1072: l_step := 2;
1073:
1074: -- Update the row in IBY_TEMP_EXT_BANK_ACCTS
1075: POS_SBD_IBY_PKG.update_iby_temp_account (
1076: p_temp_ext_bank_acct_id => l_temp_ext_bank_account_id
1077: , p_party_id => p_party_id
1078: , p_status => 'IN_VERIFICATION'

Line 1236: l_notes_from_supplier iby_temp_ext_bank_accts.note%TYPE;

1232: )
1233: IS
1234: l_temp_ext_bank_account_id number;
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

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 1306: -- Update the row in IBY_TEMP_EXT_BANK_ACCTS

1302: if (l_object_version_number = p_object_version_number) then
1303:
1304: l_step := 2;
1305:
1306: -- Update the row in IBY_TEMP_EXT_BANK_ACCTS
1307: POS_SBD_IBY_PKG.update_iby_temp_account (
1308: p_temp_ext_bank_acct_id => l_temp_ext_bank_account_id
1309: , p_party_id => p_party_id
1310: , p_status => 'APPROVED'

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 2244: l_status iby_temp_ext_bank_accts.status%TYPE;

2240:
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:

Line 2246: l_temp_ext_bank_acct_id iby_temp_ext_bank_accts.temp_ext_bank_acct_id%TYPE;

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;
2250: l_itemkey wf_items.item_key%TYPE;

Line 2252: l_bank_account_number iby_temp_ext_bank_accts.bank_account_num%TYPE;

2248:
2249: l_itemtype wf_items.item_type%TYPE;
2250: l_itemkey wf_items.item_key%TYPE;
2251:
2252: l_bank_account_number iby_temp_ext_bank_accts.bank_account_num%TYPE;
2253: l_bank_name iby_temp_ext_bank_accts.bank_name%TYPE;
2254: l_vendor_id po_vendors.vendor_id%TYPE;
2255: l_ntf_status iby_temp_ext_bank_accts.status%TYPE;
2256:

Line 2253: l_bank_name iby_temp_ext_bank_accts.bank_name%TYPE;

2249: l_itemtype wf_items.item_type%TYPE;
2250: l_itemkey wf_items.item_key%TYPE;
2251:
2252: l_bank_account_number iby_temp_ext_bank_accts.bank_account_num%TYPE;
2253: l_bank_name iby_temp_ext_bank_accts.bank_name%TYPE;
2254: l_vendor_id po_vendors.vendor_id%TYPE;
2255: l_ntf_status iby_temp_ext_bank_accts.status%TYPE;
2256:
2257: BEGIN

Line 2255: l_ntf_status iby_temp_ext_bank_accts.status%TYPE;

2251:
2252: l_bank_account_number iby_temp_ext_bank_accts.bank_account_num%TYPE;
2253: l_bank_name iby_temp_ext_bank_accts.bank_name%TYPE;
2254: l_vendor_id po_vendors.vendor_id%TYPE;
2255: l_ntf_status iby_temp_ext_bank_accts.status%TYPE;
2256:
2257: BEGIN
2258:
2259: x_status := 'E';

Line 2307: update iby_temp_ext_bank_accts

2303: end if;
2304:
2305: if l_status = 'IN_VERIFICATION' OR l_status = 'CORRECTED' then
2306: l_step := 3;
2307: update iby_temp_ext_bank_accts
2308: set status = 'VERIFICATION_FAILED', note_alt = p_note_from_buyer
2309: where temp_ext_bank_acct_id = l_temp_ext_bank_acct_id;
2310: l_ntf_status := 'VERIFICATION_FAILED';
2311: end if;

Line 2633: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;

2629: , x_exception_msg out nocopy VARCHAR2)
2630: IS
2631: l_end_date DATE;
2632: l_start_date DATE;
2633: l_ext_bank_account_id IBY_TEMP_EXT_BANK_ACCTS.EXT_BANK_ACCOUNT_ID%TYPE;
2634: l_party_id ap_suppliers.party_id%TYPE;
2635: l_supplier_name ap_suppliers.vendor_name%TYPE;
2636: l_supplier_number ap_suppliers.segment1%TYPE;
2637: l_msg_count NUMBER;