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_TASKS_PUB dependencies on JTF_TASKS_B

Line 3: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';

1: PACKAGE BODY jtf_tasks_pub AS
2: /* $Header: jtfptktb.pls 120.17 2009/09/07 13:15:43 anangupt ship $ */
3: g_entity CONSTANT jtf_tasks_b.entity%TYPE := 'TASK';
4: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';
5:
6: -- new version without table type parameters
7: -- Remove the fix of Bug 2152549

Line 643: l_task_number jtf_tasks_b.task_number%TYPE;

639: , p_location_id IN NUMBER
640: ) IS
641: l_api_version CONSTANT NUMBER := 1.0;
642: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TASK';
643: l_task_number jtf_tasks_b.task_number%TYPE;
644: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 start */
645: l_task_name jtf_tasks_tl.task_name%TYPE;
646: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */
647: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;

Line 647: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;

643: l_task_number jtf_tasks_b.task_number%TYPE;
644: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 start */
645: l_task_name jtf_tasks_tl.task_name%TYPE;
646: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */
647: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
648: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
649: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
650: l_owner_type_name jtf_objects_tl.NAME%TYPE := p_owner_type_name;
651: l_owner_type_code jtf_objects_b.object_code%TYPE := p_owner_type_code;

Line 648: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;

644: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 start */
645: l_task_name jtf_tasks_tl.task_name%TYPE;
646: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */
647: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
648: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
649: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
650: l_owner_type_name jtf_objects_tl.NAME%TYPE := p_owner_type_name;
651: l_owner_type_code jtf_objects_b.object_code%TYPE := p_owner_type_code;
652: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;

Line 649: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;

645: l_task_name jtf_tasks_tl.task_name%TYPE;
646: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */
647: l_task_type_id jtf_tasks_b.task_type_id%TYPE := p_task_type_id;
648: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
649: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
650: l_owner_type_name jtf_objects_tl.NAME%TYPE := p_owner_type_name;
651: l_owner_type_code jtf_objects_b.object_code%TYPE := p_owner_type_code;
652: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
653: l_timezone_id hz_timezones.timezone_id%TYPE := p_timezone_id;

Line 652: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;

648: l_task_priority_id jtf_tasks_b.task_priority_id%TYPE := p_task_priority_id;
649: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
650: l_owner_type_name jtf_objects_tl.NAME%TYPE := p_owner_type_name;
651: l_owner_type_code jtf_objects_b.object_code%TYPE := p_owner_type_code;
652: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
653: l_timezone_id hz_timezones.timezone_id%TYPE := p_timezone_id;
654: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
655: l_planned_start_date DATE := p_planned_start_date;
656: l_planned_end_date DATE := p_planned_end_date;

Line 670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;

666: l_customer_number hz_parties.party_number%TYPE := p_customer_number;
667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;
668: l_location_id hz_locations.location_id%TYPE := p_location_id;
669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;
670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;
672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
674: l_source_object_name jtf_tasks_b.source_object_name%TYPE

Line 671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;

667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;
668: l_location_id hz_locations.location_id%TYPE := p_location_id;
669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;
670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;
672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
674: l_source_object_name jtf_tasks_b.source_object_name%TYPE
675: := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);

Line 672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;

668: l_location_id hz_locations.location_id%TYPE := p_location_id;
669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;
670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;
672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
674: l_source_object_name jtf_tasks_b.source_object_name%TYPE
675: := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
676: x CHAR;

Line 673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;

669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;
670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;
672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
674: l_source_object_name jtf_tasks_b.source_object_name%TYPE
675: := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
676: x CHAR;
677: l_costs jtf_tasks_b.costs%TYPE := p_costs;

Line 674: l_source_object_name jtf_tasks_b.source_object_name%TYPE

670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;
672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
674: l_source_object_name jtf_tasks_b.source_object_name%TYPE
675: := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
676: x CHAR;
677: l_costs jtf_tasks_b.costs%TYPE := p_costs;
678: l_currency_code jtf_tasks_b.currency_code%TYPE := p_currency_code;

