1 PACKAGE JTF_UM_APPROVAL_REQUESTS_PVT AUTHID CURRENT_USER as
2 /* $Header: JTFVAPRS.pls 115.4 2002/11/22 01:35:16 kching 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 );
16
17 TYPE APPROVAL_REQUEST_TABLE_TYPE IS TABLE OF APPROVAL_REQUEST_TYPE INDEX BY BINARY_INTEGER;
18
19 /**
20 * Procedure : PENDING_APPROVAL_SYSADMIN
21 * Type : Private
22 * Pre_reqs : None
23 * Description : Return the pending requests foy sysadmin
24 * Parameters :
25 * input parameters
26 * @param p_sort_order
27 * description: The sort order
28 * required : Y
29 * validation : Must be a valid sort order
30 * p_number_of_records:
31 * description: The number of records to retrieve from a database
32 * required : Y
33 * validation : Must be a valid number
34 * output parameters
35 * x_result: APPROVAL_REQUEST_TABLE_TYPE
36 */
37 procedure PENDING_APPROVAL_SYSADMIN(
38 p_sort_order in varchar2,
39 p_number_of_records in number,
40 x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE
41 );
42
43
44 /**
45 * Procedure : PENDING_APPROVAL_PRIMARY
46 * Type : Private
47 * Pre_reqs : None
48 * Description : Return the pending requests foy Primary User
49 * Parameters :
50 * input parameters
51 * @param p_sort_order
52 * description: The sort order
53 * required : Y
54 * validation : Must be a valid sort order
55 * p_number_of_records:
56 * description: The number of records to retrieve from a database
57 * required : Y
58 * validation : Must be a valid number
59 * p_approver_user_id
60 * description: The user_id of a logged in user
61 * required : Y
62 * validation : Must be a valid user_id
63 * output parameters
64 * x_result: APPROVAL_REQUEST_TABLE_TYPE
65 */
66 procedure PENDING_APPROVAL_PRIMARY(
67 p_sort_order in varchar2,
68 p_number_of_records in number,
69 p_approver_user_id in number,
70 x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE
71 );
72
73
74 /**
75 * Procedure : PENDING_APPROVAL_OWNER
76 * Type : Private
77 * Pre_reqs : None
78 * Description : Return the pending requests for the request owner
79 * Parameters :
80 * input parameters
81 * @param p_sort_order
82 * description: The sort order
83 * required : Y
84 * validation : Must be a valid sort order
85 * p_number_of_records:
86 * description: The number of records to retrieve from a database
87 * required : Y
88 * validation : Must be a valid number
89 * p_approver_user_id
90 * description: The user_id of a logged in user
91 * required : Y
92 * validation : Must be a valid user_id
93 * output parameters
94 * x_result: APPROVAL_REQUEST_TABLE_TYPE
95 */
96 procedure PENDING_APPROVAL_OWNER(
97 p_sort_order in varchar2,
98 p_number_of_records in number,
99 p_approver_user_id in number,
100 x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE
101 );
102
103 end JTF_UM_APPROVAL_REQUESTS_PVT;