[Home] [Help]
PACKAGE: APPS.JTF_TASK_RESOURCES_PVT
Source
1 PACKAGE JTF_TASK_RESOURCES_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvtkrs.pls 115.21 2002/12/05 00:08:12 cjang ship $ */
3
4 ---------------------------------------------------------------------------
5 --Define Global Variables
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_RESOURCES_PVT' ;
8 G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
9 G_FALSE CONSTANT VARCHAR2(30):=FND_API.G_FALSE;
10 G_TRUE CONSTANT VARCHAR2(30):=FND_API.G_TRUE;
11 ---------------------------------------------------------------------------
12
13 --Define Record Variables
14
15 TYPE TASK_RSRC_REQ_REC is RECORD
16 ( RESOURCE_REQ_ID NUMBER ,
17 TASK_TYPE_ID NUMBER ,
18 TASK_TYPE_NAME VARCHAR2(30) ,
19 TASK_ID NUMBER ,
20 TASK_NAME VARCHAR(80) ,
21 TASK_NUMBER VARCHAR2(30) ,
22 TASK_TEMPLATE_ID NUMBER ,
23 TASK_TEMPLATE_NAME VARCHAR2(80) ,
24 RESOURCE_TYPE_CODE VARCHAR2(10) ,
25 REQUIRED_UNITS NUMBER ,
26 ENABLED_FLAG VARCHAR2(1) );
27
28
29
30 --Function to validate resource type code
31
32 Function validate_resource_type_code
33 (p_resource_type_code in varchar2 ) return boolean ;
34
35 PROCEDURE validate_task_template (
36 x_return_status OUT NOCOPY VARCHAR2 ,
37 p_task_template_id IN NUMBER DEFAULT NULL,
38 p_task_name IN VARCHAR2 DEFAULT NULL,
39 x_task_template_id OUT NOCOPY NUMBER ,
40 x_task_name OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE validate_task_type (
44 x_return_status OUT NOCOPY VARCHAR2 ,
45 p_task_type_id IN NUMBER DEFAULT NULL,
46 p_name IN VARCHAR2 DEFAULT NULL,
47 x_task_type_id OUT NOCOPY NUMBER ,
48 x_task_name OUT NOCOPY VARCHAR2
49 );
50
51
52 --Procedure to validate Enabled Flag
53
54 PROCEDURE VALIDATE_ENABLED_FLAG
55 (L_API_NAME IN VARCHAR2,
56 P_FLAG IN VARCHAR2,
57 P_FLAG_NAME IN VARCHAR2);
58
59
60 PROCEDURE dump_long_line
61 (txt IN VARCHAR2,
62 v_str IN VARCHAR2) ;
63
64
65
66
67 --Procedure to Create Task Resource Requirements
68
69 PROCEDURE CREATE_TASK_RSRC_REQ
70 (P_API_VERSION IN NUMBER ,
71 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
72 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
73 P_TASK_ID IN NUMBER DEFAULT NULL ,
74 P_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
75 P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL ,
76 P_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
77 P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT NULL ,
78 P_TASK_TEMPLATE_ID IN NUMBER DEFAULT NULL ,
79 P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT NULL ,
80 P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
81 P_REQUIRED_UNITS IN NUMBER ,
82 P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
83 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
84 X_MSG_COUNT OUT NOCOPY NUMBER ,
85 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
86 X_RESOURCE_REQ_ID OUT NOCOPY NUMBER ,
87 p_attribute1 IN VARCHAR2 DEFAULT null ,
88 p_attribute2 IN VARCHAR2 DEFAULT null ,
89 p_attribute3 IN VARCHAR2 DEFAULT null ,
90 p_attribute4 IN VARCHAR2 DEFAULT null ,
91 p_attribute5 IN VARCHAR2 DEFAULT null ,
92 p_attribute6 IN VARCHAR2 DEFAULT null ,
93 p_attribute7 IN VARCHAR2 DEFAULT null ,
94 p_attribute8 IN VARCHAR2 DEFAULT null ,
95 p_attribute9 IN VARCHAR2 DEFAULT null ,
96 p_attribute10 IN VARCHAR2 DEFAULT null ,
97 p_attribute11 IN VARCHAR2 DEFAULT null ,
98 p_attribute12 IN VARCHAR2 DEFAULT null ,
99 p_attribute13 IN VARCHAR2 DEFAULT null ,
100 p_attribute14 IN VARCHAR2 DEFAULT null ,
101 p_attribute15 IN VARCHAR2 DEFAULT null ,
102 p_attribute_category IN VARCHAR2 DEFAULT null
103 ) ;
104
105
106
107
108 --Procedure to Update the Task Resource Requirements
109
110
111 PROCEDURE UPDATE_TASK_RSCR_REQ
112 (P_API_VERSION IN NUMBER ,
113 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
114 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
115 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
116 P_RESOURCE_REQ_ID IN NUMBER ,
117 P_TASK_ID IN NUMBER DEFAULT NULL ,
118 P_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
119 P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL ,
120 P_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
121 P_TASK_TYPE_NAME IN VARCHAR2 ,
122 P_TASK_TEMPLATE_ID IN NUMBER DEFAULT NULL ,
123 P_TASK_TEMPLATE_NAME IN VARCHAR2 ,
124 P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
125 P_REQUIRED_UNITS IN NUMBER ,
126 P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
127 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
128 X_MSG_COUNT OUT NOCOPY NUMBER ,
129 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
130 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
131 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
132 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
133 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
134 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
135 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
136 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
137 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
138 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
139 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
140 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
141 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
142 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
143 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
144 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
145 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
146
147 );
148
149
150
151 --Procedure to Delete the Task Resource Requirements
152
153
154
155 PROCEDURE DELETE_TASK_RSRC_REQ
156 (P_API_VERSION IN NUMBER ,
157 P_OBJECT_VERSION_NUMBER IN NUMBER ,
158 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
159 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
160 P_RESOURCE_REQ_ID IN NUMBER ,
161 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
162 X_MSG_COUNT OUT NOCOPY NUMBER ,
163 X_MSG_DATA OUT NOCOPY VARCHAR2 );
164
165
166 --Procedure to get the Task Resource Req
167
168
169
170 PROCEDURE GET_TASK_RSRC_REQ
171 (
172 P_API_VERSION IN NUMBER ,
173 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT G_FALSE ,
174 P_COMMIT IN VARCHAR2 DEFAULT G_FALSE ,
175 P_RESOURCE_REQ_ID IN NUMBER ,
176 P_RESOURCE_REQ_NAME IN VARCHAR2 DEFAULT NULL ,
177 P_TASK_ID IN NUMBER DEFAULT NULL ,
178 P_TASK_NAME IN VARCHAR2 DEFAULT NULL ,
179 P_TASK_TYPE_ID IN NUMBER DEFAULT NULL ,
180 P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT NULL ,
181 P_TASK_TEMPLATE_ID IN NUMBER DEFAULT NULL ,
182 P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT NULL ,
183 P_SORT_DATA IN JTF_TASK_RESOURCES_PUB.SORT_DATA ,
184 P_QUERY_OR_NEXT_CODE IN VARCHAR2 DEFAULT 'Q' ,
185 P_START_POINTER IN NUMBER ,
186 P_REC_WANTED IN NUMBER ,
187 P_SHOW_ALL IN VARCHAR2 DEFAULT 'Y' ,
188 P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
189 P_REQUIRED_UNITS IN NUMBER ,
190 P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
191 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
192 X_MSG_COUNT OUT NOCOPY NUMBER ,
193 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
194 X_TASK_RSC_REQ_REC OUT NOCOPY JTF_TASK_RESOURCES_PUB.TASK_RSC_REQ_TBL,
195 X_TOTAL_RETRIEVED OUT NOCOPY NUMBER ,
196 X_TOTAL_RETURNED OUT NOCOPY NUMBER );
197
198
199
200
201 END ;