DBA Data[Home] [Help]

APPS.JTF_TASK_RESOURCES_PVT dependencies on JTF_TASK_UTL

Line 163: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,

159: P_TASK_TEMPLATE_ID IN NUMBER DEFAULT NULL ,
160: P_TASK_TEMPLATE_NAME IN VARCHAR2 DEFAULT NULL ,
161: P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
162: P_REQUIRED_UNITS IN NUMBER ,
163: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
164: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
165: X_MSG_COUNT OUT NOCOPY NUMBER ,
166: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
167: X_RESOURCE_REQ_ID OUT NOCOPY NUMBER ,

Line 229: --if p_enabled_flag = jtf_task_utl.g_yes then

225: x_return_status := fnd_api.g_ret_sts_success ;
226:
227:
228:
229: --if p_enabled_flag = jtf_task_utl.g_yes then
230:
231:
232: select JTF_TASK_RSC_REQS_S.nextval into l_resource_req_id
233: from dual ;

Line 265: X_CREATED_BY => jtf_task_utl.created_by ,

261: x_attribute15 => p_attribute15,
262: x_attribute_category => p_attribute_category ,
263: X_RESOURCE_TYPE_CODE =>l_resource_type_code,
264: X_CREATION_DATE => sysdate ,
265: X_CREATED_BY => jtf_task_utl.created_by ,
266: X_LAST_UPDATE_DATE => sysdate ,
267: X_LAST_UPDATED_BY => -1 ,
268: X_LAST_UPDATE_LOGIN => jtf_task_utl.login_id );
269:

Line 268: X_LAST_UPDATE_LOGIN => jtf_task_utl.login_id );

264: X_CREATION_DATE => sysdate ,
265: X_CREATED_BY => jtf_task_utl.created_by ,
266: X_LAST_UPDATE_DATE => sysdate ,
267: X_LAST_UPDATED_BY => -1 ,
268: X_LAST_UPDATE_LOGIN => jtf_task_utl.login_id );
269:
270:
271:
272:

Line 328: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,

324: P_TASK_TEMPLATE_ID IN NUMBER default null ,
325: P_TASK_TEMPLATE_NAME IN VARCHAR2 ,
326: P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
327: P_REQUIRED_UNITS IN NUMBER ,
328: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
329: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
330: X_MSG_COUNT OUT NOCOPY NUMBER ,
331: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

328: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
329: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
330: X_MSG_COUNT OUT NOCOPY NUMBER ,
331: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

329: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
330: X_MSG_COUNT OUT NOCOPY NUMBER ,
331: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

330: X_MSG_COUNT OUT NOCOPY NUMBER ,
331: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

331: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

332: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

333: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

334: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

335: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

336: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

337: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

338: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

339: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char ) IS

Line 344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

340: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char ) IS
348:

Line 345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

341: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char ) IS
348:
349:

Line 346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

342: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char ) IS
348:
349:
350: --Declare the variables

Line 347: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char ) IS

343: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char ) IS
348:
349:
350: --Declare the variables
351: --

Line 437: L_ENABLED_FLAG := jtf_task_utl.g_no ;

433:
434: l_enabled_flag := task_res.ENABLED_FLAG ;
435:
436: if L_ENABLED_FLAG IS NULL THEN
437: L_ENABLED_FLAG := jtf_task_utl.g_no ;
438: END IF ;
439:
440: if l_task_id IS NULL then
441:

Line 517: X_LAST_UPDATE_LOGIN =>jtf_task_utl.login_id

513: x_attribute_category => task_res.attribute_category ,
514: X_RESOURCE_TYPE_CODE => l_resource_type_code,
515: X_LAST_UPDATE_DATE =>sysdate,
516: X_LAST_UPDATED_BY => -1 ,
517: X_LAST_UPDATE_LOGIN =>jtf_task_utl.login_id
518: );
519:
520:
521:

Line 691: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,

687: P_REC_WANTED IN NUMBER ,
688: P_SHOW_ALL IN VARCHAR2 default 'Y' ,
689: P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
690: P_REQUIRED_UNITS IN NUMBER ,
691: P_ENABLED_FLAG IN VARCHAR2 DEFAULT jtf_task_utl.g_no ,
692: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
693: X_MSG_COUNT OUT NOCOPY NUMBER ,
694: X_MSG_DATA OUT NOCOPY VARCHAR2 ,
695: X_TASK_RSC_REQ_REC OUT NOCOPY JTF_TASK_RESOURCES_PUB.TASK_RSC_REQ_TBL,