1018: , p_attribute_category IN VARCHAR2
1019: , p_date_selected IN VARCHAR2
1020: , p_category_id IN NUMBER
1021: , p_show_on_calendar IN VARCHAR2
1022: , p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl
1023: , p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1019: , p_date_selected IN VARCHAR2
1020: , p_category_id IN NUMBER
1021: , p_show_on_calendar IN VARCHAR2
1022: , p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl
1023: , p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1020: , p_category_id IN NUMBER
1021: , p_show_on_calendar IN VARCHAR2
1022: , p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl
1023: , p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1028: , p_task_recur_rec IN jtf_tasks_pub.task_recur_rec
1021: , p_show_on_calendar IN VARCHAR2
1022: , p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl
1023: , p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1028: , p_task_recur_rec IN jtf_tasks_pub.task_recur_rec
1029: , p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl
1022: , p_task_assign_tbl IN jtf_tasks_pub.task_assign_tbl
1023: , p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1028: , p_task_recur_rec IN jtf_tasks_pub.task_recur_rec
1029: , p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl
1030: , p_template_id IN NUMBER
1023: , p_task_depends_tbl IN jtf_tasks_pub.task_depends_tbl
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1028: , p_task_recur_rec IN jtf_tasks_pub.task_recur_rec
1029: , p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl
1030: , p_template_id IN NUMBER
1031: , p_template_group_id IN NUMBER
1024: , p_task_rsrc_req_tbl IN jtf_tasks_pub.task_rsrc_req_tbl
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1028: , p_task_recur_rec IN jtf_tasks_pub.task_recur_rec
1029: , p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl
1030: , p_template_id IN NUMBER
1031: , p_template_group_id IN NUMBER
1032: , p_enable_workflow IN VARCHAR2
1025: , p_task_refer_tbl IN jtf_tasks_pub.task_refer_tbl
1026: , p_task_dates_tbl IN jtf_tasks_pub.task_dates_tbl
1027: , p_task_notes_tbl IN jtf_tasks_pub.task_notes_tbl
1028: , p_task_recur_rec IN jtf_tasks_pub.task_recur_rec
1029: , p_task_contacts_tbl IN jtf_tasks_pub.task_contacts_tbl
1030: , p_template_id IN NUMBER
1031: , p_template_group_id IN NUMBER
1032: , p_enable_workflow IN VARCHAR2
1033: , p_abort_workflow IN VARCHAR2
1074: fnd_msg_pub.ADD;
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: jtf_tasks_pub.create_task (
1079: p_api_version => p_api_version
1080: , p_init_msg_list => fnd_api.g_false
1081: , p_commit => fnd_api.g_false
1082: , x_return_status => x_return_status
1239: , p_object_version_number IN NUMBER
1240: , p_delete_future_recurrences IN VARCHAR2
1241: ) IS
1242: BEGIN
1243: jtf_tasks_pub.delete_task (
1244: p_api_version => p_api_version
1245: , p_init_msg_list => p_init_msg_list
1246: , p_commit => p_commit
1247: , x_return_status => x_return_status
1477: l_task_info.scheduled_end_date := NULL;
1478: END IF;
1479:
1480: -- Update the Task with the new Task Status Information
1481: jtf_tasks_pub.update_task (
1482: p_api_version => 1.0
1483: , x_return_status => x_return_status
1484: , x_msg_count => x_msg_count
1485: , x_msg_data => x_msg_data
1971: END IF;
1972:
1973:
1974:
1975: jtf_tasks_pub.update_task(
1976: p_api_version => p_api_version
1977: , p_init_msg_list => p_init_msg_list
1978: , p_commit => fnd_api.g_false
1979: , x_return_status => x_return_status
3300: IF l_new_parent_info.actual_effort IS NOT NULL THEN
3301: l_actual_effort_uom := csf_util_pvt.get_uom_minutes;
3302: END IF;
3303:
3304: jtf_tasks_pub.update_task (
3305: p_api_version => 1.0
3306: , p_init_msg_list => p_init_msg_list
3307: , p_commit => fnd_api.g_false
3308: , x_return_status => x_return_status
3412: IF ( (v_child_task.child_sequence_num <> v_child_task.correct_seq_num)
3413: OR (v_child_task.child_position <> l_child_position) )
3414: THEN
3415: -- Update the Child Task
3416: jtf_tasks_pub.update_task(
3417: p_api_version => 1.0
3418: , x_return_status => x_return_status
3419: , x_msg_count => x_msg_count
3420: , x_msg_data => x_msg_data
3621: END IF;
3622:
3623:
3624: -- Update the Task
3625: jtf_tasks_pub.update_task(
3626: p_api_version => 1.0
3627: , x_return_status => x_return_status
3628: , x_msg_count => x_msg_count
3629: , x_msg_data => x_msg_data
3804: l_task_info.scheduled_end_date := NULL;
3805: END IF;
3806:
3807: -- Update the Task Information.
3808: jtf_tasks_pub.update_task(
3809: p_api_version => 1.0
3810: , x_return_status => x_return_status
3811: , x_msg_count => x_msg_count
3812: , x_msg_data => x_msg_data
3935: END IF;
3936:
3937: -- Update the Task if any columns are changing
3938: IF p_scheduled_start_date IS NOT NULL OR p_scheduled_end_date IS NOT NULL THEN
3939: jtf_tasks_pub.update_task(
3940: p_api_version => 1.0
3941: , x_return_status => x_return_status
3942: , x_msg_count => x_msg_count
3943: , x_msg_data => x_msg_data
4087: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4088: RAISE fnd_api.g_exc_unexpected_error;
4089: END IF;
4090: ELSIF p_action = g_action_parent_to_normal THEN
4091: jtf_tasks_pub.update_task(
4092: p_api_version => 1.0
4093: , x_return_status => x_return_status
4094: , x_msg_count => x_msg_count
4095: , x_msg_data => x_msg_data
4249: CLOSE c_parent_task_info;
4250:
4251: -- Create the Child Task using Parent Task Information
4252: -- (Set Zero Length Planned Window at Scheduled Start, Bound Mode code in BTS)
4253: jtf_tasks_pub.create_task(
4254: p_api_version => 1.0
4255: , p_init_msg_list => fnd_api.g_false
4256: , p_commit => fnd_api.g_false
4257: , x_return_status => x_return_status
5035: , p_planned_effort in number
5036: , p_planned_effort_uom in varchar2
5037: , p_bound_mode_code in varchar2
5038: , p_soft_bound_flag in varchar2
5039: , p_task_assign_tbl jtf_tasks_pub.task_assign_tbl
5040: , p_type in varchar2
5041: , p_trip in number
5042: , x_return_status out nocopy varchar2
5043: , x_msg_count out nocopy number
5067: fnd_msg_pub.initialize;
5068: END IF;
5069:
5070:
5071: jtf_tasks_pub.create_task(
5072: p_api_version => p_api_version
5073: , p_init_msg_list => p_init_msg_list
5074: , p_commit => p_commit
5075: , p_task_name => p_task_name
5581: -- Initialize API return status to success
5582: x_return_status := fnd_api.g_ret_sts_success;
5583:
5584: -- Update the Task with the new Task Status Information
5585: jtf_tasks_pub.update_task (
5586: p_api_version => 1.0
5587: , x_return_status => x_return_status
5588: , x_msg_count => x_msg_count
5589: , x_msg_data => x_msg_data
5871: SAVEPOINT create_achrs_s;
5872:
5873:
5874:
5875: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
5876: l_tpl_id := jtf_tasks_pub.p_task_user_hooks.template_id;
5877: l_tpl_grp_id := jtf_tasks_pub.p_task_user_hooks.template_group_id;
5878: IF l_tpl_id IS NOT NULL
5879: THEN
5872:
5873:
5874:
5875: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
5876: l_tpl_id := jtf_tasks_pub.p_task_user_hooks.template_id;
5877: l_tpl_grp_id := jtf_tasks_pub.p_task_user_hooks.template_group_id;
5878: IF l_tpl_id IS NOT NULL
5879: THEN
5880: open c_task_type;
5873:
5874:
5875: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
5876: l_tpl_id := jtf_tasks_pub.p_task_user_hooks.template_id;
5877: l_tpl_grp_id := jtf_tasks_pub.p_task_user_hooks.template_group_id;
5878: IF l_tpl_id IS NOT NULL
5879: THEN
5880: open c_task_type;
5881: fetch c_task_type into l_task_type;