DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on FND_API

Line 317: p_updation_record.actual_end_date :=convert_gmt_to_task (p_exclusion.actualenddate, p_exclude_task_id); -- DATE DEFAULT fnd_api.g_miss_date,

313: p_updation_record.planned_start_date :=convert_gmt_to_task (p_exclusion.plannedstartdate, p_exclude_task_id);
314: p_updation_record.planned_end_date :=convert_gmt_to_task (p_exclusion.plannedenddate, p_exclude_task_id);
315: p_updation_record.scheduled_start_date:=convert_gmt_to_task (p_exclusion.scheduledstartdate, p_exclude_task_id);
316: p_updation_record.scheduled_end_date :=convert_gmt_to_task (p_exclusion.scheduledenddate, p_exclude_task_id);
317: p_updation_record.actual_end_date :=convert_gmt_to_task (p_exclusion.actualenddate, p_exclude_task_id); -- DATE DEFAULT fnd_api.g_miss_date,
318: p_updation_record.actual_start_date :=convert_gmt_to_task (p_exclusion.actualstartdate, p_exclude_task_id); -- DATE
319: p_updation_record.old_calendar_start_date:=convert_gmt_to_task (p_exclusion.exclusion_date,p_exclude_task_id); --.plannedstartdate;
320: p_updation_record.new_calendar_start_date:=convert_gmt_to_task (p_exclusion.plannedstartdate,p_exclude_task_id);
321: p_updation_record.new_calendar_end_date:=convert_gmt_to_task (p_exclusion.plannedenddate,p_exclude_task_id);

Line 331: p_updation_record.actual_end_date :=convert_gmt_to_server (p_exclusion.actualenddate); -- DATE DEFAULT fnd_api.g_miss_date,

327: p_updation_record.planned_start_date :=convert_gmt_to_server (p_exclusion.plannedstartdate);
328: p_updation_record.planned_end_date :=convert_gmt_to_server (p_exclusion.plannedenddate);
329: p_updation_record.scheduled_start_date:=convert_gmt_to_server (p_exclusion.scheduledstartdate);
330: p_updation_record.scheduled_end_date :=convert_gmt_to_server (p_exclusion.scheduledenddate);
331: p_updation_record.actual_end_date :=convert_gmt_to_server (p_exclusion.actualenddate); -- DATE DEFAULT fnd_api.g_miss_date,
332: p_updation_record.actual_start_date :=convert_gmt_to_server (p_exclusion.actualstartdate); -- DATE
333: p_updation_record.old_calendar_start_date:=convert_gmt_to_server (p_exclusion.exclusion_date); --.plannedstartdate;
334: p_updation_record.new_calendar_start_date:=convert_gmt_to_server (p_exclusion.plannedstartdate);
335: p_updation_record.new_calendar_end_date:=convert_gmt_to_server (p_exclusion.plannedenddate);

Line 341: p_updation_record.private_flag :=p_exclusion.privateflag ; -- jtf_tasks_b.private_flag%TYPE DEFAULT fnd_api.g_miss_char,

337: end if;
338:
339: p_updation_record.timezone_id :=get_task_timezone_id(p_task_id=>p_exclude_task_id);
340:
341: p_updation_record.private_flag :=p_exclusion.privateflag ; -- jtf_tasks_b.private_flag%TYPE DEFAULT fnd_api.g_miss_char,
342: p_updation_record.alarm_on:=p_exclusion.alarmflag; -- NUMBER DEFAULT fnd_api.g_miss_num,
343: p_updation_record.change_mode:=jtf_task_repeat_appt_pvt.G_ONE;
344: p_updation_record.recurrence_rule_id:=p_rec_rule_id;
345: p_updation_record.free_busy_type :=p_exclusion.free_busy_type;

Line 342: p_updation_record.alarm_on:=p_exclusion.alarmflag; -- NUMBER DEFAULT fnd_api.g_miss_num,

