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 3183: FROM jtf_tasks_vl

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

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

4706:
4707: -- p_file_name - file name for output of export file, always
4708: -- placed in /sqlcom/out directory
4709: --
4710: -- possible query variables which are named after fields in jtf_tasks_v
4711: -- p_task_number - query by task number
4712: -- p_task_id
4713: -- p_task_name
4714: -- p_description

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

4760: p_api_version IN NUMBER
4761: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
4762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4763: , p_file_name IN VARCHAR2
4764: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4765: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

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

4761: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
4762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4763: , p_file_name IN VARCHAR2
4764: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4765: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

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

4762: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4763: , p_file_name IN VARCHAR2
4764: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4765: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

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

4763: , p_file_name IN VARCHAR2
4764: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4765: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

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

4764: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4765: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

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

4765: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

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

4766: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

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

4767: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

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

4768: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

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

4769: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

4770: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

4771: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

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

4772: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

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

4773: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

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

4774: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

4775: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

4776: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

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

4777: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

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

4778: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

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

4779: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

4780: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

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

4781: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

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

4782: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

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

4783: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

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

4784: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

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

4785: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

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

4786: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

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

4787: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

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

4788: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

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

4789: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

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

4790: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

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

4791: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

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

4792: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

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

4793: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

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

4794: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

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

4795: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

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

4796: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

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

4797: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4805: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

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

4798: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4805: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4806: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

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

4799: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4805: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4806: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4807: , p_ref_object_id IN NUMBER DEFAULT NULL

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

4800: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4805: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4806: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4807: , p_ref_object_id IN NUMBER DEFAULT NULL
4808: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

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

4801: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4805: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4806: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4807: , p_ref_object_id IN NUMBER DEFAULT NULL
4808: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
4809: , p_sort_data IN sort_data

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

4802: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
4803: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
4804: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
4805: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
4806: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
4807: , p_ref_object_id IN NUMBER DEFAULT NULL
4808: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
4809: , p_sort_data IN sort_data
4810: , p_start_pointer IN NUMBER

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

4922:
4923: -- p_file_name - file name for output of export file, always
4924: -- placed in /sqlcom/out directory
4925: --
4926: -- possible query variables which are named after fields in jtf_tasks_v
4927: -- p_task_number - query by task number
4928: -- p_task_id
4929: -- p_task_name
4930: -- p_description

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

4976: p_api_version IN NUMBER
4977: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
4978: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4979: , p_file_name IN VARCHAR2
4980: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4981: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

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

4977: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
4978: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4979: , p_file_name IN VARCHAR2
4980: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4981: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

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

4978: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
4979: , p_file_name IN VARCHAR2
4980: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4981: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

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

4979: , p_file_name IN VARCHAR2
4980: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4981: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

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

4980: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
4981: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

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

4981: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

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

4982: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

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

4983: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

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

4984: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

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

4985: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

4986: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

4987: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

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

4988: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

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

4989: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

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

4990: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

4991: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

4992: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

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

4993: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

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

4994: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

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

4995: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

4996: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

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

4997: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

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

4998: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

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

4999: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

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

5000: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

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

5001: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

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

5002: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

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

5003: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

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

5004: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

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

5005: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

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

5006: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

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

5007: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

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

5008: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

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

5009: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

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

5010: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

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

5011: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

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

5012: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

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

5013: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5021: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

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

5014: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5021: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5022: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

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

5015: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5021: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5022: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5023: , p_ref_object_id IN NUMBER DEFAULT NULL

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

5016: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5021: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5022: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5023: , p_ref_object_id IN NUMBER DEFAULT NULL
5024: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

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

5017: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5021: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5022: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5023: , p_ref_object_id IN NUMBER DEFAULT NULL
5024: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5025: , p_sort_data IN sort_data

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

5018: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5019: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5020: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5021: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5022: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5023: , p_ref_object_id IN NUMBER DEFAULT NULL
5024: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5025: , p_sort_data IN sort_data
5026: , p_start_pointer IN NUMBER

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

5213: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5214: END export_file;
5215:
5216: PROCEDURE val_task(
5217: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE
5218: , p_task_number IN jtf_tasks_v.task_number%TYPE
5219: , p_task_name IN jtf_tasks_v.task_name%TYPE
5220: ) IS
5221: CURSOR c_task_number IS

Line 5218: , p_task_number IN jtf_tasks_v.task_number%TYPE

5214: END export_file;
5215:
5216: PROCEDURE val_task(
5217: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE
5218: , p_task_number IN jtf_tasks_v.task_number%TYPE
5219: , p_task_name IN jtf_tasks_v.task_name%TYPE
5220: ) IS
5221: CURSOR c_task_number IS
5222: SELECT task_id

