eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASKS_PUB dependencies on JTF_TASKS_V

Line 3184: FROM jtf_tasks_vl

3180: p_child_sequence_num
3181: , fnd_api.g_miss_num, child_sequence_num
3182: , p_child_sequence_num
3183: ) child_sequence_num
3184: FROM jtf_tasks_vl
3185: WHERE task_id = l_task_id;
3186:
3187: task_rec c_task_update%ROWTYPE;
3188:

Line 4735: -- possible query variables which are named after fields in jtf_tasks_v

4731:
4732: -- p_file_name - file name for output of export file, always
4733: -- placed in /sqlcom/out directory
4734: --
4735: -- possible query variables which are named after fields in jtf_tasks_v
4736: -- p_task_number - query by task number
4737: -- p_task_id
4738: -- p_task_name
4739: -- p_description

Line 4789: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

4785: p_api_version IN NUMBER
4786: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
4787: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4788: , p_file_name IN VARCHAR2
4789: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

4786: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
4787: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4788: , p_file_name IN VARCHAR2
4789: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

4787: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4788: , p_file_name IN VARCHAR2
4789: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

4788: , p_file_name IN VARCHAR2
4789: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

4789: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

4790: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

4791: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

4792: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

4793: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

4794: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

4795: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

4796: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

4797: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

4798: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

4799: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

4800: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

4801: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

4802: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

4803: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

4804: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

4805: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

4806: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

4807: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

4808: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

4809: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

4810: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

4811: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

4812: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

4813: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

4814: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

4815: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

4816: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

4817: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

4818: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

4819: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

4820: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

4821: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

4822: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

4823: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4831: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

4824: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4831: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4832: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

4825: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4831: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4832: , p_ref_object_id IN NUMBER DEFAULT NULL
4833: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

4826: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4831: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4832: , p_ref_object_id IN NUMBER DEFAULT NULL
4833: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
4834: , p_sort_data IN sort_data

Line 4831: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

4827: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4828: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4829: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4830: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4831: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4832: , p_ref_object_id IN NUMBER DEFAULT NULL
4833: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
4834: , p_sort_data IN sort_data
4835: , p_start_pointer IN NUMBER

Line 4951: -- possible query variables which are named after fields in jtf_tasks_v

4947:
4948: -- p_file_name - file name for output of export file, always
4949: -- placed in /sqlcom/out directory
4950: --
4951: -- possible query variables which are named after fields in jtf_tasks_v
4952: -- p_task_number - query by task number
4953: -- p_task_id
4954: -- p_task_name
4955: -- p_description

Line 5005: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

5001: p_api_version IN NUMBER
5002: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5003: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5004: , p_file_name IN VARCHAR2
5005: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

5002: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5003: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5004: , p_file_name IN VARCHAR2
5005: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

5003: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5004: , p_file_name IN VARCHAR2
5005: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

5004: , p_file_name IN VARCHAR2
5005: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

5005: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

5006: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

5007: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

5008: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

5009: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

5010: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

5011: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

5012: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

5013: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

5014: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

5015: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

5016: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

5017: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

5018: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

5019: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

5020: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

5021: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

5022: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

5023: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

5024: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

5025: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

5026: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

5027: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

5028: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

5029: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

5030: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

5031: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

5032: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

5033: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

5034: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

5035: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

5036: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

5037: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

5038: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

5039: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5047: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

5040: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5047: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5048: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

5041: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5047: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5048: , p_ref_object_id IN NUMBER DEFAULT NULL
5049: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

5042: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5047: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5048: , p_ref_object_id IN NUMBER DEFAULT NULL
5049: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5050: , p_sort_data IN sort_data

Line 5047: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

5043: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5044: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5045: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5046: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5047: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5048: , p_ref_object_id IN NUMBER DEFAULT NULL
5049: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5050: , p_sort_data IN sort_data
5051: , p_start_pointer IN NUMBER

Line 5242: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE

5238: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5239: END export_file;
5240:
5241: PROCEDURE val_task(
5242: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE
5243: , p_task_number IN jtf_tasks_v.task_number%TYPE
5244: , p_task_name IN jtf_tasks_v.task_name%TYPE
5245: ) IS
5246: CURSOR c_task_number IS

Line 5243: , p_task_number IN jtf_tasks_v.task_number%TYPE

5239: END export_file;
5240:
5241: PROCEDURE val_task(
5242: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE
5243: , p_task_number IN jtf_tasks_v.task_number%TYPE
5244: , p_task_name IN jtf_tasks_v.task_name%TYPE
5245: ) IS
5246: CURSOR c_task_number IS
5247: SELECT task_id

