PACKAGE: APPS.OZF_REQUEST_STATUS_PVT

Source

1 PACKAGE OZF_REQUEST_STATUS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvrsts.pls 120.1 2007/12/24 06:44:09 ateotia ship $ */
3 
4 ---------------------------------------------------------------------
5 -- PROCEDURE
6 --    Event_Subscription
7 --
8 -- PURPOSE
9 --    Subscription for the event raised during status change
10 --
11 -- PARAMETERS
12 --
13 -- NOTES
14 ---------------------------------------------------------------------
15 FUNCTION Event_Subscription(
16    p_subscription_guid in     raw,
17    p_event             in out nocopy wf_event_t)
18 RETURN varchar2;
19 ---------------------------------------------------------------------
20 -- PROCEDURE
21 --    Set_Request_Message
22 --
23 -- PURPOSE
24 --    Handles the approvals and rejections of objects
25 --
26 -- PARAMETERS
27 --
28 -- NOTES
29 ---------------------------------------------------------------------
30 PROCEDURE Set_Request_Message (
31    p_itemtype            IN VARCHAR2,
32    p_itemkey             IN VARCHAR2,
33    P_ENTITY_ID           IN  NUMBER,
34    P_USER_TYPE           IN  VARCHAR2,
35 
36    P_STATUS              IN  VARCHAR2);
37 ---------------------------------------------------------------------
38 -- PROCEDURE
39 --    Return_Request_Userlist
40 --
41 -- PURPOSE
42 --    Handles the approvals and rejections of objects
43 --
44 -- PARAMETERS
45 --
46 -- NOTES
47 ---------------------------------------------------------------------
48 FUNCTION Return_Request_Userlist (
49    p_benefit_type        IN VARCHAR2,
50    p_entity_id           IN  NUMBER,
51    p_user_role           IN  VARCHAR2,
52    p_status              IN  VARCHAR2) RETURN VARCHAR2;
53 
54 ---------------------------------------------------------------------
55 -- PROCEDURE
56 --    Create_Interaction
57 --
58 -- PURPOSE
59 --    Created Interaction History
60 --
61 -- PARAMETERS
62 --
63 -- NOTES
64 ---------------------------------------------------------------------
65 PROCEDURE  Create_Interaction (
66     p_api_version            IN  NUMBER
67    ,p_init_msg_list          IN  VARCHAR2 := FND_API.G_FALSE
68    ,p_commit                 IN  VARCHAR2 := FND_API.G_FALSE
69    ,p_validation_level       IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL
70 
71    ,x_return_status          OUT NOCOPY   VARCHAR2
72    ,x_msg_data               OUT NOCOPY   VARCHAR2
73    ,x_msg_count              OUT NOCOPY   NUMBER
74 
75    ,p_approval_rec           IN  OZF_APPROVAL_PVT.approval_rec_type
76 );
77 
78 -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(+)
79 
80 ---------------------------------------------------------------------
81 -- PROCEDURE
82 --    Event_SD_Subscription
83 --
84 -- PURPOSE
85 --    Subscription for the event raised for Ship & Debit Request
86 --
87 -- PARAMETERS
88 --
89 -- NOTES
90 ---------------------------------------------------------------------
91 FUNCTION Event_SD_Subscription(
92    p_subscription_guid IN     raw,
93    p_event             IN OUT NOCOPY wf_event_t)
94 RETURN varchar2;
95 
96 -- 'R12.1 Enhancement: Ship & Debit Request' by ateotia(-)
97 
98 
99 END OZF_REQUEST_STATUS_PVT;