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 WF_ITEMS

Line 395: l_itemtype wf_items.item_type%TYPE;

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:
398: BEGIN
399: l_step := 0;

Line 396: l_itemkey wf_items.item_key%TYPE;

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:
398: BEGIN
399: l_step := 0;
400: x_status := 'E';

Line 661: l_itemtype wf_items.item_type%TYPE;

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;
662: l_itemkey wf_items.item_key%TYPE;
663: l_account_request_id_rec l_account_request_id_cur%ROWTYPE;
664: BEGIN
665:

Line 662: l_itemkey wf_items.item_key%TYPE;

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;
662: l_itemkey wf_items.item_key%TYPE;
663: l_account_request_id_rec l_account_request_id_cur%ROWTYPE;
664: BEGIN
665:
666: l_step := 0;

Line 1002: l_itemtype wf_items.item_type%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
1005: select vendor_id from pos_supplier_mappings where party_id = p_party_id;
1006: l_vendor_id po_vendors.vendor_id%TYPE;

Line 1003: l_itemkey wf_items.item_key%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
1005: select vendor_id from pos_supplier_mappings where party_id = p_party_id;
1006: l_vendor_id po_vendors.vendor_id%TYPE;
1007:

Line 1247: l_itemtype wf_items.item_type%TYPE;

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;
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;

Line 1248: l_itemkey wf_items.item_key%TYPE;

1244:
1245: l_step number;
1246:
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:

Line 2249: l_itemtype wf_items.item_type%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;
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;

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