Line 5244: , p_task_name IN jtf_tasks_v.task_name%TYPE

5240:
5241: PROCEDURE val_task(
5242: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE
5243: , p_task_number IN jtf_tasks_v.task_number%TYPE
5244: , p_task_name IN jtf_tasks_v.task_name%TYPE
5245: ) IS
5246: CURSOR c_task_number IS
5247: SELECT task_id
5248: FROM jtf_tasks_b

Line 5252: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl

5248: FROM jtf_tasks_b
5249: WHERE task_number = p_task_number;
5250:
5251: CURSOR c_task_name IS
5252: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5253: SELECT NULL
5254: FROM jtf_tasks_vl
5255: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5256:

Line 5254: FROM jtf_tasks_vl

5250:
5251: CURSOR c_task_name IS
5252: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5253: SELECT NULL
5254: FROM jtf_tasks_vl
5255: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5256:
5257: v_dummy VARCHAR2(1);
5258: BEGIN

Line 5293: PROCEDURE val_task_id(p_task_id IN jtf_tasks_v.task_id%TYPE) IS

5289: END IF;
5290: END IF;
5291: END;
5292:
5293: PROCEDURE val_task_id(p_task_id IN jtf_tasks_v.task_id%TYPE) IS
5294: CURSOR c_task_id IS
5295: SELECT NULL
5296: FROM jtf_tasks_b
5297: WHERE task_id = p_task_id;

Line 5333: v_assigned_by_id IN OUT NOCOPY jtf_tasks_v.assigned_by_id%TYPE

5329: END IF;
5330: END val_dates;
5331:
5332: PROCEDURE val_assigned(
5333: v_assigned_by_id IN OUT NOCOPY jtf_tasks_v.assigned_by_id%TYPE
5334: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE
5335: ) IS
5336: CURSOR c_assigned_by_name IS
5337: SELECT user_id assigned_by_id

Line 5334: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE

5330: END val_dates;
5331:
5332: PROCEDURE val_assigned(
5333: v_assigned_by_id IN OUT NOCOPY jtf_tasks_v.assigned_by_id%TYPE
5334: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE
5335: ) IS
5336: CURSOR c_assigned_by_name IS
5337: SELECT user_id assigned_by_id
5338: FROM fnd_user

Line 5362: v_object_type_code IN OUT NOCOPY jtf_tasks_v.source_object_type_code%TYPE

5358: END IF;
5359: END;
5360:
5361: PROCEDURE val_object_type(
5362: v_object_type_code IN OUT NOCOPY jtf_tasks_v.source_object_type_code%TYPE
5363: , p_object_name IN jtf_tasks_v.source_object_name%TYPE
5364: ) IS
5365: CURSOR c_object_type_name IS
5366: SELECT object_code

Line 5363: , p_object_name IN jtf_tasks_v.source_object_name%TYPE

5359: END;
5360:
5361: PROCEDURE val_object_type(
5362: v_object_type_code IN OUT NOCOPY jtf_tasks_v.source_object_type_code%TYPE
5363: , p_object_name IN jtf_tasks_v.source_object_name%TYPE
5364: ) IS
5365: CURSOR c_object_type_name IS
5366: SELECT object_code
5367: FROM jtf_objects_vl

Line 5392: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE

5388: END IF;
5389: END;
5390:
5391: PROCEDURE val_customer(
5392: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE
5393: , p_customer_name IN jtf_tasks_v.customer_name%TYPE
5394: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5395: ) IS
5396: CURSOR c1 IS

Line 5393: , p_customer_name IN jtf_tasks_v.customer_name%TYPE

5389: END;
5390:
5391: PROCEDURE val_customer(
5392: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE
5393: , p_customer_name IN jtf_tasks_v.customer_name%TYPE
5394: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5395: ) IS
5396: CURSOR c1 IS
5397: SELECT party_id

Line 5394: , p_customer_number IN jtf_tasks_v.customer_number%TYPE

5390:
5391: PROCEDURE val_customer(
5392: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE
5393: , p_customer_name IN jtf_tasks_v.customer_name%TYPE
5394: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5395: ) IS
5396: CURSOR c1 IS
5397: SELECT party_id
5398: FROM hz_parties

Line 5442: p_cust_account_id IN OUT NOCOPY jtf_tasks_v.cust_account_id%TYPE

