DBA Data[Home] [Help]

APPS.FEM_BUSINESS_RULE_PVT dependencies on WF_ENGINE

Line 2706: l_request_type_code := WF_ENGINE.GetItemAttrText(

2702: l_approval_status_code t_approval_status_code%TYPE;
2703:
2704: BEGIN
2705:
2706: l_request_type_code := WF_ENGINE.GetItemAttrText(
2707: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
2708:
2709: if (l_request_type_code = G_APPROVAL_TYPE) then
2710:

Line 2725: l_request_id := WF_ENGINE.GetItemAttrNumber(

2721: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2722:
2723: end if;
2724:
2725: l_request_id := WF_ENGINE.GetItemAttrNumber(
2726: p_item_type, p_item_key, G_REQUEST_ID);
2727:
2728: l_request_item_code := WF_ENGINE.GetItemAttrText(
2729: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);

Line 2728: l_request_item_code := WF_ENGINE.GetItemAttrText(

2724:
2725: l_request_id := WF_ENGINE.GetItemAttrNumber(
2726: p_item_type, p_item_key, G_REQUEST_ID);
2727:
2728: l_request_item_code := WF_ENGINE.GetItemAttrText(
2729: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2730:
2731: for req_obj_def_rec in req_obj_defs_cur(
2732: l_request_id

Line 2782: l_request_id := WF_ENGINE.GetItemAttrNumber(

2778: l_msg_data t_msg_data%TYPE;
2779:
2780: BEGIN
2781:
2782: l_request_id := WF_ENGINE.GetItemAttrNumber(
2783: p_item_type, p_item_key, G_REQUEST_ID);
2784:
2785: l_request_item_code := WF_ENGINE.GetItemAttrText(
2786: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);

Line 2785: l_request_item_code := WF_ENGINE.GetItemAttrText(

2781:
2782: l_request_id := WF_ENGINE.GetItemAttrNumber(
2783: p_item_type, p_item_key, G_REQUEST_ID);
2784:
2785: l_request_item_code := WF_ENGINE.GetItemAttrText(
2786: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2787:
2788: l_request_type_code := WF_ENGINE.GetItemAttrText(
2789: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);

Line 2788: l_request_type_code := WF_ENGINE.GetItemAttrText(

2784:
2785: l_request_item_code := WF_ENGINE.GetItemAttrText(
2786: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2787:
2788: l_request_type_code := WF_ENGINE.GetItemAttrText(
2789: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
2790:
2791: l_approver_user_id := WF_ENGINE.GetItemAttrNumber(
2792: p_item_type, p_item_key, G_APPROVER_USER_ID);

Line 2791: l_approver_user_id := WF_ENGINE.GetItemAttrNumber(

2787:
2788: l_request_type_code := WF_ENGINE.GetItemAttrText(
2789: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
2790:
2791: l_approver_user_id := WF_ENGINE.GetItemAttrNumber(
2792: p_item_type, p_item_key, G_APPROVER_USER_ID);
2793:
2794: if (l_request_type_code = G_APPROVAL_TYPE) then
2795:

Line 2876: l_request_id := WF_ENGINE.GetItemAttrNumber(

2872: l_request_type_code t_code%TYPE;
2873:
2874: BEGIN
2875:
2876: l_request_id := WF_ENGINE.GetItemAttrNumber(
2877: p_item_type, p_item_key, G_REQUEST_ID);
2878:
2879: l_request_item_code := WF_ENGINE.GetItemAttrText(
2880: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);

Line 2879: l_request_item_code := WF_ENGINE.GetItemAttrText(

2875:
2876: l_request_id := WF_ENGINE.GetItemAttrNumber(
2877: p_item_type, p_item_key, G_REQUEST_ID);
2878:
2879: l_request_item_code := WF_ENGINE.GetItemAttrText(
2880: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2881:
2882: l_request_type_code := WF_ENGINE.GetItemAttrText(
2883: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);

Line 2882: l_request_type_code := WF_ENGINE.GetItemAttrText(

2878:
2879: l_request_item_code := WF_ENGINE.GetItemAttrText(
2880: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2881:
2882: l_request_type_code := WF_ENGINE.GetItemAttrText(
2883: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
2884:
2885: if (l_request_type_code in (G_APPROVAL_TYPE, G_DELETE_TYPE)) then
2886:

Line 2948: l_request_type_code := WF_ENGINE.GetItemAttrText(

2944: l_count number;
2945:
2946: BEGIN
2947:
2948: l_request_type_code := WF_ENGINE.GetItemAttrText(
2949: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
2950:
2951: if (l_request_type_code in (G_APPROVAL_TYPE, G_DELETE_TYPE)) then
2952:

Line 2953: l_request_item_code := WF_ENGINE.GetItemAttrText(

2949: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
2950:
2951: if (l_request_type_code in (G_APPROVAL_TYPE, G_DELETE_TYPE)) then
2952:
2953: l_request_item_code := WF_ENGINE.GetItemAttrText(
2954: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2955:
2956: l_request_id := WF_ENGINE.GetItemAttrNumber(
2957: p_item_type, p_item_key, G_REQUEST_ID);

Line 2956: l_request_id := WF_ENGINE.GetItemAttrNumber(

2952:
2953: l_request_item_code := WF_ENGINE.GetItemAttrText(
2954: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
2955:
2956: l_request_id := WF_ENGINE.GetItemAttrNumber(
2957: p_item_type, p_item_key, G_REQUEST_ID);
2958:
2959: l_count := GetObjectDefinitionsCount(
2960: p_request_id => l_request_id

Line 3017: l_request_type_code := WF_ENGINE.GetItemAttrText(

3013: l_old_approved_copy_obj_def_id t_object_definition_id%TYPE;
3014:
3015: BEGIN
3016:
3017: l_request_type_code := WF_ENGINE.GetItemAttrText(
3018: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
3019:
3020: l_request_item_code := WF_ENGINE.GetItemAttrText(
3021: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);

Line 3020: l_request_item_code := WF_ENGINE.GetItemAttrText(

3016:
3017: l_request_type_code := WF_ENGINE.GetItemAttrText(
3018: p_item_type, p_item_key, G_REQUEST_TYPE_CODE);
3019:
3020: l_request_item_code := WF_ENGINE.GetItemAttrText(
3021: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
3022:
3023: l_request_id := WF_ENGINE.GetItemAttrNumber(
3024: p_item_type, p_item_key, G_REQUEST_ID);

Line 3023: l_request_id := WF_ENGINE.GetItemAttrNumber(

3019:
3020: l_request_item_code := WF_ENGINE.GetItemAttrText(
3021: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
3022:
3023: l_request_id := WF_ENGINE.GetItemAttrNumber(
3024: p_item_type, p_item_key, G_REQUEST_ID);
3025:
3026: if (l_request_type_code in (G_APPROVAL_TYPE, G_DELETE_TYPE)) then
3027:

Line 3035: WF_ENGINE.SetItemAttrNumber(

3031: ,l_request_type_code) loop
3032:
3033: l_obj_def_id := info_obj_def_rec.object_definition_id;
3034:
3035: WF_ENGINE.SetItemAttrNumber(
3036: p_item_type
3037: ,p_item_key
3038: ,G_OBJECT_DEFINITION_ID
3039: ,l_obj_def_id

Line 3042: WF_ENGINE.SetItemAttrText(

3038: ,G_OBJECT_DEFINITION_ID
3039: ,l_obj_def_id
3040: );
3041:
3042: WF_ENGINE.SetItemAttrText(
3043: p_item_type
3044: ,p_item_key
3045: ,G_OBJECT_DEFINITION_NAME
3046: ,info_obj_def_rec.object_definition_name

Line 3049: WF_ENGINE.SetItemAttrText(

3045: ,G_OBJECT_DEFINITION_NAME
3046: ,info_obj_def_rec.object_definition_name
3047: );
3048:
3049: WF_ENGINE.SetItemAttrText(
3050: p_item_type
3051: ,p_item_key
3052: ,G_OBJECT_NAME
3053: ,info_obj_def_rec.object_name

Line 3056: WF_ENGINE.SetItemAttrText(

3052: ,G_OBJECT_NAME
3053: ,info_obj_def_rec.object_name
3054: );
3055:
3056: WF_ENGINE.SetItemAttrText(
3057: p_item_type
3058: ,p_item_key
3059: ,G_OBJECT_TYPE_CODE
3060: ,info_obj_def_rec.object_type_code

Line 3063: WF_ENGINE.SetItemAttrText(

3059: ,G_OBJECT_TYPE_CODE
3060: ,info_obj_def_rec.object_type_code
3061: );
3062:
3063: WF_ENGINE.SetItemAttrText(
3064: p_item_type
3065: ,p_item_key
3066: ,G_OBJECT_TYPE
3067: ,info_obj_def_rec.object_type_name

Line 3070: WF_ENGINE.SetItemAttrText(

3066: ,G_OBJECT_TYPE
3067: ,info_obj_def_rec.object_type_name
3068: );
3069:
3070: WF_ENGINE.SetItemAttrText(
3071: p_item_type
3072: ,p_item_key
3073: ,G_FOLDER_NAME
3074: ,info_obj_def_rec.folder_name

Line 3083: WF_ENGINE.SetItemAttrText(

3079: G_URL_PAGE_MODE_VIEW ||
3080: G_URL_FOLDER_ID || info_obj_def_rec.folder_id ||
3081: G_URL_OBJ_DEF_ID;
3082:
3083: WF_ENGINE.SetItemAttrText(
3084: p_item_type
3085: ,p_item_key
3086: ,G_URL_SUBMITTED
3087: ,l_url || to_char(l_obj_def_id)

Line 3090: WF_ENGINE.SetItemAttrText(

3086: ,G_URL_SUBMITTED
3087: ,l_url || to_char(l_obj_def_id)
3088: );
3089:
3090: WF_ENGINE.SetItemAttrText(
3091: p_item_type
3092: ,p_item_key
3093: ,G_URL_REJECTED
3094: ,l_url || to_char(l_obj_def_id)

Line 3099: WF_ENGINE.SetItemAttrText(

3095: );
3096:
3097: if (l_request_type_code = G_APPROVAL_TYPE) then
3098:
3099: WF_ENGINE.SetItemAttrText(
3100: p_item_type
3101: ,p_item_key
3102: ,G_URL_APPROVED
3103: ,l_url || to_char(l_obj_def_id)

Line 3108: WF_ENGINE.SetItemAttrText(

3104: );
3105:
3106: if (info_obj_def_rec.old_approved_copy_obj_def_id is not null) then
3107:
3108: WF_ENGINE.SetItemAttrText(
3109: p_item_type
3110: ,p_item_key
3111: ,G_URL_ORIGINAL
3112: ,l_url || to_char(info_obj_def_rec.old_approved_copy_obj_def_id)

Line 3165: l_request_id := WF_ENGINE.GetItemAttrNumber(

3161: l_request_id t_request_id%TYPE;
3162:
3163: BEGIN
3164:
3165: l_request_id := WF_ENGINE.GetItemAttrNumber(
3166: p_item_type, p_item_key, G_REQUEST_ID);
3167:
3168: if (l_request_id is not null) then
3169: