eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_DEPENDENCY_PVT dependencies on JTF_TASK_DEPENDS

Line 156: from jtf_task_depends

152: l_dependent_on_task_id in number,
153: l_dependency_id in number)
154: is
155: select 1
156: from jtf_task_depends
157: where task_id = l_task_id
158: and dependent_on_task_id = l_dependent_on_task_id
159: and dependency_id <> l_dependency_id
160: and template_flag = 'Y';

Line 168: from jtf_task_depends

164: l_dependent_on_task_id in number,
165: l_dependency_id in number)
166: is
167: select 1
168: from jtf_task_depends
169: where task_id = l_task_id
170: and dependent_on_task_id = l_dependent_on_task_id
171: and dependency_id <> l_dependency_id
172: and (template_flag = 'N' or template_flag is null);

Line 178: from jtf_task_depends

174: -- Cursor for checking if there is a cyclic chain dependency
175: cursor c_check_cyc_temp_y (l_dependency_id in number)
176: is
177: select 1
178: from jtf_task_depends
179: where task_id = p_dependent_on_task_id
180: and dependency_id <> l_dependency_id
181: connect by prior task_id = dependent_on_task_id
182: start with dependent_on_task_id = p_task_id

Line 189: from jtf_task_depends

185: -- Cursor for checking if there is a cyclic chain dependency
186: cursor c_check_cyc_temp_n (l_dependency_id in number)
187: is
188: select 1
189: from jtf_task_depends
190: where task_id = p_dependent_on_task_id
191: and dependency_id <> l_dependency_id
192: connect by prior task_id = dependent_on_task_id
193: start with dependent_on_task_id = p_task_id

Line 217: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_EXISTS');

213: if c_check_dup_temp_y%found
214: then
215: close c_check_dup_temp_y;
216: l_return_status := fnd_api.g_ret_sts_error;
217: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_EXISTS');
218: fnd_msg_pub.add;
219: raise fnd_api.g_exc_error;
220: end if;
221: close c_check_dup_temp_y;

Line 230: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_RVERSE_EXISTS');

226: if c_check_dup_temp_y%found
227: then
228: close c_check_dup_temp_y;
229: l_return_status := fnd_api.g_ret_sts_error;
230: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_RVERSE_EXISTS');
231: fnd_msg_pub.add;
232: raise fnd_api.g_exc_error;
233: end if;
234: close c_check_dup_temp_y;

Line 243: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_CYCLICAL');

239: if c_check_cyc_temp_y%found
240: then
241: close c_check_cyc_temp_y;
242: l_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_CYCLICAL');
244: fnd_msg_pub.add;
245: raise fnd_api.g_exc_error;
246: end if;
247: close c_check_cyc_temp_y;

Line 257: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_EXISTS');

253: if c_check_dup_temp_n%found
254: then
255: close c_check_dup_temp_n;
256: l_return_status := fnd_api.g_ret_sts_error;
257: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_EXISTS');
258: fnd_msg_pub.add;
259: raise fnd_api.g_exc_error;
260: end if;
261: close c_check_dup_temp_n;

Line 270: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_RVERSE_EXISTS');

266: if c_check_dup_temp_n%found
267: then
268: close c_check_dup_temp_n;
269: l_return_status := fnd_api.g_ret_sts_error;
270: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_RVERSE_EXISTS');
271: fnd_msg_pub.add;
272: raise fnd_api.g_exc_error;
273: end if;
274: close c_check_dup_temp_n;

Line 283: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_CYCLICAL');

279: if c_check_cyc_temp_n%found
280: then
281: close c_check_cyc_temp_n;
282: l_return_status := fnd_api.g_ret_sts_unexp_error;
283: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_CYCLICAL');
284: fnd_msg_pub.add;
285: raise fnd_api.g_exc_error;
286: end if;
287: close c_check_cyc_temp_n;

Line 318: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;

314: p_template_flag in varchar2 default 'N')
315: is
316: l_api_version constant number := 1.0;
317: l_api_name constant varchar2(30) := 'RECONNECT_DEPENDENCY';
318: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;
319: x_dependency_id jtf_task_depends.dependency_id%TYPE;
320:
321: -- Cursor for finding successor dependencies
322: cursor c_successor_dependency

Line 319: x_dependency_id jtf_task_depends.dependency_id%TYPE;

315: is
316: l_api_version constant number := 1.0;
317: l_api_name constant varchar2(30) := 'RECONNECT_DEPENDENCY';
318: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;
319: x_dependency_id jtf_task_depends.dependency_id%TYPE;
320:
321: -- Cursor for finding successor dependencies
322: cursor c_successor_dependency
323: is

