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 2700: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2696: begin
2697:
2698: l_progress := '001';
2699:
2700: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2701: itemkey => itemkey,
2702: aname => 'IS_AME_APPROVAL'
2703: );
2704: --Bug 11664961 Adding timeout

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

2727: FETCH mipr_csr INTO l_mipr_type_disp;
2728: CLOSE mipr_csr;
2729:
2730: IF l_mipr_type_disp IS NOT NULL THEN
2731: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2732: itemkey => itemkey,
2733: aname => 'DOCUMENT_TYPE_DISP',
2734: avalue => l_mipr_type_disp);
2735: END IF;

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

2783: end if;
2784:
2785: l_progress := '003';
2786:
2787: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2788: itemkey => itemkey,
2789: aname => 'IS_AME_APPROVAL'
2790: );
2791:

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

2789: aname => 'IS_AME_APPROVAL'
2790: );
2791:
2792: if ( funcmode = 'FORWARD' AND l_is_ame_approval = 'Y' ) then
2793: po_wf_util_pkg.SetItemAttrNumber( itemtype => itemtype,
2794: itemkey => itemkey,
2795: aname => 'APPROVER_EMPID',
2796: avalue => l_new_recipient_id
2797: );

Line 2892: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => p_itemtype,

2888: IF (g_po_wf_debug = 'Y') THEN
2889: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2890: END IF;
2891: else
2892: l_is_ame_approval := po_wf_util_pkg.GetItemAttrText( itemtype => p_itemtype,
2893: itemkey => p_itemkey,
2894: aname => 'IS_AME_APPROVAL'
2895: );
2896: l_progress := 'notif callback l_is_ame_approval was not Y hence get this from parent wf now p_itemtype,'

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

2927: -- to here, it was not initialized inside the if condition if the control went to the
2928: -- else part.
2929:
2930: l_preparer_resp_id :=
2931: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2932: itemkey => itemkey,
2933: aname => 'RESPONSIBILITY_ID');
2934: l_preparer_appl_id :=
2935: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

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

2931: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2932: itemkey => itemkey,
2933: aname => 'RESPONSIBILITY_ID');
2934: l_preparer_appl_id :=
2935: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2936: itemkey => itemkey,
2937: aname => 'APPLICATION_ID');
2938:
2939:

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

2958: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2959: END IF;
2960: --
2961:
2962: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2963: itemkey => itemkey,
2964: aname => 'RESPONDER_USER_ID',
2965: avalue => l_responder_id);
2966: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2962: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2963: itemkey => itemkey,
2964: aname => 'RESPONDER_USER_ID',
2965: avalue => l_responder_id);
2966: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2967: itemkey => itemkey,
2968: aname => 'RESPONDER_RESP_ID',
2969: avalue => l_preparer_resp_id);
2970: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2966: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2967: itemkey => itemkey,
2968: aname => 'RESPONDER_RESP_ID',
2969: avalue => l_preparer_resp_id);
2970: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2971: itemkey => itemkey,
2972: aname => 'RESPONDER_APPL_ID',
2973: avalue => l_preparer_appl_id);
2974:

Line 2981: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

2977: IF (g_po_wf_debug = 'Y') THEN
2978: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
2979: END IF;
2980:
2981: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
2982: itemkey => p_itemkey,
2983: aname => 'RESPONDER_USER_ID',
2984: avalue => l_responder_id);
2985: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 2985: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

2981: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
2982: itemkey => p_itemkey,
2983: aname => 'RESPONDER_USER_ID',
2984: avalue => l_responder_id);
2985: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
2986: itemkey => p_itemkey,
2987: aname => 'RESPONDER_RESP_ID',
2988: avalue => l_preparer_resp_id);
2989: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 2989: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

2985: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
2986: itemkey => p_itemkey,
2987: aname => 'RESPONDER_RESP_ID',
2988: avalue => l_preparer_resp_id);
2989: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
2990: itemkey => p_itemkey,
2991: aname => 'RESPONDER_APPL_ID',
2992: avalue => l_preparer_appl_id);
2993:

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

3002: IF (g_po_wf_debug = 'Y') THEN
3003: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3004: END IF;
3005:
3006: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3007: itemkey => itemkey,
3008: aname => 'RESPONDER_USER_ID',
3009: avalue => l_responder_id);
3010: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

3006: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3007: itemkey => itemkey,
3008: aname => 'RESPONDER_USER_ID',
3009: avalue => l_responder_id);
3010: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3011: itemkey => itemkey,
3012: aname => 'RESPONDER_RESP_ID',
3013: avalue => l_preparer_resp_id);
3014: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

3010: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3011: itemkey => itemkey,
3012: aname => 'RESPONDER_RESP_ID',
3013: avalue => l_preparer_resp_id);
3014: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3015: itemkey => itemkey,
3016: aname => 'RESPONDER_APPL_ID',
3017: avalue => l_preparer_appl_id);
3018: if( l_is_ame_approval = 'Y' ) then

Line 3024: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3020: IF (g_po_wf_debug = 'Y') THEN
3021: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3022: END IF;
3023:
3024: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3025: itemkey => p_itemkey,
3026: aname => 'RESPONDER_USER_ID',
3027: avalue => l_responder_id);
3028: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 3028: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3024: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3025: itemkey => p_itemkey,
3026: aname => 'RESPONDER_USER_ID',
3027: avalue => l_responder_id);
3028: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3029: itemkey => p_itemkey,
3030: aname => 'RESPONDER_RESP_ID',
3031: avalue => l_preparer_resp_id);
3032: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 3032: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3028: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3029: itemkey => p_itemkey,
3030: aname => 'RESPONDER_RESP_ID',
3031: avalue => l_preparer_resp_id);
3032: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3033: itemkey => p_itemkey,
3034: aname => 'RESPONDER_APPL_ID',
3035: avalue => l_preparer_appl_id);
3036: end if;

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

