1 PACKAGE AHL_WF_NOTIFICATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVNTFS.pls 120.1.12020000.2 2012/12/07 01:14:27 sareepar ship $ */
3
4 ------------------------------------------------------------------------------------
5 -- Start of Comments
6 -- Procedure name : Launch_OA_Notification
7 -- Type : Public
8 -- Function : Launches the Workflow notification process having an embedded OA region.
9 -- Pre-reqs :
10 -- Parameters :
11 --
12 -- Launch_OA_Notification Parameters:
13 -- p_object IN CMRO object types, defined for the lookup type Required
14 -- AHL_APPR_OBJECT_TYPE
15 -- p_process_name IN Workflow process name Required
16 -- p_item_type IN Workflow process item type Required
17 -- p_subject IN Notification subject Required
18 -- p_oa_function IN AOL function name for the OA region Required
19 -- p_parami_name IN Parameter name, if any, required by the OA Required
20 -- region. Up to three can be given.
21 -- p_parami_value IN Parameter values Required
22 -- x_item_key OUT Item key of the launched notification Required
23 -- x_return_status OUT Return status. Item key to be used only if Required
24 -- this status is FND_API.G_RET_STS_SUCCESS.
25 --
26 -- End of Comments
27
28 PROCEDURE Launch_OA_Notification (
29 p_object IN VARCHAR2,
30 p_process_name IN VARCHAR2,
31 p_item_type IN VARCHAR2,
32 p_subject IN VARCHAR2,
33 p_oa_function IN VARCHAR2,
34 p_param1_name IN VARCHAR2 := NULL,
35 p_param2_name IN VARCHAR2 := NULL,
36 p_param3_name IN VARCHAR2 := NULL,
37 p_param1_value IN VARCHAR2 := NULL,
38 p_param2_value IN VARCHAR2 := NULL,
39 p_param3_value IN VARCHAR2 := NULL,
40 x_item_key OUT NOCOPY VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2
42 );
43
44 END AHL_WF_NOTIFICATION_PVT;