Line 330: from jtf_task_depends

326: dependency_type_code,
327: adjustment_time,
328: adjustment_time_uom,
329: object_version_number
330: from jtf_task_depends
331: where dependent_on_task_id = p_task_id and
332: (template_flag is null or template_flag = 'N');
333:
334: -- Cursor for finding successor dependencies for template

Line 343: from jtf_task_depends

339: dependency_type_code,
340: adjustment_time,
341: adjustment_time_uom,
342: object_version_number
343: from jtf_task_depends
344: where dependent_on_task_id = p_task_id and template_flag = 'Y';
345:
346: -- Cursor for finding predecessor dependencies
347: cursor c_predecessor_dependency

Line 355: from jtf_task_depends

351: dependency_type_code,
352: adjustment_time,
353: adjustment_time_uom,
354: object_version_number
355: from jtf_task_depends
356: where task_id = p_task_id and
357: (template_flag is null or template_flag = 'N');
358:
359:

Line 369: from jtf_task_depends

365: dependency_type_code,
366: adjustment_time,
367: adjustment_time_uom,
368: object_version_number
369: from jtf_task_depends
370: where task_id = p_task_id and template_flag = 'Y';
371:
372: parent_depend c_predecessor_dependency%rowtype;
373: child_depend c_successor_dependency%rowtype;

Line 495: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;

491: IS
492:
493: l_api_version CONSTANT NUMBER := 1.0;
494: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
495: l_dependency_id jtf_task_depends.dependency_id%TYPE := -1;
496: l_rowid ROWID;
497: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
498: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
499: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

Line 576: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');

572: l_d_source_object_type_code is not null) or
573: (l_source_object_type_code is not null and
574: l_d_source_object_type_code is null))
575: then
576: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
577: fnd_msg_pub.add;
578: raise fnd_api.g_exc_error;
579: end if;
580:

Line 585: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');

581: if (l_source_object_type_code is not null and l_d_source_object_type_code is not null)
582: then
583: if (l_source_object_type_code <> l_d_source_object_type_code)
584: then
585: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
586: fnd_msg_pub.add;
587: raise fnd_api.g_exc_error;
588: end if;
589: end if;

Line 610: SELECT jtf_task_depends_s.nextval

