1 PACKAGE JTF_UM_SUBSCRIPTION_INFO AUTHID CURRENT_USER as
2 /*$Header: JTFVSBIS.pls 115.4 2002/11/21 22:57:56 kching ship $*/
3
4
5 TYPE SUBSCRIPTION_INFO IS RECORD
6 (
7 NAME JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_NAME%TYPE := FND_API.G_MISS_CHAR,
8 KEY JTF_UM_SUBSCRIPTIONS_B.SUBSCRIPTION_KEY%TYPE := FND_API.G_MISS_CHAR,
9 DESCRIPTION JTF_UM_SUBSCRIPTIONS_TL.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
10 DISPLAY_ORDER NUMBER := FND_API.G_MISS_NUM,
11 ACTIVATION_MODE JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_FLAG%TYPE := FND_API.G_MISS_CHAR,
12 DELEGATION_ROLE NUMBER := FND_API.G_MISS_NUM,
13 CHECKBOX_STATUS NUMBER := FND_API.G_MISS_NUM,
14 APPROVAL_REQUIRED NUMBER := FND_API.G_MISS_NUM,
15 SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM,
16 SUBSCRIPTION_REG_ID NUMBER := FND_API.G_MISS_NUM,
17 APPROVAL_ID NUMBER := FND_API.G_MISS_NUM,
18 IS_USER_ENROLLED NUMBER := FND_API.G_MISS_NUM,
19 SUBSCRIPTION_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 TEMPLATE_HANDLER JTF_UM_TEMPLATES_B.TEMPLATE_HANDLER%TYPE := FND_API.G_MISS_CHAR,
21 PAGE_NAME JTF_UM_TEMPLATES_B.PAGE_NAME%TYPE := FND_API.G_MISS_CHAR
22 );
23
24 TYPE SUBSCRIPTION_ID_REC IS RECORD
25 (
26 SUBSCRIPTION_ID NUMBER := FND_API.G_MISS_NUM
27 );
28
29 TYPE SUBSCRIPTION_INFO_TABLE IS TABLE OF SUBSCRIPTION_INFO INDEX BY BINARY_INTEGER;
30
31 TYPE SUBSCRIPTION_LIST IS TABLE OF SUBSCRIPTION_ID_REC INDEX BY BINARY_INTEGER;
32
33 /**
34 * Procedure : GET_USERTYPE_SUB_INFO
35 * Type : Private
36 * Pre_reqs : None
37 * Description : Returns the enrollment information for a user type
38 * Parameters :
39 * input parameters
40 * @param p_usertype_id
41 * description: The user type id
42 * required : Y
43 * validation : Must be a valid user type id
44 * @param p_user_id
45 * description: The user id of a logged in user
46 * required : Y
47 * validation : Must be a valid user id
48 * @param p_is_admin
49 * description: To know, if logged in user is an admin
50 * required : Y
51 * validation : Must be 0 or 1
52 * output parameters
53 * x_result: SUBSCRIPTION_INFO_TABLE
54 */
55
56 procedure GET_USERTYPE_SUB_INFO(
57 p_usertype_id in number,
58 p_user_id in number,
59 p_is_admin in number,
60 x_result out NOCOPY SUBSCRIPTION_INFO_TABLE
61 );
62
63
64 /**
65 * Procedure : GET_USER_SUB_INFO
66 * Type : Private
67 * Pre_reqs : None
68 * Description : Returns the enrollment information for a user type
69 * Parameters :
70 * input parameters
71 * @param p_user_id
72 * description: The user id for which enrollments are queried
73 * required : Y
74 * validation : Must be a valid user id
75 * @param p_is_admin
76 * description: To know, if logged in user is an admin
77 * required : Y
78 * validation : Must be 0 or 1
79 * @param p_logged_in_user_id
80 * description: The user id of logged in user
81 * required : Y
82 * validation : Must be a valid user id
83 * @param p_sub_status
84 * description: The status of the enrollment assignment
85 * required : Y
86 * validation : Must be 'AVAILABLE', 'APPROVED' or 'PENDING'
87 * output parameters
88 * x_result: SUBSCRIPTION_INFO_TABLE
89 */
90
91 procedure GET_USER_SUB_INFO(
92 p_user_id in number,
93 p_is_admin in number,
94 p_logged_in_user_id in number,
95 p_administrator in number,
96 p_sub_status in varchar2,
97 x_result out NOCOPY SUBSCRIPTION_INFO_TABLE
98 ) ;
99
100 /**
101 * Procedure : GET_CONF_SUB_INFO
102 * Type : Private
103 * Pre_reqs : None
104 * Description : Returns the enrollment information for a user type
105 * Parameters :
106 * input parameters
107 * @param p_user_id
108 * description: The user id
109 * required : Y
110 * validation : Must be a valid user id
111 * @param p_usetype_id
112 * description: The user type id
113 * required : Y
114 * validation : Must be a valid user type id
115 * @param p_sub_list
116 * description: The list of enrollments
117 * required : Y
118 * validation : Must be a valid list
119 * output parameters
120 * x_result: SUBSCRIPTION_INFO_TABLE
121 */
122 procedure GET_CONF_SUB_INFO(
123 p_user_id in number,
124 p_usertype_id in number,
125 p_is_admin in number,
126 p_admin_id in number,
127 p_administrator in number,
128 p_sub_list in SUBSCRIPTION_LIST,
129 x_result out NOCOPY SUBSCRIPTION_INFO_TABLE
130 ) ;
131
132 /**
133 * Procedure : GET_USERTYPE_SUB
134 * Type : Private
135 * Pre_reqs : None
136 * Description : Returns the enrollment information for a user type
137 * Parameters :
138 * input parameters
139 * @param p_usetype_id
140 * description: The user type id
141 * required : Y
142 * validation : Must be a valid user type id
143 * @param p_user_id
144 * description: The user id
145 * required : Y
146 * validation : Must be a valid user id
147 * @param p_sub_list
148 * description: The list of enrollments
149 * required : Y
150 * validation : Must be a valid list
151 * @param p_is_admin
152 * description: To know, if logged in user is an admin
153 * required : Y
154 * validation : Must be 0 or 1
155 * output parameters
156 * x_result: SUBSCRIPTION_INFO_TABLE
157 */
158 procedure GET_USERTYPE_SUB(
159 p_usertype_id in number,
160 p_user_id in number,
161 p_is_admin in number,
162 p_admin_id in number,
163 p_sub_list in SUBSCRIPTION_LIST,
164 x_result out NOCOPY SUBSCRIPTION_INFO_TABLE
165 ) ;
166
167
168 end JTF_UM_SUBSCRIPTION_INFO;