Line 677: l_costs jtf_tasks_b.costs%TYPE := p_costs;

673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;
674: l_source_object_name jtf_tasks_b.source_object_name%TYPE
675: := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
676: x CHAR;
677: l_costs jtf_tasks_b.costs%TYPE := p_costs;
678: l_currency_code jtf_tasks_b.currency_code%TYPE := p_currency_code;
679: y BOOLEAN;
680: l_date_selected jtf_tasks_b.date_selected%TYPE;
681: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

Line 678: l_currency_code jtf_tasks_b.currency_code%TYPE := p_currency_code;

674: l_source_object_name jtf_tasks_b.source_object_name%TYPE
675: := jtf_task_utl.check_truncation(p_object_name => p_source_object_name);
676: x CHAR;
677: l_costs jtf_tasks_b.costs%TYPE := p_costs;
678: l_currency_code jtf_tasks_b.currency_code%TYPE := p_currency_code;
679: y BOOLEAN;
680: l_date_selected jtf_tasks_b.date_selected%TYPE;
681: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
682: l_type VARCHAR2(10);

Line 680: l_date_selected jtf_tasks_b.date_selected%TYPE;

676: x CHAR;
677: l_costs jtf_tasks_b.costs%TYPE := p_costs;
678: l_currency_code jtf_tasks_b.currency_code%TYPE := p_currency_code;
679: y BOOLEAN;
680: l_date_selected jtf_tasks_b.date_selected%TYPE;
681: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
682: l_type VARCHAR2(10);
683: l_msg_data VARCHAR2(2000); -- debug
684: l_task_id jtf_tasks_b.task_id%TYPE;

Line 684: l_task_id jtf_tasks_b.task_id%TYPE;

680: l_date_selected jtf_tasks_b.date_selected%TYPE;
681: l_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
682: l_type VARCHAR2(10);
683: l_msg_data VARCHAR2(2000); -- debug
684: l_task_id jtf_tasks_b.task_id%TYPE;
685: l_notes_id NUMBER;
686: l_dependency_id jtf_task_depends.dependency_id%TYPE;
687: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
688: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

Line 2919: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

2915: , p_location_id IN NUMBER
2916: ) IS
2917: l_api_version CONSTANT NUMBER := 1.0;
2918: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
2919: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
2920: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
2921: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 start */
2922: l_task_name jtf_tasks_tl.task_name%TYPE;
2923: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */

Line 2920: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;

2916: ) IS
2917: l_api_version CONSTANT NUMBER := 1.0;
2918: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
2919: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
2920: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
2921: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 start */
2922: l_task_name jtf_tasks_tl.task_name%TYPE;
2923: /* Modified by TSINGHAL dt 8/10/2003 for bug fix 3182170 End */
2924: l_task_type_name jtf_task_types_tl.NAME%TYPE := p_task_type_name;

Line 2945: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;

2941: l_scheduled_start_date DATE;
2942: l_scheduled_end_date DATE;
2943: l_actual_start_date DATE;
2944: l_actual_end_date DATE;
2945: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2946: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;

Line 2946: l_source_object_id jtf_tasks_b.source_object_id%TYPE;

2942: l_scheduled_end_date DATE;
2943: l_actual_start_date DATE;
2944: l_actual_end_date DATE;
2945: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2946: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;

Line 2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

2943: l_actual_start_date DATE;
2944: l_actual_end_date DATE;
2945: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2946: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;

Line 2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;

2944: l_actual_end_date DATE;
2945: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE;
2946: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;

Line 2950: l_duration jtf_tasks_b.DURATION%TYPE;

2946: l_source_object_id jtf_tasks_b.source_object_id%TYPE;
2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;

Line 2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;

2947: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;

Line 2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;

2948: l_timezone_id jtf_tasks_b.timezone_id%TYPE := p_timezone_id;
2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;

Line 2953: l_owner_id jtf_tasks_b.owner_id%TYPE;

2949: l_timezone_name hz_timezones.global_timezone_name%TYPE := p_timezone_name;
2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