Line 5219: , p_task_name IN jtf_tasks_v.task_name%TYPE

5215:
5216: PROCEDURE val_task(
5217: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE
5218: , p_task_number IN jtf_tasks_v.task_number%TYPE
5219: , p_task_name IN jtf_tasks_v.task_name%TYPE
5220: ) IS
5221: CURSOR c_task_number IS
5222: SELECT task_id
5223: FROM jtf_tasks_b

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

5223: FROM jtf_tasks_b
5224: WHERE task_number = p_task_number;
5225:
5226: CURSOR c_task_name IS
5227: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5228: SELECT NULL
5229: FROM jtf_tasks_vl
5230: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5231:

Line 5229: FROM jtf_tasks_vl

5225:
5226: CURSOR c_task_name IS
5227: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5228: SELECT NULL
5229: FROM jtf_tasks_vl
5230: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5231:
5232: v_dummy VARCHAR2(1);
5233: BEGIN

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

5264: END IF;
5265: END IF;
5266: END;
5267:
5268: PROCEDURE val_task_id(p_task_id IN jtf_tasks_v.task_id%TYPE) IS
5269: CURSOR c_task_id IS
5270: SELECT NULL
5271: FROM jtf_tasks_b
5272: WHERE task_id = p_task_id;

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

5304: END IF;
5305: END val_dates;
5306:
5307: PROCEDURE val_assigned(
5308: v_assigned_by_id IN OUT NOCOPY jtf_tasks_v.assigned_by_id%TYPE
5309: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE
5310: ) IS
5311: CURSOR c_assigned_by_name IS
5312: SELECT user_id assigned_by_id

Line 5309: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE

5305: END val_dates;
5306:
5307: PROCEDURE val_assigned(
5308: v_assigned_by_id IN OUT NOCOPY jtf_tasks_v.assigned_by_id%TYPE
5309: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE
5310: ) IS
5311: CURSOR c_assigned_by_name IS
5312: SELECT user_id assigned_by_id
5313: FROM fnd_user

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

5333: END IF;
5334: END;
5335:
5336: PROCEDURE val_object_type(
5337: v_object_type_code IN OUT NOCOPY jtf_tasks_v.source_object_type_code%TYPE
5338: , p_object_name IN jtf_tasks_v.source_object_name%TYPE
5339: ) IS
5340: CURSOR c_object_type_name IS
5341: SELECT object_code

Line 5338: , p_object_name IN jtf_tasks_v.source_object_name%TYPE

5334: END;
5335:
5336: PROCEDURE val_object_type(
5337: v_object_type_code IN OUT NOCOPY jtf_tasks_v.source_object_type_code%TYPE
5338: , p_object_name IN jtf_tasks_v.source_object_name%TYPE
5339: ) IS
5340: CURSOR c_object_type_name IS
5341: SELECT object_code
5342: FROM jtf_objects_vl

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

5363: END IF;
5364: END;
5365:
5366: PROCEDURE val_customer(
5367: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE
5368: , p_customer_name IN jtf_tasks_v.customer_name%TYPE
5369: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5370: ) IS
5371: CURSOR c1 IS

Line 5368: , p_customer_name IN jtf_tasks_v.customer_name%TYPE

5364: END;
5365:
5366: PROCEDURE val_customer(
5367: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE
5368: , p_customer_name IN jtf_tasks_v.customer_name%TYPE
5369: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5370: ) IS
5371: CURSOR c1 IS
5372: SELECT party_id

Line 5369: , p_customer_number IN jtf_tasks_v.customer_number%TYPE

5365:
5366: PROCEDURE val_customer(
5367: p_customer_id IN OUT NOCOPY jtf_tasks_v.customer_id%TYPE
5368: , p_customer_name IN jtf_tasks_v.customer_name%TYPE
5369: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5370: ) IS
5371: CURSOR c1 IS
5372: SELECT party_id
5373: FROM hz_parties

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

5413: END IF;
5414: END val_customer;
5415:
5416: PROCEDURE val_cust_account(
5417: p_cust_account_id IN OUT NOCOPY jtf_tasks_v.cust_account_id%TYPE
5418: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE
5419: ) IS
5420: CURSOR c1 IS
5421: SELECT cust_account_id

Line 5418: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE

5414: END val_customer;
5415:
5416: PROCEDURE val_cust_account(
5417: p_cust_account_id IN OUT NOCOPY jtf_tasks_v.cust_account_id%TYPE
5418: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE
5419: ) IS
5420: CURSOR c1 IS
5421: SELECT cust_account_id
5422: FROM hz_cust_accounts

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

