[Home] [Help]
77: x_progress varchar2(100);
78: x_account number;
79: x_dest_org_id number;
80: --Bug# 1902716 togeorge 07/25/2001
81: --EAM: if item id is null get the accrual account from po_system_parameters
82: -- (one time items can be delivered to shopfloor with eam)
83: x_item_id number;
84: --
85: --
149: */
150: begin
151:
152: --Bug# 1902716 togeorge 07/25/2001
153: --EAM: if item id is null get the accrual account from po_system_parameters
154: -- (one time items can be delivered to shopfloor with eam)
155: IF x_item_id is not null then
156: select ap_accrual_account into x_account
157: from mtl_parameters
157: from mtl_parameters
158: where organization_id = x_dest_org_id;
159: ELSE --treating it as an expense item.
160: select accrued_code_combination_id into x_account
161: from po_system_parameters;
162: END IF;
163: --
164:
165: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
271: --
272: */
273: begin
274: select accrued_code_combination_id into x_account
275: from po_system_parameters;
276:
277: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
278: itemkey=>itemkey,
279: aname=>'TEMP_ACCOUNT_ID',
380: --SQL WHY: To potentially default this as the PO Accrual Account for SPS case
381: BEGIN
382: SELECT accrued_code_combination_id
383: INTO l_account_id
384: FROM PO_SYSTEM_PARAMETERS_ALL
385: WHERE org_id = l_purchasing_ou_id;
386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN
388: l_account_id := NULL;