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_TASK_ASSIGNMENTS_PVT dependencies on JTF_TASK_UTL

Line 35: x_booking_start_date := jtf_task_utl_ext.adjust_date

31: THEN
32: RETURN;
33: END IF;
34:
35: x_booking_start_date := jtf_task_utl_ext.adjust_date
36: (
37: p_calendar_start_date,
38: p_actual_travel_duration * (-1),
39: p_actual_travel_duration_uom

Line 47: x_booking_end_date := jtf_task_utl_ext.adjust_date

43: IF (p_calendar_start_date <= p_calendar_end_date)
44: THEN
45: x_booking_end_date := p_calendar_end_date;
46: ELSE
47: x_booking_end_date := jtf_task_utl_ext.adjust_date
48: (
49: p_calendar_start_date,
50: p_planned_effort,
51: p_planned_effort_uom

Line 104: x_booking_start_date := jtf_task_utl_ext.adjust_date

100: );
101: RETURN;
102: END IF;
103:
104: x_booking_start_date := jtf_task_utl_ext.adjust_date
105: (
106: p_actual_start_date,
107: p_actual_travel_duration * (-1),
108: p_actual_travel_duration_uom

Line 117: x_booking_end_date := jtf_task_utl_ext.adjust_date

113: THEN
114: x_booking_end_date := p_actual_end_date;
115: ELSIF p_actual_effort >= 0
116: THEN
117: x_booking_end_date := jtf_task_utl_ext.adjust_date
118: (
119: p_actual_start_date,
120: p_actual_effort,
121: p_actual_effort_uom

Line 124: x_booking_end_date := jtf_task_utl_ext.adjust_date

120: p_actual_effort,
121: p_actual_effort_uom
122: );
123: ELSE
124: x_booking_end_date := jtf_task_utl_ext.adjust_date
125: (
126: p_actual_start_date,
127: p_planned_effort,
128: p_planned_effort_uom

Line 208: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,

204: p_attribute14 IN VARCHAR2 DEFAULT NULL,
205: p_attribute15 IN VARCHAR2 DEFAULT NULL,
206: p_attribute_category IN VARCHAR2 DEFAULT NULL,
207: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
208: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
209: p_category_id IN NUMBER DEFAULT NULL,
210: p_enable_workflow IN VARCHAR2,
211: p_abort_workflow IN VARCHAR2,
212: p_add_option IN VARCHAR2,

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

383: ------------------------------------------
384:
385: IF p_task_assignment_id IS NOT NULL
386: THEN
387: IF p_task_assignment_id > jtf_task_utl_ext.get_last_number('JTF_TASK_ASSIGNMENTS_S') and -- Enh# 2734020
388: p_task_assignment_id < 1e+12
389: THEN
390: fnd_message.set_name ('JTF', 'JTF_TASK_OUT_OF_RANGE');
391: fnd_msg_pub.add;

Line 411: IF NOT jtf_task_utl.validate_lookup(

407: l_category_id := NULL;
408: END IF;
409:
410: -- Validate the value in ASSIGNEE_ROLE
411: IF NOT jtf_task_utl.validate_lookup(
412: 'JTF_TASK_ASSIGNEE_ROLES',
413: NVL (l_assignee_role, 'ASSIGNEE'),
414: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )')
415: THEN

Line 502: x_created_by => jtf_task_utl.created_by,

498: x_sched_travel_distance => l_sched_travel_distance,
499: x_sched_travel_duration => l_sched_travel_duration,
500: x_resource_type_code => l_resource_type_code,
501: x_creation_date => SYSDATE,
502: x_created_by => jtf_task_utl.created_by,
503: x_last_update_date => SYSDATE,
504: x_last_updated_by => jtf_task_utl.updated_by,
505: x_last_update_login => jtf_task_utl.login_id,
506: x_resource_territory_id => l_resource_territory_id,

Line 504: x_last_updated_by => jtf_task_utl.updated_by,

500: x_resource_type_code => l_resource_type_code,
501: x_creation_date => SYSDATE,
502: x_created_by => jtf_task_utl.created_by,
503: x_last_update_date => SYSDATE,
504: x_last_updated_by => jtf_task_utl.updated_by,
505: x_last_update_login => jtf_task_utl.login_id,
506: x_resource_territory_id => l_resource_territory_id,
507: x_assignment_status_id => l_assignment_status_id,
508: x_shift_construct_id => l_shift_construct_id,

Line 505: x_last_update_login => jtf_task_utl.login_id,

501: x_creation_date => SYSDATE,
502: x_created_by => jtf_task_utl.created_by,
503: x_last_update_date => SYSDATE,
504: x_last_updated_by => jtf_task_utl.updated_by,
505: x_last_update_login => jtf_task_utl.login_id,
506: x_resource_territory_id => l_resource_territory_id,
507: x_assignment_status_id => l_assignment_status_id,
508: x_shift_construct_id => l_shift_construct_id,
509: x_assignee_role => l_assignee_role,

Line 577: jtf_task_utl.create_party_reference (

573: -- ------------------------------------------------------------------------
574: IF (rec_task.source_object_type_code <> 'APPOINTMENT') THEN
575: --Do not create automatic references for party assignment created for an APPOINTMENT
576: --Check bug 3968128
577: jtf_task_utl.create_party_reference (
578: p_reference_from => 'ASSIGNMENT',
579: p_task_id => l_task_id,
580: p_party_type_code => l_resource_type_code,
581: p_party_id => l_resource_id,

Line 668: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,

664: p_attribute14 IN VARCHAR2 DEFAULT NULL,
665: p_attribute15 IN VARCHAR2 DEFAULT NULL,
666: p_attribute_category IN VARCHAR2 DEFAULT NULL,
667: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
668: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
669: p_category_id IN NUMBER DEFAULT NULL,
670: p_enable_workflow IN VARCHAR2,
671: p_abort_workflow IN VARCHAR2,
672: p_add_option IN VARCHAR2,

Line 790: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,

786: p_attribute14 IN VARCHAR2 DEFAULT NULL,
787: p_attribute15 IN VARCHAR2 DEFAULT NULL,
788: p_attribute_category IN VARCHAR2 DEFAULT NULL,
789: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
790: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
791: p_category_id IN NUMBER DEFAULT NULL,
792: p_enable_workflow IN VARCHAR2,
793: p_abort_workflow IN VARCHAR2,
794: p_add_option IN VARCHAR2

Line 911: DEFAULT jtf_task_utl.g_yes_char,

907: p_attribute15 IN VARCHAR2 DEFAULT NULL,
908: p_attribute_category IN VARCHAR2 DEFAULT NULL,
909: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
910: p_show_on_calendar IN VARCHAR2
911: DEFAULT jtf_task_utl.g_yes_char,
912: p_category_id IN NUMBER DEFAULT NULL,
913: p_enable_workflow IN VARCHAR2,
914: p_abort_workflow IN VARCHAR2
915: )

Line 1030: DEFAULT jtf_task_utl.g_yes_char,

1026: p_attribute15 IN VARCHAR2 DEFAULT NULL,
1027: p_attribute_category IN VARCHAR2 DEFAULT NULL,
1028: p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
1029: p_show_on_calendar IN VARCHAR2
1030: DEFAULT jtf_task_utl.g_yes_char,
1031: p_category_id IN NUMBER DEFAULT NULL
1032: )
1033: IS
1034: BEGIN

Line 1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1125: p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1126: x_return_status OUT NOCOPY VARCHAR2,
1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1127: x_msg_count OUT NOCOPY NUMBER,
1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1128: x_msg_data OUT NOCOPY VARCHAR2,
1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1129: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1130: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1131: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1132: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1133: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1134: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1135: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1136: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1137: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1138: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1139: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1147: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,

Line 1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1140: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1147: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1148: p_enable_workflow IN VARCHAR2,

Line 1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1141: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1147: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1148: p_enable_workflow IN VARCHAR2,
1149: p_abort_workflow IN VARCHAR2,

Line 1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1142: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1147: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1148: p_enable_workflow IN VARCHAR2,
1149: p_abort_workflow IN VARCHAR2,
1150: p_free_busy_type IN VARCHAR2

Line 1147: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,

1143: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1144: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1145: p_assignee_role IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1146: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1147: p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
1148: p_enable_workflow IN VARCHAR2,
1149: p_abort_workflow IN VARCHAR2,
1150: p_free_busy_type IN VARCHAR2
1151: )

Line 1271: DEFAULT jtf_task_utl.g_miss_char,

1267: x_return_status OUT NOCOPY VARCHAR2,
1268: x_msg_count OUT NOCOPY NUMBER,
1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: p_attribute1 IN VARCHAR2
1271: DEFAULT jtf_task_utl.g_miss_char,
1272: p_attribute2 IN VARCHAR2
1273: DEFAULT jtf_task_utl.g_miss_char,
1274: p_attribute3 IN VARCHAR2
1275: DEFAULT jtf_task_utl.g_miss_char,

Line 1273: DEFAULT jtf_task_utl.g_miss_char,

1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: p_attribute1 IN VARCHAR2
1271: DEFAULT jtf_task_utl.g_miss_char,
1272: p_attribute2 IN VARCHAR2
1273: DEFAULT jtf_task_utl.g_miss_char,
1274: p_attribute3 IN VARCHAR2
1275: DEFAULT jtf_task_utl.g_miss_char,
1276: p_attribute4 IN VARCHAR2
1277: DEFAULT jtf_task_utl.g_miss_char,

Line 1275: DEFAULT jtf_task_utl.g_miss_char,

1271: DEFAULT jtf_task_utl.g_miss_char,
1272: p_attribute2 IN VARCHAR2
1273: DEFAULT jtf_task_utl.g_miss_char,
1274: p_attribute3 IN VARCHAR2
1275: DEFAULT jtf_task_utl.g_miss_char,
1276: p_attribute4 IN VARCHAR2
1277: DEFAULT jtf_task_utl.g_miss_char,
1278: p_attribute5 IN VARCHAR2
1279: DEFAULT jtf_task_utl.g_miss_char,

Line 1277: DEFAULT jtf_task_utl.g_miss_char,

1273: DEFAULT jtf_task_utl.g_miss_char,
1274: p_attribute3 IN VARCHAR2
1275: DEFAULT jtf_task_utl.g_miss_char,
1276: p_attribute4 IN VARCHAR2
1277: DEFAULT jtf_task_utl.g_miss_char,
1278: p_attribute5 IN VARCHAR2
1279: DEFAULT jtf_task_utl.g_miss_char,
1280: p_attribute6 IN VARCHAR2
1281: DEFAULT jtf_task_utl.g_miss_char,

Line 1279: DEFAULT jtf_task_utl.g_miss_char,

1275: DEFAULT jtf_task_utl.g_miss_char,
1276: p_attribute4 IN VARCHAR2
1277: DEFAULT jtf_task_utl.g_miss_char,
1278: p_attribute5 IN VARCHAR2
1279: DEFAULT jtf_task_utl.g_miss_char,
1280: p_attribute6 IN VARCHAR2
1281: DEFAULT jtf_task_utl.g_miss_char,
1282: p_attribute7 IN VARCHAR2
1283: DEFAULT jtf_task_utl.g_miss_char,

Line 1281: DEFAULT jtf_task_utl.g_miss_char,

1277: DEFAULT jtf_task_utl.g_miss_char,
1278: p_attribute5 IN VARCHAR2
1279: DEFAULT jtf_task_utl.g_miss_char,
1280: p_attribute6 IN VARCHAR2
1281: DEFAULT jtf_task_utl.g_miss_char,
1282: p_attribute7 IN VARCHAR2
1283: DEFAULT jtf_task_utl.g_miss_char,
1284: p_attribute8 IN VARCHAR2
1285: DEFAULT jtf_task_utl.g_miss_char,

Line 1283: DEFAULT jtf_task_utl.g_miss_char,

1279: DEFAULT jtf_task_utl.g_miss_char,
1280: p_attribute6 IN VARCHAR2
1281: DEFAULT jtf_task_utl.g_miss_char,
1282: p_attribute7 IN VARCHAR2
1283: DEFAULT jtf_task_utl.g_miss_char,
1284: p_attribute8 IN VARCHAR2
1285: DEFAULT jtf_task_utl.g_miss_char,
1286: p_attribute9 IN VARCHAR2
1287: DEFAULT jtf_task_utl.g_miss_char,

Line 1285: DEFAULT jtf_task_utl.g_miss_char,

1281: DEFAULT jtf_task_utl.g_miss_char,
1282: p_attribute7 IN VARCHAR2
1283: DEFAULT jtf_task_utl.g_miss_char,
1284: p_attribute8 IN VARCHAR2
1285: DEFAULT jtf_task_utl.g_miss_char,
1286: p_attribute9 IN VARCHAR2
1287: DEFAULT jtf_task_utl.g_miss_char,
1288: p_attribute10 IN VARCHAR2
1289: DEFAULT jtf_task_utl.g_miss_char,

Line 1287: DEFAULT jtf_task_utl.g_miss_char,

1283: DEFAULT jtf_task_utl.g_miss_char,
1284: p_attribute8 IN VARCHAR2
1285: DEFAULT jtf_task_utl.g_miss_char,
1286: p_attribute9 IN VARCHAR2
1287: DEFAULT jtf_task_utl.g_miss_char,
1288: p_attribute10 IN VARCHAR2
1289: DEFAULT jtf_task_utl.g_miss_char,
1290: p_attribute11 IN VARCHAR2
1291: DEFAULT jtf_task_utl.g_miss_char,

Line 1289: DEFAULT jtf_task_utl.g_miss_char,

1285: DEFAULT jtf_task_utl.g_miss_char,
1286: p_attribute9 IN VARCHAR2
1287: DEFAULT jtf_task_utl.g_miss_char,
1288: p_attribute10 IN VARCHAR2
1289: DEFAULT jtf_task_utl.g_miss_char,
1290: p_attribute11 IN VARCHAR2
1291: DEFAULT jtf_task_utl.g_miss_char,
1292: p_attribute12 IN VARCHAR2
1293: DEFAULT jtf_task_utl.g_miss_char,

Line 1291: DEFAULT jtf_task_utl.g_miss_char,

1287: DEFAULT jtf_task_utl.g_miss_char,
1288: p_attribute10 IN VARCHAR2
1289: DEFAULT jtf_task_utl.g_miss_char,
1290: p_attribute11 IN VARCHAR2
1291: DEFAULT jtf_task_utl.g_miss_char,
1292: p_attribute12 IN VARCHAR2
1293: DEFAULT jtf_task_utl.g_miss_char,
1294: p_attribute13 IN VARCHAR2
1295: DEFAULT jtf_task_utl.g_miss_char,

Line 1293: DEFAULT jtf_task_utl.g_miss_char,

1289: DEFAULT jtf_task_utl.g_miss_char,
1290: p_attribute11 IN VARCHAR2
1291: DEFAULT jtf_task_utl.g_miss_char,
1292: p_attribute12 IN VARCHAR2
1293: DEFAULT jtf_task_utl.g_miss_char,
1294: p_attribute13 IN VARCHAR2
1295: DEFAULT jtf_task_utl.g_miss_char,
1296: p_attribute14 IN VARCHAR2
1297: DEFAULT jtf_task_utl.g_miss_char,

Line 1295: DEFAULT jtf_task_utl.g_miss_char,

1291: DEFAULT jtf_task_utl.g_miss_char,
1292: p_attribute12 IN VARCHAR2
1293: DEFAULT jtf_task_utl.g_miss_char,
1294: p_attribute13 IN VARCHAR2
1295: DEFAULT jtf_task_utl.g_miss_char,
1296: p_attribute14 IN VARCHAR2
1297: DEFAULT jtf_task_utl.g_miss_char,
1298: p_attribute15 IN VARCHAR2
1299: DEFAULT jtf_task_utl.g_miss_char,

Line 1297: DEFAULT jtf_task_utl.g_miss_char,

1293: DEFAULT jtf_task_utl.g_miss_char,
1294: p_attribute13 IN VARCHAR2
1295: DEFAULT jtf_task_utl.g_miss_char,
1296: p_attribute14 IN VARCHAR2
1297: DEFAULT jtf_task_utl.g_miss_char,
1298: p_attribute15 IN VARCHAR2
1299: DEFAULT jtf_task_utl.g_miss_char,
1300: p_attribute_category IN VARCHAR2
1301: DEFAULT jtf_task_utl.g_miss_char,

Line 1299: DEFAULT jtf_task_utl.g_miss_char,

1295: DEFAULT jtf_task_utl.g_miss_char,
1296: p_attribute14 IN VARCHAR2
1297: DEFAULT jtf_task_utl.g_miss_char,
1298: p_attribute15 IN VARCHAR2
1299: DEFAULT jtf_task_utl.g_miss_char,
1300: p_attribute_category IN VARCHAR2
1301: DEFAULT jtf_task_utl.g_miss_char,
1302: p_assignee_role IN VARCHAR2
1303: DEFAULT jtf_task_utl.g_miss_char,

Line 1301: DEFAULT jtf_task_utl.g_miss_char,

1297: DEFAULT jtf_task_utl.g_miss_char,
1298: p_attribute15 IN VARCHAR2
1299: DEFAULT jtf_task_utl.g_miss_char,
1300: p_attribute_category IN VARCHAR2
1301: DEFAULT jtf_task_utl.g_miss_char,
1302: p_assignee_role IN VARCHAR2
1303: DEFAULT jtf_task_utl.g_miss_char,
1304: p_show_on_calendar IN VARCHAR2
1305: DEFAULT jtf_task_utl.g_miss_char,

Line 1303: DEFAULT jtf_task_utl.g_miss_char,

1299: DEFAULT jtf_task_utl.g_miss_char,
1300: p_attribute_category IN VARCHAR2
1301: DEFAULT jtf_task_utl.g_miss_char,
1302: p_assignee_role IN VARCHAR2
1303: DEFAULT jtf_task_utl.g_miss_char,
1304: p_show_on_calendar IN VARCHAR2
1305: DEFAULT jtf_task_utl.g_miss_char,
1306: p_category_id IN NUMBER
1307: DEFAULT jtf_task_utl.g_miss_number,

Line 1305: DEFAULT jtf_task_utl.g_miss_char,

1301: DEFAULT jtf_task_utl.g_miss_char,
1302: p_assignee_role IN VARCHAR2
1303: DEFAULT jtf_task_utl.g_miss_char,
1304: p_show_on_calendar IN VARCHAR2
1305: DEFAULT jtf_task_utl.g_miss_char,
1306: p_category_id IN NUMBER
1307: DEFAULT jtf_task_utl.g_miss_number,
1308: p_enable_workflow IN VARCHAR2,
1309: p_abort_workflow IN VARCHAR2,

Line 1307: DEFAULT jtf_task_utl.g_miss_number,

1303: DEFAULT jtf_task_utl.g_miss_char,
1304: p_show_on_calendar IN VARCHAR2
1305: DEFAULT jtf_task_utl.g_miss_char,
1306: p_category_id IN NUMBER
1307: DEFAULT jtf_task_utl.g_miss_number,
1308: p_enable_workflow IN VARCHAR2,
1309: p_abort_workflow IN VARCHAR2,
1310: p_free_busy_type IN VARCHAR2,
1311: p_object_capacity_id IN NUMBER

Line 1531: jtf_task_utl.g_miss_number, category_id,

1527: p_show_on_calendar
1528: ) show_on_calendar,
1529: DECODE (
1530: p_category_id,
1531: jtf_task_utl.g_miss_number, category_id,
1532: p_category_id
1533: ) category_id,
1534: DECODE (
1535: p_attribute1,

Line 1616: jtf_task_utl.g_miss_char, free_busy_type,

1612: p_attribute_category
1613: ) attribute_category,
1614: DECODE (
1615: p_free_busy_type,
1616: jtf_task_utl.g_miss_char, free_busy_type,
1617: p_free_busy_type
1618: ) free_busy_type,
1619: DECODE (
1620: p_object_capacity_id,

Line 1643: ass_orig jtf_task_utl.c_ass_orig%ROWTYPE;

1639:
1640: -- Business Event System Enhancement # 2391065
1641: l_assignment_rec_old jtf_task_assignments_pvt.task_assignments_rec ;
1642: l_assignment_rec_new jtf_task_assignments_pvt.task_assignments_rec ;
1643: ass_orig jtf_task_utl.c_ass_orig%ROWTYPE;
1644: x_event_return_status varchar2(100);
1645:
1646: CURSOR c_task (b_task_id NUMBER) IS
1647: SELECT source_object_type_code

Line 1686: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);

1682: END IF;
1683: CLOSE task_ass_u;
1684:
1685: -- Business Event System Enhancement # 2391065
1686: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);
1687: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1688:
1689: IF jtf_task_utl.c_ass_orig%NOTFOUND
1690: THEN

Line 1687: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;

1683: CLOSE task_ass_u;
1684:
1685: -- Business Event System Enhancement # 2391065
1686: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);
1687: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1688:
1689: IF jtf_task_utl.c_ass_orig%NOTFOUND
1690: THEN
1691: CLOSE jtf_task_utl.c_ass_orig;

