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.CN_WF_PMT_PKG dependencies on WF_ENGINE

Line 69: wf_engine.CreateProcess( ItemType => p_Item_Type,

65: open get_accgen_type;
66: fetch get_accgen_type into l_accgen_type;
67: close get_accgen_type;
68:
69: wf_engine.CreateProcess( ItemType => p_Item_Type,
70: ItemKey => ItemKey,
71: process => p_WorkflowProcess );
72:
73: wf_engine.SetItemUserKey ( ItemType => p_Item_Type,

Line 73: wf_engine.SetItemUserKey ( ItemType => p_Item_Type,

69: wf_engine.CreateProcess( ItemType => p_Item_Type,
70: ItemKey => ItemKey,
71: process => p_WorkflowProcess );
72:
73: wf_engine.SetItemUserKey ( ItemType => p_Item_Type,
74: ItemKey => ItemKey,
75: UserKey => ItemUserKey);
76:
77: FOR i IN get_details LOOP

Line 91: wf_engine.SetItemAttrNumber ( itemtype => p_item_type,

87:
88:
89:
90:
91: wf_engine.SetItemAttrNumber ( itemtype => p_item_type,
92: itemkey => itemkey,
93: aname => 'POSTING_DETAIL_ID',
94: avalue => p_posting_detail_id);
95:

Line 97: wf_engine.SetItemAttrText ( itemtype => p_item_type,

93: aname => 'POSTING_DETAIL_ID',
94: avalue => p_posting_detail_id);
95:
96: --+
97: wf_engine.SetItemAttrText ( itemtype => p_item_type,
98: itemkey => itemkey,
99: aname => 'QUOTA_ID',
100: avalue => i.quota_id);
101:

Line 106: wf_engine.SetItemAttrText ( itemtype => p_item_type,

102: --+
103: -- changes for bug#2568937
104: IF l_profile_value = 'Y' THEN
105:
106: wf_engine.SetItemAttrText ( itemtype => p_item_type,
107: itemkey => itemkey,
108: aname => 'REVENUE_CLASS_ID',
109: avalue => l_revenue_class_id);
110:

Line 113: wf_engine.SetItemAttrText ( itemtype => p_item_type,

109: avalue => l_revenue_class_id);
110:
111: END IF;
112: --+
113: wf_engine.SetItemAttrText ( itemtype => p_item_type,
114: itemkey => itemkey,
115: aname => 'ACCGEN_TYPE',
116: avalue => l_accgen_type);
117: -- changes for bug#2568937

Line 121: wf_engine.SetItemAttrText ( itemtype => p_item_type,

117: -- changes for bug#2568937
118: IF l_profile_value = 'Y' THEN
119:
120: -- Added KS
121: wf_engine.SetItemAttrText ( itemtype => p_item_type,
122: itemkey => itemkey,
123: aname => 'COMMISSION_HEADER_ID',
124: avalue => i.commission_header_id);
125: END IF;

Line 130: wf_engine.SetItemOwner ( itemtype => p_item_type,

126:
127: END LOOP;
128:
129:
130: wf_engine.SetItemOwner ( itemtype => p_item_type,
131: itemkey => itemkey,
132: owner => p_ProcessOwner );
133:
134: --+

Line 136: wf_engine.StartProcess( itemtype => p_item_type,

132: owner => p_ProcessOwner );
133:
134: --+
135:
136: wf_engine.StartProcess( itemtype => p_item_type,
137: itemkey => itemkey );
138:
139: --+
140: exception

Line 219: l_expense_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,

215: begin
216: --+
217: -- RUN mode - normal process execution
218: --+
219: l_expense_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'EXPENSE_CCID');
222: l_liability_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,
223: itemkey => itemkey,

Line 222: l_liability_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,

218: --+
219: l_expense_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'EXPENSE_CCID');
222: l_liability_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,
223: itemkey => itemkey,
224: aname => 'LIABILITY_CCID');
225: l_posting_detail_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
226: itemkey => itemkey,

Line 225: l_posting_detail_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

221: aname => 'EXPENSE_CCID');
222: l_liability_ccid := wf_engine.GetItemAttrNumber( itemtype => itemtype,
223: itemkey => itemkey,
224: aname => 'LIABILITY_CCID');
225: l_posting_detail_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'POSTING_DETAIL_ID');
228: if (funcmode = 'RUN') then
229: update cn_payment_transactions_all

Line 300: l_accgen_type := wf_engine.GetItemAttrText( itemtype => itemtype,

296: l_payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE;
297: l_itc cn_payment_transactions.incentive_type_code%TYPE;
298:
299: begin
300: l_accgen_type := wf_engine.GetItemAttrText( itemtype => itemtype,
301: itemkey => itemkey,
302: aname => 'ACCGEN_TYPE');
303:
304: --Bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.

Line 305: l_payment_transaction_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

301: itemkey => itemkey,
302: aname => 'ACCGEN_TYPE');
303:
304: --Bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.
305: l_payment_transaction_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
306: itemkey => itemkey,
307: aname => 'POSTING_DETAIL_ID');
308:
309: SELECT pr.payrun_mode, pr.org_id , cnpt.incentive_type_code

Line 320: l_ccid_identifier := wf_engine.GetItemAttrNumber( itemtype => itemtype,itemkey => itemkey,aname => 'REVENUE_CLASS_ID');

316: -- changes for bug#2568937
317: --Bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.
318: IF l_accgen_type = 'REVCLS' AND l_profile_value = 'Y' AND l_itc IN ('COMMISSION','BONUS') THEN
319:
320: l_ccid_identifier := wf_engine.GetItemAttrNumber( itemtype => itemtype,itemkey => itemkey,aname => 'REVENUE_CLASS_ID');
321: SELECT expense_account_id, liability_account_id
322: INTO l_expense_ccid, l_liability_ccid
323: FROM cn_revenue_classes_all
324: WHERE revenue_class_id = l_ccid_identifier;

Line 327: l_ccid_identifier := wf_engine.GetItemAttrNumber( itemtype => itemtype,

323: FROM cn_revenue_classes_all
324: WHERE revenue_class_id = l_ccid_identifier;
325:
326: ELSIF l_accgen_type = 'PLANELEM' THEN
327: l_ccid_identifier := wf_engine.GetItemAttrNumber( itemtype => itemtype,
328: itemkey => itemkey,
329: aname => 'QUOTA_ID');
330: SELECT expense_account_id, liability_account_id
331: INTO l_expense_ccid, l_liability_ccid

Line 338: l_ccid_identifier := wf_engine.getitemattrnumber

334:
335: -- changes for bug#2568937
336: --Bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.
337: ELSIF l_accgen_type = 'CLASSIFICATION' AND l_profile_value = 'Y' AND l_itc IN ('COMMISSION','BONUS') THEN
338: l_ccid_identifier := wf_engine.getitemattrnumber
339: ( itemtype => itemtype,
340: itemkey => itemkey,
341: aname => 'COMMISSION_HEADER_ID');
342: IF l_cached_org_id = -99 then

Line 367: l_ccid_identifier := wf_engine.GetItemAttrNumber( itemtype => itemtype,itemkey => itemkey,aname => 'QUOTA_ID');

363: --Bug 3866105 (the same as 11.5.8 bug 3854249, 11.5.10 3866113) by Julia Huang on 9/1/04.
364: ELSIF l_accgen_type IN ('CLASSIFICATION','REVCLS') AND l_profile_value = 'Y'
365: AND l_itc IN ('MANUAL_PAY_ADJ','PMTPLN','PMTPLN_REC')
366: THEN
367: l_ccid_identifier := wf_engine.GetItemAttrNumber( itemtype => itemtype,itemkey => itemkey,aname => 'QUOTA_ID');
368:
369: SELECT expense_account_id, liability_account_id
370: INTO l_expense_ccid, l_liability_ccid
371: FROM cn_quotas_all

Line 376: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

372: WHERE quota_id = l_ccid_identifier;
373:
374: END IF;
375:
376: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
377: itemkey => itemkey,
378: aname => 'EXPENSE_CCID',
379: avalue => l_expense_ccid);
380: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

Line 380: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

376: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
377: itemkey => itemkey,
378: aname => 'EXPENSE_CCID',
379: avalue => l_expense_ccid);
380: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'LIABILITY_CCID',
383: avalue => l_liability_ccid);
384:

Line 402: resultout := wf_engine.GetItemAttrText( itemtype => itemtype,

398: funcmode in varchar2,
399: resultout out nocopy varchar2 ) is
400:
401: begin
402: resultout := wf_engine.GetItemAttrText( itemtype => itemtype,
403: itemkey => itemkey,
404: aname => 'ACCGEN_TYPE');
405: null;
406: end;