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.15 2008/03/26 09:58:33 venjayar 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_owner_status_id jtf_task_all_assignments.assignment_status_id%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_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2955: l_percentage_complete jtf_tasks_b.percentage_complete%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_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2955: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2956: l_reason_code jtf_tasks_b.reason_code%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_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2955: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2956: l_reason_code jtf_tasks_b.reason_code%TYPE;
2957: l_private_flag jtf_tasks_b.private_flag%TYPE;

Line 2955: l_percentage_complete jtf_tasks_b.percentage_complete%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_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2955: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2956: l_reason_code jtf_tasks_b.reason_code%TYPE;
2957: l_private_flag jtf_tasks_b.private_flag%TYPE;
2958: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2959: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;

Line 2956: l_reason_code jtf_tasks_b.reason_code%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_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2955: l_percentage_complete jtf_tasks_b.percentage_complete%TYPE;
2956: l_reason_code jtf_tasks_b.reason_code%TYPE;
2957: l_private_flag jtf_tasks_b.private_flag%TYPE;
2958: l_publish_flag jtf_tasks_b.publish_flag%TYPE;
2959: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;
2960: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;

Line 2957: l_private_flag jtf_tasks_b.private_flag%TYPE;

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

Line 2958: l_publish_flag jtf_tasks_b.publish_flag%TYPE;

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

Line 2959: l_restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE;

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

Line 2960: l_multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE;

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

Line 2961: l_palm_flag jtf_tasks_b.palm_flag%TYPE;

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

Line 2962: l_wince_flag jtf_tasks_b.wince_flag%TYPE;

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

Line 2963: l_laptop_flag jtf_tasks_b.laptop_flag%TYPE;

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

Line 2964: l_device1_flag jtf_tasks_b.device1_flag%TYPE;

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

Line 2965: l_device2_flag jtf_tasks_b.device2_flag%TYPE;

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

Line 2966: l_device3_flag jtf_tasks_b.device3_flag%TYPE;

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

Line 2968: l_planned_effort jtf_tasks_b.planned_effort%TYPE;

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

Line 2969: l_planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

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

Line 2970: l_actual_effort jtf_tasks_b.actual_effort%TYPE;

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

Line 2971: l_actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE;

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

Line 2972: l_milestone_flag jtf_tasks_b.milestone_flag%TYPE;

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

Line 2973: l_holiday_flag jtf_tasks_b.holiday_flag%TYPE;

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

Line 2974: l_currency_code jtf_tasks_b.currency_code%TYPE;

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

Line 2975: l_costs jtf_tasks_b.costs%TYPE;

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

Line 2976: l_notification_flag jtf_tasks_b.notification_flag%TYPE;

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

Line 2977: l_notification_period jtf_tasks_b.notification_period%TYPE;

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

Line 2978: l_notification_period_uom jtf_tasks_b.notification_period_uom%TYPE;

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

Line 2979: l_billable_flag jtf_tasks_b.billable_flag%TYPE;

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

Line 2980: l_bound_mode_code jtf_tasks_b.bound_mode_code%TYPE;

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

Line 2981: l_soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE;

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

Line 2982: l_workflow_process_id jtf_tasks_b.workflow_process_id%TYPE;

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

Line 2983: l_parent_task_id jtf_tasks_b.parent_task_id%TYPE;

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

Line 2984: l_parent_task_number jtf_tasks_b.task_number%TYPE;

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

Line 2985: l_alarm_start jtf_tasks_b.alarm_start%TYPE;

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

Line 2986: l_alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE;

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

Line 2987: l_alarm_on jtf_tasks_b.alarm_on%TYPE;

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

Line 2988: l_alarm_count jtf_tasks_b.alarm_count%TYPE;

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

Line 2989: l_alarm_fired_count jtf_tasks_b.alarm_fired_count%TYPE;

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

Line 2990: l_alarm_interval jtf_tasks_b.alarm_interval%TYPE;

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

Line 2991: l_alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE;

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

Line 2993: l_date_selected jtf_tasks_b.date_selected%TYPE;

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

Line 2996: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;

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

Line 3723: update jtf_tasks_b

3719:
3720: ---- Commented out by lokumar as part of bug#5741482
3721: ---- source_object_name is ultimately updated at PKG level
3722: /*
3723: update jtf_tasks_b
3724: set source_object_name = l_source_object_name
3725: where task_id = l_task_id ;
3726: */
3727: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN

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

4655: , p_abort_workflow IN VARCHAR2
4656: ) IS
4657: l_api_version CONSTANT NUMBER := 1.0;
4658: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
4659: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4660: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
4661: BEGIN
4662: SAVEPOINT delete_task_pub;
4663: x_return_status := fnd_api.g_ret_sts_success;

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

4656: ) IS
4657: l_api_version CONSTANT NUMBER := 1.0;
4658: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK';
4659: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4660: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
4661: BEGIN
4662: SAVEPOINT delete_task_pub;
4663: x_return_status := fnd_api.g_ret_sts_success;
4664:

Line 5248: FROM jtf_tasks_b

