DBA Data[Home] [Help]

APPS.JTF_TASK_RESOURCES_PUB dependencies on JTF_TASK_UTL

Line 16: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no

12: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
13: , p_task_template_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
14: , p_resource_type_code IN VARCHAR2
15: , p_required_units IN NUMBER
16: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no
17: , x_return_status OUT NOCOPY VARCHAR2
18: , x_msg_count OUT NOCOPY NUMBER
19: , x_msg_data OUT NOCOPY VARCHAR2
20: , x_resource_req_id OUT NOCOPY NUMBER

Line 87: jtf_task_utl.validate_flag(

83: RAISE fnd_api.g_exc_unexpected_error;
84: END IF;
85:
86: --- Validate enabled flag
87: jtf_task_utl.validate_flag(
88: p_api_name => l_api_name
89: , p_init_msg_list => fnd_api.g_false
90: , x_return_status => l_return_status
91: , p_flag_name => 'Enabled_Flag'

Line 105: IF l_enabled_flag IN(jtf_task_utl.g_yes, jtf_task_utl.g_no) THEN

101: ---- if Enabled flag is null,Task is not Active
102:
103: --Validations for Task_id ,Task_template_id and task_type _id
104: --based on the status of P_ENABLED_FLAG
105: IF l_enabled_flag IN(jtf_task_utl.g_yes, jtf_task_utl.g_no) THEN
106: IF (p_task_template_id <> fnd_api.g_miss_num OR p_task_template_name <> fnd_api.g_miss_char) THEN
107: SELECT DECODE(p_task_template_id, fnd_api.g_miss_num, NULL, p_task_template_id)
108: INTO l_task_template_id
109: FROM DUAL;

Line 137: jtf_task_utl.validate_task(

133: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
134: INTO l_task_number
135: FROM DUAL;
136:
137: jtf_task_utl.validate_task(
138: x_return_status => l_return_status
139: , p_task_id => l_task_id
140: , p_task_number => l_task_number
141: , x_task_id => l_task_id

Line 319: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no

315: , p_task_template_id IN NUMBER DEFAULT fnd_api.g_miss_num
316: , p_task_template_name IN VARCHAR2 DEFAULT NULL
317: , p_resource_type_code IN VARCHAR2
318: , p_required_units IN NUMBER
319: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no
320: , x_return_status OUT NOCOPY VARCHAR2
321: , x_msg_count OUT NOCOPY NUMBER
322: , x_msg_data OUT NOCOPY VARCHAR2
323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

319: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no
320: , x_return_status OUT NOCOPY VARCHAR2
321: , x_msg_count OUT NOCOPY NUMBER
322: , x_msg_data OUT NOCOPY VARCHAR2
323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

320: , x_return_status OUT NOCOPY VARCHAR2
321: , x_msg_count OUT NOCOPY NUMBER
322: , x_msg_data OUT NOCOPY VARCHAR2
323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

321: , x_msg_count OUT NOCOPY NUMBER
322: , x_msg_data OUT NOCOPY VARCHAR2
323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

322: , x_msg_data OUT NOCOPY VARCHAR2
323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

323: , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

324: , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

325: , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

326: , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

327: , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

328: , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

329: , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

330: , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

331: , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
339: ) IS

Line 336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

332: , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
339: ) IS
340: l_api_version CONSTANT NUMBER := 1.0;

Line 337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

333: , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
339: ) IS
340: l_api_version CONSTANT NUMBER := 1.0;
341: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_RSRC_REQ';

Line 338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

334: , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
335: , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
336: , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
337: , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
338: , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
339: ) IS
340: l_api_version CONSTANT NUMBER := 1.0;
341: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_RSRC_REQ';
342: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 442: jtf_task_utl.validate_task(

438: ---- Here the task id is assigned null, if the task id is NOT input,
439: --- because then task number could be input.
440:
441: --- This means task id is being updated.
442: jtf_task_utl.validate_task(
443: x_return_status => l_return_status
444: , p_task_id => l_task_id
445: , p_task_number => l_task_number
446: , x_task_id => l_task_id

Line 449: jtf_task_utl.validate_task_template(

445: , p_task_number => l_task_number
446: , x_task_id => l_task_id
447: );
448: ELSE
449: jtf_task_utl.validate_task_template(
450: x_return_status => l_return_status
451: , p_task_id => l_task_template_id
452: , p_task_number => NULL
453: , x_task_id => l_task_template_id

Line 731: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no

727: , p_rec_wanted IN NUMBER
728: , p_show_all IN VARCHAR2 DEFAULT 'Y'
729: , p_resource_type_code IN VARCHAR2
730: , p_required_units IN NUMBER
731: , p_enabled_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no
732: , x_return_status OUT NOCOPY VARCHAR2
733: , x_msg_count OUT NOCOPY NUMBER
734: , x_msg_data OUT NOCOPY VARCHAR2
735: , x_task_rsc_req_rec OUT NOCOPY jtf_task_resources_pub.task_rsc_req_tbl