606: raise fnd_api.g_exc_error;
607: end if;
608:
609:
610: SELECT jtf_task_depends_s.nextval
611: INTO l_dependency_id
612: FROM dual;
613:
614: jtf_task_depends_pkg.insert_row (

Line 614: jtf_task_depends_pkg.insert_row (

610: SELECT jtf_task_depends_s.nextval
611: INTO l_dependency_id
612: FROM dual;
613:
614: jtf_task_depends_pkg.insert_row (
615: x_rowid => l_rowid,
616: x_dependency_id => l_dependency_id,
617: x_task_id => p_task_id,
618: x_dependent_on_task_id => p_dependent_on_task_id,

Line 728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;

724: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;

Line 729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;

725: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;

Line 730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;

726: l_d_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
734: l_template_flag jtf_task_depends.template_flag%TYPE;

Line 731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;

727: l_d_source_object_id jtf_tasks_b.source_object_id%TYPE;
728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
734: l_template_flag jtf_task_depends.template_flag%TYPE;
735: Resource_Locked exception ;

Line 732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;

728: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
734: l_template_flag jtf_task_depends.template_flag%TYPE;
735: Resource_Locked exception ;
736:

Line 733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;

729: l_task_id jtf_task_depends.task_id%TYPE := p_task_id;
730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
734: l_template_flag jtf_task_depends.template_flag%TYPE;
735: Resource_Locked exception ;
736:
737: PRAGMA EXCEPTION_INIT ( Resource_Locked , - 54 ) ;

Line 734: l_template_flag jtf_task_depends.template_flag%TYPE;

730: l_dependent_on_task_id jtf_task_depends.dependent_on_task_id%TYPE := p_dependent_on_task_id;
731: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
732: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
733: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
734: l_template_flag jtf_task_depends.template_flag%TYPE;
735: Resource_Locked exception ;
736:
737: PRAGMA EXCEPTION_INIT ( Resource_Locked , - 54 ) ;
738:

Line 740: CURSOR c_jtf_task_depends

736:
737: PRAGMA EXCEPTION_INIT ( Resource_Locked , - 54 ) ;
738:
739:
740: CURSOR c_jtf_task_depends
741: IS
742: SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id,
743: DECODE (p_dependent_on_task_id, fnd_api.g_miss_num, dependent_on_task_id, p_dependent_on_task_id) dependent_on_task_id,
744: DECODE (p_dependency_type_code, fnd_api.g_miss_char, dependency_type_code, p_dependency_type_code) dependency_type_code,

Line 765: FROM jtf_task_depends

761: DECODE( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
762: DECODE( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
763: DECODE( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
764: DECODE( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
765: FROM jtf_task_depends
766: WHERE dependency_id = l_dependency_id;
767:
768: task_depends c_jtf_task_depends%ROWTYPE;
769: BEGIN

Line 768: task_depends c_jtf_task_depends%ROWTYPE;

764: DECODE( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
765: FROM jtf_task_depends
766: WHERE dependency_id = l_dependency_id;
767:
768: task_depends c_jtf_task_depends%ROWTYPE;
769: BEGIN
770: --- This does not check between tasks and templates
771: --- because it is assumed the same is validated before
772: --- calling this proc.

Line 777: OPEN c_jtf_task_depends;

773:
774: SAVEPOINT update_task_dependency_pvt;
775: x_return_status := fnd_api.g_ret_sts_success;
776:
777: OPEN c_jtf_task_depends;
778: FETCH c_jtf_task_depends INTO task_depends;
779:
780: IF c_jtf_task_depends%NOTFOUND
781: THEN

Line 778: FETCH c_jtf_task_depends INTO task_depends;

774: SAVEPOINT update_task_dependency_pvt;
775: x_return_status := fnd_api.g_ret_sts_success;
776:
777: OPEN c_jtf_task_depends;
778: FETCH c_jtf_task_depends INTO task_depends;
779:
780: IF c_jtf_task_depends%NOTFOUND
781: THEN
782: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');

Line 780: IF c_jtf_task_depends%NOTFOUND

776:
777: OPEN c_jtf_task_depends;
778: FETCH c_jtf_task_depends INTO task_depends;
779:
780: IF c_jtf_task_depends%NOTFOUND
781: THEN
782: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
783: fnd_message.set_token ('P_DEPENDENCY_ID', p_dependency_id);
784: fnd_msg_pub.add;

Line 878: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');

874: l_d_source_object_type_code is not null) or
875: (l_source_object_type_code is not null and
876: l_d_source_object_type_code is null))
877: then
878: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
879: fnd_msg_pub.add;
880: raise fnd_api.g_exc_error;
881: end if;
882:

Line 887: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');

883: if (l_source_object_type_code is not null and l_d_source_object_type_code is not null)
884: then
885: if (l_source_object_type_code <> l_d_source_object_type_code)
886: then
887: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
888: fnd_msg_pub.add;
889: raise fnd_api.g_exc_error;
890: end if;
891: end if;

Line 912: jtf_task_depends_pkg.lock_row(

908: raise fnd_api.g_exc_error;
909: end if;
910:
911:
912: jtf_task_depends_pkg.lock_row(
913: x_dependency_id => p_dependency_id ,
914: x_object_version_number => p_object_version_number );
915:
916:

Line 917: jtf_task_depends_pkg.update_row (

913: x_dependency_id => p_dependency_id ,
914: x_object_version_number => p_object_version_number );
915:
916:
917: jtf_task_depends_pkg.update_row (
918: x_dependency_id => l_dependency_id,
919: x_object_version_number => p_object_version_number + 1,
920: x_task_id => l_task_id,
921: x_dependent_on_task_id => l_dependent_on_task_id,

Line 948: IF c_jtf_task_depends%ISOPEN

944: x_last_updated_by => jtf_task_utl.updated_by,
945: x_last_update_login => -1
946: );
947:
948: IF c_jtf_task_depends%ISOPEN
949: THEN
950: CLOSE c_jtf_task_depends;
951: END IF;
952:

Line 950: CLOSE c_jtf_task_depends;

946: );
947:
948: IF c_jtf_task_depends%ISOPEN
949: THEN
950: CLOSE c_jtf_task_depends;
951: END IF;
952:
953: IF fnd_api.to_boolean (p_commit)
954: THEN

Line 973: IF c_jtf_task_depends%ISOPEN

969: x_return_status := fnd_api.g_ret_sts_error;
970: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
971: WHEN fnd_api.g_exc_unexpected_error
972: THEN
973: IF c_jtf_task_depends%ISOPEN
974: THEN
975: CLOSE c_jtf_task_depends;
976: END IF;
977: ROLLBACK TO update_task_dependency_pvt;

Line 975: CLOSE c_jtf_task_depends;

971: WHEN fnd_api.g_exc_unexpected_error
972: THEN
973: IF c_jtf_task_depends%ISOPEN
974: THEN
975: CLOSE c_jtf_task_depends;
976: END IF;
977: ROLLBACK TO update_task_dependency_pvt;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 995: IF c_jtf_task_depends%ISOPEN

991: x_return_status := fnd_api.g_ret_sts_unexp_error;
992: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
993: WHEN OTHERS
994: THEN
995: IF c_jtf_task_depends%ISOPEN
996: THEN
997: CLOSE c_jtf_task_depends;
998: END IF;
999:

Line 997: CLOSE c_jtf_task_depends;

993: WHEN OTHERS
994: THEN
995: IF c_jtf_task_depends%ISOPEN
996: THEN
997: CLOSE c_jtf_task_depends;
998: END IF;
999:
1000: ROLLBACK TO update_task_dependency_pvt;
1001: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1025: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;

1021: x_msg_data OUT NOCOPY VARCHAR2
1022: )
1023: IS
1024: x char;
1025: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
1026: Resource_Locked exception ;
1027: PRAGMA EXCEPTION_INIT ( Resource_Locked , - 54 ) ;
1028:
1029:

Line 1030: CURSOR c_jtf_task_depends

1026: Resource_Locked exception ;
1027: PRAGMA EXCEPTION_INIT ( Resource_Locked , - 54 ) ;
1028:
1029:
1030: CURSOR c_jtf_task_depends
1031: IS
1032: SELECT 1
1033: FROM jtf_task_depends
1034: WHERE dependency_id = l_dependency_id;

Line 1033: FROM jtf_task_depends

1029:
1030: CURSOR c_jtf_task_depends
1031: IS
1032: SELECT 1
1033: FROM jtf_task_depends
1034: WHERE dependency_id = l_dependency_id;
1035: BEGIN
1036: --- This does not check between tasks and templates
1037: --- because it is assumed the same is validated before

Line 1043: jtf_task_depends_pkg.lock_row(

1039: SAVEPOINT delete_task_dependency_pvt;
1040:
1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: jtf_task_depends_pkg.lock_row(
1044: x_dependency_id => p_dependency_id ,
1045: x_object_version_number => p_object_version_number );
1046:
1047: jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);

Line 1047: jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);

1043: jtf_task_depends_pkg.lock_row(
1044: x_dependency_id => p_dependency_id ,
1045: x_object_version_number => p_object_version_number );
1046:
1047: jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);
1048: OPEN c_jtf_task_depends;
1049: FETCH c_jtf_task_depends INTO x;
1050:
1051: IF c_jtf_task_depends%FOUND

Line 1048: OPEN c_jtf_task_depends;

1044: x_dependency_id => p_dependency_id ,
1045: x_object_version_number => p_object_version_number );
1046:
1047: jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);
1048: OPEN c_jtf_task_depends;
1049: FETCH c_jtf_task_depends INTO x;
1050:
1051: IF c_jtf_task_depends%FOUND
1052: THEN

Line 1049: FETCH c_jtf_task_depends INTO x;

1045: x_object_version_number => p_object_version_number );
1046:
1047: jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);
1048: OPEN c_jtf_task_depends;
1049: FETCH c_jtf_task_depends INTO x;
1050:
1051: IF c_jtf_task_depends%FOUND
1052: THEN
1053: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_DEPEND');