3057: IF (g_po_wf_debug = 'Y') THEN
3058: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3059: END IF;
3060:
3061: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3062: itemkey => itemkey,
3063: aname => 'RESPONDER_USER_ID',
3064: avalue => l_responder_id);
3065: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

3061: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3062: itemkey => itemkey,
3063: aname => 'RESPONDER_USER_ID',
3064: avalue => l_responder_id);
3065: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3066: itemkey => itemkey,
3067: aname => 'RESPONDER_RESP_ID',
3068: avalue => l_session_resp_id);
3069: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

3065: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3066: itemkey => itemkey,
3067: aname => 'RESPONDER_RESP_ID',
3068: avalue => l_session_resp_id);
3069: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3070: itemkey => itemkey,
3071: aname => 'RESPONDER_APPL_ID',
3072: avalue => l_session_appl_id);
3073: if( l_is_ame_approval = 'Y' ) then

Line 3080: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3076: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3077: END IF;
3078:
3079:
3080: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3081: itemkey => p_itemkey,
3082: aname => 'RESPONDER_USER_ID',
3083: avalue => l_responder_id);
3084: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 3084: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3080: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3081: itemkey => p_itemkey,
3082: aname => 'RESPONDER_USER_ID',
3083: avalue => l_responder_id);
3084: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3085: itemkey => p_itemkey,
3086: aname => 'RESPONDER_RESP_ID',
3087: avalue => l_session_resp_id);
3088: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 3088: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3084: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3085: itemkey => p_itemkey,
3086: aname => 'RESPONDER_RESP_ID',
3087: avalue => l_session_resp_id);
3088: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3089: itemkey => p_itemkey,
3090: aname => 'RESPONDER_APPL_ID',
3091: avalue => l_session_appl_id);
3092:

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

3098: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3099: END IF;
3100: --
3101:
3102: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3103: itemkey => itemkey,
3104: aname => 'RESPONDER_USER_ID',
3105: avalue => l_responder_id);
3106: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

3102: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3103: itemkey => itemkey,
3104: aname => 'RESPONDER_USER_ID',
3105: avalue => l_responder_id);
3106: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3107: itemkey => itemkey,
3108: aname => 'RESPONDER_RESP_ID',
3109: avalue => l_preparer_resp_id);
3110: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

3106: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3107: itemkey => itemkey,
3108: aname => 'RESPONDER_RESP_ID',
3109: avalue => l_preparer_resp_id);
3110: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
3111: itemkey => itemkey,
3112: aname => 'RESPONDER_APPL_ID',
3113: avalue => l_preparer_appl_id);
3114: if( l_is_ame_approval = 'Y' ) then

Line 3121: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3117: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_progress);
3118: END IF;
3119:
3120:
3121: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3122: itemkey => p_itemkey,
3123: aname => 'RESPONDER_USER_ID',
3124: avalue => l_responder_id);
3125: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 3125: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3121: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3122: itemkey => p_itemkey,
3123: aname => 'RESPONDER_USER_ID',
3124: avalue => l_responder_id);
3125: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3126: itemkey => p_itemkey,
3127: aname => 'RESPONDER_RESP_ID',
3128: avalue => l_preparer_resp_id);
3129: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

Line 3129: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,

3125: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3126: itemkey => p_itemkey,
3127: aname => 'RESPONDER_RESP_ID',
3128: avalue => l_preparer_resp_id);
3129: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>p_itemtype,
3130: itemkey => p_itemkey,
3131: aname => 'RESPONDER_APPL_ID',
3132: avalue => l_preparer_appl_id);
3133:

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

3252: l_authority_type VARCHAR2(30);
3253:
3254: BEGIN
3255:
3256: l_authority_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => p_itemtype,
3257: itemkey => p_itemkey,
3258: aname => 'AME_AUTHORITY_TYPE');
3259: if(l_authority_type is null) then
3260: return true;

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

3339: IF (g_po_wf_debug = 'Y') THEN
3340: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3341: END IF;
3342:
3343: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3344: itemkey => itemkey,
3345: aname => 'DOCUMENT_SUBTYPE');
3346:
3347: Wf_Directory.GetRoleInfo(

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

3376: IF (g_po_wf_debug = 'Y') THEN
3377: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3378: END IF;
3379:
3380: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
3381: itemkey => itemkey,
3382: aname => 'DOCUMENT_TYPE_DISP',
3383: avalue => l_doc_disp);
3384: EXCEPTION

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

3423: IF (g_po_wf_debug = 'Y') THEN
3424: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3425: END IF;
3426:
3427: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3428: itemkey => itemkey,
3429: aname => 'APPROVER_USER_NAME');
3430: /* Bug# 2616355: kagarwal
3431: ** Desc Need to set the org context

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

3485: IF (g_po_wf_debug = 'Y') THEN
3486: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3487: END IF;
3488:
3489: l_preparer_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3490: itemkey => itemkey,
3491: aname => 'PREPARER_USER_NAME');
3492:
3493: /* Bug# 2616355: kagarwal

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

3574: IF (g_po_wf_debug = 'Y') THEN
3575: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3576: END IF;
3577:
3578: l_fwdfrom_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3579: itemkey => itemkey,
3580: aname => 'FORWARD_FROM_USER_NAME');
3581:
3582: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,