5438: END IF;
5439: END val_customer;
5440:
5441: PROCEDURE val_cust_account(
5442: p_cust_account_id IN OUT NOCOPY jtf_tasks_v.cust_account_id%TYPE
5443: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE
5444: ) IS
5445: CURSOR c1 IS
5446: SELECT cust_account_id

Line 5443: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE

5439: END val_customer;
5440:
5441: PROCEDURE val_cust_account(
5442: p_cust_account_id IN OUT NOCOPY jtf_tasks_v.cust_account_id%TYPE
5443: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE
5444: ) IS
5445: CURSOR c1 IS
5446: SELECT cust_account_id
5447: FROM hz_cust_accounts

Line 5470: v_task_priority_id IN OUT NOCOPY jtf_tasks_v.task_priority_id%TYPE

5466: END IF;
5467: END val_cust_account;
5468:
5469: PROCEDURE val_priority(
5470: v_task_priority_id IN OUT NOCOPY jtf_tasks_v.task_priority_id%TYPE
5471: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE
5472: ) IS
5473: CURSOR c_task_priority_name IS
5474: SELECT task_priority_id

Line 5471: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE

5467: END val_cust_account;
5468:
5469: PROCEDURE val_priority(
5470: v_task_priority_id IN OUT NOCOPY jtf_tasks_v.task_priority_id%TYPE
5471: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE
5472: ) IS
5473: CURSOR c_task_priority_name IS
5474: SELECT task_priority_id
5475: FROM jtf_task_priorities_vl

Line 5499: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v

5495: END IF;
5496: END IF;
5497: END val_priority;
5498:
5499: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v
5500:
5501: -- p_task_number - query by task number
5502: -- p_task_id
5503: -- p_task_name

Line 5551: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

