DBA Data[Home] [Help]

APPS.JTF_TASK_DEPENDENCY_PUB dependencies on JTF_TASK_UTL

Line 15: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,

11: p_task_number IN VARCHAR2 DEFAULT NULL,
12: p_dependent_on_task_id IN NUMBER DEFAULT NULL,
13: p_dependent_on_task_number IN VARCHAR2 DEFAULT NULL,
14: p_dependency_type_code IN VARCHAR2,
15: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
16: p_adjustment_time IN NUMBER DEFAULT NULL,
17: p_adjustment_time_uom IN VARCHAR2 DEFAULT NULL,
18: p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
19: x_dependency_id OUT NOCOPY NUMBER,

Line 18: p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,

14: p_dependency_type_code IN VARCHAR2,
15: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
16: p_adjustment_time IN NUMBER DEFAULT NULL,
17: p_adjustment_time_uom IN VARCHAR2 DEFAULT NULL,
18: p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
19: x_dependency_id OUT NOCOPY NUMBER,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,

Line 67: jtf_task_utl.validate_flag (

63: fnd_msg_pub.initialize;
64: END IF;
65:
66: --- Validate if the template flag is in the following fnd_api.g_true , fnd_api.g_false , NULL
67: jtf_task_utl.validate_flag (
68: p_api_name => l_api_name,
69: p_init_msg_list => fnd_api.g_false,
70: x_return_status => x_return_status,
71: p_flag_name => 'Template Flag',

Line 85: IF jtf_task_utl.to_boolean (l_template_flag)

81:
82:
83: ---- The dependecy is between the tasks
84: ---- if the template flag is null, it assumes the dependency is between the tasks.
85: IF jtf_task_utl.to_boolean (l_template_flag)
86: THEN
87: jtf_task_utl.validate_task_template (
88: x_return_status => x_return_status,
89: p_task_id => l_task_id,

Line 87: jtf_task_utl.validate_task_template (

83: ---- The dependecy is between the tasks
84: ---- if the template flag is null, it assumes the dependency is between the tasks.
85: IF jtf_task_utl.to_boolean (l_template_flag)
86: THEN
87: jtf_task_utl.validate_task_template (
88: x_return_status => x_return_status,
89: p_task_id => l_task_id,
90: p_task_number => l_task_number,
91: x_task_id => l_task_id

Line 109: jtf_task_utl.validate_task_template (

105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_unexpected_error;
107: END IF;
108:
109: jtf_task_utl.validate_task_template (
110: x_return_status => x_return_status,
111: p_task_id => l_dependent_on_task_id,
112: p_task_number => l_dependent_on_task_number,
113: x_task_id => l_dependent_on_task_id

Line 130: jtf_task_utl.validate_task (

126: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
127: RAISE fnd_api.g_exc_unexpected_error;
128: END IF;
129: ELSE
130: jtf_task_utl.validate_task (
131: x_return_status => x_return_status,
132: p_task_id => l_task_id,
133: p_task_number => l_task_number,
134: x_task_id => l_task_id

Line 153: jtf_task_utl.validate_task (

149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;
151:
152:
153: jtf_task_utl.validate_task (
154: x_return_status => x_return_status,
155: p_task_id => l_dependent_on_task_id,
156: p_task_number => l_dependent_on_task_number,
157: x_task_id => l_dependent_on_task_id

Line 176: IF NOT jtf_task_utl.validate_dependency_code (l_dependency_type_code)

172: END IF;
173:
174: END IF;
175:
176: IF NOT jtf_task_utl.validate_dependency_code (l_dependency_type_code)
177: THEN
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;

Line 182: jtf_task_utl.validate_effort (x_return_status => x_return_status, p_effort => l_adjustment_time, p_effort_uom => l_adjustment_time_uom);

178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;
181:
182: jtf_task_utl.validate_effort (x_return_status => x_return_status, p_effort => l_adjustment_time, p_effort_uom => l_adjustment_time_uom);
183:
184: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
185: THEN
186: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 337: p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,

333: p_dependent_on_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
334: p_dependency_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
335: p_adjustment_time IN NUMBER DEFAULT fnd_api.g_miss_num,
336: p_adjustment_time_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
337: p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

337: p_validated_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

341: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

342: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

343: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

344: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

345: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

346: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

347: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

348: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
356: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

349: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
356: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
357: )

Line 354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

350: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
356: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
357: )
358: IS

Line 355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

351: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
356: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
357: )
358: IS
359: l_api_version CONSTANT NUMBER := 1.0;

Line 356: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

352: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
353: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
354: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
355: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
356: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
357: )
358: IS
359: l_api_version CONSTANT NUMBER := 1.0;
360: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';

Line 458: jtf_task_utl.validate_task (

454: ---- Here the task id is assigned null, if the task id is NOT input,
455: --- because then task number could be input.
456:
457: --- This means task id is being updated.
458: jtf_task_utl.validate_task (
459: x_return_status => x_return_status,
460: p_task_id => l_dependent_on_task_id,
461: p_task_number => l_dependent_on_task_number,
462: x_task_id => l_dependent_on_task_id

Line 465: jtf_task_utl.validate_task_template (

461: p_task_number => l_dependent_on_task_number,
462: x_task_id => l_dependent_on_task_id
463: );
464: ELSE
465: jtf_task_utl.validate_task_template (
466: x_return_status => x_return_status,
467: p_task_id => l_dependent_on_task_id,
468: p_task_number => l_dependent_on_task_number,
469: x_task_id => l_dependent_on_task_id

Line 498: IF NOT jtf_task_utl.validate_dependency_code (l_dependency_type_code)

494: --- if the dependency type code is supplied then
495: --- check if it exists
496: l_dependency_type_code := task_depends.dependency_type_code;
497: ELSE
498: IF NOT jtf_task_utl.validate_dependency_code (l_dependency_type_code)
499: THEN
500: x_return_status := fnd_api.g_ret_sts_unexp_error;
501: RAISE fnd_api.g_exc_unexpected_error;
502: END IF;