Line 2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;

2950: l_duration jtf_tasks_b.DURATION%TYPE;
2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;

Line 2955: l_reason_code jtf_tasks_b.reason_code%TYPE;

2951: l_duration_uom jtf_tasks_b.duration_uom%TYPE;
2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;

Line 2956: l_private_flag jtf_tasks_b.private_flag%TYPE;

2952: l_owner_type_code jtf_tasks_b.owner_type_code%TYPE;
2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;

Line 2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

2953: l_owner_id jtf_tasks_b.owner_id%TYPE;
2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;

Line 2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;

2954: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;

Line 2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;

2955: l_reason_code jtf_tasks_b.reason_code%TYPE;
2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;

Line 2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;

2956: l_private_flag jtf_tasks_b.private_flag%TYPE;
2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;

Line 2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;

2957: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;

Line 2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;

2958: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;

Line 2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;

2959: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;
2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;

Line 2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;

2960: l_palm_flag jtf_tasks_b.palm_flag%TYPE;
2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

Line 2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;

2961: l_wince_flag jtf_tasks_b.wince_flag%TYPE;
2962: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;
2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;

Line 2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;

2963: l_device1_flag jtf_tasks_b.device1_flag%TYPE;
2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;

Line 2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

2964: l_device2_flag jtf_tasks_b.device2_flag%TYPE;
2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;

Line 2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;

2965: l_device3_flag jtf_tasks_b.device3_flag%TYPE;
2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;

Line 2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;

2966: l_description jtf_tasks_tl.description%TYPE;
2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;

Line 2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;

2967: l_planned_effort jtf_tasks_b.planned_effort%TYPE;
2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;

Line 2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;

2968: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;

Line 2973: l_currency_code jtf_tasks_b.currency_code%TYPE;

2969: l_actual_effort jtf_tasks_b.actual_effort%TYPE;
2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

Line 2974: l_costs jtf_tasks_b.costs%TYPE;

2970: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;
2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;

Line 2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;

2971: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;
2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;

Line 2976: l_notification_period jtf_tasks_b.notification_period%TYPE;

2972: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;
2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;

Line 2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

2973: l_currency_code jtf_tasks_b.currency_code%TYPE;
2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

Line 2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;

2974: l_costs jtf_tasks_b.costs%TYPE;
2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;

Line 2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;

2975: l_notification_flag jtf_tasks_b.notification_flag%TYPE;
2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;

Line 2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;

2976: l_notification_period jtf_tasks_b.notification_period%TYPE;
2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

Line 2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

2977: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;
2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

Line 2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;

2978: l_billable_flag jtf_tasks_b.billable_flag%TYPE;
2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;

Line 2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;

2979: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;
2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

Line 2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

2980: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;
2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;

Line 2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

2981: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;
2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

Line 2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;

2982: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;
2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

Line 2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

2983: l_parent_task_number jtf_tasks_b.task_number%TYPE;
2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2991: l_owner_type_name jtf_objects_tl.NAME%TYPE;

Line 2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;

2984: l_alarm_start jtf_tasks_b.alarm_start%TYPE;
2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2991: l_owner_type_name jtf_objects_tl.NAME%TYPE;
2992: l_date_selected jtf_tasks_b.date_selected%TYPE;

Line 2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

2985: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;
2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2991: l_owner_type_name jtf_objects_tl.NAME%TYPE;
2992: l_date_selected jtf_tasks_b.date_selected%TYPE;
2993: l_type VARCHAR2(10);

Line 2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

2986: l_alarm_on jtf_tasks_b.alarm_on%TYPE;
2987: l_alarm_count jtf_tasks_b.alarm_count%TYPE;
2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2991: l_owner_type_name jtf_objects_tl.NAME%TYPE;
2992: l_date_selected jtf_tasks_b.date_selected%TYPE;
2993: l_type VARCHAR2(10);
2994: y BOOLEAN;

Line 2992: l_date_selected jtf_tasks_b.date_selected%TYPE;

