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:
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:
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:
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:
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:
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
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;
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:
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: );
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,'
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,
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:
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,
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,
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:
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,
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,
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:
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,
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,
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
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,
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,
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;
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,
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,
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
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,
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,
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:
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,
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,
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
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,
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,
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:
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;
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(
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
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
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
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,