190: if (x_dest_sub_inv is not null) then
191: x_subinv_type := check_sub_inv_type(itemtype, itemkey, x_dest_sub_inv,
192: x_dest_org_id);
193: end if;
194: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_INV_ACCT;
195: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := x_inv_item_type;
196: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := x_subinv_type;
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
191: x_subinv_type := check_sub_inv_type(itemtype, itemkey, x_dest_sub_inv,
192: x_dest_org_id);
193: end if;
194: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_INV_ACCT;
195: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := x_inv_item_type;
196: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := x_subinv_type;
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
199: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
192: x_dest_org_id);
193: end if;
194: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_INV_ACCT;
195: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := x_inv_item_type;
196: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := x_subinv_type;
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
199: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
200:
193: end if;
194: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_INV_ACCT;
195: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := x_inv_item_type;
196: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := x_subinv_type;
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
199: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
200:
201: GMF_transaction_accounts_PUB.get_accounts(
194: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_INV_ACCT;
195: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := x_inv_item_type;
196: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := x_subinv_type;
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
199: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
200:
201: GMF_transaction_accounts_PUB.get_accounts(
202: p_api_version => 1.0,
195: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := x_inv_item_type;
196: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := x_subinv_type;
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
199: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
200:
201: GMF_transaction_accounts_PUB.get_accounts(
202: p_api_version => 1.0,
203: p_init_msg_list => dummy,
197: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
198: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
199: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
200:
201: GMF_transaction_accounts_PUB.get_accounts(
202: p_api_version => 1.0,
203: p_init_msg_list => dummy,
204: p_source => 'PO',
205: x_return_status => X_status,
204: p_source => 'PO',
205: x_return_status => X_status,
206: x_msg_data => x_msg_data,
207: x_msg_count => x_msg_count);
208: x_account := GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).target_ccid;
209: --
210: ELSE
211:
212:
519: then
520: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'VENDOR_SITE_ID');
523: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';
525: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := '';
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
520: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'VENDOR_SITE_ID');
523: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';
525: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := '';
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
521: itemkey => itemkey,
522: aname => 'VENDOR_SITE_ID');
523: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';
525: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := '';
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
529:
522: aname => 'VENDOR_SITE_ID');
523: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';
525: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := '';
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
529:
530: GMF_transaction_accounts_PUB.get_accounts(
523: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';
525: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := '';
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
529:
530: GMF_transaction_accounts_PUB.get_accounts(
531: p_api_version => 1.0,
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';
525: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).subinventory_type := '';
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
529:
530: GMF_transaction_accounts_PUB.get_accounts(
531: p_api_version => 1.0,
532: p_init_msg_list => dummy,
526: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).organization_id := x_dest_org_id;
527: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).inventory_item_id := x_item_id;
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).vendor_site_id := x_vendor_site_id;
529:
530: GMF_transaction_accounts_PUB.get_accounts(
531: p_api_version => 1.0,
532: p_init_msg_list => dummy,
533: p_source => 'PO',
534: x_return_status => X_status,
533: p_source => 'PO',
534: x_return_status => X_status,
535: x_msg_data => x_msg_data,
536: x_msg_count => x_msg_count);
537: x_expense_acc := GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).target_ccid;
538:
539: /* GML_ACCT_GENERATE.GENERATE_OPM_ACCT('EXPENSE','', '', x_dest_org_id, x_item_id, x_vendor_site_id, x_expense_acc); */
540: If (x_expense_acc is null) then
541: success := 'N';