1 PACKAGE JTF_UM_APPROVAL_REQUESTS_PVT AUTHID CURRENT_USER as
2 /* $Header: JTFVAPRS.pls 120.2 2009/06/15 11:15:47 kkasibha ship $ */
3
4
5 TYPE APPROVAL_REQUEST_TYPE IS RECORD
6 (
7 REG_LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
8 USER_NAME FND_USER.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
9 COMPANY_NAME HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR,
10 ENTITY_SOURCE VARCHAR2(25) := FND_API.G_MISS_CHAR,
11 ENTITY_NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
12 WF_ITEM_TYPE JTF_UM_USERTYPE_REG.WF_ITEM_TYPE%TYPE := FND_API.G_MISS_CHAR,
13 REG_ID NUMBER := FND_API.G_MISS_NUM,
14 APPROVER FND_USER.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
15 ERROR_ACTIVITY NUMBER := FND_API.G_MISS_NUM
16 );
17
18 TYPE APPROVAL_REQUEST_TABLE_TYPE IS TABLE OF APPROVAL_REQUEST_TYPE INDEX BY BINARY_INTEGER;
19
20 /**
21 * Procedure : PENDING_APPROVAL_SYSADMIN
22 * Type : Private
23 * Pre_reqs : None
24 * Description : Return the pending requests foy sysadmin
25 * Parameters :
26 * input parameters
27 * @param p_sort_order
28 * description: The sort order
29 * required : Y
30 * validation : Must be a valid sort order
31 * p_number_of_records:
32 * description: The number of records to retrieve from a database
33 * required : Y
34 * validation : Must be a valid number
35 * output parameters
36 * x_result: APPROVAL_REQUEST_TABLE_TYPE
37 */
38 procedure PENDING_APPROVAL_SYSADMIN(
39 p_sort_order in varchar2,
40 p_number_of_records in number,
41 x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE
42 );
43
44
45 /**
46 * Procedure : PENDING_APPROVAL_PRIMARY
47 * Type : Private
48 * Pre_reqs : None
49 * Description : Return the pending requests foy Primary User
50 * Parameters :
51 * input parameters
52 * @param p_sort_order
53 * description: The sort order
54 * required : Y
55 * validation : Must be a valid sort order
56 * p_number_of_records:
57 * description: The number of records to retrieve from a database
58 * required : Y
59 * validation : Must be a valid number
60 * p_approver_user_id
61 * description: The user_id of a logged in user
62 * required : Y
63 * validation : Must be a valid user_id
64 * output parameters
65 * x_result: APPROVAL_REQUEST_TABLE_TYPE
66 */
67 procedure PENDING_APPROVAL_PRIMARY(
68 p_sort_order in varchar2,
69 p_number_of_records in number,
70 p_approver_user_id in number,
71 x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE
72 );
73
74
75 /**
76 * Procedure : PENDING_APPROVAL_OWNER
77 * Type : Private
78 * Pre_reqs : None
79 * Description : Return the pending requests for the request owner
80 * Parameters :
81 * input parameters
82 * @param p_sort_order
83 * description: The sort order
84 * required : Y
85 * validation : Must be a valid sort order
86 * p_number_of_records:
87 * description: The number of records to retrieve from a database
88 * required : Y
89 * validation : Must be a valid number
90 * p_approver_user_id
91 * description: The user_id of a logged in user
92 * required : Y
93 * validation : Must be a valid user_id
94 * output parameters
95 * x_result: APPROVAL_REQUEST_TABLE_TYPE
96 */
97 procedure PENDING_APPROVAL_OWNER(
98 p_sort_order in varchar2,
99 p_number_of_records in number,
100 p_approver_user_id in number,
101 x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE
102 );
103
104
105 /**
106 * Function : getWFActivityStatus
107 * Type : Private
108 * Pre_reqs : None
109 * Description : Return the status of the given WF item
110 * Parameters :
111 * input parameters
112 * @param itemType
113 * description: The WF item type
114 * required : Y
115 * validation : Must be a valid WF item type
116 * itemKey:
117 * description: The WF item key
118 * required : Y
119 * validation : Must be a valid WF item key
120 *
121 * Return Value
122 * x_result: -1 => Errored WF
123 * -2 => Cancelled WF
124 * 0 => Active WF
125 */
126 function getWorkflowActivityStatus(itemType varchar2, itemKey varchar2) return number;
127
128 end JTF_UM_APPROVAL_REQUESTS_PVT;