DBA Data[Home] [Help]

APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_WF_UTIL_PKG

Line 142: PO_WF_UTIL_PKG.SetItemAttrNumber

138: );
139:
140: -- Set all the Item Attributes
141:
142: PO_WF_UTIL_PKG.SetItemAttrNumber
143: ( itemtype => g_ITEMTYPE,
144: itemkey => l_ItemKey,
145: aname => 'PO_HEADER_ID',
146: avalue => p_po_header_id

Line 149: PO_WF_UTIL_PKG.SetItemAttrText

145: aname => 'PO_HEADER_ID',
146: avalue => p_po_header_id
147: );
148:
149: PO_WF_UTIL_PKG.SetItemAttrText
150: ( itemtype => g_ITEMTYPE,
151: itemkey => l_ItemKey,
152: aname => 'AGREEMENT_NUM',
153: avalue => l_agreement_num

Line 158: PO_WF_UTIL_PKG.SetItemAttrNumber

154: );
155:
156: d_position := 40;
157:
158: PO_WF_UTIL_PKG.SetItemAttrNumber
159: ( itemtype => g_ITEMTYPE,
160: itemkey => l_ItemKey,
161: aname => 'ORG_ID',
162: avalue => l_org_id

Line 165: PO_WF_UTIL_PKG.SetItemAttrNumber

161: aname => 'ORG_ID',
162: avalue => l_org_id
163: );
164:
165: PO_WF_UTIL_PKG.SetItemAttrNumber
166: ( itemtype => g_ITEMTYPE,
167: itemkey => l_ItemKey,
168: aname => 'REVISION_NUM',
169: avalue => l_revision_num

Line 174: PO_WF_UTIL_PKG.SetItemAttrNumber

170: );
171:
172: d_position := 50;
173:
174: PO_WF_UTIL_PKG.SetItemAttrNumber
175: ( itemtype => g_ITEMTYPE,
176: itemkey => l_ItemKey,
177: aname => 'DRAFT_ID',
178: avalue => l_draft_id

Line 181: PO_WF_UTIL_PKG.SetItemAttrText

177: aname => 'DRAFT_ID',
178: avalue => l_draft_id
179: );
180:
181: PO_WF_UTIL_PKG.SetItemAttrText
182: ( itemtype => g_ITEMTYPE,
183: itemkey => l_ItemKey,
184: aname => 'DRAFT_OWNER_ROLE',
185: avalue => l_draft_owner_role

Line 190: PO_WF_UTIL_PKG.SetItemAttrNumber

186: );
187:
188: d_position := 60;
189:
190: PO_WF_UTIL_PKG.SetItemAttrNumber
191: ( itemtype => g_ITEMTYPE,
192: itemkey => l_ItemKey,
193: aname => 'DRAFT_OWNER_USER_ID',
194: avalue => l_draft_owner_user_id

Line 197: PO_WF_UTIL_PKG.SetItemAttrNumber

193: aname => 'DRAFT_OWNER_USER_ID',
194: avalue => l_draft_owner_user_id
195: );
196:
197: PO_WF_UTIL_PKG.SetItemAttrNumber
198: ( itemtype => g_ITEMTYPE,
199: itemkey => l_ItemKey,
200: aname => 'AGENT_ID',
201: avalue => l_agent_id

Line 206: PO_WF_UTIL_PKG.SetItemAttrText

202: );
203:
204: d_position := 70;
205:
206: PO_WF_UTIL_PKG.SetItemAttrText
207: ( itemtype => g_ITEMTYPE,
208: itemkey => l_ItemKey,
209: aname => 'BUYER_USER_NAME',
210: avalue => l_buyer_user_name

Line 213: PO_WF_UTIL_PKG.SetItemAttrText

209: aname => 'BUYER_USER_NAME',
210: avalue => l_buyer_user_name
211: );
212:
213: PO_WF_UTIL_PKG.SetItemAttrText
214: ( itemtype => g_ITEMTYPE,
215: itemkey => l_ItemKey,
216: aname => 'BUYER_NAME_DSP',
217: avalue => l_buyer_name_dsp

Line 271: PO_WF_UTIL_PKG.GetItemAttrNumber

267:
268: ELSIF (command = 'SET_CTX') THEN
269: d_position := 20;
270: l_org_id :=
271: PO_WF_UTIL_PKG.GetItemAttrNumber
272: ( itemtype => item_type,
273: itemkey => item_key,
274: aname => 'ORG_ID'
275: );

Line 284: PO_WF_UTIL_PKG.GetItemAttrNumber

280: d_position := 30;
281: l_cur_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;
282:
283: l_org_id :=
284: PO_WF_UTIL_PKG.GetItemAttrNumber
285: ( itemtype => item_type,
286: itemkey => item_key,
287: aname => 'ORG_ID'
288: );

Line 341: PO_WF_UTIL_PKG.GetItemAttrNumber

337:
338: l_acceptance_required := FND_API.G_TRUE;
339:
340: l_org_id :=
341: PO_WF_UTIL_PKG.GetItemAttrNumber
342: ( itemtype => itemType,
343: itemkey => itemKey,
344: aname => 'ORG_ID'
345: );

Line 348: PO_WF_UTIL_PKG.GetItemAttrNumber

344: aname => 'ORG_ID'
345: );
346:
347: l_draft_id :=
348: PO_WF_UTIL_PKG.GetItemAttrNumber
349: ( itemtype => itemType,
350: itemkey => itemKey,
351: aname => 'DRAFT_ID'
352: );

