[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: --
146:
147: begin
148:
149: --Bug# 1902716 togeorge 07/25/2001
150: --EAM: if item id is null get the accrual account from po_system_parameters
151: -- (one time items can be delivered to shopfloor with eam)
152: IF x_item_id is not null then
153: select ap_accrual_account into x_account
154: from mtl_parameters
154: from mtl_parameters
155: where organization_id = x_dest_org_id;
156: ELSE --treating it as an expense item.
157: select accrued_code_combination_id into x_account
158: from po_system_parameters;
159: END IF;
160: --
161:
162: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
265: --
266:
267: begin
268: select accrued_code_combination_id into x_account
269: from po_system_parameters;
270:
271: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
272: itemkey=>itemkey,
273: aname=>'TEMP_ACCOUNT_ID',
374: --SQL WHY: To potentially default this as the PO Accrual Account for SPS case
375: BEGIN
376: SELECT accrued_code_combination_id
377: INTO l_account_id
378: FROM PO_SYSTEM_PARAMETERS_ALL
379: WHERE org_id = l_purchasing_ou_id;
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: l_account_id := NULL;