5547: (
5548: p_api_version IN NUMBER
5549: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5550: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5551: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

5548: p_api_version IN NUMBER
5549: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5550: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5551: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

5549: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5550: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5551: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

5550: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5551: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

5551: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

5552: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

5553: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

5554: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

5555: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

5556: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

5557: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

5558: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

5559: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

5560: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

5561: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

5562: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

5563: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

5564: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

5565: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

5566: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

5567: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

5568: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

5569: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

5570: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

5571: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

5572: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

5573: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

5574: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

5575: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

5576: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

5577: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

5578: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

5579: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

5580: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

5581: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

5582: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

5583: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

5584: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

5585: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5593: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

5586: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5593: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5594: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

5587: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5593: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5594: , p_ref_object_id IN NUMBER DEFAULT NULL
5595: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

5588: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5593: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5594: , p_ref_object_id IN NUMBER DEFAULT NULL
5595: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5596: , p_sort_data IN sort_data

Line 5593: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

5589: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5590: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5591: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5592: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5593: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5594: , p_ref_object_id IN NUMBER DEFAULT NULL
5595: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5596: , p_sort_data IN sort_data
5597: , p_start_pointer IN NUMBER

Line 5711: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v

5707:
5708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5709: END query_task;
5710:
5711: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v
5712:
5713: -- p_task_number - query by task number
5714: -- p_task_id
5715: -- p_task_name

Line 5763: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL

5759: (
5760: p_api_version IN NUMBER
5761: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5763: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

Line 5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL

5760: p_api_version IN NUMBER
5761: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5763: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

Line 5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL

5761: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5763: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

Line 5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL

5762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5763: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

Line 5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

5763: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

Line 5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

5764: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

Line 5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

5765: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

Line 5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

5766: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

Line 5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

5767: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

Line 5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

5768: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

5769: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

5770: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

Line 5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

5771: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

Line 5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

5772: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

Line 5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

5773: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

5774: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

5775: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

Line 5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

5776: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

Line 5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

5777: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

Line 5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

5778: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

5779: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

Line 5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

5780: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

Line 5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

5781: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

Line 5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

5782: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

Line 5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

5783: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

Line 5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

5784: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

Line 5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

5785: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

Line 5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

5786: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

Line 5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

5787: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

Line 5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

5788: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

Line 5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

5789: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

Line 5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

5790: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

Line 5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

5791: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

Line 5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

5792: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

Line 5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

5793: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

Line 5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

5794: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

Line 5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

5795: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

Line 5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

5796: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

Line 5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

5797: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5805: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

Line 5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

5798: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5805: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5806: , p_ref_object_id IN NUMBER DEFAULT NULL

Line 5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

5799: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5805: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5806: , p_ref_object_id IN NUMBER DEFAULT NULL
5807: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

Line 5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

5800: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5805: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5806: , p_ref_object_id IN NUMBER DEFAULT NULL
5807: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5808: , p_sort_data IN sort_data

Line 5805: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

5801: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5802: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5803: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5804: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5805: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5806: , p_ref_object_id IN NUMBER DEFAULT NULL
5807: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5808: , p_sort_data IN sort_data
5809: , p_start_pointer IN NUMBER

Line 5827: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;

5823: l_api_name CONSTANT VARCHAR2(30) := 'QUERY_TASK';
5824: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5825: l_msg_data VARCHAR2(2000);
5826: l_msg_count NUMBER;
5827: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;

Line 5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;

5824: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5825: l_msg_data VARCHAR2(2000);
5826: l_msg_count NUMBER;
5827: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;

Line 5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;

5825: l_msg_data VARCHAR2(2000);
5826: l_msg_count NUMBER;
5827: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;

Line 5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;

5826: l_msg_count NUMBER;
5827: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5834: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;

Line 5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;

5827: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5834: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5835: l_type VARCHAR2(10);

Line 5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;

5828: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5834: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5835: l_type VARCHAR2(10);
5836: BEGIN

Line 5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;

5829: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5834: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5835: l_type VARCHAR2(10);
5836: BEGIN
5837: SAVEPOINT query_task_pub2;

Line 5834: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;

5830: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5831: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5832: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5833: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5834: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5835: l_type VARCHAR2(10);
5836: BEGIN
5837: SAVEPOINT query_task_pub2;
5838: x_return_status := fnd_api.g_ret_sts_success;

Line 6104: -- p_owner_id -- query owner_id from jtf_tasks_v

6100:
6101: --The following parameters only used if p_query_type is date
6102: -- p_date_type -- date type, values scheduled, planned, actual
6103: -- p_date_start_or_end -- use start or end date of current task values start/end
6104: -- p_owner_id -- query owner_id from jtf_tasks_v
6105: -- p_owner_type_code -- query owner_type_code from jtf_tasks_v
6106: -- p_assigned_by -- assigned_by
6107:
6108: -- p_sort_data -- sort data structucture based on sort date

Line 6105: -- p_owner_type_code -- query owner_type_code from jtf_tasks_v

6101: --The following parameters only used if p_query_type is date
6102: -- p_date_type -- date type, values scheduled, planned, actual
6103: -- p_date_start_or_end -- use start or end date of current task values start/end
6104: -- p_owner_id -- query owner_id from jtf_tasks_v
6105: -- p_owner_type_code -- query owner_type_code from jtf_tasks_v
6106: -- p_assigned_by -- assigned_by
6107:
6108: -- p_sort_data -- sort data structucture based on sort date
6109: -- p_start_pointer -- return records starting at this number

Line 6122: , p_task_id IN jtf_tasks_v.task_id%TYPE

6118: (
6119: p_api_version IN NUMBER
6120: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6121: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
6122: , p_task_id IN jtf_tasks_v.task_id%TYPE
6123: , -- current task id
6124: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
6125: , -- values Dependency or Date
6126: p_date_type IN VARCHAR2 DEFAULT NULL

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

6124: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
6125: , -- values Dependency or Date
6126: p_date_type IN VARCHAR2 DEFAULT NULL
6127: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
6128: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
6129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
6130: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
6131: , p_sort_data IN sort_data
6132: , p_start_pointer IN NUMBER

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

6125: , -- values Dependency or Date
6126: p_date_type IN VARCHAR2 DEFAULT NULL
6127: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
6128: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
6129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
6130: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
6131: , p_sort_data IN sort_data
6132: , p_start_pointer IN NUMBER
6133: , p_rec_wanted IN NUMBER

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

6126: p_date_type IN VARCHAR2 DEFAULT NULL
6127: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
6128: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
6129: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
6130: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
6131: , p_sort_data IN sort_data
6132: , p_start_pointer IN NUMBER
6133: , p_rec_wanted IN NUMBER
6134: , p_show_all IN VARCHAR2 DEFAULT 'Y'

Line 6410: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka

6406: , NVL(tka.show_on_calendar, NULL) show_on_calendar
6407: , NVL(tka.assignment_status_id, NULL) assignment_status_id
6408: , tka.free_busy_type free_busy_type
6409: , tk.entity
6410: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
6411: WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
6412:
6413: -- Fetch also assignment details for OWNER, if present, as this is
6414: -- created by the task_create API