Line 1689: IF jtf_task_utl.c_ass_orig%NOTFOUND

1685: -- Business Event System Enhancement # 2391065
1686: OPEN jtf_task_utl.c_ass_orig(p_task_assignment_id);
1687: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1688:
1689: IF jtf_task_utl.c_ass_orig%NOTFOUND
1690: THEN
1691: CLOSE jtf_task_utl.c_ass_orig;
1692: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1693: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);

Line 1691: CLOSE jtf_task_utl.c_ass_orig;

1687: FETCH jtf_task_utl.c_ass_orig INTO ass_orig;
1688:
1689: IF jtf_task_utl.c_ass_orig%NOTFOUND
1690: THEN
1691: CLOSE jtf_task_utl.c_ass_orig;
1692: fnd_message.set_name ('JTF', 'JTF_TASK_INS_TK_ASS');
1693: fnd_message.set_token ('TASK_ASSIGNMENT', p_task_assignment_id);
1694: fnd_msg_pub.add;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1698: CLOSE jtf_task_utl.c_ass_orig;

1694: fnd_msg_pub.add;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: RAISE fnd_api.g_exc_unexpected_error;
1697: END IF;
1698: CLOSE jtf_task_utl.c_ass_orig;
1699:
1700: l_task_assignment_id := p_task_assignment_id;
1701: l_task_id := task_ass.task_id;
1702: l_resource_id := task_ass.resource_id;

Line 1764: IF g_response_flag = jtf_task_utl.g_no_char

1760: IF l_recurrence_rule_id IS NOT NULL AND
1761: l_source_object_type_code = 'APPOINTMENT' AND
1762: task_ass.old_assignment_status_id in ( 18 , 3 ) -- Invited
1763: THEN
1764: IF g_response_flag = jtf_task_utl.g_no_char
1765: THEN
1766: l_response_invitation_rec.task_assignment_id := p_task_assignment_id;
1767: l_response_invitation_rec.assignment_status_id := l_assignment_status_id;
1768: l_response_invitation_rec.task_id := l_task_id;

Line 1782: g_response_flag := jtf_task_utl.g_no_char;

1778: x_msg_count => x_msg_count,
1779: x_msg_data => x_msg_data
1780: );
1781:
1782: g_response_flag := jtf_task_utl.g_no_char;
1783:
1784: ----------------------------------------------------------------
1785: -- response_invitation() will call this procedure again
1786: -- to update the assignment status with accepted or rejected.

Line 1815: jtf_task_utl.check_security_privilege(

1811: END IF;
1812:
1813:
1814: -- Validate the user_id
1815: jtf_task_utl.check_security_privilege(
1816: p_task_id => l_task_id,
1817: p_session => l_session,
1818: x_return_status => x_return_status
1819: );

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

1824: RAISE fnd_api.g_exc_unexpected_error;
1825: END IF;
1826:
1827: --Bug 2467222 for assignee category update
1828: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)
1829: THEN
1830: UPDATE jtf_task_all_assignments
1831: SET category_id = p_category_id
1832: WHERE task_id = l_task_id

Line 1853: IF NOT jtf_task_utl.validate_lookup (

1849: l_assignee_role := 'ASSIGNEE';
1850: END IF;
1851:
1852: -- Validate the value in ASSIGNEE_ROLE
1853: IF NOT jtf_task_utl.validate_lookup (
1854: 'JTF_TASK_ASSIGNEE_ROLES',
1855: l_assignee_role,
1856: 'assignment assignee role ( JTF_TK_ASSOGNEE_ROLE )'
1857: )

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

1912: x_booking_end_date => l_booking_end_date
1913: );
1914:
1915: IF l_entity = 'TASK' AND
1916: p_free_busy_type = jtf_task_utl.g_miss_char AND -- no explicit value
1917: nvl(p_assignment_status_id, 0) <> fnd_api.g_miss_num AND
1918: nvl(l_old_assignment_status_id, 0) <> nvl(l_assignment_status_id, 0) -- Modified for bug# 5514013 on 11/09/2006
1919: THEN
1920: update_free_busy_type(

Line 1969: x_last_updated_by => jtf_task_utl.updated_by,

1965: x_sched_travel_distance => l_sched_travel_distance,
1966: x_sched_travel_duration => l_sched_travel_duration,
1967: x_resource_type_code => l_resource_type_code,
1968: x_last_update_date => SYSDATE,
1969: x_last_updated_by => jtf_task_utl.updated_by,
1970: x_last_update_login => jtf_task_utl.login_id,
1971: x_resource_territory_id => l_resource_territory_id,
1972: x_assignment_status_id => l_assignment_status_id,
1973: x_shift_construct_id => l_shift_construct_id,

Line 1970: x_last_update_login => jtf_task_utl.login_id,

1966: x_sched_travel_duration => l_sched_travel_duration,
1967: x_resource_type_code => l_resource_type_code,
1968: x_last_update_date => SYSDATE,
1969: x_last_updated_by => jtf_task_utl.updated_by,
1970: x_last_update_login => jtf_task_utl.login_id,
1971: x_resource_territory_id => l_resource_territory_id,
1972: x_assignment_status_id => l_assignment_status_id,
1973: x_shift_construct_id => l_shift_construct_id,
1974: x_assignee_role => l_assignee_role,

Line 1995: jtf_task_utl.delete_party_reference(

1991: if (nvl(l_resource_id, 0) <> fnd_api.g_miss_num and
1992: nvl(l_resource_id, 0) <> nvl(l_orig_res_id, 0))
1993: or (nvl(l_resource_type_code, fnd_api.g_miss_char) <> nvl(l_orig_res_type_code, fnd_api.g_miss_char)) then
1994: -- delete the old one
1995: jtf_task_utl.delete_party_reference(
1996: p_reference_from => 'ASSIGNMENT',
1997: p_task_id => l_task_id,
1998: p_party_type_code => l_orig_res_type_code,
1999: p_party_id => l_orig_res_id,

Line 2010: jtf_task_utl.create_party_reference(

2006: x_return_status := fnd_api.g_ret_sts_unexp_error;
2007: RAISE fnd_api.g_exc_unexpected_error;
2008: END IF;
2009: -- create a new one
2010: jtf_task_utl.create_party_reference(
2011: p_reference_from => 'ASSIGNMENT',
2012: p_task_id => l_task_id,
2013: p_party_type_code => l_resource_type_code,
2014: p_party_id => l_resource_id,

Line 2181: DEFAULT jtf_task_utl.g_miss_char,

2177: x_return_status OUT NOCOPY VARCHAR2,
2178: x_msg_count OUT NOCOPY NUMBER,
2179: x_msg_data OUT NOCOPY VARCHAR2,
2180: p_attribute1 IN VARCHAR2
2181: DEFAULT jtf_task_utl.g_miss_char,
2182: p_attribute2 IN VARCHAR2
2183: DEFAULT jtf_task_utl.g_miss_char,
2184: p_attribute3 IN VARCHAR2
2185: DEFAULT jtf_task_utl.g_miss_char,

Line 2183: DEFAULT jtf_task_utl.g_miss_char,

2179: x_msg_data OUT NOCOPY VARCHAR2,
2180: p_attribute1 IN VARCHAR2
2181: DEFAULT jtf_task_utl.g_miss_char,
2182: p_attribute2 IN VARCHAR2
2183: DEFAULT jtf_task_utl.g_miss_char,
2184: p_attribute3 IN VARCHAR2
2185: DEFAULT jtf_task_utl.g_miss_char,
2186: p_attribute4 IN VARCHAR2
2187: DEFAULT jtf_task_utl.g_miss_char,

Line 2185: DEFAULT jtf_task_utl.g_miss_char,

2181: DEFAULT jtf_task_utl.g_miss_char,
2182: p_attribute2 IN VARCHAR2
2183: DEFAULT jtf_task_utl.g_miss_char,
2184: p_attribute3 IN VARCHAR2
2185: DEFAULT jtf_task_utl.g_miss_char,
2186: p_attribute4 IN VARCHAR2
2187: DEFAULT jtf_task_utl.g_miss_char,
2188: p_attribute5 IN VARCHAR2
2189: DEFAULT jtf_task_utl.g_miss_char,

Line 2187: DEFAULT jtf_task_utl.g_miss_char,

2183: DEFAULT jtf_task_utl.g_miss_char,
2184: p_attribute3 IN VARCHAR2
2185: DEFAULT jtf_task_utl.g_miss_char,
2186: p_attribute4 IN VARCHAR2
2187: DEFAULT jtf_task_utl.g_miss_char,
2188: p_attribute5 IN VARCHAR2
2189: DEFAULT jtf_task_utl.g_miss_char,
2190: p_attribute6 IN VARCHAR2
2191: DEFAULT jtf_task_utl.g_miss_char,

Line 2189: DEFAULT jtf_task_utl.g_miss_char,

2185: DEFAULT jtf_task_utl.g_miss_char,
2186: p_attribute4 IN VARCHAR2
2187: DEFAULT jtf_task_utl.g_miss_char,
2188: p_attribute5 IN VARCHAR2
2189: DEFAULT jtf_task_utl.g_miss_char,
2190: p_attribute6 IN VARCHAR2
2191: DEFAULT jtf_task_utl.g_miss_char,
2192: p_attribute7 IN VARCHAR2
2193: DEFAULT jtf_task_utl.g_miss_char,

Line 2191: DEFAULT jtf_task_utl.g_miss_char,

2187: DEFAULT jtf_task_utl.g_miss_char,
2188: p_attribute5 IN VARCHAR2
2189: DEFAULT jtf_task_utl.g_miss_char,
2190: p_attribute6 IN VARCHAR2
2191: DEFAULT jtf_task_utl.g_miss_char,
2192: p_attribute7 IN VARCHAR2
2193: DEFAULT jtf_task_utl.g_miss_char,
2194: p_attribute8 IN VARCHAR2
2195: DEFAULT jtf_task_utl.g_miss_char,

Line 2193: DEFAULT jtf_task_utl.g_miss_char,

2189: DEFAULT jtf_task_utl.g_miss_char,
2190: p_attribute6 IN VARCHAR2
2191: DEFAULT jtf_task_utl.g_miss_char,
2192: p_attribute7 IN VARCHAR2
2193: DEFAULT jtf_task_utl.g_miss_char,
2194: p_attribute8 IN VARCHAR2
2195: DEFAULT jtf_task_utl.g_miss_char,
2196: p_attribute9 IN VARCHAR2
2197: DEFAULT jtf_task_utl.g_miss_char,

Line 2195: DEFAULT jtf_task_utl.g_miss_char,

2191: DEFAULT jtf_task_utl.g_miss_char,
2192: p_attribute7 IN VARCHAR2
2193: DEFAULT jtf_task_utl.g_miss_char,
2194: p_attribute8 IN VARCHAR2
2195: DEFAULT jtf_task_utl.g_miss_char,
2196: p_attribute9 IN VARCHAR2
2197: DEFAULT jtf_task_utl.g_miss_char,
2198: p_attribute10 IN VARCHAR2
2199: DEFAULT jtf_task_utl.g_miss_char,

Line 2197: DEFAULT jtf_task_utl.g_miss_char,

2193: DEFAULT jtf_task_utl.g_miss_char,
2194: p_attribute8 IN VARCHAR2
2195: DEFAULT jtf_task_utl.g_miss_char,
2196: p_attribute9 IN VARCHAR2
2197: DEFAULT jtf_task_utl.g_miss_char,
2198: p_attribute10 IN VARCHAR2
2199: DEFAULT jtf_task_utl.g_miss_char,
2200: p_attribute11 IN VARCHAR2
2201: DEFAULT jtf_task_utl.g_miss_char,

Line 2199: DEFAULT jtf_task_utl.g_miss_char,

2195: DEFAULT jtf_task_utl.g_miss_char,
2196: p_attribute9 IN VARCHAR2
2197: DEFAULT jtf_task_utl.g_miss_char,
2198: p_attribute10 IN VARCHAR2
2199: DEFAULT jtf_task_utl.g_miss_char,
2200: p_attribute11 IN VARCHAR2
2201: DEFAULT jtf_task_utl.g_miss_char,
2202: p_attribute12 IN VARCHAR2
2203: DEFAULT jtf_task_utl.g_miss_char,

Line 2201: DEFAULT jtf_task_utl.g_miss_char,

2197: DEFAULT jtf_task_utl.g_miss_char,
2198: p_attribute10 IN VARCHAR2
2199: DEFAULT jtf_task_utl.g_miss_char,
2200: p_attribute11 IN VARCHAR2
2201: DEFAULT jtf_task_utl.g_miss_char,
2202: p_attribute12 IN VARCHAR2
2203: DEFAULT jtf_task_utl.g_miss_char,
2204: p_attribute13 IN VARCHAR2
2205: DEFAULT jtf_task_utl.g_miss_char,

Line 2203: DEFAULT jtf_task_utl.g_miss_char,

2199: DEFAULT jtf_task_utl.g_miss_char,
2200: p_attribute11 IN VARCHAR2
2201: DEFAULT jtf_task_utl.g_miss_char,
2202: p_attribute12 IN VARCHAR2
2203: DEFAULT jtf_task_utl.g_miss_char,
2204: p_attribute13 IN VARCHAR2
2205: DEFAULT jtf_task_utl.g_miss_char,
2206: p_attribute14 IN VARCHAR2
2207: DEFAULT jtf_task_utl.g_miss_char,

Line 2205: DEFAULT jtf_task_utl.g_miss_char,

2201: DEFAULT jtf_task_utl.g_miss_char,
2202: p_attribute12 IN VARCHAR2
2203: DEFAULT jtf_task_utl.g_miss_char,
2204: p_attribute13 IN VARCHAR2
2205: DEFAULT jtf_task_utl.g_miss_char,
2206: p_attribute14 IN VARCHAR2
2207: DEFAULT jtf_task_utl.g_miss_char,
2208: p_attribute15 IN VARCHAR2
2209: DEFAULT jtf_task_utl.g_miss_char,

Line 2207: DEFAULT jtf_task_utl.g_miss_char,

2203: DEFAULT jtf_task_utl.g_miss_char,
2204: p_attribute13 IN VARCHAR2
2205: DEFAULT jtf_task_utl.g_miss_char,
2206: p_attribute14 IN VARCHAR2
2207: DEFAULT jtf_task_utl.g_miss_char,
2208: p_attribute15 IN VARCHAR2
2209: DEFAULT jtf_task_utl.g_miss_char,
2210: p_attribute_category IN VARCHAR2
2211: DEFAULT jtf_task_utl.g_miss_char,

Line 2209: DEFAULT jtf_task_utl.g_miss_char,

2205: DEFAULT jtf_task_utl.g_miss_char,
2206: p_attribute14 IN VARCHAR2
2207: DEFAULT jtf_task_utl.g_miss_char,
2208: p_attribute15 IN VARCHAR2
2209: DEFAULT jtf_task_utl.g_miss_char,
2210: p_attribute_category IN VARCHAR2
2211: DEFAULT jtf_task_utl.g_miss_char,
2212: p_assignee_role IN VARCHAR2
2213: DEFAULT jtf_task_utl.g_miss_char,

Line 2211: DEFAULT jtf_task_utl.g_miss_char,

2207: DEFAULT jtf_task_utl.g_miss_char,
2208: p_attribute15 IN VARCHAR2
2209: DEFAULT jtf_task_utl.g_miss_char,
2210: p_attribute_category IN VARCHAR2
2211: DEFAULT jtf_task_utl.g_miss_char,
2212: p_assignee_role IN VARCHAR2
2213: DEFAULT jtf_task_utl.g_miss_char,
2214: p_show_on_calendar IN VARCHAR2
2215: DEFAULT jtf_task_utl.g_miss_char,

Line 2213: DEFAULT jtf_task_utl.g_miss_char,

2209: DEFAULT jtf_task_utl.g_miss_char,
2210: p_attribute_category IN VARCHAR2
2211: DEFAULT jtf_task_utl.g_miss_char,
2212: p_assignee_role IN VARCHAR2
2213: DEFAULT jtf_task_utl.g_miss_char,
2214: p_show_on_calendar IN VARCHAR2
2215: DEFAULT jtf_task_utl.g_miss_char,
2216: p_category_id IN NUMBER
2217: DEFAULT jtf_task_utl.g_miss_number

Line 2215: DEFAULT jtf_task_utl.g_miss_char,

2211: DEFAULT jtf_task_utl.g_miss_char,
2212: p_assignee_role IN VARCHAR2
2213: DEFAULT jtf_task_utl.g_miss_char,
2214: p_show_on_calendar IN VARCHAR2
2215: DEFAULT jtf_task_utl.g_miss_char,
2216: p_category_id IN NUMBER
2217: DEFAULT jtf_task_utl.g_miss_number
2218: )
2219: IS

Line 2217: DEFAULT jtf_task_utl.g_miss_number

2213: DEFAULT jtf_task_utl.g_miss_char,
2214: p_show_on_calendar IN VARCHAR2
2215: DEFAULT jtf_task_utl.g_miss_char,
2216: p_category_id IN NUMBER
2217: DEFAULT jtf_task_utl.g_miss_number
2218: )
2219: IS
2220: BEGIN
2221: jtf_task_assignments_pvt.update_task_assignment (

Line 2336: DEFAULT jtf_task_utl.g_miss_char,

2332: x_return_status OUT NOCOPY VARCHAR2,
2333: x_msg_count OUT NOCOPY NUMBER,
2334: x_msg_data OUT NOCOPY VARCHAR2,
2335: p_attribute1 IN VARCHAR2
2336: DEFAULT jtf_task_utl.g_miss_char,
2337: p_attribute2 IN VARCHAR2
2338: DEFAULT jtf_task_utl.g_miss_char,
2339: p_attribute3 IN VARCHAR2
2340: DEFAULT jtf_task_utl.g_miss_char,

Line 2338: DEFAULT jtf_task_utl.g_miss_char,

2334: x_msg_data OUT NOCOPY VARCHAR2,
2335: p_attribute1 IN VARCHAR2
2336: DEFAULT jtf_task_utl.g_miss_char,
2337: p_attribute2 IN VARCHAR2
2338: DEFAULT jtf_task_utl.g_miss_char,
2339: p_attribute3 IN VARCHAR2
2340: DEFAULT jtf_task_utl.g_miss_char,
2341: p_attribute4 IN VARCHAR2
2342: DEFAULT jtf_task_utl.g_miss_char,

Line 2340: DEFAULT jtf_task_utl.g_miss_char,

2336: DEFAULT jtf_task_utl.g_miss_char,
2337: p_attribute2 IN VARCHAR2
2338: DEFAULT jtf_task_utl.g_miss_char,
2339: p_attribute3 IN VARCHAR2
2340: DEFAULT jtf_task_utl.g_miss_char,
2341: p_attribute4 IN VARCHAR2
2342: DEFAULT jtf_task_utl.g_miss_char,
2343: p_attribute5 IN VARCHAR2
2344: DEFAULT jtf_task_utl.g_miss_char,

Line 2342: DEFAULT jtf_task_utl.g_miss_char,

2338: DEFAULT jtf_task_utl.g_miss_char,
2339: p_attribute3 IN VARCHAR2
2340: DEFAULT jtf_task_utl.g_miss_char,
2341: p_attribute4 IN VARCHAR2
2342: DEFAULT jtf_task_utl.g_miss_char,
2343: p_attribute5 IN VARCHAR2
2344: DEFAULT jtf_task_utl.g_miss_char,
2345: p_attribute6 IN VARCHAR2
2346: DEFAULT jtf_task_utl.g_miss_char,

Line 2344: DEFAULT jtf_task_utl.g_miss_char,

2340: DEFAULT jtf_task_utl.g_miss_char,
2341: p_attribute4 IN VARCHAR2
2342: DEFAULT jtf_task_utl.g_miss_char,
2343: p_attribute5 IN VARCHAR2
2344: DEFAULT jtf_task_utl.g_miss_char,
2345: p_attribute6 IN VARCHAR2
2346: DEFAULT jtf_task_utl.g_miss_char,
2347: p_attribute7 IN VARCHAR2
2348: DEFAULT jtf_task_utl.g_miss_char,

Line 2346: DEFAULT jtf_task_utl.g_miss_char,

2342: DEFAULT jtf_task_utl.g_miss_char,
2343: p_attribute5 IN VARCHAR2
2344: DEFAULT jtf_task_utl.g_miss_char,
2345: p_attribute6 IN VARCHAR2
2346: DEFAULT jtf_task_utl.g_miss_char,
2347: p_attribute7 IN VARCHAR2
2348: DEFAULT jtf_task_utl.g_miss_char,
2349: p_attribute8 IN VARCHAR2
2350: DEFAULT jtf_task_utl.g_miss_char,

Line 2348: DEFAULT jtf_task_utl.g_miss_char,

2344: DEFAULT jtf_task_utl.g_miss_char,
2345: p_attribute6 IN VARCHAR2
2346: DEFAULT jtf_task_utl.g_miss_char,
2347: p_attribute7 IN VARCHAR2
2348: DEFAULT jtf_task_utl.g_miss_char,
2349: p_attribute8 IN VARCHAR2
2350: DEFAULT jtf_task_utl.g_miss_char,
2351: p_attribute9 IN VARCHAR2
2352: DEFAULT jtf_task_utl.g_miss_char,

Line 2350: DEFAULT jtf_task_utl.g_miss_char,

2346: DEFAULT jtf_task_utl.g_miss_char,
2347: p_attribute7 IN VARCHAR2
2348: DEFAULT jtf_task_utl.g_miss_char,
2349: p_attribute8 IN VARCHAR2
2350: DEFAULT jtf_task_utl.g_miss_char,
2351: p_attribute9 IN VARCHAR2
2352: DEFAULT jtf_task_utl.g_miss_char,
2353: p_attribute10 IN VARCHAR2
2354: DEFAULT jtf_task_utl.g_miss_char,

Line 2352: DEFAULT jtf_task_utl.g_miss_char,

2348: DEFAULT jtf_task_utl.g_miss_char,
2349: p_attribute8 IN VARCHAR2
2350: DEFAULT jtf_task_utl.g_miss_char,
2351: p_attribute9 IN VARCHAR2
2352: DEFAULT jtf_task_utl.g_miss_char,
2353: p_attribute10 IN VARCHAR2
2354: DEFAULT jtf_task_utl.g_miss_char,
2355: p_attribute11 IN VARCHAR2
2356: DEFAULT jtf_task_utl.g_miss_char,

Line 2354: DEFAULT jtf_task_utl.g_miss_char,

2350: DEFAULT jtf_task_utl.g_miss_char,
2351: p_attribute9 IN VARCHAR2
2352: DEFAULT jtf_task_utl.g_miss_char,
2353: p_attribute10 IN VARCHAR2
2354: DEFAULT jtf_task_utl.g_miss_char,
2355: p_attribute11 IN VARCHAR2
2356: DEFAULT jtf_task_utl.g_miss_char,
2357: p_attribute12 IN VARCHAR2
2358: DEFAULT jtf_task_utl.g_miss_char,

Line 2356: DEFAULT jtf_task_utl.g_miss_char,

2352: DEFAULT jtf_task_utl.g_miss_char,
2353: p_attribute10 IN VARCHAR2
2354: DEFAULT jtf_task_utl.g_miss_char,
2355: p_attribute11 IN VARCHAR2
2356: DEFAULT jtf_task_utl.g_miss_char,
2357: p_attribute12 IN VARCHAR2
2358: DEFAULT jtf_task_utl.g_miss_char,
2359: p_attribute13 IN VARCHAR2
2360: DEFAULT jtf_task_utl.g_miss_char,

Line 2358: DEFAULT jtf_task_utl.g_miss_char,

2354: DEFAULT jtf_task_utl.g_miss_char,
2355: p_attribute11 IN VARCHAR2
2356: DEFAULT jtf_task_utl.g_miss_char,
2357: p_attribute12 IN VARCHAR2
2358: DEFAULT jtf_task_utl.g_miss_char,
2359: p_attribute13 IN VARCHAR2
2360: DEFAULT jtf_task_utl.g_miss_char,
2361: p_attribute14 IN VARCHAR2
2362: DEFAULT jtf_task_utl.g_miss_char,

Line 2360: DEFAULT jtf_task_utl.g_miss_char,

2356: DEFAULT jtf_task_utl.g_miss_char,
2357: p_attribute12 IN VARCHAR2
2358: DEFAULT jtf_task_utl.g_miss_char,
2359: p_attribute13 IN VARCHAR2
2360: DEFAULT jtf_task_utl.g_miss_char,
2361: p_attribute14 IN VARCHAR2
2362: DEFAULT jtf_task_utl.g_miss_char,
2363: p_attribute15 IN VARCHAR2
2364: DEFAULT jtf_task_utl.g_miss_char,

Line 2362: DEFAULT jtf_task_utl.g_miss_char,

2358: DEFAULT jtf_task_utl.g_miss_char,
2359: p_attribute13 IN VARCHAR2
2360: DEFAULT jtf_task_utl.g_miss_char,
2361: p_attribute14 IN VARCHAR2
2362: DEFAULT jtf_task_utl.g_miss_char,
2363: p_attribute15 IN VARCHAR2
2364: DEFAULT jtf_task_utl.g_miss_char,
2365: p_attribute_category IN VARCHAR2
2366: DEFAULT jtf_task_utl.g_miss_char,

Line 2364: DEFAULT jtf_task_utl.g_miss_char,

2360: DEFAULT jtf_task_utl.g_miss_char,
2361: p_attribute14 IN VARCHAR2
2362: DEFAULT jtf_task_utl.g_miss_char,
2363: p_attribute15 IN VARCHAR2
2364: DEFAULT jtf_task_utl.g_miss_char,
2365: p_attribute_category IN VARCHAR2
2366: DEFAULT jtf_task_utl.g_miss_char,
2367: p_assignee_role IN VARCHAR2
2368: DEFAULT jtf_task_utl.g_miss_char,

Line 2366: DEFAULT jtf_task_utl.g_miss_char,

2362: DEFAULT jtf_task_utl.g_miss_char,
2363: p_attribute15 IN VARCHAR2
2364: DEFAULT jtf_task_utl.g_miss_char,
2365: p_attribute_category IN VARCHAR2
2366: DEFAULT jtf_task_utl.g_miss_char,
2367: p_assignee_role IN VARCHAR2
2368: DEFAULT jtf_task_utl.g_miss_char,
2369: p_show_on_calendar IN VARCHAR2
2370: DEFAULT jtf_task_utl.g_miss_char,

Line 2368: DEFAULT jtf_task_utl.g_miss_char,

2364: DEFAULT jtf_task_utl.g_miss_char,
2365: p_attribute_category IN VARCHAR2
2366: DEFAULT jtf_task_utl.g_miss_char,
2367: p_assignee_role IN VARCHAR2
2368: DEFAULT jtf_task_utl.g_miss_char,
2369: p_show_on_calendar IN VARCHAR2
2370: DEFAULT jtf_task_utl.g_miss_char,
2371: p_category_id IN NUMBER
2372: DEFAULT jtf_task_utl.g_miss_number,

Line 2370: DEFAULT jtf_task_utl.g_miss_char,

2366: DEFAULT jtf_task_utl.g_miss_char,
2367: p_assignee_role IN VARCHAR2
2368: DEFAULT jtf_task_utl.g_miss_char,
2369: p_show_on_calendar IN VARCHAR2
2370: DEFAULT jtf_task_utl.g_miss_char,
2371: p_category_id IN NUMBER
2372: DEFAULT jtf_task_utl.g_miss_number,
2373: p_enable_workflow IN VARCHAR2,
2374: p_abort_workflow IN VARCHAR2

Line 2372: DEFAULT jtf_task_utl.g_miss_number,

2368: DEFAULT jtf_task_utl.g_miss_char,
2369: p_show_on_calendar IN VARCHAR2
2370: DEFAULT jtf_task_utl.g_miss_char,
2371: p_category_id IN NUMBER
2372: DEFAULT jtf_task_utl.g_miss_number,
2373: p_enable_workflow IN VARCHAR2,
2374: p_abort_workflow IN VARCHAR2
2375: )
2376: IS

Line 2600: jtf_task_utl.check_security_privilege(

2596: RAISE fnd_api.g_exc_unexpected_error;
2597: END IF;
2598: CLOSE ass_res_orig; -- Fix a missing CLOSE on 4/18/2002
2599:
2600: jtf_task_utl.check_security_privilege(
2601: p_task_id => l_task_id,
2602: p_session => l_session,
2603: x_return_status => x_return_status
2604: );

Line 2639: jtf_task_utl.delete_party_reference(

2635:
2636: -- ------------------------------------------------------------------------
2637: -- Delete reference to resource, fix enh #1845501
2638: -- ------------------------------------------------------------------------
2639: jtf_task_utl.delete_party_reference(
2640: p_reference_from => 'ASSIGNMENT',
2641: p_task_id => l_task_id,
2642: p_party_type_code => l_resource_type_code,
2643: p_party_id => l_resource_id,