APPS.POS_SBD_PKG dependencies on PO_VENDORS

Line 393: l_vendor_id po_vendors.vendor_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;
393: l_vendor_id po_vendors.vendor_id%TYPE;
394:
395: l_itemtype wf_items.item_type%TYPE;
396: l_itemkey wf_items.item_key%TYPE;
397:

Line 646: l_vendor_id po_vendors.vendor_id%TYPE;

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
650: where mapping_id = p_mapping_id;

Line 1006: l_vendor_id po_vendors.vendor_id%TYPE;

1002: l_itemtype wf_items.item_type%TYPE;
1003: l_itemkey wf_items.item_key%TYPE;
1004: CURSOR l_vendor_cur is
1005: select vendor_id from pos_supplier_mappings where party_id = p_party_id;
1006: l_vendor_id po_vendors.vendor_id%TYPE;
1007:
1008: BEGIN
1009:
1010: l_step := 0;

Line 1251: l_vendor_id po_vendors.vendor_id%TYPE;

1247: l_itemtype wf_items.item_type%TYPE;
1248: l_itemkey wf_items.item_key%TYPE;
1249: CURSOR l_vendor_cur is
1250: select vendor_id from pos_supplier_mappings where party_id = p_party_id;
1251: l_vendor_id po_vendors.vendor_id%TYPE;
1252:
1253: BEGIN
1254:
1255: l_step := 0;

Line 2254: l_vendor_id po_vendors.vendor_id%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
2258: