DBA Data[Home] [Help]

APPS.PO_WF_PO_VARIANCE_ACC dependencies on PO_WF_UTIL_PKG

Line 47: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

43: return;
44:
45: end if;
46:
47: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
48: itemkey => itemkey,
49: aname => 'DESTINATION_TYPE_CODE');
50: if x_destination_type = 'EXPENSE' then
51: result := 'COMPLETE:EXPENSE';

Line 104: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

100: return;
101:
102: end if;
103:
104: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
105: itemkey => itemkey,
106: aname => 'DESTINATION_ORGANIZATION_ID');
107: --Bug# 1902716 togeorge 07/25/2001
108: --EAM: if item id is null get the accrual account from po_system_parameters

Line 110: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

106: aname => 'DESTINATION_ORGANIZATION_ID');
107: --Bug# 1902716 togeorge 07/25/2001
108: --EAM: if item id is null get the accrual account from po_system_parameters
109: -- (one time items can be delivered to shopfloor with eam)
110: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
111: itemkey => itemkey,
112: aname => 'ITEM_ID');
113:
114: -- Bug 4008665: Get the destination type code.

Line 134: x_account:=po_wf_util_pkg.GetItemAttrNumber (

130: select invoice_price_var_account into x_account
131: from mtl_parameters
132: where organization_id = x_dest_org_id;
133: ELSE --treat like an expense item, directly copy the charge account here.
134: x_account:=po_wf_util_pkg.GetItemAttrNumber (
135: itemtype => itemtype,
136: itemkey => itemkey,
137: aname => 'CODE_COMBINATION_ID');
138: END IF;

Line 140: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,

136: itemkey => itemkey,
137: aname => 'CODE_COMBINATION_ID');
138: END IF;
139: --
140: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
141: itemkey=>itemkey,
142: aname=>'TEMP_ACCOUNT_ID',
143: avalue=>x_account );
144:

Line 203: x_ccid := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

199: begin
200:
201: -- get code_combination_id from item attribute
202:
203: x_ccid := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'CODE_COMBINATION_ID');
206:
207: if (x_ccid IS NOT NULL) then

Line 209: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,

205: aname => 'CODE_COMBINATION_ID');
206:
207: if (x_ccid IS NOT NULL) then
208:
209: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
210: itemkey=>itemkey,
211: aname=>'TEMP_ACCOUNT_ID',
212: avalue=>x_ccid );
213: result := 'COMPLETE:SUCCESS';

Line 272: l_dest_variance_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

268: RETURN;
269: END IF;
270:
271: l_progress := '020';
272: l_dest_variance_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
273: itemtype => itemtype,
274: itemkey => itemkey,
275: aname => 'DEST_VARIANCE_ACCOUNT_ID');
276:

Line 293: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,

289: ELSE
290: -- If the Dest Variance Account is not null (only one case -- autocreate),
291: -- then copy it into the TEMP_ACCOUNT_ID.
292: l_progress := '040';
293: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
294: itemkey => itemkey,
295: aname => 'TEMP_ACCOUNT_ID',
296: avalue => l_dest_variance_account_id);
297: l_progress := '050';

Line 360: l_dest_charge_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

356: RETURN;
357: END IF;
358:
359: l_progress := '020';
360: l_dest_charge_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
361: itemtype => itemtype,
362: itemkey => itemkey,
363: aname => 'DEST_CHARGE_ACCOUNT_ID');
364:

Line 378: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,

374: l_dest_charge_account_id = -1 THEN
375: result := WF_ENGINE.eng_completed || ':FAILURE';
376: ELSE
377: l_progress := '040';
378: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'TEMP_ACCOUNT_ID',
381: avalue => l_dest_charge_account_id);
382: l_progress := '050';

Line 450: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,

446: result := wf_engine.eng_null;
447: RETURN;
448: END IF;
449:
450: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
451: itemkey => itemkey,
452: aname => 'DESTINATION_ORGANIZATION_ID');
453:
454: --EAM: if item id is null get the accrual account from po_system_parameters

Line 456: x_item_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,

452: aname => 'DESTINATION_ORGANIZATION_ID');
453:
454: --EAM: if item id is null get the accrual account from po_system_parameters
455: -- (one time items can be delivered to shopfloor with eam)
456: x_item_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
457: itemkey => itemkey,
458: aname => 'ITEM_ID');
459:
460: IF x_item_id IS NOT NULL THEN

Line 470: x_account := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

466: WHEN no_data_found THEN
467: NULL;
468: END;
469: ELSE --treat like an expense item, directly copy the dest charge account here
470: x_account := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'DEST_CHARGE_ACCOUNT_ID');
473:
474: x_progress := 'PO_WF_PO_VARIANCE_ACC.dest_VA_from_org : 02';

Line 481: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,

477: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
478: END IF;
479: END IF;
480:
481: po_wf_util_pkg.SetItemAttrNumber(itemtype => itemtype,
482: itemkey => itemkey,
483: aname => 'TEMP_ACCOUNT_ID',
484: avalue => x_account);
485: