DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_WF_UTIL_PKG

Line 320: l_note := PO_WF_UTIL_PKG.GetItemAttrText

316: (itemtype => l_item_type,
317: itemkey => l_item_key,
318: aname => 'PREPARER_DISPLAY_NAME');
319:
320: l_note := PO_WF_UTIL_PKG.GetItemAttrText
321: (itemtype => l_item_type,
322: itemkey => l_item_key,
323: aname => 'JUSTIFICATION');
324:

Line 561: l_note := PO_WF_UTIL_PKG.GetItemAttrText

557: (itemtype => l_item_type,
558: itemkey => l_item_key,
559: aname => 'PREPARER_DISPLAY_NAME');
560:
561: l_note := PO_WF_UTIL_PKG.GetItemAttrText
562: (itemtype => l_item_type,
563: itemkey => l_item_key,
564: aname => 'JUSTIFICATION');
565:

Line 827: l_note := PO_WF_UTIL_PKG.GetItemAttrText

823: (itemtype => l_item_type,
824: itemkey => l_item_key,
825: aname => 'PREPARER_DISPLAY_NAME');
826:
827: l_note := PO_WF_UTIL_PKG.GetItemAttrText
828: (itemtype => l_item_type,
829: itemkey => l_item_key,
830: aname => 'JUSTIFICATION');
831:

Line 1053: l_note := PO_WF_UTIL_PKG.GetItemAttrText

1049: (itemtype => l_item_type,
1050: itemkey => l_item_key,
1051: aname => 'PREPARER_DISPLAY_NAME');
1052:
1053: l_note := PO_WF_UTIL_PKG.GetItemAttrText
1054: (itemtype => l_item_type,
1055: itemkey => l_item_key,
1056: aname => 'JUSTIFICATION');
1057:

Line 1532: l_disp_item := PO_WF_UTIL_PKG.GetItemAttrText

1528: **
1529: ** If the attribute is not present, it will be treated as 'N'.
1530: */
1531:
1532: l_disp_item := PO_WF_UTIL_PKG.GetItemAttrText
1533: (itemtype => l_item_type,
1534: itemkey => l_item_key,
1535: aname => 'DISPLAY_ITEM');
1536:

Line 2640: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2636: end if;
2637:
2638: l_progress := '003';
2639:
2640: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2641: itemkey => itemkey,
2642: aname => 'IS_AME_APPROVAL'
2643: );
2644:

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

2642: aname => 'IS_AME_APPROVAL'
2643: );
2644:
2645: if ( funcmode = 'FORWARD' AND l_is_ame_approval = 'Y' ) then
2646: po_wf_util_pkg.SetItemAttrNumber( itemtype => itemtype,
2647: itemkey => itemkey,
2648: aname => 'APPROVER_EMPID',
2649: avalue => l_new_recipient_id
2650: );

Line 2755: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

2751: -- to here, it was not initialized inside the if condition if the control went to the
2752: -- else part.
2753:
2754: l_preparer_resp_id :=
2755: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2756: itemkey => itemkey,
2757: aname => 'RESPONSIBILITY_ID');
2758: l_preparer_appl_id :=
2759: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

Line 2759: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

2755: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2756: itemkey => itemkey,
2757: aname => 'RESPONSIBILITY_ID');
2758: l_preparer_appl_id :=
2759: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2760: itemkey => itemkey,
2761: aname => 'APPLICATION_ID');
2762:
2763: --

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

2780: */
2781:
2782:
2783:
2784: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2785: itemkey => itemkey,
2786: aname => 'RESPONDER_USER_ID',
2787: avalue => l_responder_id);
2788: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2784: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2785: itemkey => itemkey,
2786: aname => 'RESPONDER_USER_ID',
2787: avalue => l_responder_id);
2788: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2789: itemkey => itemkey,
2790: aname => 'RESPONDER_RESP_ID',
2791: avalue => l_preparer_resp_id);
2792: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2788: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2789: itemkey => itemkey,
2790: aname => 'RESPONDER_RESP_ID',
2791: avalue => l_preparer_resp_id);
2792: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2793: itemkey => itemkey,
2794: aname => 'RESPONDER_APPL_ID',
2795: avalue => l_preparer_appl_id);
2796: else

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

2796: else
2797: if (l_session_resp_id is null) THEN
2798: /* possible when the response is made from the default worklist
2799: without choosing a valid responsibility */
2800: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2801: itemkey => itemkey,
2802: aname => 'RESPONDER_USER_ID',
2803: avalue => l_responder_id);
2804: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2800: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2801: itemkey => itemkey,
2802: aname => 'RESPONDER_USER_ID',
2803: avalue => l_responder_id);
2804: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2805: itemkey => itemkey,
2806: aname => 'RESPONDER_RESP_ID',
2807: avalue => l_preparer_resp_id);
2808: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2804: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2805: itemkey => itemkey,
2806: aname => 'RESPONDER_RESP_ID',
2807: avalue => l_preparer_resp_id);
2808: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2809: itemkey => itemkey,
2810: aname => 'RESPONDER_APPL_ID',
2811: avalue => l_preparer_appl_id);
2812: else

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

2818: through the email or the background process picks the wf up.
2819: This may happen due to the fact that the mailer / background process
2820: carries the context set by the notification/wf it processed last*/
2821: if ( l_preserved_ctx = 'TRUE') then
2822: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2823: itemkey => itemkey,
2824: aname => 'RESPONDER_USER_ID',
2825: avalue => l_responder_id);
2826: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2822: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2823: itemkey => itemkey,
2824: aname => 'RESPONDER_USER_ID',
2825: avalue => l_responder_id);
2826: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2827: itemkey => itemkey,
2828: aname => 'RESPONDER_RESP_ID',
2829: avalue => l_session_resp_id);
2830: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2826: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2827: itemkey => itemkey,
2828: aname => 'RESPONDER_RESP_ID',
2829: avalue => l_session_resp_id);
2830: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2831: itemkey => itemkey,
2832: aname => 'RESPONDER_APPL_ID',
2833: avalue => l_session_appl_id);
2834: else

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

2831: itemkey => itemkey,
2832: aname => 'RESPONDER_APPL_ID',
2833: avalue => l_session_appl_id);
2834: else
2835: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2836: itemkey => itemkey,
2837: aname => 'RESPONDER_USER_ID',
2838: avalue => l_responder_id);
2839: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2835: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2836: itemkey => itemkey,
2837: aname => 'RESPONDER_USER_ID',
2838: avalue => l_responder_id);
2839: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2840: itemkey => itemkey,
2841: aname => 'RESPONDER_RESP_ID',
2842: avalue => l_preparer_resp_id);
2843: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2839: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2840: itemkey => itemkey,
2841: aname => 'RESPONDER_RESP_ID',
2842: avalue => l_preparer_resp_id);
2843: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2844: itemkey => itemkey,
2845: aname => 'RESPONDER_APPL_ID',
2846: avalue => l_preparer_appl_id);
2847: end if;

Line 2970: l_authority_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => p_itemtype,

2966: l_authority_type VARCHAR2(30);
2967:
2968: BEGIN
2969:
2970: l_authority_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => p_itemtype,
2971: itemkey => p_itemkey,
2972: aname => 'AME_AUTHORITY_TYPE');
2973: if(l_authority_type is null) then
2974: return true;

Line 3041: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3037: IF (g_po_wf_debug = 'Y') THEN
3038: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3039: END IF;
3040:
3041: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3042: itemkey => itemkey,
3043: aname => 'DOCUMENT_SUBTYPE');
3044:
3045: Wf_Directory.GetRoleInfo(

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

3063: IF (g_po_wf_debug = 'Y') THEN
3064: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3065: END IF;
3066:
3067: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
3068: itemkey => itemkey,
3069: aname => 'DOCUMENT_TYPE_DISP',
3070: avalue => l_doc_disp);
3071: EXCEPTION

Line 3114: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3110: IF (g_po_wf_debug = 'Y') THEN
3111: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3112: END IF;
3113:
3114: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3115: itemkey => itemkey,
3116: aname => 'APPROVER_USER_NAME');
3117: /* Bug# 2616355: kagarwal
3118: ** Desc Need to set the org context

Line 3176: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3172: IF (g_po_wf_debug = 'Y') THEN
3173: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3174: END IF;
3175:
3176: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3177: itemkey => itemkey,
3178: aname => 'PREPARER_USER_NAME');
3179:
3180: /* Bug# 2616355: kagarwal

Line 3265: l_fwdfrom_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3261: IF (g_po_wf_debug = 'Y') THEN
3262: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3263: END IF;
3264:
3265: l_fwdfrom_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3266: itemkey => itemkey,
3267: aname => 'FORWARD_FROM_USER_NAME');
3268:
3269: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,