338:
339: p_updation_record.timezone_id :=get_task_timezone_id(p_task_id=>p_exclude_task_id);
340:
341: p_updation_record.private_flag :=p_exclusion.privateflag ; -- jtf_tasks_b.private_flag%TYPE DEFAULT fnd_api.g_miss_char,
342: p_updation_record.alarm_on:=p_exclusion.alarmflag; -- NUMBER DEFAULT fnd_api.g_miss_num,
343: p_updation_record.change_mode:=jtf_task_repeat_appt_pvt.G_ONE;
344: p_updation_record.recurrence_rule_id:=p_rec_rule_id;
345: p_updation_record.free_busy_type :=p_exclusion.free_busy_type;
346: p_updation_record.alarm_start :=l_alarm_mins;

Line 352: p_init_msg_list =>fnd_api.g_false,

348: l_ovn:=get_ovn(p_task_id=>p_exclude_task_id);
349:
350: jtf_task_repeat_appt_pvt.update_repeat_appointment(
351: p_api_version =>1.0,
352: p_init_msg_list =>fnd_api.g_false,
353: p_commit =>fnd_api.g_false,
354: p_object_version_number =>l_ovn,
355: p_updated_field_rec =>p_updation_record ,
356: x_return_status =>l_return_status,

Line 353: p_commit =>fnd_api.g_false,

349:
350: jtf_task_repeat_appt_pvt.update_repeat_appointment(
351: p_api_version =>1.0,
352: p_init_msg_list =>fnd_api.g_false,
353: p_commit =>fnd_api.g_false,
354: p_object_version_number =>l_ovn,
355: p_updated_field_rec =>p_updation_record ,
356: x_return_status =>l_return_status,
357: x_msg_count =>l_msg_count,

Line 3397: p_init_msg_list => fnd_api.g_true,

3393: ELSIF (l_source_object_type_code = G_TASK) THEN
3394:
3395: jtf_tasks_pvt.create_task (
3396: p_api_version => 1.0,
3397: p_init_msg_list => fnd_api.g_true,
3398: p_commit => fnd_api.g_false,
3399: p_source_object_type_code => p_task_rec.objectcode,
3400: p_task_name => l_subject,
3401: p_task_type_id => get_default_task_type,

Line 3398: p_commit => fnd_api.g_false,

3394:
3395: jtf_tasks_pvt.create_task (
3396: p_api_version => 1.0,
3397: p_init_msg_list => fnd_api.g_true,
3398: p_commit => fnd_api.g_false,
3399: p_source_object_type_code => p_task_rec.objectcode,
3400: p_task_name => l_subject,
3401: p_task_type_id => get_default_task_type,
3402: p_description => p_task_rec.description,

Line 3572: AND p_task_rec.unit_of_measure <> fnd_api.g_miss_char

3568: -- Check whether it has a repeating information
3569: -- If it has, then create a recurrence
3570: --------------------------------------------
3571: IF ( l_source_object_type_code <> G_TASK -- = G_APPOINTMENT
3572: AND p_task_rec.unit_of_measure <> fnd_api.g_miss_char
3573: AND p_task_rec.unit_of_measure IS NOT NULL)
3574: -- include open end dates also
3575: -- AND p_task_rec.end_date IS NOT NULL)
3576: THEN

Line 3631: p_commit => fnd_api.g_false,

3627:
3628:
3629: jtf_task_recurrences_pvt.create_task_recurrence (
3630: p_api_version => 1,
3631: p_commit => fnd_api.g_false,
3632: p_task_id => l_task_id,
3633: p_occurs_which => l_occurs_which,
3634: p_template_flag => 'N',
3635: p_date_of_month => l_date_of_month,

Line 4098: l_free_busy_type VARCHAR2(25) := FND_API.G_MISS_CHAR;

4094:
4095: repeat_to_nonrepeat BOOLEAN;
4096: nonrepeat_to_repeat BOOLEAN;
4097: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%type:=substrb(p_task_rec.locations,1,100);
4098: l_free_busy_type VARCHAR2(25) := FND_API.G_MISS_CHAR;
4099:
4100: BEGIN
4101: fnd_msg_pub.initialize;
4102:

Line 4186: p_task_rec.unit_of_measure <> fnd_api.g_miss_char

4182: --process exclusions
4183: IF NVL(p_task_rec.resultId,0) < 2 AND
4184: l_rec_rule_id IS NOT NULL AND
4185: p_task_rec.unit_of_measure IS NOT NULL AND
4186: p_task_rec.unit_of_measure <> fnd_api.g_miss_char
4187: THEN
4188: IF l_update_type = g_update_all
4189: THEN
4190: IF p_exclusion_tbl.COUNT > 0

Line 4496: p_init_msg_list => fnd_api.g_true,

4492: THEN
4493:
4494: jtf_tasks_pvt.update_task (
4495: p_api_version => 1.0,
4496: p_init_msg_list => fnd_api.g_true,
4497: p_commit => fnd_api.g_false,
4498: p_task_id => l_task_id,
4499: p_object_version_number => l_ovn,
4500: p_task_name => NVL (l_task_name, ' '),

Line 4497: p_commit => fnd_api.g_false,

4493:
4494: jtf_tasks_pvt.update_task (
4495: p_api_version => 1.0,
4496: p_init_msg_list => fnd_api.g_true,
4497: p_commit => fnd_api.g_false,
4498: p_task_id => l_task_id,
4499: p_object_version_number => l_ovn,
4500: p_task_name => NVL (l_task_name, ' '),
4501: p_description => p_task_rec.description,

Line 4510: p_show_on_calendar => fnd_api.g_miss_char, -- Fix Bug 2467021: For update, pass g_miss_char

4506: p_scheduled_start_date => l_scheduled_start_date,
4507: p_scheduled_end_date => l_scheduled_end_date,
4508: -- p_actual_start_date => l_actual_start_date,
4509: -- p_actual_end_date => l_actual_end_date,
4510: p_show_on_calendar => fnd_api.g_miss_char, -- Fix Bug 2467021: For update, pass g_miss_char
4511: p_date_selected => fnd_api.g_miss_char, -- Fix Bug 2467021: For update, pass g_miss_char
4512: p_alarm_start => l_alarm_mins,
4513: p_alarm_start_uom => 'MIN',
4514: p_timezone_id => get_task_timezone_id (l_task_id),

Line 4511: p_date_selected => fnd_api.g_miss_char, -- Fix Bug 2467021: For update, pass g_miss_char

4507: p_scheduled_end_date => l_scheduled_end_date,
4508: -- p_actual_start_date => l_actual_start_date,
4509: -- p_actual_end_date => l_actual_end_date,
4510: p_show_on_calendar => fnd_api.g_miss_char, -- Fix Bug 2467021: For update, pass g_miss_char
4511: p_date_selected => fnd_api.g_miss_char, -- Fix Bug 2467021: For update, pass g_miss_char
4512: p_alarm_start => l_alarm_mins,
4513: p_alarm_start_uom => 'MIN',
4514: p_timezone_id => get_task_timezone_id (l_task_id),
4515: p_private_flag => p_task_rec.privateflag,

Line 4654: p_init_msg_list => fnd_api.g_true,

4650:
4651: jtf_task_assignments_pvt.update_task_assignment (
4652: p_api_version => 1.0,
4653: p_object_version_number => l_ovn,
4654: p_init_msg_list => fnd_api.g_true,
4655: p_commit => fnd_api.g_false,
4656: p_task_assignment_id => l_task_assignment_id,
4657: p_assignment_status_id => 3, -- ACCEPT
4658: p_free_busy_type => l_free_busy_type,

Line 4655: p_commit => fnd_api.g_false,

4651: jtf_task_assignments_pvt.update_task_assignment (
4652: p_api_version => 1.0,
4653: p_object_version_number => l_ovn,
4654: p_init_msg_list => fnd_api.g_true,
4655: p_commit => fnd_api.g_false,
4656: p_task_assignment_id => l_task_assignment_id,
4657: p_assignment_status_id => 3, -- ACCEPT
4658: p_free_busy_type => l_free_busy_type,
4659: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),

Line 4715: p_init_msg_list => fnd_api.g_true,

4711:
4712: jtf_task_assignments_pvt.update_task_assignment (
4713: p_api_version => 1.0,
4714: p_object_version_number => l_ovn,
4715: p_init_msg_list => fnd_api.g_true,
4716: p_commit => fnd_api.g_false,
4717: p_task_assignment_id => l_task_assignment_id,
4718: p_free_busy_type => p_task_rec.free_busy_type,
4719: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),

Line 4716: p_commit => fnd_api.g_false,

4712: jtf_task_assignments_pvt.update_task_assignment (
4713: p_api_version => 1.0,
4714: p_object_version_number => l_ovn,
4715: p_init_msg_list => fnd_api.g_true,
4716: p_commit => fnd_api.g_false,
4717: p_task_assignment_id => l_task_assignment_id,
4718: p_free_busy_type => p_task_rec.free_busy_type,
4719: p_enable_workflow => fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
4720: p_abort_workflow => fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),

Line 4761: l_return_status := fnd_api.g_ret_sts_success;

4757: l_msg_data VARCHAR2(2000);
4758: l_msg_count NUMBER;
4759: BEGIN
4760:
4761: l_return_status := fnd_api.g_ret_sts_success;
4762:
4763: l_ovn := get_ovn (p_task_id => p_repeating_task_id);
4764:
4765: IF x_task_rec.objectcode = G_APPOINTMENT

Line 4770: p_delete_future_recurrences => fnd_api.g_false,

4766: THEN
4767: jta_cal_appointment_pvt.delete_appointment (
4768: p_object_version_number => l_ovn,
4769: p_task_id => p_repeating_task_id,
4770: p_delete_future_recurrences => fnd_api.g_false,
4771: x_return_status => l_return_status
4772: );
4773: ELSE
4774: jtf_tasks_pvt.delete_task (

Line 4776: p_init_msg_list => fnd_api.g_true,

4772: );
4773: ELSE
4774: jtf_tasks_pvt.delete_task (
4775: p_api_version => 1.0,
4776: p_init_msg_list => fnd_api.g_true,
4777: p_commit => fnd_api.g_false,
4778: p_task_id => p_repeating_task_id,
4779: p_object_version_number => l_ovn,
4780: x_return_status => l_return_status,

Line 4777: p_commit => fnd_api.g_false,

4773: ELSE
4774: jtf_tasks_pvt.delete_task (
4775: p_api_version => 1.0,
4776: p_init_msg_list => fnd_api.g_true,
4777: p_commit => fnd_api.g_false,
4778: p_task_id => p_repeating_task_id,
4779: p_object_version_number => l_ovn,
4780: x_return_status => l_return_status,
4781: p_delete_future_recurrences => fnd_api.g_false ,

Line 4781: p_delete_future_recurrences => fnd_api.g_false ,

4777: p_commit => fnd_api.g_false,
4778: p_task_id => p_repeating_task_id,
4779: p_object_version_number => l_ovn,
4780: x_return_status => l_return_status,
4781: p_delete_future_recurrences => fnd_api.g_false ,
4782: x_msg_count => l_msg_count,
4783: x_msg_data => l_msg_data
4784: );
4785: END IF;

Line 4816: l_return_status := fnd_api.g_ret_sts_success;

4812: l_return_status VARCHAR2(1);
4813: l_msg_data VARCHAR2(2000);
4814: l_msg_count NUMBER;
4815: BEGIN
4816: l_return_status := fnd_api.g_ret_sts_success;
4817:
4818: l_task_id := get_task_id (p_sync_id => p_task_rec.syncid);
4819:
4820: delete_tasks(p_task_id => l_task_id,

Line 4898: p_init_msg_list => fnd_api.g_true,

4894:
4895: jtf_task_assignments_pvt.update_task_assignment (
4896: p_api_version => 1.0,
4897: p_object_version_number => l_ovn,
4898: p_init_msg_list => fnd_api.g_true,
4899: p_commit => fnd_api.g_false,
4900: p_task_assignment_id => l_task_assignment_id,
4901: p_assignment_status_id => 4, -- reject
4902: x_return_status => l_return_status,

Line 4899: p_commit => fnd_api.g_false,

4895: jtf_task_assignments_pvt.update_task_assignment (
4896: p_api_version => 1.0,
4897: p_object_version_number => l_ovn,
4898: p_init_msg_list => fnd_api.g_true,
4899: p_commit => fnd_api.g_false,
4900: p_task_assignment_id => l_task_assignment_id,
4901: p_assignment_status_id => 4, -- reject
4902: x_return_status => l_return_status,
4903: x_msg_count => l_msg_count,

Line 5110: RETURN fnd_api.g_miss_num;

5106: RETURN p_task_status_id;
5107: ELSE
5108: IF (checkuserstatusrule ())
5109: THEN
5110: RETURN fnd_api.g_miss_num;
5111: ELSE
5112: RETURN p_task_status_id;
5113: END IF;
5114: END IF;

Line 5267: l_return_status := fnd_api.g_ret_sts_success;

5263: l_user_id NUMBER;
5264:
5265:
5266: BEGIN
5267: l_return_status := fnd_api.g_ret_sts_success;
5268:
5269: OPEN getUserId(p_principal_id);
5270:
5271: FETCH getUserId INTO l_getUserId ;

Line 5481: p_init_msg_list => fnd_api.g_false,

5477: l_recurrence_rule_id :=get_recurrence_rule_id(p_task_id);
5478:
5479: jtf_tasks_pvt.delete_task (
5480: p_api_version => 1.0,
5481: p_init_msg_list => fnd_api.g_false,
5482: p_commit => fnd_api.g_false,
5483: p_task_id => p_task_id,
5484: p_object_version_number => l_ovn,
5485: p_delete_future_recurrences => 'A',

Line 5482: p_commit => fnd_api.g_false,

5478:
5479: jtf_tasks_pvt.delete_task (
5480: p_api_version => 1.0,
5481: p_init_msg_list => fnd_api.g_false,
5482: p_commit => fnd_api.g_false,
5483: p_task_id => p_task_id,
5484: p_object_version_number => l_ovn,
5485: p_delete_future_recurrences => 'A',
5486: x_return_status => x_return_status,

Line 5505: p_init_msg_list => fnd_api.g_false,

5501: l_ovn := get_ovn (p_task_id =>l_tsk_ids.task_id);
5502:
5503: jtf_tasks_pvt.delete_task (
5504: p_api_version => 1.0,
5505: p_init_msg_list => fnd_api.g_false,
5506: p_commit => fnd_api.g_false,
5507: p_task_id => l_tsk_ids.task_id,
5508: p_object_version_number => l_ovn,
5509: p_delete_future_recurrences => jtf_task_repeat_appt_pvt.G_ONE,

Line 5506: p_commit => fnd_api.g_false,

5502:
5503: jtf_tasks_pvt.delete_task (
5504: p_api_version => 1.0,
5505: p_init_msg_list => fnd_api.g_false,
5506: p_commit => fnd_api.g_false,
5507: p_task_id => l_tsk_ids.task_id,
5508: p_object_version_number => l_ovn,
5509: p_delete_future_recurrences => jtf_task_repeat_appt_pvt.G_ONE,
5510: x_return_status => x_return_status,