Line 355: PO_WF_UTIL_PKG.GetItemAttrText

351: aname => 'DRAFT_ID'
352: );
353:
354: l_draft_owner_role :=
355: PO_WF_UTIL_PKG.GetItemAttrText
356: ( itemtype => itemType,
357: itemkey => itemKey,
358: aname => 'DRAFT_OWNER_ROLE'
359: );

Line 418: PO_WF_UTIL_PKG.SetItemAttrText

414:
415: -- bug5249414 END
416: END IF;
417:
418: PO_WF_UTIL_PKG.SetItemAttrText
419: ( itemtype => itemType,
420: itemkey => itemKey,
421: aname => 'BUYER_ACCEPTANCE_REQUIRED',
422: avalue => l_acceptance_required

Line 456: l_accept_required := PO_WF_UTIL_PKG.GetItemAttrText

452: IF (PO_LOG.d_proc) THEN
453: PO_LOG.proc_begin (d_module);
454: END IF;
455:
456: l_accept_required := PO_WF_UTIL_PKG.GetItemAttrText
457: ( itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'BUYER_ACCEPTANCE_REQUIRED'
460: );

Line 499: l_transfer_flag := PO_WF_UTIL_PKG.GetItemAttrText

495: IF (PO_LOG.d_proc) THEN
496: PO_LOG.proc_begin (d_module);
497: END IF;
498:
499: l_transfer_flag := PO_WF_UTIL_PKG.GetItemAttrText
500: ( itemtype => itemtype,
501: itemkey => itemkey,
502: aname => 'TRANSFER_IF_AUTOACCEPT_ALL'
503: );

Line 552: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber

548: IF (PO_LOG.d_proc) THEN
549: PO_LOG.proc_begin (d_module);
550: END IF;
551:
552: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber
553: ( itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'PO_HEADER_ID'
556: );

Line 558: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

554: itemkey => itemkey,
555: aname => 'PO_HEADER_ID'
556: );
557:
558: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
559: ( itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'DRAFT_ID'
562: );

Line 571: l_buyer_user_name := PO_WF_UTIL_PKG.GetItemAttrText

567: ( p_draft_id => l_draft_id,
568: p_new_status => PO_DRAFTS_PVT.g_status_IN_PROCESS
569: );
570:
571: l_buyer_user_name := PO_WF_UTIL_PKG.GetItemAttrText
572: ( itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'BUYER_USER_NAME'
575: );

Line 579: PO_WF_UTIL_PKG.SetItemAttrText

