DBA Data[Home] [Help]

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on JTF_TASK_UTL

Line 76: x_booking_start_date := jtf_task_utl_ext.adjust_date

72: THEN
73: RETURN;
74: END IF;
75:
76: x_booking_start_date := jtf_task_utl_ext.adjust_date
77: (
78: p_calendar_start_date,
79: p_actual_travel_duration * (-1),
80: p_actual_travel_duration_uom

Line 88: x_booking_end_date := jtf_task_utl_ext.adjust_date

84: IF (p_calendar_start_date <= p_calendar_end_date)
85: THEN
86: x_booking_end_date := p_calendar_end_date;
87: ELSE
88: x_booking_end_date := jtf_task_utl_ext.adjust_date
89: (
90: p_calendar_start_date,
91: p_planned_effort,
92: p_planned_effort_uom

Line 145: x_booking_start_date := jtf_task_utl_ext.adjust_date

141: );
142: RETURN;
143: END IF;
144:
145: x_booking_start_date := jtf_task_utl_ext.adjust_date
146: (
147: p_actual_start_date,
148: p_actual_travel_duration * (-1),
149: p_actual_travel_duration_uom

Line 158: x_booking_end_date := jtf_task_utl_ext.adjust_date

154: THEN
155: x_booking_end_date := p_actual_end_date;
156: ELSIF p_actual_effort >= 0
157: THEN
158: x_booking_end_date := jtf_task_utl_ext.adjust_date
159: (
160: p_actual_start_date,
161: p_actual_effort,
162: p_actual_effort_uom

Line 165: x_booking_end_date := jtf_task_utl_ext.adjust_date

161: p_actual_effort,
162: p_actual_effort_uom
163: );
164: ELSE
165: x_booking_end_date := jtf_task_utl_ext.adjust_date
166: (
167: p_actual_start_date,
168: p_planned_effort,
169: p_planned_effort_uom

Line 249: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,

245: p_attribute14 IN VARCHAR2 DEFAULT NULL,
246: p_attribute15 IN VARCHAR2 DEFAULT NULL,
247: p_attribute_category IN VARCHAR2 DEFAULT NULL,
248: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
249: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
250: p_category_id IN NUMBER DEFAULT NULL,
251: p_enable_workflow IN VARCHAR2,
252: p_abort_workflow IN VARCHAR2,
253: p_add_option IN VARCHAR2,

Line 428: IF p_task_assignment_id > jtf_task_utl_ext.get_last_number('JTF_TASK_ASSIGNMENTS_S') and -- Enh# 2734020

424: ------------------------------------------
425:
426: IF p_task_assignment_id IS NOT NULL
427: THEN
428: IF p_task_assignment_id > jtf_task_utl_ext.get_last_number('JTF_TASK_ASSIGNMENTS_S') and -- Enh# 2734020
429: p_task_assignment_id < 1e+12
430: THEN
431: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
432: fnd_msg_pub.add;

Line 452: IF NOT jtf_task_utl.validate_lookup(

448: l_category_id := NULL;
449: END IF;
450:
451: -- Validate the value in ASSIGNEE_ROLE
452: IF NOT jtf_task_utl.validate_lookup(
453: 'JTF_TASK_ASSIGNEE_ROLES',
454: NVL (l_assignee_role, 'ASSIGNEE'),
455: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )')
456: THEN

Line 561: x_created_by => jtf_task_utl.created_by,

557: x_sched_travel_distance => l_sched_travel_distance,
558: x_sched_travel_duration => l_sched_travel_duration,
559: x_resource_type_code => l_resource_type_code,
560: x_creation_date => SYSDATE,
561: x_created_by => jtf_task_utl.created_by,
562: x_last_update_date => SYSDATE,
563: x_last_updated_by => jtf_task_utl.updated_by,
564: x_last_update_login => jtf_task_utl.login_id,
565: x_resource_territory_id => l_resource_territory_id,

Line 563: x_last_updated_by => jtf_task_utl.updated_by,

559: x_resource_type_code => l_resource_type_code,
560: x_creation_date => SYSDATE,
561: x_created_by => jtf_task_utl.created_by,
562: x_last_update_date => SYSDATE,
563: x_last_updated_by => jtf_task_utl.updated_by,
564: x_last_update_login => jtf_task_utl.login_id,
565: x_resource_territory_id => l_resource_territory_id,
566: x_assignment_status_id => l_assignment_status_id,
567: x_shift_construct_id => l_shift_construct_id,

Line 564: x_last_update_login => jtf_task_utl.login_id,

560: x_creation_date => SYSDATE,
561: x_created_by => jtf_task_utl.created_by,
562: x_last_update_date => SYSDATE,
563: x_last_updated_by => jtf_task_utl.updated_by,
564: x_last_update_login => jtf_task_utl.login_id,
565: x_resource_territory_id => l_resource_territory_id,
566: x_assignment_status_id => l_assignment_status_id,
567: x_shift_construct_id => l_shift_construct_id,
568: x_assignee_role => l_assignee_role,

Line 636: jtf_task_utl.create_party_reference (

632: -- ------------------------------------------------------------------------
633: IF (rec_task.source_object_type_code <> 'APPOINTMENT') THEN
634: --Do not create automatic references for party assignment created for an APPOINTMENT
635: --Check bug 3968128
636: jtf_task_utl.create_party_reference (
637: p_reference_from => 'ASSIGNMENT',
638: p_task_id => l_task_id,
639: p_party_type_code => l_resource_type_code,
640: p_party_id => l_resource_id,

Line 727: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,

723: p_attribute14 IN VARCHAR2 DEFAULT NULL,
724: p_attribute15 IN VARCHAR2 DEFAULT NULL,
725: p_attribute_category IN VARCHAR2 DEFAULT NULL,
726: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
727: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
728: p_category_id IN NUMBER DEFAULT NULL,
729: p_enable_workflow IN VARCHAR2,
730: p_abort_workflow IN VARCHAR2,
731: p_add_option IN VARCHAR2,

Line 849: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,

845: p_attribute14 IN VARCHAR2 DEFAULT NULL,
846: p_attribute15 IN VARCHAR2 DEFAULT NULL,
847: p_attribute_category IN VARCHAR2 DEFAULT NULL,
848: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
849: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
850: p_category_id IN NUMBER DEFAULT NULL,
851: p_enable_workflow IN VARCHAR2,
852: p_abort_workflow IN VARCHAR2,
853: p_add_option IN VARCHAR2

Line 970: DEFAULT jtf_task_utl.g_yes_char,

966: p_attribute15 IN VARCHAR2 DEFAULT NULL,
967: p_attribute_category IN VARCHAR2 DEFAULT NULL,
968: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
969: p_show_on_calendar IN VARCHAR2
970: DEFAULT jtf_task_utl.g_yes_char,
971: p_category_id IN NUMBER DEFAULT NULL,
972: p_enable_workflow IN VARCHAR2,
973: p_abort_workflow IN VARCHAR2
974: )

Line 1089: DEFAULT jtf_task_utl.g_yes_char,

1085: p_attribute15 IN VARCHAR2 DEFAULT NULL,
1086: p_attribute_category IN VARCHAR2 DEFAULT NULL,
1087: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
1088: p_show_on_calendar IN VARCHAR2
1089: DEFAULT jtf_task_utl.g_yes_char,
1090: p_category_id IN NUMBER DEFAULT NULL
1091: )
1092: IS
1093: BEGIN

Line 1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1184: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1185: x_return_status OUT NOCOPY VARCHAR2,
1186: x_msg_count OUT NOCOPY NUMBER,
1187: x_msg_data OUT NOCOPY VARCHAR2,
1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1185: x_return_status OUT NOCOPY VARCHAR2,
1186: x_msg_count OUT NOCOPY NUMBER,
1187: x_msg_data OUT NOCOPY VARCHAR2,
1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1186: x_msg_count OUT NOCOPY NUMBER,
1187: x_msg_data OUT NOCOPY VARCHAR2,
1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1187: x_msg_data OUT NOCOPY VARCHAR2,
1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1188: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1189: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1190: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1191: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1192: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1193: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1194: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1195: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1196: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1197: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1198: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1206: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,

Line 1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1199: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1206: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1207: p_enable_workflow IN VARCHAR2,

Line 1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1200: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1206: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1207: p_enable_workflow IN VARCHAR2,
1208: p_abort_workflow IN VARCHAR2,

Line 1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1201: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1206: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1207: p_enable_workflow IN VARCHAR2,
1208: p_abort_workflow IN VARCHAR2,
1209: p_free_busy_type IN VARCHAR2

Line 1206: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,

1202: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1203: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1204: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1205: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1206: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1207: p_enable_workflow IN VARCHAR2,
1208: p_abort_workflow IN VARCHAR2,
1209: p_free_busy_type IN VARCHAR2
1210: )

Line 1330: DEFAULT jtf_task_utl.g_miss_char,

1326: x_return_status OUT NOCOPY VARCHAR2,
1327: x_msg_count OUT NOCOPY NUMBER,
1328: x_msg_data OUT NOCOPY VARCHAR2,
1329: p_attribute1 IN VARCHAR2
1330: DEFAULT jtf_task_utl.g_miss_char,
1331: p_attribute2 IN VARCHAR2
1332: DEFAULT jtf_task_utl.g_miss_char,
1333: p_attribute3 IN VARCHAR2
1334: DEFAULT jtf_task_utl.g_miss_char,

Line 1332: DEFAULT jtf_task_utl.g_miss_char,

1328: x_msg_data OUT NOCOPY VARCHAR2,
1329: p_attribute1 IN VARCHAR2
1330: DEFAULT jtf_task_utl.g_miss_char,
1331: p_attribute2 IN VARCHAR2
1332: DEFAULT jtf_task_utl.g_miss_char,
1333: p_attribute3 IN VARCHAR2
1334: DEFAULT jtf_task_utl.g_miss_char,
1335: p_attribute4 IN VARCHAR2
1336: DEFAULT jtf_task_utl.g_miss_char,

Line 1334: DEFAULT jtf_task_utl.g_miss_char,

1330: DEFAULT jtf_task_utl.g_miss_char,
1331: p_attribute2 IN VARCHAR2
1332: DEFAULT jtf_task_utl.g_miss_char,
1333: p_attribute3 IN VARCHAR2
1334: DEFAULT jtf_task_utl.g_miss_char,
1335: p_attribute4 IN VARCHAR2
1336: DEFAULT jtf_task_utl.g_miss_char,
1337: p_attribute5 IN VARCHAR2
1338: DEFAULT jtf_task_utl.g_miss_char,

Line 1336: DEFAULT jtf_task_utl.g_miss_char,

1332: DEFAULT jtf_task_utl.g_miss_char,
1333: p_attribute3 IN VARCHAR2
1334: DEFAULT jtf_task_utl.g_miss_char,
1335: p_attribute4 IN VARCHAR2
1336: DEFAULT jtf_task_utl.g_miss_char,
1337: p_attribute5 IN VARCHAR2
1338: DEFAULT jtf_task_utl.g_miss_char,
1339: p_attribute6 IN VARCHAR2
1340: DEFAULT jtf_task_utl.g_miss_char,

Line 1338: DEFAULT jtf_task_utl.g_miss_char,

1334: DEFAULT jtf_task_utl.g_miss_char,
1335: p_attribute4 IN VARCHAR2
1336: DEFAULT jtf_task_utl.g_miss_char,
1337: p_attribute5 IN VARCHAR2
1338: DEFAULT jtf_task_utl.g_miss_char,
1339: p_attribute6 IN VARCHAR2
1340: DEFAULT jtf_task_utl.g_miss_char,
1341: p_attribute7 IN VARCHAR2
1342: DEFAULT jtf_task_utl.g_miss_char,

Line 1340: DEFAULT jtf_task_utl.g_miss_char,

1336: DEFAULT jtf_task_utl.g_miss_char,
1337: p_attribute5 IN VARCHAR2
1338: DEFAULT jtf_task_utl.g_miss_char,
1339: p_attribute6 IN VARCHAR2
1340: DEFAULT jtf_task_utl.g_miss_char,
1341: p_attribute7 IN VARCHAR2
1342: DEFAULT jtf_task_utl.g_miss_char,
1343: p_attribute8 IN VARCHAR2
1344: DEFAULT jtf_task_utl.g_miss_char,

Line 1342: DEFAULT jtf_task_utl.g_miss_char,

1338: DEFAULT jtf_task_utl.g_miss_char,
1339: p_attribute6 IN VARCHAR2
1340: DEFAULT jtf_task_utl.g_miss_char,
1341: p_attribute7 IN VARCHAR2
1342: DEFAULT jtf_task_utl.g_miss_char,
1343: p_attribute8 IN VARCHAR2
1344: DEFAULT jtf_task_utl.g_miss_char,
1345: p_attribute9 IN VARCHAR2
1346: DEFAULT jtf_task_utl.g_miss_char,

Line 1344: DEFAULT jtf_task_utl.g_miss_char,

1340: DEFAULT jtf_task_utl.g_miss_char,
1341: p_attribute7 IN VARCHAR2
1342: DEFAULT jtf_task_utl.g_miss_char,
1343: p_attribute8 IN VARCHAR2
1344: DEFAULT jtf_task_utl.g_miss_char,
1345: p_attribute9 IN VARCHAR2
1346: DEFAULT jtf_task_utl.g_miss_char,
1347: p_attribute10 IN VARCHAR2
1348: DEFAULT jtf_task_utl.g_miss_char,

Line 1346: DEFAULT jtf_task_utl.g_miss_char,

1342: DEFAULT jtf_task_utl.g_miss_char,
1343: p_attribute8 IN VARCHAR2
1344: DEFAULT jtf_task_utl.g_miss_char,
1345: p_attribute9 IN VARCHAR2
1346: DEFAULT jtf_task_utl.g_miss_char,
1347: p_attribute10 IN VARCHAR2
1348: DEFAULT jtf_task_utl.g_miss_char,
1349: p_attribute11 IN VARCHAR2
1350: DEFAULT jtf_task_utl.g_miss_char,

Line 1348: DEFAULT jtf_task_utl.g_miss_char,

1344: DEFAULT jtf_task_utl.g_miss_char,
1345: p_attribute9 IN VARCHAR2
1346: DEFAULT jtf_task_utl.g_miss_char,
1347: p_attribute10 IN VARCHAR2
1348: DEFAULT jtf_task_utl.g_miss_char,
1349: p_attribute11 IN VARCHAR2
1350: DEFAULT jtf_task_utl.g_miss_char,
1351: p_attribute12 IN VARCHAR2
1352: DEFAULT jtf_task_utl.g_miss_char,

Line 1350: DEFAULT jtf_task_utl.g_miss_char,

1346: DEFAULT jtf_task_utl.g_miss_char,
1347: p_attribute10 IN VARCHAR2
1348: DEFAULT jtf_task_utl.g_miss_char,
1349: p_attribute11 IN VARCHAR2
1350: DEFAULT jtf_task_utl.g_miss_char,
1351: p_attribute12 IN VARCHAR2
1352: DEFAULT jtf_task_utl.g_miss_char,
1353: p_attribute13 IN VARCHAR2
1354: DEFAULT jtf_task_utl.g_miss_char,

Line 1352: DEFAULT jtf_task_utl.g_miss_char,

1348: DEFAULT jtf_task_utl.g_miss_char,
1349: p_attribute11 IN VARCHAR2
1350: DEFAULT jtf_task_utl.g_miss_char,
1351: p_attribute12 IN VARCHAR2
1352: DEFAULT jtf_task_utl.g_miss_char,
1353: p_attribute13 IN VARCHAR2
1354: DEFAULT jtf_task_utl.g_miss_char,
1355: p_attribute14 IN VARCHAR2
1356: DEFAULT jtf_task_utl.g_miss_char,

Line 1354: DEFAULT jtf_task_utl.g_miss_char,

1350: DEFAULT jtf_task_utl.g_miss_char,
1351: p_attribute12 IN VARCHAR2
1352: DEFAULT jtf_task_utl.g_miss_char,
1353: p_attribute13 IN VARCHAR2
1354: DEFAULT jtf_task_utl.g_miss_char,
1355: p_attribute14 IN VARCHAR2
1356: DEFAULT jtf_task_utl.g_miss_char,
1357: p_attribute15 IN VARCHAR2
1358: DEFAULT jtf_task_utl.g_miss_char,

Line 1356: DEFAULT jtf_task_utl.g_miss_char,

1352: DEFAULT jtf_task_utl.g_miss_char,
1353: p_attribute13 IN VARCHAR2
1354: DEFAULT jtf_task_utl.g_miss_char,
1355: p_attribute14 IN VARCHAR2
1356: DEFAULT jtf_task_utl.g_miss_char,
1357: p_attribute15 IN VARCHAR2
1358: DEFAULT jtf_task_utl.g_miss_char,
1359: p_attribute_category IN VARCHAR2
1360: DEFAULT jtf_task_utl.g_miss_char,

Line 1358: DEFAULT jtf_task_utl.g_miss_char,

1354: DEFAULT jtf_task_utl.g_miss_char,
1355: p_attribute14 IN VARCHAR2
1356: DEFAULT jtf_task_utl.g_miss_char,
1357: p_attribute15 IN VARCHAR2
1358: DEFAULT jtf_task_utl.g_miss_char,
1359: p_attribute_category IN VARCHAR2
1360: DEFAULT jtf_task_utl.g_miss_char,
1361: p_assignee_role IN VARCHAR2
1362: DEFAULT jtf_task_utl.g_miss_char,

Line 1360: DEFAULT jtf_task_utl.g_miss_char,

1356: DEFAULT jtf_task_utl.g_miss_char,
1357: p_attribute15 IN VARCHAR2
1358: DEFAULT jtf_task_utl.g_miss_char,
1359: p_attribute_category IN VARCHAR2
1360: DEFAULT jtf_task_utl.g_miss_char,
1361: p_assignee_role IN VARCHAR2
1362: DEFAULT jtf_task_utl.g_miss_char,
1363: p_show_on_calendar IN VARCHAR2
1364: DEFAULT jtf_task_utl.g_miss_char,

Line 1362: DEFAULT jtf_task_utl.g_miss_char,

1358: DEFAULT jtf_task_utl.g_miss_char,
1359: p_attribute_category IN VARCHAR2
1360: DEFAULT jtf_task_utl.g_miss_char,
1361: p_assignee_role IN VARCHAR2
1362: DEFAULT jtf_task_utl.g_miss_char,
1363: p_show_on_calendar IN VARCHAR2
1364: DEFAULT jtf_task_utl.g_miss_char,
1365: p_category_id IN NUMBER
1366: DEFAULT jtf_task_utl.g_miss_number,

Line 1364: DEFAULT jtf_task_utl.g_miss_char,

1360: DEFAULT jtf_task_utl.g_miss_char,
1361: p_assignee_role IN VARCHAR2
1362: DEFAULT jtf_task_utl.g_miss_char,
1363: p_show_on_calendar IN VARCHAR2
1364: DEFAULT jtf_task_utl.g_miss_char,
1365: p_category_id IN NUMBER
1366: DEFAULT jtf_task_utl.g_miss_number,
1367: p_enable_workflow IN VARCHAR2,
1368: p_abort_workflow IN VARCHAR2,

Line 1366: DEFAULT jtf_task_utl.g_miss_number,

1362: DEFAULT jtf_task_utl.g_miss_char,
1363: p_show_on_calendar IN VARCHAR2
1364: DEFAULT jtf_task_utl.g_miss_char,
1365: p_category_id IN NUMBER
1366: DEFAULT jtf_task_utl.g_miss_number,
1367: p_enable_workflow IN VARCHAR2,
1368: p_abort_workflow IN VARCHAR2,
1369: p_free_busy_type IN VARCHAR2,
1370: p_object_capacity_id IN NUMBER

Line 1590: jtf_task_utl.g_miss_number, category_id,

1586: p_show_on_calendar
1587: ) show_on_calendar,
1588: DECODE (
1589: p_category_id,
1590: jtf_task_utl.g_miss_number, category_id,
1591: p_category_id
1592: ) category_id,
1593: DECODE (
1594: p_attribute1,

Line 1675: jtf_task_utl.g_miss_char, free_busy_type,

1671: p_attribute_category
1672: ) attribute_category,
1673: DECODE (
1674: p_free_busy_type,
1675: jtf_task_utl.g_miss_char, free_busy_type,
1676: p_free_busy_type
1677: ) free_busy_type,
1678: DECODE (
1679: p_object_capacity_id,

Line 1702: ass_orig jtf_task_utl.c_ass_orig%ROWTYPE;

1698:
1699: -- Business Event System Enhancement # 2391065
1700: l_assignment_rec_old jtf_task_assignments_pvt.task_assignments_rec ;
1701: l_assignment_rec_new jtf_task_assignments_pvt.task_assignments_rec ;
1702: ass_orig jtf_task_utl.c_ass_orig%ROWTYPE;
1703: x_event_return_status varchar2(100);
1704:
1705: CURSOR c_task (b_task_id NUMBER) IS
1706: SELECT source_object_type_code

Line 1745: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);

1741: END IF;
1742: CLOSE task_ass_u;
1743:
1744: -- Business Event System Enhancement # 2391065
1745: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);
1746: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1747:
1748: IF jtf_task_utl.c_ass_orig%NOTFOUND
1749: THEN

Line 1746: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;

1742: CLOSE task_ass_u;
1743:
1744: -- Business Event System Enhancement # 2391065
1745: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);
1746: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1747:
1748: IF jtf_task_utl.c_ass_orig%NOTFOUND
1749: THEN
1750: CLOSE jtf_task_utl.c_ass_orig;

