APPS.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_CITEM_WORKFLOW_PVT

Line 1: PACKAGE BODY IBC_CITEM_WORKFLOW_PVT as

1: PACKAGE BODY IBC_CITEM_WORKFLOW_PVT as
2: /* $Header: ibcciwfb.pls 120.10.12010000.3 2008/09/25 05:43:26 rsatyava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_CITEM_WORKFLOW_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcciwfb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_CITEM_WORKFLOW_PVT';

1: PACKAGE BODY IBC_CITEM_WORKFLOW_PVT as
2: /* $Header: ibcciwfb.pls 120.10.12010000.3 2008/09/25 05:43:26 rsatyava ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_CITEM_WORKFLOW_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcciwfb.pls';
6:
7:
8: -- --------------------------------------------------------------

Line 1221: l_error_msg_stack := 'Error During IBC_CITEM_WORKFLOW_PVT.Process_Translations -- ' ||

1217: END IF;
1218: ELSE
1219: -- IF l_return_status not successful then return 'N'
1220: result := 'COMPLETE:N';
1221: l_error_msg_stack := 'Error During IBC_CITEM_WORKFLOW_PVT.Process_Translations -- ' ||
1222: FND_GLOBAL.Newline() || 'CITEM_VER_ID:' || l_citem_ver_id;
1223: l_error_msg_stack := l_error_msg_stack || FND_GLOBAL.Newline() || 'Return Status: ' ||
1224: l_return_status || FND_GLOBAL.Newline() || FND_GLOBAL.Newline() ;
1225: FOR I IN 1..l_msg_count LOOP

Line 1786: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Submit_For_Trans_Approval

1782: );
1783: END Get_Pending_Translations;
1784:
1785: -- --------------------------------------------------------------------
1786: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Submit_For_Trans_Approval
1787: -- DESCRIPTION: It launches Content Item Translation Approval Workflow process
1788: -- PARAMETERS:
1789: -- p_citem_ver_id => Content Item Version ID
1790: -- p_object_version_number => Content Item Object Version Number

Line 2366: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Process_TA_Response

2362:
2363:
2364:
2365: -- --------------------------------------------------------------------
2366: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Process_TA_Response
2367: -- DESCRIPTION: Procedure to be called from WF to process the response
2368: -- for translation approval(TA) notification request.
2369: -- It focuses more on REJECTED response to set callback
2370: -- URL

Line 2506: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Approve_Translation

2502: END Process_TA_Response;
2503:
2504:
2505: -- --------------------------------------------------------------------
2506: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Approve_Translation
2507: -- DESCRIPTION: Procedure to be called from WF to actually perform the
2508: -- translation approval process thru status change API.
2509: -- If it's approved succesfully then 'COMPLETE:Y' will be
2510: -- returned and callback URL updated, otherwise

Line 2748: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Notify_Move

2744: RETURN l_result;
2745: END Is_Security_OK_For_Dir;
2746:
2747: -- --------------------------------------------------------------------------------
2748: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Notify_Move
2749: -- DESCRIPTION: Procedure to be called from WF and a notification has to be
2750: -- sent to all users with the Read Item permission that the category
2751: -- or folder has moved to a new location.
2752: -- -------------------------------------------------------------------------------

Line 2807: g_pkg_name CONSTANT VARCHAR2(240) := 'IBC_CITEM_WORKFLOW_PVT';

2803: x_msg_count VARCHAR2(30);
2804: x_msg_data VARCHAR2(4096);
2805:
2806: l_api_name CONSTANT VARCHAR2(30) := 'Notify_Move';
2807: g_pkg_name CONSTANT VARCHAR2(240) := 'IBC_CITEM_WORKFLOW_PVT';
2808:
2809: BEGIN
2810:
2811: l_ItemType := 'IBC_WF';

Line 2959: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Notify_Translator

2955: RAISE;
2956: END Notify_Move;
2957:
2958: -- --------------------------------------------------------------------------------
2959: -- PROCEDURE: IBC_CITEM_WORKFLOW_PVT.Notify_Translator
2960: -- DESCRIPTION: Procedure to be called from WF and a notification has to be
2961: -- sent to all users with Translate permission when a change is
2962: -- made to the content item that has translation enabled.
2963: -- -------------------------------------------------------------------------------

Line 2992: g_pkg_name CONSTANT VARCHAR2(240) := 'IBC_CITEM_WORKFLOW_PVT';

2988: l_appr_user_list VARCHAR2(32000);
2989:
2990:
2991: l_api_name CONSTANT VARCHAR2(30) := 'Notify_Translator';
2992: g_pkg_name CONSTANT VARCHAR2(240) := 'IBC_CITEM_WORKFLOW_PVT';
2993:
2994: CURSOR c_citem_info(p_content_item_id NUMBER) IS
2995: SELECT content_item_name
2996: FROM ibc_citem_versions_vl civ

Line 3120: END IBC_CITEM_WORKFLOW_PVT;

3116: WHEN OTHERS THEN
3117: RAISE;
3118: END Notify_Translator;
3119:
3120: END IBC_CITEM_WORKFLOW_PVT;