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

1144: );
1145:
1146: PROCEDURE query_task(
1147: p_object_version_number IN NUMBER
1148: , p_task_id IN jtf_tasks_v.task_id%TYPE
1149: , p_description IN jtf_tasks_v.description%TYPE
1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

Line 1149: , p_description IN jtf_tasks_v.description%TYPE

1145:
1146: PROCEDURE query_task(
1147: p_object_version_number IN NUMBER
1148: , p_task_id IN jtf_tasks_v.task_id%TYPE
1149: , p_description IN jtf_tasks_v.description%TYPE
1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

Line 1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE

1146: PROCEDURE query_task(
1147: p_object_version_number IN NUMBER
1148: , p_task_id IN jtf_tasks_v.task_id%TYPE
1149: , p_description IN jtf_tasks_v.description%TYPE
1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

Line 1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE

1147: p_object_version_number IN NUMBER
1148: , p_task_id IN jtf_tasks_v.task_id%TYPE
1149: , p_description IN jtf_tasks_v.description%TYPE
1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

Line 1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

1148: , p_task_id IN jtf_tasks_v.task_id%TYPE
1149: , p_description IN jtf_tasks_v.description%TYPE
1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE

Line 1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

1149: , p_description IN jtf_tasks_v.description%TYPE
1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

1150: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

1151: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 1156: , p_address_id IN jtf_tasks_v.address_id%TYPE

1152: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

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

1153: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

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

1154: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

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

1155: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

Line 1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

1156: , p_address_id IN jtf_tasks_v.address_id%TYPE
1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

Line 1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

1157: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

Line 1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

1158: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

Line 1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

1159: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

Line 1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

1160: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

Line 1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

1161: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

Line 1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

1162: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

Line 1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

1163: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

Line 1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

1164: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

Line 1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

1165: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

Line 1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

1166: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

Line 1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

1167: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

Line 1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

1168: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

Line 1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

1169: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

Line 1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

1170: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

Line 1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

1171: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

Line 1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

1172: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

Line 1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

1173: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181: , p_ref_object_id IN NUMBER

Line 1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

1174: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181: , p_ref_object_id IN NUMBER
1182: , p_ref_object_type_code IN VARCHAR2

Line 1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

1175: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181: , p_ref_object_id IN NUMBER
1182: , p_ref_object_type_code IN VARCHAR2
1183: , p_task_name IN jtf_tasks_v.task_name%TYPE

Line 1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

1176: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181: , p_ref_object_id IN NUMBER
1182: , p_ref_object_type_code IN VARCHAR2
1183: , p_task_name IN jtf_tasks_v.task_name%TYPE
1184: , p_sort_data IN jtf_tasks_pub.sort_data

Line 1183: , p_task_name IN jtf_tasks_v.task_name%TYPE

1179: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181: , p_ref_object_id IN NUMBER
1182: , p_ref_object_type_code IN VARCHAR2
1183: , p_task_name IN jtf_tasks_v.task_name%TYPE
1184: , p_sort_data IN jtf_tasks_pub.sort_data
1185: , p_start_pointer IN NUMBER
1186: , p_rec_wanted IN NUMBER
1187: , p_show_all IN VARCHAR2

Line 1200: , p_task_id IN jtf_tasks_v.task_id%TYPE

1196: );
1197:
1198: PROCEDURE query_task(
1199: p_object_version_number IN NUMBER
1200: , p_task_id IN jtf_tasks_v.task_id%TYPE
1201: , p_description IN jtf_tasks_v.description%TYPE
1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

Line 1201: , p_description IN jtf_tasks_v.description%TYPE

1197:
1198: PROCEDURE query_task(
1199: p_object_version_number IN NUMBER
1200: , p_task_id IN jtf_tasks_v.task_id%TYPE
1201: , p_description IN jtf_tasks_v.description%TYPE
1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

Line 1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE

1198: PROCEDURE query_task(
1199: p_object_version_number IN NUMBER
1200: , p_task_id IN jtf_tasks_v.task_id%TYPE
1201: , p_description IN jtf_tasks_v.description%TYPE
1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

Line 1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE

1199: p_object_version_number IN NUMBER
1200: , p_task_id IN jtf_tasks_v.task_id%TYPE
1201: , p_description IN jtf_tasks_v.description%TYPE
1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

Line 1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE

1200: , p_task_id IN jtf_tasks_v.task_id%TYPE
1201: , p_description IN jtf_tasks_v.description%TYPE
1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE

Line 1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE

1201: , p_description IN jtf_tasks_v.description%TYPE
1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE

1202: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE

1203: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 1208: , p_address_id IN jtf_tasks_v.address_id%TYPE

1204: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

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

1205: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

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

1206: , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

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

1207: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

Line 1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE

1208: , p_address_id IN jtf_tasks_v.address_id%TYPE
1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

Line 1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE

1209: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

Line 1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE

1210: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

Line 1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE

1211: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

Line 1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE

1212: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

Line 1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE

1213: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

Line 1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE

1214: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

Line 1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE

1215: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

Line 1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE

1216: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

Line 1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE

1217: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

Line 1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE

1218: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

Line 1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE

1219: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

Line 1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE

1220: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

Line 1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE

1221: , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

Line 1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE

1222: , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

Line 1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE

1223: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

Line 1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE

1224: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

Line 1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE

1225: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233: , p_ref_object_id IN NUMBER

Line 1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE

1226: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233: , p_ref_object_id IN NUMBER
1234: , p_ref_object_type_code IN VARCHAR2

Line 1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE

1227: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233: , p_ref_object_id IN NUMBER
1234: , p_ref_object_type_code IN VARCHAR2
1235: , p_task_name IN jtf_tasks_v.task_name%TYPE

Line 1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE

1228: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233: , p_ref_object_id IN NUMBER
1234: , p_ref_object_type_code IN VARCHAR2
1235: , p_task_name IN jtf_tasks_v.task_name%TYPE
1236: , p_sort_data IN jtf_tasks_pub.sort_data

Line 1235: , p_task_name IN jtf_tasks_v.task_name%TYPE

1231: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233: , p_ref_object_id IN NUMBER
1234: , p_ref_object_type_code IN VARCHAR2
1235: , p_task_name IN jtf_tasks_v.task_name%TYPE
1236: , p_sort_data IN jtf_tasks_pub.sort_data
1237: , p_start_pointer IN NUMBER
1238: , p_rec_wanted IN NUMBER
1239: , p_show_all IN VARCHAR2

Line 1251: , p_task_id IN jtf_tasks_v.task_id%TYPE

1247: );
1248:
1249: PROCEDURE query_next_task(
1250: p_object_version_number IN NUMBER
1251: , p_task_id IN jtf_tasks_v.task_id%TYPE
1252: , -- current task id
1253: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
1254: , -- values Dependency, Owner, assigned
1255: p_date_type IN VARCHAR2 DEFAULT NULL

Line 1257: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

1253: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
1254: , -- values Dependency, Owner, assigned
1255: p_date_type IN VARCHAR2 DEFAULT NULL
1256: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
1257: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1258: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1259: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1260: , p_sort_data IN jtf_tasks_pub.sort_data
1261: , p_start_pointer IN NUMBER

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

1254: , -- values Dependency, Owner, assigned
1255: p_date_type IN VARCHAR2 DEFAULT NULL
1256: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
1257: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1258: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1259: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1260: , p_sort_data IN jtf_tasks_pub.sort_data
1261: , p_start_pointer IN NUMBER
1262: , p_rec_wanted IN NUMBER

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

1255: p_date_type IN VARCHAR2 DEFAULT NULL
1256: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
1257: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1258: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1259: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1260: , p_sort_data IN jtf_tasks_pub.sort_data
1261: , p_start_pointer IN NUMBER
1262: , p_rec_wanted IN NUMBER
1263: , p_show_all IN VARCHAR2 DEFAULT 'Y'