Line 1748: IF jtf_task_utl.c_ass_orig%NOTFOUND

1744: -- Business Event System Enhancement # 2391065
1745: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);
1746: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1747:
1748: IF jtf_task_utl.c_ass_orig%NOTFOUND
1749: THEN
1750: CLOSE jtf_task_utl.c_ass_orig;
1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);

Line 1750: CLOSE jtf_task_utl.c_ass_orig;

1746: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1747:
1748: IF jtf_task_utl.c_ass_orig%NOTFOUND
1749: THEN
1750: CLOSE jtf_task_utl.c_ass_orig;
1751: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1752: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1757: CLOSE jtf_task_utl.c_ass_orig;

1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_unexp_error;
1755: RAISE fnd_api.g_exc_unexpected_error;
1756: END IF;
1757: CLOSE jtf_task_utl.c_ass_orig;
1758:
1759: l_task_assignment_id := p_task_assignment_id;
1760: l_task_id := task_ass.task_id;
1761: l_resource_id := task_ass.resource_id;

Line 1823: IF g_response_flag = jtf_task_utl.g_no_char

1819: IF l_recurrence_rule_id IS NOT NULL AND
1820: l_source_object_type_code = 'APPOINTMENT' AND
1821: task_ass.old_assignment_status_id in ( 18 , 3 ) -- Invited
1822: THEN
1823: IF g_response_flag = jtf_task_utl.g_no_char
1824: THEN
1825: l_response_invitation_rec.task_assignment_id := p_task_assignment_id;
1826: l_response_invitation_rec.assignment_status_id := l_assignment_status_id;
1827: l_response_invitation_rec.task_id := l_task_id;

Line 1841: g_response_flag := jtf_task_utl.g_no_char;

1837: x_msg_count => x_msg_count,
1838: x_msg_data => x_msg_data
1839: );
1840:
1841: g_response_flag := jtf_task_utl.g_no_char;
1842:
1843: ----------------------------------------------------------------
1844: -- response_invitation() will call this procedure again
1845: -- to update the assignment status with accepted or rejected.

Line 1874: jtf_task_utl.check_security_privilege(

1870: END IF;
1871:
1872:
1873: -- Validate the user_id
1874: jtf_task_utl.check_security_privilege(
1875: p_task_id => l_task_id,
1876: p_session => l_session,
1877: x_return_status => x_return_status
1878: );

Line 1887: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)

1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: --Bug 2467222 for assignee category update
1887: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)
1888: THEN
1889: UPDATE jtf_task_all_assignments
1890: SET category_id = p_category_id
1891: WHERE task_id = l_task_id

Line 1912: IF NOT jtf_task_utl.validate_lookup (

1908: l_assignee_role := 'ASSIGNEE';
1909: END IF;
1910:
1911: -- Validate the value in ASSIGNEE_ROLE
1912: IF NOT jtf_task_utl.validate_lookup (
1913: 'JTF_TASK_ASSIGNEE_ROLES',
1914: l_assignee_role,
1915: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )'
1916: )