2988: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;
2989: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;
2990: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;
2991: l_owner_type_name jtf_objects_tl.NAME%TYPE;
2992: l_date_selected jtf_tasks_b.date_selected%TYPE;
2993: l_type VARCHAR2(10);
2994: y BOOLEAN;
2995: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
2996:

Line 2995: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;

2991: l_owner_type_name jtf_objects_tl.NAME%TYPE;
2992: l_date_selected jtf_tasks_b.date_selected%TYPE;
2993: l_type VARCHAR2(10);
2994: y BOOLEAN;
2995: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
2996:
2997: CURSOR c_task_update(l_task_id IN NUMBER) IS
2998: SELECT DECODE(p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id
2999: , DECODE(p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number

Line 3715: update jtf_tasks_b

3711:
3712: ---- Commented out by lokumar as part of bug#5741482
3713: ---- source_object_name is ultimately updated at PKG level
3714: /*
3715: update jtf_tasks_b
3716: set source_object_name = l_source_object_name
3717: where task_id = l_task_id ;
3718: */
3719: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

Line 4634: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

4630: , p_abort_workflow IN VARCHAR2
4631: ) IS
4632: l_api_version CONSTANT NUMBER := 1.0;
4633: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
4634: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4635: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
4636: BEGIN
4637: SAVEPOINT delete_task_pub;
4638: x_return_status := fnd_api.g_ret_sts_success;

Line 4635: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;

4631: ) IS
4632: l_api_version CONSTANT NUMBER := 1.0;
4633: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
4634: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4635: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
4636: BEGIN
4637: SAVEPOINT delete_task_pub;
4638: x_return_status := fnd_api.g_ret_sts_success;
4639:

Line 5223: FROM jtf_tasks_b

5219: , p_task_name IN jtf_tasks_v.task_name%TYPE
5220: ) IS
5221: CURSOR c_task_number IS
5222: SELECT task_id
5223: FROM jtf_tasks_b
5224: WHERE task_number = p_task_number;
5225:
5226: CURSOR c_task_name IS
5227: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl

Line 5271: FROM jtf_tasks_b

5267:
5268: PROCEDURE val_task_id(p_task_id IN jtf_tasks_v.task_id%TYPE) IS
5269: CURSOR c_task_id IS
5270: SELECT NULL
5271: FROM jtf_tasks_b
5272: WHERE task_id = p_task_id;
5273:
5274: v_dummy VARCHAR2(1);
5275: BEGIN

Line 6287: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;

6283: , p_copy_task_contact_points IN VARCHAR2 DEFAULT jtf_task_utl.g_false_char
6284: ) IS
6285: l_api_version CONSTANT NUMBER := 1.0;
6286: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6287: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6290: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6291: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

Line 6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;

6284: ) IS
6285: l_api_version CONSTANT NUMBER := 1.0;
6286: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6287: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6290: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6291: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6292: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

Line 6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;

6285: l_api_version CONSTANT NUMBER := 1.0;
6286: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6287: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6290: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6291: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6292: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6293: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;

Line 6909: , p_owner_table_name => 'JTF_TASKS_B'

6905: , p_commit => fnd_api.g_false
6906: , p_task_contact_id => l_target_task_id
6907: , p_phone_id => contact_points.phone_id
6908: , p_primary_flag => contact_points.primary_flag
6909: , p_owner_table_name => 'JTF_TASKS_B'
6910: , x_return_status => x_return_status
6911: , x_msg_count => x_msg_count
6912: , x_msg_data => x_msg_data
6913: , x_task_phone_id => l_task_phone_id

Line 7150: FROM jtf_tasks_b

7146: ---- get the recurrence rule id for the source task
7147: BEGIN
7148: SELECT recurrence_rule_id
7149: INTO l_recurrence_rule_id
7150: FROM jtf_tasks_b
7151: WHERE task_id = l_source_task_id;
7152: EXCEPTION
7153: WHEN NO_DATA_FOUND THEN
7154: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 7799: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

