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_PVT dependencies on JTF_TASKS_V

Line 3234: FROM jtf_tasks_vl

3230: , jtf_task_utl.g_miss_number, child_sequence_num
3231: , p_child_sequence_num
3232: ) child_sequence_num
3233: , DECODE(p_location_id, fnd_api.g_miss_num, location_id, p_location_id) location_id
3234: FROM jtf_tasks_vl
3235: WHERE task_id = p_task_id;
3236:
3237: tasks c_task%ROWTYPE;
3238: x NUMBER;

Line 5124: , p_task_id IN jtf_tasks_v.task_id%TYPE

5120: END dump_long_line;
5121:
5122: PROCEDURE query_task(
5123: p_object_version_number IN NUMBER
5124: , p_task_id IN jtf_tasks_v.task_id%TYPE
5125: , p_description IN jtf_tasks_v.description%TYPE
5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

Line 5125: , p_description IN jtf_tasks_v.description%TYPE

5121:
5122: PROCEDURE query_task(
5123: p_object_version_number IN NUMBER
5124: , p_task_id IN jtf_tasks_v.task_id%TYPE
5125: , p_description IN jtf_tasks_v.description%TYPE
5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

Line 5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE

5122: PROCEDURE query_task(
5123: p_object_version_number IN NUMBER
5124: , p_task_id IN jtf_tasks_v.task_id%TYPE
5125: , p_description IN jtf_tasks_v.description%TYPE
5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

Line 5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE

5123: p_object_version_number IN NUMBER
5124: , p_task_id IN jtf_tasks_v.task_id%TYPE
5125: , p_description IN jtf_tasks_v.description%TYPE
5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

Line 5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

5124: , p_task_id IN jtf_tasks_v.task_id%TYPE
5125: , p_description IN jtf_tasks_v.description%TYPE
5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE

Line 5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

5125: , p_description IN jtf_tasks_v.description%TYPE
5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

5126: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

5127: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5132: , p_address_id IN jtf_tasks_v.address_id%TYPE

5128: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

Line 5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

5129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

Line 5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

5130: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

Line 5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

5131: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

Line 5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

5132: , p_address_id IN jtf_tasks_v.address_id%TYPE
5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

Line 5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

5133: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

Line 5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

5134: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

Line 5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

5135: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

Line 5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

5136: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

Line 5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

5137: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

Line 5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

5138: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

Line 5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

5139: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

Line 5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

5140: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

Line 5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

5141: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

Line 5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

5142: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

Line 5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

5143: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

Line 5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

5144: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

Line 5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

5145: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

Line 5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

5146: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

Line 5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

5147: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

Line 5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

5148: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

Line 5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

5149: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5157: , p_ref_object_id IN NUMBER

Line 5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

5150: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5157: , p_ref_object_id IN NUMBER
5158: , p_ref_object_type_code IN VARCHAR2

Line 5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

5151: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5157: , p_ref_object_id IN NUMBER
5158: , p_ref_object_type_code IN VARCHAR2
5159: , p_task_name IN jtf_tasks_v.task_name%TYPE

Line 5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

5152: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5153: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5154: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5157: , p_ref_object_id IN NUMBER
5158: , p_ref_object_type_code IN VARCHAR2
5159: , p_task_name IN jtf_tasks_v.task_name%TYPE
5160: , p_sort_data IN jtf_tasks_pub.sort_data

Line 5159: , p_task_name IN jtf_tasks_v.task_name%TYPE

5155: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5156: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5157: , p_ref_object_id IN NUMBER
5158: , p_ref_object_type_code IN VARCHAR2
5159: , p_task_name IN jtf_tasks_v.task_name%TYPE
5160: , p_sort_data IN jtf_tasks_pub.sort_data
5161: , p_start_pointer IN NUMBER
5162: , p_rec_wanted IN NUMBER
5163: , p_show_all IN VARCHAR2

Line 5246: , p_task_id IN jtf_tasks_v.task_id%TYPE

5242: END query_task;
5243:
5244: PROCEDURE query_task(
5245: p_object_version_number IN NUMBER
5246: , p_task_id IN jtf_tasks_v.task_id%TYPE
5247: , p_description IN jtf_tasks_v.description%TYPE
5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

Line 5247: , p_description IN jtf_tasks_v.description%TYPE

5243:
5244: PROCEDURE query_task(
5245: p_object_version_number IN NUMBER
5246: , p_task_id IN jtf_tasks_v.task_id%TYPE
5247: , p_description IN jtf_tasks_v.description%TYPE
5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

Line 5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE

5244: PROCEDURE query_task(
5245: p_object_version_number IN NUMBER
5246: , p_task_id IN jtf_tasks_v.task_id%TYPE
5247: , p_description IN jtf_tasks_v.description%TYPE
5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

Line 5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE

5245: p_object_version_number IN NUMBER
5246: , p_task_id IN jtf_tasks_v.task_id%TYPE
5247: , p_description IN jtf_tasks_v.description%TYPE
5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

Line 5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

5246: , p_task_id IN jtf_tasks_v.task_id%TYPE
5247: , p_description IN jtf_tasks_v.description%TYPE
5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE

Line 5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

5247: , p_description IN jtf_tasks_v.description%TYPE
5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

5248: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

5249: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5254: , p_address_id IN jtf_tasks_v.address_id%TYPE

5250: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

Line 5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

5251: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

Line 5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

5252: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

Line 5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

5253: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

Line 5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

5254: , p_address_id IN jtf_tasks_v.address_id%TYPE
5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

Line 5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

5255: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

Line 5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

5256: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

Line 5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

5257: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

Line 5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

5258: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

Line 5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

5259: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

Line 5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

5260: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

Line 5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

5261: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

Line 5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

5262: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

Line 5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

5263: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

Line 5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

5264: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

Line 5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

5265: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

Line 5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

5266: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

Line 5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

5267: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

Line 5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

5268: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

Line 5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

5269: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

Line 5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

5270: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

Line 5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

5271: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5279: , p_ref_object_id IN NUMBER

Line 5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

5272: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5279: , p_ref_object_id IN NUMBER
5280: , p_ref_object_type_code IN VARCHAR2

Line 5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

5273: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5279: , p_ref_object_id IN NUMBER
5280: , p_ref_object_type_code IN VARCHAR2
5281: , p_task_name IN jtf_tasks_v.task_name%TYPE

Line 5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

5274: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5275: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5276: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5279: , p_ref_object_id IN NUMBER
5280: , p_ref_object_type_code IN VARCHAR2
5281: , p_task_name IN jtf_tasks_v.task_name%TYPE
5282: , p_sort_data IN jtf_tasks_pub.sort_data

Line 5281: , p_task_name IN jtf_tasks_v.task_name%TYPE

5277: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5278: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5279: , p_ref_object_id IN NUMBER
5280: , p_ref_object_type_code IN VARCHAR2
5281: , p_task_name IN jtf_tasks_v.task_name%TYPE
5282: , p_sort_data IN jtf_tasks_pub.sort_data
5283: , p_start_pointer IN NUMBER
5284: , p_rec_wanted IN NUMBER
5285: , p_show_all IN VARCHAR2

Line 5443: || 'from jtf_tasks_v ';

5439: || 'creation_date, '
5440: || 'escalation_level, '
5441: || 'object_version_number, '
5442: || 'location_id '
5443: || 'from jtf_tasks_v ';
5444: add_to_sql(p_task_id, 'b1', 'task_id');
5445: add_to_sql(p_description, 'b2', 'description');
5446: add_to_sql(p_task_status_id, 'b3', 'task_status_id');
5447: add_to_sql(p_task_priority_id, 'b4', 'task_priority_id');

Line 5490: || ' where r.task_id = jtf_tasks_v.task_id '

5486: v_where :=
5487: v_where
5488: || ' exists '
5489: || '(select * from jtf_task_references_vl r '
5490: || ' where r.task_id = jtf_tasks_v.task_id '
5491: || ' and r.object_id = :b100 '
5492: || ' and r.object_type_code = :b101 ) ';
5493: END IF;
5494:

Line 5892: , p_task_id IN jtf_tasks_v.task_id%TYPE

5888: END query_task;
5889:
5890: PROCEDURE query_next_task(
5891: p_object_version_number IN NUMBER
5892: , p_task_id IN jtf_tasks_v.task_id%TYPE
5893: , -- current task id
5894: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
5895: , -- values Dependency or Date
5896: p_date_type IN VARCHAR2 DEFAULT NULL

Line 5899: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

5895: , -- values Dependency or Date
5896: p_date_type IN VARCHAR2 DEFAULT NULL
5897: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
5898: , -- start or end
5899: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5900: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5901: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5902: , p_sort_data IN jtf_tasks_pub.sort_data
5903: , p_start_pointer IN NUMBER

Line 5900: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

5896: p_date_type IN VARCHAR2 DEFAULT NULL
5897: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
5898: , -- start or end
5899: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5900: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5901: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5902: , p_sort_data IN jtf_tasks_pub.sort_data
5903: , p_start_pointer IN NUMBER
5904: , p_rec_wanted IN NUMBER

Line 5901: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

5897: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
5898: , -- start or end
5899: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5900: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5901: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5902: , p_sort_data IN jtf_tasks_pub.sort_data
5903: , p_start_pointer IN NUMBER
5904: , p_rec_wanted IN NUMBER
5905: , p_show_all IN VARCHAR2 DEFAULT 'Y'

Line 6002: from jtf_tasks_v

5998: 'SCHEDULED_START_DATE', scheduled_start_date,
5999: 'SCHEDULED_END_DATE', scheduled_end_date,
6000: 'ACTUAL_START_DATE', actual_start_date,
6001: 'ACTUAL_END_DATE', actual_end_date, null)
6002: from jtf_tasks_v
6003: where task_id = p_task_id;*/
6004:
6005: -- Added by SBARAT on 30/05/2006 for perf bug# 5213367
6006: -- This query takea less sharable memory compared to previous one.

Line 6018: FROM jtf_tasks_vl jta

6014: , 'ACTUAL_START_DATE', actual_start_date
6015: , 'ACTUAL_END_DATE', actual_end_date
6016: , NULL
6017: )
6018: FROM jtf_tasks_vl jta
6019: , jtf_task_types_tl jttt
6020: , jtf_task_types_b jttb
6021: , jtf_task_statuses_tl jtst
6022: , jtf_task_statuses_b jtsb

Line 6134: || 'from jtf_tasks_v v ';

6130: || 'v.attribute13,'
6131: || 'v.attribute14,'
6132: || 'v.attribute15,'
6133: || 'v.attribute_category '
6134: || 'from jtf_tasks_v v ';
6135:
6136: IF (p_query_type = 'DEPENDENCY') THEN
6137: v_select := v_select || ', jtf_task_depends d ';
6138: add_to_sql(p_task_id, 'b1', 'd.dependent_on_task_id');

Line 6150: || ') from jtf_tasks_v where assigned_by_id = '

6146: IF (p_query_type = 'ASSIGNED') THEN
6147: v_date_sql :=
6148: 'select min('
6149: || v_start_date
6150: || ') from jtf_tasks_v where assigned_by_id = '
6151: || TO_CHAR(p_assigned_by)
6152: || ' and '
6153: || v_start_date
6154: || ' > :1 ';

Line 6166: || ') from jtf_tasks_v where owner_type_code = '''

6162: ELSIF(p_query_type = 'OWNER') THEN
6163: v_date_sql :=
6164: 'select min('
6165: || v_start_date
6166: || ') from jtf_tasks_v where owner_type_code = '''
6167: || p_owner_type_code
6168: || ''' and '
6169: || 'owner_id = '
6170: || TO_CHAR(p_owner_id)