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 5043: , p_task_id IN jtf_tasks_v.task_id%TYPE

5039: END dump_long_line;
5040:
5041: PROCEDURE query_task(
5042: p_object_version_number IN NUMBER
5043: , p_task_id IN jtf_tasks_v.task_id%TYPE
5044: , p_description IN jtf_tasks_v.description%TYPE
5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

Line 5044: , p_description IN jtf_tasks_v.description%TYPE

5040:
5041: PROCEDURE query_task(
5042: p_object_version_number IN NUMBER
5043: , p_task_id IN jtf_tasks_v.task_id%TYPE
5044: , p_description IN jtf_tasks_v.description%TYPE
5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

Line 5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE

5041: PROCEDURE query_task(
5042: p_object_version_number IN NUMBER
5043: , p_task_id IN jtf_tasks_v.task_id%TYPE
5044: , p_description IN jtf_tasks_v.description%TYPE
5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

Line 5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE

5042: p_object_version_number IN NUMBER
5043: , p_task_id IN jtf_tasks_v.task_id%TYPE
5044: , p_description IN jtf_tasks_v.description%TYPE
5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

Line 5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

5043: , p_task_id IN jtf_tasks_v.task_id%TYPE
5044: , p_description IN jtf_tasks_v.description%TYPE
5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE

Line 5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

5044: , p_description IN jtf_tasks_v.description%TYPE
5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

5045: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

5046: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5051: , p_address_id IN jtf_tasks_v.address_id%TYPE

5047: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

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

5048: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

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

5049: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

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

5050: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

Line 5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

5051: , p_address_id IN jtf_tasks_v.address_id%TYPE
5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

Line 5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

5052: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

Line 5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

5053: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

Line 5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

5054: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

Line 5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

5055: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

Line 5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

5056: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

Line 5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

5057: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

Line 5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

5058: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

Line 5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

5059: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

Line 5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

5060: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

Line 5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

5061: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

Line 5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

5062: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

Line 5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

5063: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

Line 5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

5064: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

Line 5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

5065: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

Line 5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

5066: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

Line 5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

5067: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

Line 5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

5068: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5076: , p_ref_object_id IN NUMBER

Line 5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

5069: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5076: , p_ref_object_id IN NUMBER
5077: , p_ref_object_type_code IN VARCHAR2

Line 5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

5070: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5076: , p_ref_object_id IN NUMBER
5077: , p_ref_object_type_code IN VARCHAR2
5078: , p_task_name IN jtf_tasks_v.task_name%TYPE

Line 5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

5071: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5072: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5073: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5076: , p_ref_object_id IN NUMBER
5077: , p_ref_object_type_code IN VARCHAR2
5078: , p_task_name IN jtf_tasks_v.task_name%TYPE
5079: , p_sort_data IN jtf_tasks_pub.sort_data

Line 5078: , p_task_name IN jtf_tasks_v.task_name%TYPE

5074: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5075: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5076: , p_ref_object_id IN NUMBER
5077: , p_ref_object_type_code IN VARCHAR2
5078: , p_task_name IN jtf_tasks_v.task_name%TYPE
5079: , p_sort_data IN jtf_tasks_pub.sort_data
5080: , p_start_pointer IN NUMBER
5081: , p_rec_wanted IN NUMBER
5082: , p_show_all IN VARCHAR2

Line 5165: , p_task_id IN jtf_tasks_v.task_id%TYPE

5161: END query_task;
5162:
5163: PROCEDURE query_task(
5164: p_object_version_number IN NUMBER
5165: , p_task_id IN jtf_tasks_v.task_id%TYPE
5166: , p_description IN jtf_tasks_v.description%TYPE
5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

Line 5166: , p_description IN jtf_tasks_v.description%TYPE

5162:
5163: PROCEDURE query_task(
5164: p_object_version_number IN NUMBER
5165: , p_task_id IN jtf_tasks_v.task_id%TYPE
5166: , p_description IN jtf_tasks_v.description%TYPE
5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

Line 5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE

5163: PROCEDURE query_task(
5164: p_object_version_number IN NUMBER
5165: , p_task_id IN jtf_tasks_v.task_id%TYPE
5166: , p_description IN jtf_tasks_v.description%TYPE
5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

Line 5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE

5164: p_object_version_number IN NUMBER
5165: , p_task_id IN jtf_tasks_v.task_id%TYPE
5166: , p_description IN jtf_tasks_v.description%TYPE
5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

Line 5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

5165: , p_task_id IN jtf_tasks_v.task_id%TYPE
5166: , p_description IN jtf_tasks_v.description%TYPE
5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE

Line 5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

5166: , p_description IN jtf_tasks_v.description%TYPE
5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

5167: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

5168: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5173: , p_address_id IN jtf_tasks_v.address_id%TYPE

5169: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

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

5170: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

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

5171: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

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

5172: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

Line 5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

5173: , p_address_id IN jtf_tasks_v.address_id%TYPE
5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

Line 5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

5174: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

Line 5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

5175: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

Line 5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

5176: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

Line 5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

5177: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

Line 5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

5178: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

Line 5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

5179: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

Line 5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

5180: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

Line 5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

5181: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

Line 5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

5182: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

Line 5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

5183: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

Line 5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

5184: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

Line 5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

5185: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

Line 5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

5186: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

Line 5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

5187: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

Line 5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

5188: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

Line 5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

5189: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

Line 5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

5190: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5198: , p_ref_object_id IN NUMBER

Line 5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

5191: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5198: , p_ref_object_id IN NUMBER
5199: , p_ref_object_type_code IN VARCHAR2

Line 5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

5192: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5198: , p_ref_object_id IN NUMBER
5199: , p_ref_object_type_code IN VARCHAR2
5200: , p_task_name IN jtf_tasks_v.task_name%TYPE

Line 5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

5193: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
5194: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
5195: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5198: , p_ref_object_id IN NUMBER
5199: , p_ref_object_type_code IN VARCHAR2
5200: , p_task_name IN jtf_tasks_v.task_name%TYPE
5201: , p_sort_data IN jtf_tasks_pub.sort_data

Line 5200: , p_task_name IN jtf_tasks_v.task_name%TYPE

5196: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
5197: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
5198: , p_ref_object_id IN NUMBER
5199: , p_ref_object_type_code IN VARCHAR2
5200: , p_task_name IN jtf_tasks_v.task_name%TYPE
5201: , p_sort_data IN jtf_tasks_pub.sort_data
5202: , p_start_pointer IN NUMBER
5203: , p_rec_wanted IN NUMBER
5204: , p_show_all IN VARCHAR2

Line 5362: || 'from jtf_tasks_v ';

5358: || 'creation_date, '
5359: || 'escalation_level, '
5360: || 'object_version_number, '
5361: || 'location_id '
5362: || 'from jtf_tasks_v ';
5363: add_to_sql(p_task_id, 'b1', 'task_id');
5364: add_to_sql(p_description, 'b2', 'description');
5365: add_to_sql(p_task_status_id, 'b3', 'task_status_id');
5366: add_to_sql(p_task_priority_id, 'b4', 'task_priority_id');

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

5405: v_where :=
5406: v_where
5407: || ' exists '
5408: || '(select * from jtf_task_references_vl r '
5409: || ' where r.task_id = jtf_tasks_v.task_id '
5410: || ' and r.object_id = :b100 '
5411: || ' and r.object_type_code = :b101 ) ';
5412: END IF;
5413:

Line 5811: , p_task_id IN jtf_tasks_v.task_id%TYPE

5807: END query_task;
5808:
5809: PROCEDURE query_next_task(
5810: p_object_version_number IN NUMBER
5811: , p_task_id IN jtf_tasks_v.task_id%TYPE
5812: , -- current task id
5813: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
5814: , -- values Dependency or Date
5815: p_date_type IN VARCHAR2 DEFAULT NULL

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

5814: , -- values Dependency or Date
5815: p_date_type IN VARCHAR2 DEFAULT NULL
5816: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
5817: , -- start or end
5818: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5819: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5820: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5821: , p_sort_data IN jtf_tasks_pub.sort_data
5822: , p_start_pointer IN NUMBER

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

5815: p_date_type IN VARCHAR2 DEFAULT NULL
5816: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
5817: , -- start or end
5818: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5819: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5820: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5821: , p_sort_data IN jtf_tasks_pub.sort_data
5822: , p_start_pointer IN NUMBER
5823: , p_rec_wanted IN NUMBER

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

5816: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
5817: , -- start or end
5818: p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5819: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5820: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5821: , p_sort_data IN jtf_tasks_pub.sort_data
5822: , p_start_pointer IN NUMBER
5823: , p_rec_wanted IN NUMBER
5824: , p_show_all IN VARCHAR2 DEFAULT 'Y'

Line 5921: from jtf_tasks_v

5917: 'SCHEDULED_START_DATE', scheduled_start_date,
5918: 'SCHEDULED_END_DATE', scheduled_end_date,
5919: 'ACTUAL_START_DATE', actual_start_date,
5920: 'ACTUAL_END_DATE', actual_end_date, null)
5921: from jtf_tasks_v
5922: where task_id = p_task_id;*/
5923:
5924: -- Added by SBARAT on 30/05/2006 for perf bug# 5213367
5925: -- This query takea less sharable memory compared to previous one.

Line 5937: FROM jtf_tasks_vl jta

5933: , 'ACTUAL_START_DATE', actual_start_date
5934: , 'ACTUAL_END_DATE', actual_end_date
5935: , NULL
5936: )
5937: FROM jtf_tasks_vl jta
5938: , jtf_task_types_tl jttt
5939: , jtf_task_types_b jttb
5940: , jtf_task_statuses_tl jtst
5941: , jtf_task_statuses_b jtsb

Line 6053: || 'from jtf_tasks_v v ';

6049: || 'v.attribute13,'
6050: || 'v.attribute14,'
6051: || 'v.attribute15,'
6052: || 'v.attribute_category '
6053: || 'from jtf_tasks_v v ';
6054:
6055: IF (p_query_type = 'DEPENDENCY') THEN
6056: v_select := v_select || ', jtf_task_depends d ';
6057: add_to_sql(p_task_id, 'b1', 'd.dependent_on_task_id');

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

6065: IF (p_query_type = 'ASSIGNED') THEN
6066: v_date_sql :=
6067: 'select min('
6068: || v_start_date
6069: || ') from jtf_tasks_v where assigned_by_id = '
6070: || TO_CHAR(p_assigned_by)
6071: || ' and '
6072: || v_start_date
6073: || ' > :1 ';

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

6081: ELSIF(p_query_type = 'OWNER') THEN
6082: v_date_sql :=
6083: 'select min('
6084: || v_start_date
6085: || ') from jtf_tasks_v where owner_type_code = '''
6086: || p_owner_type_code
6087: || ''' and '
6088: || 'owner_id = '
6089: || TO_CHAR(p_owner_id)