575: );
576:
577: -- Initially, the user role of the acceptance party is the buyer of
578: -- the document
579: PO_WF_UTIL_PKG.SetItemAttrText
580: ( itemtype => itemtype,
581: itemkey => itemkey,
582: aname => 'ACCEPTANCE_USER_WF_ROLE',
583: avalue => l_buyer_user_name

Line 649: l_agent_id := PO_WF_UTIL_PKG.GetItemAttrNumber

645: l_manager_name_dsp VARCHAR2(1000);
646: BEGIN
647: d_position := 0;
648:
649: l_agent_id := PO_WF_UTIL_PKG.GetItemAttrNumber
650: ( itemtype => itemtype,
651: itemkey => itemkey,
652: aname => 'AGENT_ID'
653: );

Line 673: PO_WF_UTIL_PKG.SetItemAttrText

669:
670: d_position := 20;
671:
672: -- Change user that performs acceptance
673: PO_WF_UTIL_PKG.SetItemAttrText
674: ( itemtype => itemtype,
675: itemkey => itemkey,
676: aname => 'ACCEPTANCE_USER_WF_ROLE',
677: avalue => l_manager_user_name

Line 715: PO_WF_UTIL_PKG.SetItemAttrText

711: IF (PO_LOG.d_proc) THEN
712: PO_LOG.proc_begin (d_module);
713: END IF;
714:
715: PO_WF_UTIL_PKG.SetItemAttrText
716: ( itemtype => itemType,
717: itemkey => itemKey,
718: aname => 'ACCEPTANCE_RESULT',
719: avalue => PO_DRAFTS_PVT.g_ACCEPT_ALL

Line 760: PO_WF_UTIL_PKG.GetItemAttrNumber

756: PO_LOG.proc_begin (d_module);
757: END IF;
758:
759: l_draft_id :=
760: PO_WF_UTIL_PKG.GetItemAttrNumber
761: ( itemtype => itemType,
762: itemkey => itemKey,
763: aname => 'DRAFT_ID'
764: );

Line 767: PO_WF_UTIL_PKG.GetItemAttrNumber

763: aname => 'DRAFT_ID'
764: );
765:
766: l_po_header_id :=
767: PO_WF_UTIL_PKG.GetItemAttrNumber
768: ( itemtype => itemType,
769: itemkey => itemKey,
770: aname => 'PO_HEADER_ID'
771: );

Line 886: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

882: IF (PO_LOG.d_proc) THEN
883: PO_LOG.proc_begin (d_module);
884: END IF;
885:
886: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
887: ( itemtype => itemtype,
888: itemkey => itemkey,
889: aname => 'DRAFT_ID'
890: );

Line 972: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

968: IF (PO_LOG.d_proc) THEN
969: PO_LOG.proc_begin (d_module);
970: END IF;
971:
972: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
973: ( itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'DRAFT_ID'
976: );

Line 978: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber

974: itemkey => itemkey,
975: aname => 'DRAFT_ID'
976: );
977:
978: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber
979: ( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => 'PO_HEADER_ID'
982: );

Line 984: l_acceptance_action := PO_WF_UTIL_PKG.GetItemAttrText

980: itemkey => itemkey,
981: aname => 'PO_HEADER_ID'
982: );
983:
984: l_acceptance_action := PO_WF_UTIL_PKG.GetItemAttrText
985: ( itemtype => itemtype,
986: itemkey => itemkey,
987: aname => 'ACCEPTANCE_RESULT'
988: );

Line 1060: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1056:
1057:
1058: -- Launch Approval WF
1059: -- Retrieve some settings for launching the PO Approval workflow.
1060: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1061: ( itemtype => itemtype,
1062: itemkey => itemkey,
1063: aname => 'PO_HEADER_ID'
1064: );

Line 1066: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber

1062: itemkey => itemkey,
1063: aname => 'PO_HEADER_ID'
1064: );
1065:
1066: l_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber
1067: ( itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'ORG_ID'
1070: );

Line 1072: l_note_to_approver := PO_WF_UTIL_PKG.GetItemAttrText

1068: itemkey => itemkey,
1069: aname => 'ORG_ID'
1070: );
1071:
1072: l_note_to_approver := PO_WF_UTIL_PKG.GetItemAttrText
1073: ( itemtype => itemtype,
1074: itemkey => itemkey,
1075: aname => 'NOTE_TO_APPROVER'
1076: );

Line 1432: PO_WF_UTIL_PKG.SetItemAttrText

1428: END IF;
1429:
1430: d_position := 20;
1431: --Bug 13356264
1432: PO_WF_UTIL_PKG.SetItemAttrText
1433: ( itemtype => g_ITEMTYPE,
1434: itemkey => l_ItemKey,
1435: aname => 'LAUNCH_APPROVAL',
1436: avalue => p_initiate_approval

Line 1438: PO_WF_UTIL_PKG.SetItemAttrText

1434: itemkey => l_ItemKey,
1435: aname => 'LAUNCH_APPROVAL',
1436: avalue => p_initiate_approval
1437: );
1438: PO_WF_UTIL_PKG.SetItemAttrText
1439: ( itemtype => g_ITEMTYPE,
1440: itemkey => l_ItemKey,
1441: aname => 'NOTE_TO_APPROVER',
1442: avalue => SUBSTRB(p_note_to_approver, 1, 480)

Line 3529: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,

3525: IF ( po_log.d_proc ) THEN
3526: po_log.Proc_begin (d_module);
3527: END IF;
3528:
3529: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
3530: itemkey => itemkey,
3531: aname => 'DRAFT_ID');
3532:
3533: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber

Line 3533: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber

3529: l_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,
3530: itemkey => itemkey,
3531: aname => 'DRAFT_ID');
3532:
3533: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber
3534: ( itemtype => itemtype,
3535: itemkey => itemkey,
3536: aname => 'PO_HEADER_ID'
3537: );

Line 3573: l_launch_approval := po_wf_util_pkg.Getitemattrtext (itemtype => itemtype,

3569: IF ( po_log.d_stmt ) THEN
3570: po_log.Stmt (d_module, d_position, 'l_any_line_accepted', l_any_line_accepted);
3571: END IF;
3572:
3573: l_launch_approval := po_wf_util_pkg.Getitemattrtext (itemtype => itemtype,
3574: itemkey => itemkey,
3575: aname=> 'LAUNCH_APPROVAL');
3576:
3577: d_position := 30;