17: --Define Global Variables
18: ---------------------------------------------------------------------------
19: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_RESOURCES_PUB';
20: G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
21: G_FALSE CONSTANT VARCHAR2(30):=FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(30):=FND_API.G_TRUE;
23: ---------------------------------------------------------------------------
24:
25: --Define RECORD and TABLE types
18: ---------------------------------------------------------------------------
19: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_RESOURCES_PUB';
20: G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
21: G_FALSE CONSTANT VARCHAR2(30):=FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(30):=FND_API.G_TRUE;
23: ---------------------------------------------------------------------------
24:
25: --Define RECORD and TABLE types
26:
FND_API.G_RET_STS_SUCCESS
95: * @param p_required_units the required units to create the resource requirements
96: * @param p_enabled_flag the enabled flag to create the resource requirements
97: * @param x_return_status returns the result of all the operations performed
98: * by the API and must have one of the following values:
99: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
96: * @param p_enabled_flag the enabled flag to create the resource requirements
97: * @param x_return_status returns the result of all the operations performed
98: * by the API and must have one of the following values:
99: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_UNEXP_ERROR
97: * @param x_return_status returns the result of all the operations performed
98: * by the API and must have one of the following values:
99: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.
126: * @rep:compatibility S
127: */
128: Procedure CREATE_TASK_RSRC_REQ(
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
127: */
128: Procedure CREATE_TASK_RSRC_REQ(
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
128: Procedure CREATE_TASK_RSRC_REQ(
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
130: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
138: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
131: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
138: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: P_RESOURCE_TYPE_CODE IN VARCHAR2,
132: P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
138: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: P_RESOURCE_TYPE_CODE IN VARCHAR2,
140: P_REQUIRED_UNITS IN NUMBER,
133: P_TASK_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
138: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: P_RESOURCE_TYPE_CODE IN VARCHAR2,
140: P_REQUIRED_UNITS IN NUMBER,
141: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
134: P_TASK_NUMBER IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
135: P_TASK_TYPE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
136: P_TASK_TYPE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
137: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
138: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
139: P_RESOURCE_TYPE_CODE IN VARCHAR2,
140: P_REQUIRED_UNITS IN NUMBER,
141: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
142: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
FND_API.G_RET_STS_SUCCESS
186: * @param p_required_units the required units to update the resource requirements
187: * @param p_enabled_flag the enabled flag to update the resource requirements
188: * @param x_return_status returns the result of all the operations performed
189: * by the API and must have one of the following values:
190: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_ERROR
187: * @param p_enabled_flag the enabled flag to update the resource requirements
188: * @param x_return_status returns the result of all the operations performed
189: * by the API and must have one of the following values:
190: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_UNEXP_ERROR
188: * @param x_return_status returns the result of all the operations performed
189: * by the API and must have one of the following values:
190: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.
217: */
218: Procedure UPDATE_TASK_RSCR_REQ(
219: P_API_VERSION IN NUMBER,
220: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
221: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
223: P_RESOURCE_REQ_ID IN NUMBER,
224: P_TASK_ID IN NUMBER default fnd_api.g_miss_num,
225: P_TASK_NAME IN VARCHAR2 default null,
218: Procedure UPDATE_TASK_RSCR_REQ(
219: P_API_VERSION IN NUMBER,
220: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
221: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
223: P_RESOURCE_REQ_ID IN NUMBER,
224: P_TASK_ID IN NUMBER default fnd_api.g_miss_num,
225: P_TASK_NAME IN VARCHAR2 default null,
226: P_TASK_NUMBER IN VARCHAR2 default null,
220: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
221: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
223: P_RESOURCE_REQ_ID IN NUMBER,
224: P_TASK_ID IN NUMBER default fnd_api.g_miss_num,
225: P_TASK_NAME IN VARCHAR2 default null,
226: P_TASK_NUMBER IN VARCHAR2 default null,
227: P_TASK_TYPE_ID IN NUMBER default fnd_api.g_miss_num,
228: P_TASK_TYPE_NAME IN VARCHAR2 default null,
223: P_RESOURCE_REQ_ID IN NUMBER,
224: P_TASK_ID IN NUMBER default fnd_api.g_miss_num,
225: P_TASK_NAME IN VARCHAR2 default null,
226: P_TASK_NUMBER IN VARCHAR2 default null,
227: P_TASK_TYPE_ID IN NUMBER default fnd_api.g_miss_num,
228: P_TASK_TYPE_NAME IN VARCHAR2 default null,
229: P_TASK_TEMPLATE_ID IN NUMBER default fnd_api.g_miss_num,
230: P_TASK_TEMPLATE_NAME IN VARCHAR2 default null,
231: P_RESOURCE_TYPE_CODE IN VARCHAR2,
225: P_TASK_NAME IN VARCHAR2 default null,
226: P_TASK_NUMBER IN VARCHAR2 default null,
227: P_TASK_TYPE_ID IN NUMBER default fnd_api.g_miss_num,
228: P_TASK_TYPE_NAME IN VARCHAR2 default null,
229: P_TASK_TEMPLATE_ID IN NUMBER default fnd_api.g_miss_num,
230: P_TASK_TEMPLATE_NAME IN VARCHAR2 default null,
231: P_RESOURCE_TYPE_CODE IN VARCHAR2,
232: P_REQUIRED_UNITS IN NUMBER,
233: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
FND_API.G_RET_STS_SUCCESS
264: * the API to commit on their behalf after performing its function
265: * @param p_resource_req_id the resource requirements id for delete
266: * @param x_return_status returns the result of all the operations performed
267: * by the API and must have one of the following values:
268: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
265: * @param p_resource_req_id the resource requirements id for delete
266: * @param x_return_status returns the result of all the operations performed
267: * by the API and must have one of the following values:
268: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_UNEXP_ERROR
266: * @param x_return_status returns the result of all the operations performed
267: * by the API and must have one of the following values:
268: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.
279: */
280: procedure DELETE_TASK_RSRC_REQ(
281: P_API_VERSION IN NUMBER,
282: P_OBJECT_VERSION_NUMBER IN NUMBER,
283: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
284: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: P_RESOURCE_REQ_ID IN NUMBER,
286: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
287: X_MSG_COUNT OUT NOCOPY NUMBER,
280: procedure DELETE_TASK_RSRC_REQ(
281: P_API_VERSION IN NUMBER,
282: P_OBJECT_VERSION_NUMBER IN NUMBER,
283: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
284: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: P_RESOURCE_REQ_ID IN NUMBER,
286: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
287: X_MSG_COUNT OUT NOCOPY NUMBER,
288: X_MSG_DATA OUT NOCOPY VARCHAR2
FND_API.G_RET_STS_SUCCESS
315: * @param p_required_units the required units to be queried
316: * @param p_enabled_flag the enabled flag to be queried
317: * @param x_return_status returns the result of all the operations performed
318: * by the API and must have one of the following values:
319: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
316: * @param p_enabled_flag the enabled flag to be queried
317: * @param x_return_status returns the result of all the operations performed
318: * by the API and must have one of the following values:
319: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_UNEXP_ERROR
317: * @param x_return_status returns the result of all the operations performed
318: * by the API and must have one of the following values:
319: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_SUCCESS
373: * @param p_resource_requirement_id the resource requirement id to be locked
374: * @param p_object_version_number the object version number
375: * @param x_return_status returns the result of all the operations performed
376: * by the API and must have one of the following values:
377: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
374: * @param p_object_version_number the object version number
375: * @param x_return_status returns the result of all the operations performed
376: * by the API and must have one of the following values:
377: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.FND_API.G_RET_STS_UNEXP_ERROR
375: * @param x_return_status returns the result of all the operations performed
376: * by the API and must have one of the following values:
377: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
x_msg_count
returns number one.
387: * @rep:compatibility S
388: */
389: PROCEDURE LOCK_TASK_RESOURCES(
390: P_API_VERSION IN NUMBER,
391: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
392: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
393: P_RESOURCE_REQUIREMENT_ID IN NUMBER,
394: P_OBJECT_VERSION_NUMBER IN NUMBER,
395: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
388: */
389: PROCEDURE LOCK_TASK_RESOURCES(
390: P_API_VERSION IN NUMBER,
391: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
392: P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
393: P_RESOURCE_REQUIREMENT_ID IN NUMBER,
394: P_OBJECT_VERSION_NUMBER IN NUMBER,
395: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
396: X_MSG_DATA OUT NOCOPY VARCHAR2,