5441: END IF;
5442: END val_cust_account;
5443:
5444: PROCEDURE val_priority(
5445: v_task_priority_id IN OUT NOCOPY jtf_tasks_v.task_priority_id%TYPE
5446: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE
5447: ) IS
5448: CURSOR c_task_priority_name IS
5449: SELECT task_priority_id

Line 5446: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE

5442: END val_cust_account;
5443:
5444: PROCEDURE val_priority(
5445: v_task_priority_id IN OUT NOCOPY jtf_tasks_v.task_priority_id%TYPE
5446: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE
5447: ) IS
5448: CURSOR c_task_priority_name IS
5449: SELECT task_priority_id
5450: FROM jtf_task_priorities_vl

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

5470: END IF;
5471: END IF;
5472: END val_priority;
5473:
5474: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v
5475:
5476: -- p_task_number - query by task number
5477: -- p_task_id
5478: -- p_task_name

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

5522: (
5523: p_api_version IN NUMBER
5524: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5525: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5526: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5527: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

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

5523: p_api_version IN NUMBER
5524: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5525: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5526: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5527: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

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

5524: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5525: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5526: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5527: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

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

5525: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5526: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5527: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

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

5526: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5527: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

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

5527: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

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

5528: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

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

5529: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

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

5530: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

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

5531: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

5532: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

5533: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

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

5534: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

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

5535: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

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

5536: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

5537: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

5538: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

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

5539: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

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

5540: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

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

5541: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

5542: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

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

5543: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

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

5544: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

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

5545: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

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

5546: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

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

5547: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

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

5548: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

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

5549: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

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

5550: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

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

5551: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

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

5552: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

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

5553: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

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

5554: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

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

5555: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

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

5556: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

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

5557: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

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

5558: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

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

5559: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5567: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

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

5560: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5567: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5568: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

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

5561: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5567: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5568: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5569: , p_ref_object_id IN NUMBER DEFAULT NULL

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

5562: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5567: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5568: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5569: , p_ref_object_id IN NUMBER DEFAULT NULL
5570: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

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

5563: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5567: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5568: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5569: , p_ref_object_id IN NUMBER DEFAULT NULL
5570: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5571: , p_sort_data IN sort_data

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

5564: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5565: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5566: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5567: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5568: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5569: , p_ref_object_id IN NUMBER DEFAULT NULL
5570: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5571: , p_sort_data IN sort_data
5572: , p_start_pointer IN NUMBER

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

5682:
5683: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5684: END query_task;
5685:
5686: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v
5687:
5688: -- p_task_number - query by task number
5689: -- p_task_id
5690: -- p_task_name

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

5734: (
5735: p_api_version IN NUMBER
5736: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5737: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5738: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5739: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL

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

5735: p_api_version IN NUMBER
5736: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5737: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5738: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5739: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL

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

5736: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5737: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5738: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5739: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL

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

5737: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
5738: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5739: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL

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

5738: , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
5739: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL

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

5739: , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL

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

5740: , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL

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

5741: , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL

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

5742: , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL

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

5743: , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL

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

5744: , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL

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

5745: , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL

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

5746: , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL

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

5747: , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL

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

5748: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL

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

5749: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL

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

5750: , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL

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

5751: , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL

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

5752: , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL

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

5753: , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL

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

5754: , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL

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

5755: , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL

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

5756: , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL

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

5757: , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL

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

5758: , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL

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

5759: , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL

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

5760: , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL

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

5761: , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL

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

5762: , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL

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

5763: , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL

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

5764: , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL

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

5765: , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL

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

5766: , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL

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

5767: , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL

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

5768: , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL

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

5769: , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL

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

5770: , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL

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

5771: , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5779: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL

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

5772: , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5779: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5780: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL

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

5773: , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5779: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5780: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5781: , p_ref_object_id IN NUMBER DEFAULT NULL

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

5774: , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5779: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5780: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5781: , p_ref_object_id IN NUMBER DEFAULT NULL
5782: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL

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

5775: , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5779: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5780: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5781: , p_ref_object_id IN NUMBER DEFAULT NULL
5782: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5783: , p_sort_data IN sort_data

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

5776: , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
5777: , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
5778: , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
5779: , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
5780: , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
5781: , p_ref_object_id IN NUMBER DEFAULT NULL
5782: , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
5783: , p_sort_data IN sort_data
5784: , p_start_pointer IN NUMBER

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

5798: l_api_name CONSTANT VARCHAR2(30) := 'QUERY_TASK';
5799: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5800: l_msg_data VARCHAR2(2000);
5801: l_msg_count NUMBER;
5802: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5803: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;

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

5799: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5800: l_msg_data VARCHAR2(2000);
5801: l_msg_count NUMBER;
5802: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5803: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;

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

5800: l_msg_data VARCHAR2(2000);
5801: l_msg_count NUMBER;
5802: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5803: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5808: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;

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

5801: l_msg_count NUMBER;
5802: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5803: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5808: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5809: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;

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

5802: v_task_id jtf_tasks_v.task_id%TYPE := p_task_id;
5803: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5808: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5809: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5810: l_type VARCHAR2(10);

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

5803: v_task_type_id jtf_tasks_v.task_type_id%TYPE := p_task_type_id;
5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5808: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5809: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5810: l_type VARCHAR2(10);
5811: BEGIN

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

5804: v_task_status_id jtf_tasks_v.task_status_id%TYPE := p_task_status_id;
5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5808: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5809: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5810: l_type VARCHAR2(10);
5811: BEGIN
5812: SAVEPOINT query_task_pub2;

Line 5809: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;

5805: v_object_type_code jtf_tasks_v.source_object_type_code%TYPE := p_object_type_code;
5806: v_task_priority_id jtf_tasks_v.task_priority_id%TYPE := p_task_priority_id;
5807: v_customer_id jtf_tasks_v.customer_id%TYPE := p_customer_id;
5808: v_cust_account_id jtf_tasks_v.cust_account_id%TYPE := p_cust_account_id;
5809: v_assigned_by_id jtf_tasks_v.assigned_by_id%TYPE;
5810: l_type VARCHAR2(10);
5811: BEGIN
5812: SAVEPOINT query_task_pub2;
5813: x_return_status := fnd_api.g_ret_sts_success;

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

6075:
6076: --The following parameters only used if p_query_type is date
6077: -- p_date_type -- date type, values scheduled, planned, actual
6078: -- p_date_start_or_end -- use start or end date of current task values start/end
6079: -- p_owner_id -- query owner_id from jtf_tasks_v
6080: -- p_owner_type_code -- query owner_type_code from jtf_tasks_v
6081: -- p_assigned_by -- assigned_by
6082:
6083: -- p_sort_data -- sort data structucture based on sort date

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

6076: --The following parameters only used if p_query_type is date
6077: -- p_date_type -- date type, values scheduled, planned, actual
6078: -- p_date_start_or_end -- use start or end date of current task values start/end
6079: -- p_owner_id -- query owner_id from jtf_tasks_v
6080: -- p_owner_type_code -- query owner_type_code from jtf_tasks_v
6081: -- p_assigned_by -- assigned_by
6082:
6083: -- p_sort_data -- sort data structucture based on sort date
6084: -- p_start_pointer -- return records starting at this number

Line 6097: , p_task_id IN jtf_tasks_v.task_id%TYPE

6093: (
6094: p_api_version IN NUMBER
6095: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6096: , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
6097: , p_task_id IN jtf_tasks_v.task_id%TYPE
6098: , -- current task id
6099: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
6100: , -- values Dependency or Date
6101: p_date_type IN VARCHAR2 DEFAULT NULL

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

6099: p_query_type IN VARCHAR2 DEFAULT 'Dependency'
6100: , -- values Dependency or Date
6101: p_date_type IN VARCHAR2 DEFAULT NULL
6102: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
6103: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
6104: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
6105: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
6106: , p_sort_data IN sort_data
6107: , p_start_pointer IN NUMBER

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

6100: , -- values Dependency or Date
6101: p_date_type IN VARCHAR2 DEFAULT NULL
6102: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
6103: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
6104: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
6105: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
6106: , p_sort_data IN sort_data
6107: , p_start_pointer IN NUMBER
6108: , p_rec_wanted IN NUMBER

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

6101: p_date_type IN VARCHAR2 DEFAULT NULL
6102: , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
6103: , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
6104: , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
6105: , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
6106: , p_sort_data IN sort_data
6107: , p_start_pointer IN NUMBER
6108: , p_rec_wanted IN NUMBER
6109: , p_show_all IN VARCHAR2 DEFAULT 'Y'

Line 6385: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka

6381: , NVL(tka.show_on_calendar, NULL) show_on_calendar
6382: , NVL(tka.assignment_status_id, NULL) assignment_status_id
6383: , tka.free_busy_type free_busy_type
6384: , tk.entity
6385: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
6386: WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
6387:
6388: -- Fetch also assignment details for OWNER, if present, as this is
6389: -- created by the task_create API