7795: ) IS
7796: l_api_version CONSTANT NUMBER := 1.0;
7797: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_SOURCE';
7798: l_task_id NUMBER;
7799: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
7800: BEGIN
7801: SAVEPOINT update_task_source;
7802: x_return_status := fnd_api.g_ret_sts_success;
7803:

Line 7917: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS

7913: , x_return_status OUT NOCOPY VARCHAR2
7914: , x_msg_count OUT NOCOPY NUMBER
7915: , x_msg_data OUT NOCOPY VARCHAR2
7916: ) IS
7917: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
7918: SELECT a.task_id
7919: , b.object_version_number
7920: FROM jtf_task_depends a, jtf_tasks_b b
7921: WHERE a.task_id = i_task_id AND a.task_id = b.task_id

Line 7920: FROM jtf_task_depends a, jtf_tasks_b b

7916: ) IS
7917: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
7918: SELECT a.task_id
7919: , b.object_version_number
7920: FROM jtf_task_depends a, jtf_tasks_b b
7921: WHERE a.task_id = i_task_id AND a.task_id = b.task_id
7922: AND b.task_split_flag = p_task_split_flag;
7923:
7924: -- Cursor for finding all the tasks depend on the master task

Line 7933: CURSOR c_task_validate(p_task_id jtf_tasks_b.task_id%TYPE) IS

7929: START WITH dependent_on_task_id = p_task_id
7930: CONNECT BY PRIOR task_id = dependent_on_task_id;
7931:
7932: -- changed the parameter name by SBARAT on 19/01/2006 for bug# 4888496
7933: CURSOR c_task_validate(p_task_id jtf_tasks_b.task_id%TYPE) IS
7934: SELECT object_version_number
7935: , task_split_flag
7936: FROM jtf_tasks_b
7937: WHERE task_id = p_task_id;

Line 7936: FROM jtf_tasks_b

7932: -- changed the parameter name by SBARAT on 19/01/2006 for bug# 4888496
7933: CURSOR c_task_validate(p_task_id jtf_tasks_b.task_id%TYPE) IS
7934: SELECT object_version_number
7935: , task_split_flag
7936: FROM jtf_tasks_b
7937: WHERE task_id = p_task_id;
7938:
7939: l_api_version CONSTANT NUMBER := 1.0;
7940: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SPLIT_TASKS';

Line 7948: l_task_id jtf_tasks_b.task_id%TYPE;

7944: l_msg_count NUMBER;
7945: l_ovn NUMBER;
7946: l_task_info c_task_info%ROWTYPE;
7947: l_mass_tasks_info c_mass_tasks_info%ROWTYPE;
7948: l_task_id jtf_tasks_b.task_id%TYPE;
7949: task_val c_task_validate%ROWTYPE;
7950: BEGIN
7951: SAVEPOINT delete_split_tasks_pub;
7952: x_return_status := fnd_api.g_ret_sts_success;

Line 8170: l_date_selected jtf_tasks_b.date_selected%TYPE :='S';

8166: l_new_task_owner_id NUMBER :=P_NEW_TASK_OWNER_ID;
8167: l_new_task_status_id NUMBER :=P_NEW_TASK_STATUS_ID;
8168: l_note VARCHAR2(2000) := P_NOTE;
8169: l_update_status NUMBER := 0;
8170: l_date_selected jtf_tasks_b.date_selected%TYPE :='S';
8171: l_planned_start_date DATE :=P_NEW_PLANNED_START_DATE;
8172: l_planned_end_date DATE :=P_NEW_PLANNED_END_DATE;
8173: l_actual_start_date DATE := P_NEW_ACTUAL_START_DATE;
8174: l_actual_end_date DATE := P_NEW_ACTUAL_END_DATE;

Line 8194: FROM jtf_tasks_b

8190: , planned_start_date
8191: , planned_end_date
8192: , actual_start_date
8193: , actual_end_date
8194: FROM jtf_tasks_b
8195: WHERE task_id=l_task_id;
8196:
8197: cursor c_Assignment_details(l_task_id IN NUMBER) is
8198: SELECT object_version_number,task_assignment_id