DBA Data[Home] [Help]

APPS.JTF_TASK_UTL_EXT dependencies on JTF_TASK_UTL

Line 1: PACKAGE BODY jtf_task_utl_ext AS

1: PACKAGE BODY jtf_task_utl_ext AS
2: /* $Header: jtfptkxb.pls 120.2 2005/12/21 07:04:41 sbarat ship $ */
3:
4: G_CD VARCHAR2(30) := 'CREATION_DATE';
5: G_SS VARCHAR2(30) := 'SCHEDULED_START';

Line 86: l_start_date := jtf_task_utl_ext.adjust_date(

82: END IF;
83:
84: IF NVL(p_actual_travel_duration, 0) > 0
85: THEN
86: l_start_date := jtf_task_utl_ext.adjust_date(
87: p_actual_start_date,
88: p_actual_travel_duration * (-1),
89: p_actual_travel_duration_uom);
90: END IF;

Line 129: l_end_date := jtf_task_utl_ext.adjust_date

125: ELSIF (p_calendar_start_date <= p_calendar_end_date)
126: THEN
127: l_end_date := p_calendar_end_date;
128: ELSE
129: l_end_date := jtf_task_utl_ext.adjust_date
130: (p_calendar_start_date,
131: p_planned_effort,
132: p_planned_effort_uom
133: );

Line 141: l_end_date := jtf_task_utl_ext.adjust_date

137: THEN
138: l_end_date := p_actual_end_date;
139: ELSIF p_actual_effort >= 0
140: THEN
141: l_end_date := jtf_task_utl_ext.adjust_date
142: (p_actual_start_date,
143: p_actual_effort,
144: p_actual_effort_uom
145: );

Line 147: l_end_date := jtf_task_utl_ext.adjust_date

143: p_actual_effort,
144: p_actual_effort_uom
145: );
146: ELSE
147: l_end_date := jtf_task_utl_ext.adjust_date
148: (p_actual_start_date,
149: p_planned_effort,
150: p_planned_effort_uom
151: );

Line 175: l_open_flag VARCHAR2(1) := jtf_task_utl.g_yes;

171: FROM jtf_task_statuses_b
172: WHERE task_status_id = p_task_status_id;
173:
174: rec_status c_status%ROWTYPE;
175: l_open_flag VARCHAR2(1) := jtf_task_utl.g_yes;
176: BEGIN
177: OPEN c_status;
178: FETCH c_status INTO rec_status;
179:

Line 190: IF rec_status.completed_flag = jtf_task_utl.g_yes OR

186: RAISE fnd_api.g_exc_unexpected_error;
187: END IF;
188: CLOSE c_status;
189:
190: IF rec_status.completed_flag = jtf_task_utl.g_yes OR
191: rec_status.cancelled_flag = jtf_task_utl.g_yes OR
192: rec_status.rejected_flag = jtf_task_utl.g_yes OR
193: rec_status.closed_flag = jtf_task_utl.g_yes
194: THEN

Line 191: rec_status.cancelled_flag = jtf_task_utl.g_yes OR

187: END IF;
188: CLOSE c_status;
189:
190: IF rec_status.completed_flag = jtf_task_utl.g_yes OR
191: rec_status.cancelled_flag = jtf_task_utl.g_yes OR
192: rec_status.rejected_flag = jtf_task_utl.g_yes OR
193: rec_status.closed_flag = jtf_task_utl.g_yes
194: THEN
195: l_open_flag := jtf_task_utl.g_no;

Line 192: rec_status.rejected_flag = jtf_task_utl.g_yes OR

188: CLOSE c_status;
189:
190: IF rec_status.completed_flag = jtf_task_utl.g_yes OR
191: rec_status.cancelled_flag = jtf_task_utl.g_yes OR
192: rec_status.rejected_flag = jtf_task_utl.g_yes OR
193: rec_status.closed_flag = jtf_task_utl.g_yes
194: THEN
195: l_open_flag := jtf_task_utl.g_no;
196: END IF;

Line 193: rec_status.closed_flag = jtf_task_utl.g_yes

189:
190: IF rec_status.completed_flag = jtf_task_utl.g_yes OR
191: rec_status.cancelled_flag = jtf_task_utl.g_yes OR
192: rec_status.rejected_flag = jtf_task_utl.g_yes OR
193: rec_status.closed_flag = jtf_task_utl.g_yes
194: THEN
195: l_open_flag := jtf_task_utl.g_no;
196: END IF;
197:

