DBA Data[Home] [Help]

APPS.PO_CLM_CAR_WF_UTIL dependencies on PO_WF_UTIL_PKG

Line 45: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,

41: prior_len NUMBER := 0;
42: BEGIN
43: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
44: l_item_key := substr(document_id, instr(document_id, ':') + 1);
45: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
46: itemkey => l_item_key,
47: aname => 'DOCUMENT_ID');
48: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
49: itemkey => l_item_key,

Line 48: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,

44: l_item_key := substr(document_id, instr(document_id, ':') + 1);
45: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
46: itemkey => l_item_key,
47: aname => 'DOCUMENT_ID');
48: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_item_type,
49: itemkey => l_item_key,
50: aname => 'DRAFT_ID');
51:
52: OPEN car_logs_csr(l_document_id, l_draft_id);

Line 155: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

151: resultout := wf_engine.eng_null;
152: RETURN;
153: END IF;
154:
155: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID');
158: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
159: itemkey => itemkey,

Line 158: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

154:
155: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'DOCUMENT_ID');
158: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'DRAFT_ID');
161:
162: IF l_draft_id IS NULL THEN

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

168: FROM PO_CLM_CARS
169: WHERE PO_HEADER_ID = l_document_id
170: AND PO_DRAFT_ID = l_draft_id;
171:
172: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
173: itemkey => itemkey,
174: aname => 'CAR_ID',
175: avalue => l_car_id);
176: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

Line 176: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

172: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
173: itemkey => itemkey,
174: aname => 'CAR_ID',
175: avalue => l_car_id);
176: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
177: itemkey => itemkey,
178: aname => 'INVOKER_KEY',
179: avalue => itemkey);
180:

Line 215: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

211: resultout := wf_engine.eng_null;
212: RETURN;
213: END IF;
214:
215: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'DOCUMENT_ID');
218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
219: itemkey => itemkey,

Line 218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

214:
215: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'DOCUMENT_ID');
218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
219: itemkey => itemkey,
220: aname => 'DRAFT_ID');
221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
222: itemkey => itemkey,

Line 221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

217: aname => 'DOCUMENT_ID');
218: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
219: itemkey => itemkey,
220: aname => 'DRAFT_ID');
221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'DOCUMENT_SUBTYPE');
224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
225: itemkey => itemkey,

Line 224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

220: aname => 'DRAFT_ID');
221: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'DOCUMENT_SUBTYPE');
224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'BUYER_USER_NAME');
227: l_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
228: itemkey => itemkey,

Line 227: l_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

223: aname => 'DOCUMENT_SUBTYPE');
224: l_buyer_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'BUYER_USER_NAME');
227: l_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
228: itemkey => itemkey,
229: aname => 'APPROVER_USER_NAME');
230:
231: l_update_fpds_info := 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_UPDATE_FPDSNG_INFO&poHeaderId=' || To_Char(l_document_id)

Line 262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

258: ELSE
259: l_performer_user_name := l_approver_user_name;
260: END IF;
261:
262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
263: itemkey => itemkey,
264: aname => 'DOCUMENT_TYPE_DISP',
265: avalue => l_doc_type_disp);
266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

Line 266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

262: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
263: itemkey => itemkey,
264: aname => 'DOCUMENT_TYPE_DISP',
265: avalue => l_doc_type_disp);
266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
267: itemkey => itemkey,
268: aname => 'PERFORMER_USER_NAME',
269: avalue => l_performer_user_name);
270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

Line 270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

266: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
267: itemkey => itemkey,
268: aname => 'PERFORMER_USER_NAME',
269: avalue => l_performer_user_name);
270: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
271: itemkey => itemkey,
272: aname => 'CAR_LOGS',
273: avalue => 'PLSQL:PO_CLM_CAR_WF_UTIL.GET_CAR_LOGS/' || itemtype || ':' || itemkey);
274:

Line 275: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

271: itemkey => itemkey,
272: aname => 'CAR_LOGS',
273: avalue => 'PLSQL:PO_CLM_CAR_WF_UTIL.GET_CAR_LOGS/' || itemtype || ':' || itemkey);
274:
275: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
276: itemkey => itemkey,
277: aname => 'UPDATE_FPDS_INFO',
278: avalue => l_update_fpds_info);
279:

Line 330: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>

326: RETURN;
327: END IF;
328:
329: --CLM Controls Project changes
330: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
331: itemtype,
332: itemkey =>
333: itemkey,
334: aname =>

Line 346: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>

342: resultout := wf_engine.eng_completed || ':' || 'N';
343: RETURN;
344: END IF;
345:
346: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
347: itemtype,
348: itemkey =>
349: itemkey,
350: aname

Line 353: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>

349: itemkey,
350: aname
351: =>
352: 'DOCUMENT_ID');
353: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
354: itemtype,
355: itemkey =>
356: itemkey,
357: aname

Line 401: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>

397: resultout := wf_engine.eng_null;
398: RETURN;
399: END IF;
400:
401: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
402: itemtype,
403: itemkey =>
404: itemkey,
405: aname

Line 408: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>

404: itemkey,
405: aname
406: =>
407: 'DOCUMENT_ID');
408: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype =>
409: itemtype,
410: itemkey =>
411: itemkey,
412: aname