Line 1975: p_free_busy_type = jtf_task_utl.g_miss_char AND -- no explicit value

1971: x_booking_end_date => l_booking_end_date
1972: );
1973:
1974: IF l_entity = 'TASK' AND
1975: p_free_busy_type = jtf_task_utl.g_miss_char AND -- no explicit value
1976: nvl(p_assignment_status_id, 0) <> fnd_api.g_miss_num AND
1977: nvl(l_old_assignment_status_id, 0) <> nvl(l_assignment_status_id, 0) -- Modified for bug# 5514013 on 11/09/2006
1978: THEN
1979: update_free_busy_type(

Line 2046: x_last_updated_by => jtf_task_utl.updated_by,

2042: x_sched_travel_distance => l_sched_travel_distance,
2043: x_sched_travel_duration => l_sched_travel_duration,
2044: x_resource_type_code => l_resource_type_code,
2045: x_last_update_date => SYSDATE,
2046: x_last_updated_by => jtf_task_utl.updated_by,
2047: x_last_update_login => jtf_task_utl.login_id,
2048: x_resource_territory_id => l_resource_territory_id,
2049: x_assignment_status_id => l_assignment_status_id,
2050: x_shift_construct_id => l_shift_construct_id,

Line 2047: x_last_update_login => jtf_task_utl.login_id,

2043: x_sched_travel_duration => l_sched_travel_duration,
2044: x_resource_type_code => l_resource_type_code,
2045: x_last_update_date => SYSDATE,
2046: x_last_updated_by => jtf_task_utl.updated_by,
2047: x_last_update_login => jtf_task_utl.login_id,
2048: x_resource_territory_id => l_resource_territory_id,
2049: x_assignment_status_id => l_assignment_status_id,
2050: x_shift_construct_id => l_shift_construct_id,
2051: x_assignee_role => l_assignee_role,

Line 2072: jtf_task_utl.delete_party_reference(

2068: if (nvl(l_resource_id, 0) <> fnd_api.g_miss_num and
2069: nvl(l_resource_id, 0) <> nvl(l_orig_res_id, 0))
2070: or (nvl(l_resource_type_code, fnd_api.g_miss_char) <> nvl(l_orig_res_type_code, fnd_api.g_miss_char)) then
2071: -- delete the old one
2072: jtf_task_utl.delete_party_reference(
2073: p_reference_from => 'ASSIGNMENT',
2074: p_task_id => l_task_id,
2075: p_party_type_code => l_orig_res_type_code,
2076: p_party_id => l_orig_res_id,

Line 2087: jtf_task_utl.create_party_reference(

2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END IF;
2086: -- create a new one
2087: jtf_task_utl.create_party_reference(
2088: p_reference_from => 'ASSIGNMENT',
2089: p_task_id => l_task_id,
2090: p_party_type_code => l_resource_type_code,
2091: p_party_id => l_resource_id,

Line 2258: DEFAULT jtf_task_utl.g_miss_char,

2254: x_return_status OUT NOCOPY VARCHAR2,
2255: x_msg_count OUT NOCOPY NUMBER,
2256: x_msg_data OUT NOCOPY VARCHAR2,
2257: p_attribute1 IN VARCHAR2
2258: DEFAULT jtf_task_utl.g_miss_char,
2259: p_attribute2 IN VARCHAR2
2260: DEFAULT jtf_task_utl.g_miss_char,
2261: p_attribute3 IN VARCHAR2
2262: DEFAULT jtf_task_utl.g_miss_char,

Line 2260: DEFAULT jtf_task_utl.g_miss_char,

2256: x_msg_data OUT NOCOPY VARCHAR2,
2257: p_attribute1 IN VARCHAR2
2258: DEFAULT jtf_task_utl.g_miss_char,
2259: p_attribute2 IN VARCHAR2
2260: DEFAULT jtf_task_utl.g_miss_char,
2261: p_attribute3 IN VARCHAR2
2262: DEFAULT jtf_task_utl.g_miss_char,
2263: p_attribute4 IN VARCHAR2
2264: DEFAULT jtf_task_utl.g_miss_char,

Line 2262: DEFAULT jtf_task_utl.g_miss_char,

2258: DEFAULT jtf_task_utl.g_miss_char,
2259: p_attribute2 IN VARCHAR2
2260: DEFAULT jtf_task_utl.g_miss_char,
2261: p_attribute3 IN VARCHAR2
2262: DEFAULT jtf_task_utl.g_miss_char,
2263: p_attribute4 IN VARCHAR2
2264: DEFAULT jtf_task_utl.g_miss_char,
2265: p_attribute5 IN VARCHAR2
2266: DEFAULT jtf_task_utl.g_miss_char,

Line 2264: DEFAULT jtf_task_utl.g_miss_char,

2260: DEFAULT jtf_task_utl.g_miss_char,
2261: p_attribute3 IN VARCHAR2
2262: DEFAULT jtf_task_utl.g_miss_char,
2263: p_attribute4 IN VARCHAR2
2264: DEFAULT jtf_task_utl.g_miss_char,
2265: p_attribute5 IN VARCHAR2
2266: DEFAULT jtf_task_utl.g_miss_char,
2267: p_attribute6 IN VARCHAR2
2268: DEFAULT jtf_task_utl.g_miss_char,

Line 2266: DEFAULT jtf_task_utl.g_miss_char,

2262: DEFAULT jtf_task_utl.g_miss_char,
2263: p_attribute4 IN VARCHAR2
2264: DEFAULT jtf_task_utl.g_miss_char,
2265: p_attribute5 IN VARCHAR2
2266: DEFAULT jtf_task_utl.g_miss_char,
2267: p_attribute6 IN VARCHAR2
2268: DEFAULT jtf_task_utl.g_miss_char,
2269: p_attribute7 IN VARCHAR2
2270: DEFAULT jtf_task_utl.g_miss_char,

Line 2268: DEFAULT jtf_task_utl.g_miss_char,

2264: DEFAULT jtf_task_utl.g_miss_char,
2265: p_attribute5 IN VARCHAR2
2266: DEFAULT jtf_task_utl.g_miss_char,
2267: p_attribute6 IN VARCHAR2
2268: DEFAULT jtf_task_utl.g_miss_char,
2269: p_attribute7 IN VARCHAR2
2270: DEFAULT jtf_task_utl.g_miss_char,
2271: p_attribute8 IN VARCHAR2
2272: DEFAULT jtf_task_utl.g_miss_char,

Line 2270: DEFAULT jtf_task_utl.g_miss_char,

2266: DEFAULT jtf_task_utl.g_miss_char,
2267: p_attribute6 IN VARCHAR2
2268: DEFAULT jtf_task_utl.g_miss_char,
2269: p_attribute7 IN VARCHAR2
2270: DEFAULT jtf_task_utl.g_miss_char,
2271: p_attribute8 IN VARCHAR2
2272: DEFAULT jtf_task_utl.g_miss_char,
2273: p_attribute9 IN VARCHAR2
2274: DEFAULT jtf_task_utl.g_miss_char,

Line 2272: DEFAULT jtf_task_utl.g_miss_char,

2268: DEFAULT jtf_task_utl.g_miss_char,
2269: p_attribute7 IN VARCHAR2
2270: DEFAULT jtf_task_utl.g_miss_char,
2271: p_attribute8 IN VARCHAR2
2272: DEFAULT jtf_task_utl.g_miss_char,
2273: p_attribute9 IN VARCHAR2
2274: DEFAULT jtf_task_utl.g_miss_char,
2275: p_attribute10 IN VARCHAR2
2276: DEFAULT jtf_task_utl.g_miss_char,

Line 2274: DEFAULT jtf_task_utl.g_miss_char,

2270: DEFAULT jtf_task_utl.g_miss_char,
2271: p_attribute8 IN VARCHAR2
2272: DEFAULT jtf_task_utl.g_miss_char,
2273: p_attribute9 IN VARCHAR2
2274: DEFAULT jtf_task_utl.g_miss_char,
2275: p_attribute10 IN VARCHAR2
2276: DEFAULT jtf_task_utl.g_miss_char,
2277: p_attribute11 IN VARCHAR2
2278: DEFAULT jtf_task_utl.g_miss_char,

Line 2276: DEFAULT jtf_task_utl.g_miss_char,

2272: DEFAULT jtf_task_utl.g_miss_char,
2273: p_attribute9 IN VARCHAR2
2274: DEFAULT jtf_task_utl.g_miss_char,
2275: p_attribute10 IN VARCHAR2
2276: DEFAULT jtf_task_utl.g_miss_char,
2277: p_attribute11 IN VARCHAR2
2278: DEFAULT jtf_task_utl.g_miss_char,
2279: p_attribute12 IN VARCHAR2
2280: DEFAULT jtf_task_utl.g_miss_char,

Line 2278: DEFAULT jtf_task_utl.g_miss_char,

2274: DEFAULT jtf_task_utl.g_miss_char,
2275: p_attribute10 IN VARCHAR2
2276: DEFAULT jtf_task_utl.g_miss_char,
2277: p_attribute11 IN VARCHAR2
2278: DEFAULT jtf_task_utl.g_miss_char,
2279: p_attribute12 IN VARCHAR2
2280: DEFAULT jtf_task_utl.g_miss_char,
2281: p_attribute13 IN VARCHAR2
2282: DEFAULT jtf_task_utl.g_miss_char,

Line 2280: DEFAULT jtf_task_utl.g_miss_char,

2276: DEFAULT jtf_task_utl.g_miss_char,
2277: p_attribute11 IN VARCHAR2
2278: DEFAULT jtf_task_utl.g_miss_char,
2279: p_attribute12 IN VARCHAR2
2280: DEFAULT jtf_task_utl.g_miss_char,
2281: p_attribute13 IN VARCHAR2
2282: DEFAULT jtf_task_utl.g_miss_char,
2283: p_attribute14 IN VARCHAR2
2284: DEFAULT jtf_task_utl.g_miss_char,

Line 2282: DEFAULT jtf_task_utl.g_miss_char,

2278: DEFAULT jtf_task_utl.g_miss_char,
2279: p_attribute12 IN VARCHAR2
2280: DEFAULT jtf_task_utl.g_miss_char,
2281: p_attribute13 IN VARCHAR2
2282: DEFAULT jtf_task_utl.g_miss_char,
2283: p_attribute14 IN VARCHAR2
2284: DEFAULT jtf_task_utl.g_miss_char,
2285: p_attribute15 IN VARCHAR2
2286: DEFAULT jtf_task_utl.g_miss_char,

Line 2284: DEFAULT jtf_task_utl.g_miss_char,

2280: DEFAULT jtf_task_utl.g_miss_char,
2281: p_attribute13 IN VARCHAR2
2282: DEFAULT jtf_task_utl.g_miss_char,
2283: p_attribute14 IN VARCHAR2
2284: DEFAULT jtf_task_utl.g_miss_char,
2285: p_attribute15 IN VARCHAR2
2286: DEFAULT jtf_task_utl.g_miss_char,
2287: p_attribute_category IN VARCHAR2
2288: DEFAULT jtf_task_utl.g_miss_char,

Line 2286: DEFAULT jtf_task_utl.g_miss_char,

2282: DEFAULT jtf_task_utl.g_miss_char,
2283: p_attribute14 IN VARCHAR2
2284: DEFAULT jtf_task_utl.g_miss_char,
2285: p_attribute15 IN VARCHAR2
2286: DEFAULT jtf_task_utl.g_miss_char,
2287: p_attribute_category IN VARCHAR2
2288: DEFAULT jtf_task_utl.g_miss_char,
2289: p_assignee_role IN VARCHAR2
2290: DEFAULT jtf_task_utl.g_miss_char,

Line 2288: DEFAULT jtf_task_utl.g_miss_char,

2284: DEFAULT jtf_task_utl.g_miss_char,
2285: p_attribute15 IN VARCHAR2
2286: DEFAULT jtf_task_utl.g_miss_char,
2287: p_attribute_category IN VARCHAR2
2288: DEFAULT jtf_task_utl.g_miss_char,
2289: p_assignee_role IN VARCHAR2
2290: DEFAULT jtf_task_utl.g_miss_char,
2291: p_show_on_calendar IN VARCHAR2
2292: DEFAULT jtf_task_utl.g_miss_char,

Line 2290: DEFAULT jtf_task_utl.g_miss_char,

2286: DEFAULT jtf_task_utl.g_miss_char,
2287: p_attribute_category IN VARCHAR2
2288: DEFAULT jtf_task_utl.g_miss_char,
2289: p_assignee_role IN VARCHAR2
2290: DEFAULT jtf_task_utl.g_miss_char,
2291: p_show_on_calendar IN VARCHAR2
2292: DEFAULT jtf_task_utl.g_miss_char,
2293: p_category_id IN NUMBER
2294: DEFAULT jtf_task_utl.g_miss_number

Line 2292: DEFAULT jtf_task_utl.g_miss_char,

2288: DEFAULT jtf_task_utl.g_miss_char,
2289: p_assignee_role IN VARCHAR2
2290: DEFAULT jtf_task_utl.g_miss_char,
2291: p_show_on_calendar IN VARCHAR2
2292: DEFAULT jtf_task_utl.g_miss_char,
2293: p_category_id IN NUMBER
2294: DEFAULT jtf_task_utl.g_miss_number
2295: )
2296: IS

Line 2294: DEFAULT jtf_task_utl.g_miss_number

2290: DEFAULT jtf_task_utl.g_miss_char,
2291: p_show_on_calendar IN VARCHAR2
2292: DEFAULT jtf_task_utl.g_miss_char,
2293: p_category_id IN NUMBER
2294: DEFAULT jtf_task_utl.g_miss_number
2295: )
2296: IS
2297: BEGIN
2298: jtf_task_assignments_pvt.update_task_assignment (

Line 2413: DEFAULT jtf_task_utl.g_miss_char,

2409: x_return_status OUT NOCOPY VARCHAR2,
2410: x_msg_count OUT NOCOPY NUMBER,
2411: x_msg_data OUT NOCOPY VARCHAR2,
2412: p_attribute1 IN VARCHAR2
2413: DEFAULT jtf_task_utl.g_miss_char,
2414: p_attribute2 IN VARCHAR2
2415: DEFAULT jtf_task_utl.g_miss_char,
2416: p_attribute3 IN VARCHAR2
2417: DEFAULT jtf_task_utl.g_miss_char,

Line 2415: DEFAULT jtf_task_utl.g_miss_char,

2411: x_msg_data OUT NOCOPY VARCHAR2,
2412: p_attribute1 IN VARCHAR2
2413: DEFAULT jtf_task_utl.g_miss_char,
2414: p_attribute2 IN VARCHAR2
2415: DEFAULT jtf_task_utl.g_miss_char,
2416: p_attribute3 IN VARCHAR2
2417: DEFAULT jtf_task_utl.g_miss_char,
2418: p_attribute4 IN VARCHAR2
2419: DEFAULT jtf_task_utl.g_miss_char,

Line 2417: DEFAULT jtf_task_utl.g_miss_char,

2413: DEFAULT jtf_task_utl.g_miss_char,
2414: p_attribute2 IN VARCHAR2
2415: DEFAULT jtf_task_utl.g_miss_char,
2416: p_attribute3 IN VARCHAR2
2417: DEFAULT jtf_task_utl.g_miss_char,
2418: p_attribute4 IN VARCHAR2
2419: DEFAULT jtf_task_utl.g_miss_char,
2420: p_attribute5 IN VARCHAR2
2421: DEFAULT jtf_task_utl.g_miss_char,

Line 2419: DEFAULT jtf_task_utl.g_miss_char,

2415: DEFAULT jtf_task_utl.g_miss_char,
2416: p_attribute3 IN VARCHAR2
2417: DEFAULT jtf_task_utl.g_miss_char,
2418: p_attribute4 IN VARCHAR2
2419: DEFAULT jtf_task_utl.g_miss_char,
2420: p_attribute5 IN VARCHAR2
2421: DEFAULT jtf_task_utl.g_miss_char,
2422: p_attribute6 IN VARCHAR2
2423: DEFAULT jtf_task_utl.g_miss_char,

Line 2421: DEFAULT jtf_task_utl.g_miss_char,

2417: DEFAULT jtf_task_utl.g_miss_char,
2418: p_attribute4 IN VARCHAR2
2419: DEFAULT jtf_task_utl.g_miss_char,
2420: p_attribute5 IN VARCHAR2
2421: DEFAULT jtf_task_utl.g_miss_char,
2422: p_attribute6 IN VARCHAR2
2423: DEFAULT jtf_task_utl.g_miss_char,
2424: p_attribute7 IN VARCHAR2
2425: DEFAULT jtf_task_utl.g_miss_char,

Line 2423: DEFAULT jtf_task_utl.g_miss_char,

2419: DEFAULT jtf_task_utl.g_miss_char,
2420: p_attribute5 IN VARCHAR2
2421: DEFAULT jtf_task_utl.g_miss_char,
2422: p_attribute6 IN VARCHAR2
2423: DEFAULT jtf_task_utl.g_miss_char,
2424: p_attribute7 IN VARCHAR2
2425: DEFAULT jtf_task_utl.g_miss_char,
2426: p_attribute8 IN VARCHAR2
2427: DEFAULT jtf_task_utl.g_miss_char,

Line 2425: DEFAULT jtf_task_utl.g_miss_char,

2421: DEFAULT jtf_task_utl.g_miss_char,
2422: p_attribute6 IN VARCHAR2
2423: DEFAULT jtf_task_utl.g_miss_char,
2424: p_attribute7 IN VARCHAR2
2425: DEFAULT jtf_task_utl.g_miss_char,
2426: p_attribute8 IN VARCHAR2
2427: DEFAULT jtf_task_utl.g_miss_char,
2428: p_attribute9 IN VARCHAR2
2429: DEFAULT jtf_task_utl.g_miss_char,

Line 2427: DEFAULT jtf_task_utl.g_miss_char,

2423: DEFAULT jtf_task_utl.g_miss_char,
2424: p_attribute7 IN VARCHAR2
2425: DEFAULT jtf_task_utl.g_miss_char,
2426: p_attribute8 IN VARCHAR2
2427: DEFAULT jtf_task_utl.g_miss_char,
2428: p_attribute9 IN VARCHAR2
2429: DEFAULT jtf_task_utl.g_miss_char,
2430: p_attribute10 IN VARCHAR2
2431: DEFAULT jtf_task_utl.g_miss_char,

Line 2429: DEFAULT jtf_task_utl.g_miss_char,

2425: DEFAULT jtf_task_utl.g_miss_char,
2426: p_attribute8 IN VARCHAR2
2427: DEFAULT jtf_task_utl.g_miss_char,
2428: p_attribute9 IN VARCHAR2
2429: DEFAULT jtf_task_utl.g_miss_char,
2430: p_attribute10 IN VARCHAR2
2431: DEFAULT jtf_task_utl.g_miss_char,
2432: p_attribute11 IN VARCHAR2
2433: DEFAULT jtf_task_utl.g_miss_char,

Line 2431: DEFAULT jtf_task_utl.g_miss_char,

2427: DEFAULT jtf_task_utl.g_miss_char,
2428: p_attribute9 IN VARCHAR2
2429: DEFAULT jtf_task_utl.g_miss_char,
2430: p_attribute10 IN VARCHAR2
2431: DEFAULT jtf_task_utl.g_miss_char,
2432: p_attribute11 IN VARCHAR2
2433: DEFAULT jtf_task_utl.g_miss_char,
2434: p_attribute12 IN VARCHAR2
2435: DEFAULT jtf_task_utl.g_miss_char,

Line 2433: DEFAULT jtf_task_utl.g_miss_char,

2429: DEFAULT jtf_task_utl.g_miss_char,
2430: p_attribute10 IN VARCHAR2
2431: DEFAULT jtf_task_utl.g_miss_char,
2432: p_attribute11 IN VARCHAR2
2433: DEFAULT jtf_task_utl.g_miss_char,
2434: p_attribute12 IN VARCHAR2
2435: DEFAULT jtf_task_utl.g_miss_char,
2436: p_attribute13 IN VARCHAR2
2437: DEFAULT jtf_task_utl.g_miss_char,

Line 2435: DEFAULT jtf_task_utl.g_miss_char,

2431: DEFAULT jtf_task_utl.g_miss_char,
2432: p_attribute11 IN VARCHAR2
2433: DEFAULT jtf_task_utl.g_miss_char,
2434: p_attribute12 IN VARCHAR2
2435: DEFAULT jtf_task_utl.g_miss_char,
2436: p_attribute13 IN VARCHAR2
2437: DEFAULT jtf_task_utl.g_miss_char,
2438: p_attribute14 IN VARCHAR2
2439: DEFAULT jtf_task_utl.g_miss_char,

Line 2437: DEFAULT jtf_task_utl.g_miss_char,

2433: DEFAULT jtf_task_utl.g_miss_char,
2434: p_attribute12 IN VARCHAR2
2435: DEFAULT jtf_task_utl.g_miss_char,
2436: p_attribute13 IN VARCHAR2
2437: DEFAULT jtf_task_utl.g_miss_char,
2438: p_attribute14 IN VARCHAR2
2439: DEFAULT jtf_task_utl.g_miss_char,
2440: p_attribute15 IN VARCHAR2
2441: DEFAULT jtf_task_utl.g_miss_char,

Line 2439: DEFAULT jtf_task_utl.g_miss_char,

2435: DEFAULT jtf_task_utl.g_miss_char,
2436: p_attribute13 IN VARCHAR2
2437: DEFAULT jtf_task_utl.g_miss_char,
2438: p_attribute14 IN VARCHAR2
2439: DEFAULT jtf_task_utl.g_miss_char,
2440: p_attribute15 IN VARCHAR2
2441: DEFAULT jtf_task_utl.g_miss_char,
2442: p_attribute_category IN VARCHAR2
2443: DEFAULT jtf_task_utl.g_miss_char,

Line 2441: DEFAULT jtf_task_utl.g_miss_char,

2437: DEFAULT jtf_task_utl.g_miss_char,
2438: p_attribute14 IN VARCHAR2
2439: DEFAULT jtf_task_utl.g_miss_char,
2440: p_attribute15 IN VARCHAR2
2441: DEFAULT jtf_task_utl.g_miss_char,
2442: p_attribute_category IN VARCHAR2
2443: DEFAULT jtf_task_utl.g_miss_char,
2444: p_assignee_role IN VARCHAR2
2445: DEFAULT jtf_task_utl.g_miss_char,

Line 2443: DEFAULT jtf_task_utl.g_miss_char,

2439: DEFAULT jtf_task_utl.g_miss_char,
2440: p_attribute15 IN VARCHAR2
2441: DEFAULT jtf_task_utl.g_miss_char,
2442: p_attribute_category IN VARCHAR2
2443: DEFAULT jtf_task_utl.g_miss_char,
2444: p_assignee_role IN VARCHAR2
2445: DEFAULT jtf_task_utl.g_miss_char,
2446: p_show_on_calendar IN VARCHAR2
2447: DEFAULT jtf_task_utl.g_miss_char,

Line 2445: DEFAULT jtf_task_utl.g_miss_char,

2441: DEFAULT jtf_task_utl.g_miss_char,
2442: p_attribute_category IN VARCHAR2
2443: DEFAULT jtf_task_utl.g_miss_char,
2444: p_assignee_role IN VARCHAR2
2445: DEFAULT jtf_task_utl.g_miss_char,
2446: p_show_on_calendar IN VARCHAR2
2447: DEFAULT jtf_task_utl.g_miss_char,
2448: p_category_id IN NUMBER
2449: DEFAULT jtf_task_utl.g_miss_number,

Line 2447: DEFAULT jtf_task_utl.g_miss_char,

2443: DEFAULT jtf_task_utl.g_miss_char,
2444: p_assignee_role IN VARCHAR2
2445: DEFAULT jtf_task_utl.g_miss_char,
2446: p_show_on_calendar IN VARCHAR2
2447: DEFAULT jtf_task_utl.g_miss_char,
2448: p_category_id IN NUMBER
2449: DEFAULT jtf_task_utl.g_miss_number,
2450: p_enable_workflow IN VARCHAR2,
2451: p_abort_workflow IN VARCHAR2

Line 2449: DEFAULT jtf_task_utl.g_miss_number,

2445: DEFAULT jtf_task_utl.g_miss_char,
2446: p_show_on_calendar IN VARCHAR2
2447: DEFAULT jtf_task_utl.g_miss_char,
2448: p_category_id IN NUMBER
2449: DEFAULT jtf_task_utl.g_miss_number,
2450: p_enable_workflow IN VARCHAR2,
2451: p_abort_workflow IN VARCHAR2
2452: )
2453: IS

Line 2677: jtf_task_utl.check_security_privilege(

2673: RAISE fnd_api.g_exc_unexpected_error;
2674: END IF;
2675: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2676:
2677: jtf_task_utl.check_security_privilege(
2678: p_task_id => l_task_id,
2679: p_session => l_session,
2680: x_return_status => x_return_status
2681: );

Line 2716: jtf_task_utl.delete_party_reference(

2712:
2713: -- ------------------------------------------------------------------------
2714: -- Delete reference to resource, fix enh #1845501
2715: -- ------------------------------------------------------------------------
2716: jtf_task_utl.delete_party_reference(
2717: p_reference_from => 'ASSIGNMENT',
2718: p_task_id => l_task_id,
2719: p_party_type_code => l_resource_type_code,
2720: p_party_id => l_resource_id,