Line 1051: IF c_jtf_task_depends%FOUND

1047: jtf_task_depends_pkg.delete_row (x_dependency_id => l_dependency_id);
1048: OPEN c_jtf_task_depends;
1049: FETCH c_jtf_task_depends INTO x;
1050:
1051: IF c_jtf_task_depends%FOUND
1052: THEN
1053: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_DEPEND');
1054: fnd_msg_pub.add;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1057: CLOSE c_jtf_task_depends;

1053: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_DEPEND');
1054: fnd_msg_pub.add;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: CLOSE c_jtf_task_depends;
1058: ELSE
1059: CLOSE c_jtf_task_depends;
1060: END IF;
1061:

Line 1059: CLOSE c_jtf_task_depends;

1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: CLOSE c_jtf_task_depends;
1058: ELSE
1059: CLOSE c_jtf_task_depends;
1060: END IF;
1061:
1062: IF c_jtf_task_depends%ISOPEN
1063: THEN

Line 1062: IF c_jtf_task_depends%ISOPEN

1058: ELSE
1059: CLOSE c_jtf_task_depends;
1060: END IF;
1061:
1062: IF c_jtf_task_depends%ISOPEN
1063: THEN
1064: CLOSE c_jtf_task_depends;
1065: END IF;
1066:

Line 1064: CLOSE c_jtf_task_depends;

1060: END IF;
1061:
1062: IF c_jtf_task_depends%ISOPEN
1063: THEN
1064: CLOSE c_jtf_task_depends;
1065: END IF;
1066:
1067: IF fnd_api.to_boolean (p_commit)
1068: THEN