Line 195: l_open_flag := jtf_task_utl.g_no;

191: rec_status.cancelled_flag = jtf_task_utl.g_yes OR
192: rec_status.rejected_flag = jtf_task_utl.g_yes OR
193: rec_status.closed_flag = jtf_task_utl.g_yes
194: THEN
195: l_open_flag := jtf_task_utl.g_no;
196: END IF;
197:
198: RETURN l_open_flag;
199: END get_open_flag;

Line 205: -- Moved from jtf_task_utl

201:
202: ------------------------------------------------------
203: -- For enhancement 2683868
204:
205: -- Moved from jtf_task_utl
206: PROCEDURE set_calendar_dates (
207: p_show_on_calendar in varchar2,
208: p_date_selected in varchar2,
209: p_planned_start_date in date,

Line 633: fnd_message.set_token ('P_TASK_NAME', jtf_task_utl_ext.get_task_name(p_task_id));

629: IF (p_parent_task_id = cyclic_task_rec.task_id)
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name ('JTF', 'JTF_TASK_CYCLIC_TASKS');
633: fnd_message.set_token ('P_TASK_NAME', jtf_task_utl_ext.get_task_name(p_task_id));
634: fnd_message.set_token ('P_PARENT_TASK_NAME', jtf_task_utl_ext.get_task_name(p_parent_task_id));
635: fnd_msg_pub.add;
636: END IF;
637: END LOOP;

Line 634: fnd_message.set_token ('P_PARENT_TASK_NAME', jtf_task_utl_ext.get_task_name(p_parent_task_id));

630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name ('JTF', 'JTF_TASK_CYCLIC_TASKS');
633: fnd_message.set_token ('P_TASK_NAME', jtf_task_utl_ext.get_task_name(p_task_id));
634: fnd_message.set_token ('P_PARENT_TASK_NAME', jtf_task_utl_ext.get_task_name(p_parent_task_id));
635: fnd_msg_pub.add;
636: END IF;
637: END LOOP;
638:

Line 680: jtf_task_utl.delete_party_reference(

676: -----------------------------
677: IF p_old_object_code IN ('PARTY')
678: THEN
679: -- delete the old one
680: jtf_task_utl.delete_party_reference(
681: p_reference_from => 'TASK',
682: p_task_id => p_task_id,
683: p_party_id => p_old_object_id,
684: x_msg_count => x_msg_count,

Line 697: jtf_task_utl.g_show_error_for_dup_reference := FALSE;

693: OPEN c_ref (p_task_id, p_old_object_id);
694: FETCH c_ref INTO l_task_ref_id, l_obj_version_number;
695: CLOSE c_ref;
696:
697: jtf_task_utl.g_show_error_for_dup_reference := FALSE;
698:
699: jtf_task_references_pub.delete_references (
700: p_api_version => 1.0,
701: p_init_msg_list => fnd_api.g_false,

Line 729: jtf_task_utl.create_party_reference(

725: THEN
726: IF p_new_object_code IN ('PARTY')
727: THEN
728: -- create a new one
729: jtf_task_utl.create_party_reference(
730: p_reference_from => 'TASK',
731: p_task_id => p_task_id,
732: p_party_id => p_new_object_id,
733: x_msg_count => x_msg_count,

Line 743: jtf_task_utl.g_show_error_for_dup_reference := False;

739: THEN
740: RAISE fnd_api.g_exc_unexpected_error;
741: END IF;
742: ELSE -- other than party Relation, Person, Organization 2102281
743: jtf_task_utl.g_show_error_for_dup_reference := False;
744:
745: jtf_task_references_pvt.create_references (
746: p_api_version => 1.0,
747: p_init_msg_list => fnd_api.g_false,

Line 870: jtf_task_utl.check_duplicate_reference.

866: END get_task_name;
867:
868: /*
869: Function added for bug #3360228 - extended from
870: jtf_task_utl.check_duplicate_reference.
871: */
872: FUNCTION check_dup_reference_for_update (
873: p_task_reference_id jtf_task_references_b.task_reference_id%type,
874: p_task_id jtf_tasks_b.task_id%type,

Line 911: END jtf_task_utl_ext;

907: return x_return_value;
908:
909: end check_dup_reference_for_update;
910:
911: END jtf_task_utl_ext;