5244: , p_task_name IN jtf_tasks_v.task_name%TYPE
5245: ) IS
5246: CURSOR c_task_number IS
5247: SELECT task_id
5248: FROM jtf_tasks_b
5249: WHERE task_number = p_task_number;
5250:
5251: CURSOR c_task_name IS
5252: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl

Line 5296: FROM jtf_tasks_b

5292:
5293: PROCEDURE val_task_id(p_task_id IN jtf_tasks_v.task_id%TYPE) IS
5294: CURSOR c_task_id IS
5295: SELECT NULL
5296: FROM jtf_tasks_b
5297: WHERE task_id = p_task_id;
5298:
5299: v_dummy VARCHAR2(1);
5300: BEGIN

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

6308: , p_copy_task_contact_points IN VARCHAR2 DEFAULT jtf_task_utl.g_false_char
6309: ) IS
6310: l_api_version CONSTANT NUMBER := 1.0;
6311: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6312: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6313: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6314: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6315: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

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

6309: ) IS
6310: l_api_version CONSTANT NUMBER := 1.0;
6311: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6312: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6313: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6314: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6315: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6317: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

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

6310: l_api_version CONSTANT NUMBER := 1.0;
6311: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6312: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6313: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6314: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6315: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6317: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6318: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;

Line 6934: , p_owner_table_name => 'JTF_TASKS_B'

6930: , p_commit => fnd_api.g_false
6931: , p_task_contact_id => l_target_task_id
6932: , p_phone_id => contact_points.phone_id
6933: , p_primary_flag => contact_points.primary_flag
6934: , p_owner_table_name => 'JTF_TASKS_B'
6935: , x_return_status => x_return_status
6936: , x_msg_count => x_msg_count
6937: , x_msg_data => x_msg_data
6938: , x_task_phone_id => l_task_phone_id

Line 7175: FROM jtf_tasks_b

7171: ---- get the recurrence rule id for the source task
7172: BEGIN
7173: SELECT recurrence_rule_id
7174: INTO l_recurrence_rule_id
7175: FROM jtf_tasks_b
7176: WHERE task_id = l_source_task_id;
7177: EXCEPTION
7178: WHEN NO_DATA_FOUND THEN
7179: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 7824: l_source_object_name jtf_tasks_b.source_object_name%TYPE;

7820: ) IS
7821: l_api_version CONSTANT NUMBER := 1.0;
7822: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_SOURCE';
7823: l_task_id NUMBER;
7824: l_source_object_name jtf_tasks_b.source_object_name%TYPE;
7825: BEGIN
7826: SAVEPOINT update_task_source;
7827: x_return_status := fnd_api.g_ret_sts_success;
7828:

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

7938: , x_return_status OUT NOCOPY VARCHAR2
7939: , x_msg_count OUT NOCOPY NUMBER
7940: , x_msg_data OUT NOCOPY VARCHAR2
7941: ) IS
7942: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
7943: SELECT a.task_id
7944: , b.object_version_number
7945: FROM jtf_task_depends a, jtf_tasks_b b
7946: WHERE a.task_id = i_task_id AND a.task_id = b.task_id

Line 7945: FROM jtf_task_depends a, jtf_tasks_b b

7941: ) IS
7942: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
7943: SELECT a.task_id
7944: , b.object_version_number
7945: FROM jtf_task_depends a, jtf_tasks_b b
7946: WHERE a.task_id = i_task_id AND a.task_id = b.task_id
7947: AND b.task_split_flag = p_task_split_flag;
7948:
7949: -- Cursor for finding all the tasks depend on the master task

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

7954: START WITH dependent_on_task_id = p_task_id
7955: CONNECT BY PRIOR task_id = dependent_on_task_id;
7956:
7957: -- changed the parameter name by SBARAT on 19/01/2006 for bug# 4888496
7958: CURSOR c_task_validate(p_task_id jtf_tasks_b.task_id%TYPE) IS
7959: SELECT object_version_number
7960: , task_split_flag
7961: FROM jtf_tasks_b
7962: WHERE task_id = p_task_id;

Line 7961: FROM jtf_tasks_b

7957: -- changed the parameter name by SBARAT on 19/01/2006 for bug# 4888496
7958: CURSOR c_task_validate(p_task_id jtf_tasks_b.task_id%TYPE) IS
7959: SELECT object_version_number
7960: , task_split_flag
7961: FROM jtf_tasks_b
7962: WHERE task_id = p_task_id;
7963:
7964: l_api_version CONSTANT NUMBER := 1.0;
7965: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SPLIT_TASKS';

Line 7973: l_task_id jtf_tasks_b.task_id%TYPE;

7969: l_msg_count NUMBER;
7970: l_ovn NUMBER;
7971: l_task_info c_task_info%ROWTYPE;
7972: l_mass_tasks_info c_mass_tasks_info%ROWTYPE;
7973: l_task_id jtf_tasks_b.task_id%TYPE;
7974: task_val c_task_validate%ROWTYPE;
7975: BEGIN
7976: SAVEPOINT delete_split_tasks_pub;
7977: x_return_status := fnd_api.g_ret_sts_success;