APPS.JTF_TASK_ASSIGNMENTS_PUB dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 68: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

64: l_api_version CONSTANT NUMBER
65: := 1.0;
66: l_api_name CONSTANT VARCHAR(30)
67: := 'CREATE_TASK_ASSIGNMENT';
68: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
69: l_task_id jtf_tasks_b.task_id%TYPE
70: := p_task_id;
71: l_task_number jtf_tasks_b.task_number%TYPE
72: := p_task_number;

Line 73: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE

69: l_task_id jtf_tasks_b.task_id%TYPE
70: := p_task_id;
71: l_task_number jtf_tasks_b.task_number%TYPE
72: := p_task_number;
73: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
74: := p_resource_type_code;
75: l_resource_id NUMBER
76: := p_resource_id;
77: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

Line 77: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

73: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
74: := p_resource_type_code;
75: l_resource_id NUMBER
76: := p_resource_id;
77: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
78: := p_actual_effort;
79: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
80: := p_actual_effort_uom;
81: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

Line 79: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

75: l_resource_id NUMBER
76: := p_resource_id;
77: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
78: := p_actual_effort;
79: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
80: := p_actual_effort_uom;
81: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
82: := p_schedule_flag;
83: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

Line 81: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

77: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
78: := p_actual_effort;
79: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
80: := p_actual_effort_uom;
81: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
82: := p_schedule_flag;
83: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
84: := p_alarm_type_code;
85: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

Line 83: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

79: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
80: := p_actual_effort_uom;
81: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
82: := p_schedule_flag;
83: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
84: := p_alarm_type_code;
85: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
86: := p_alarm_contact;
87: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

Line 85: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

81: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
82: := p_schedule_flag;
83: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
84: := p_alarm_type_code;
85: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
86: := p_alarm_contact;
87: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
88: := p_sched_travel_distance;
89: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

Line 87: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

83: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
84: := p_alarm_type_code;
85: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
86: := p_alarm_contact;
87: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
88: := p_sched_travel_distance;
89: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
90: := p_sched_travel_duration;
91: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

Line 89: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

85: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
86: := p_alarm_contact;
87: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
88: := p_sched_travel_distance;
89: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
90: := p_sched_travel_duration;
91: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
92: := p_sched_travel_duration_uom;
93: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

Line 91: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

87: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
88: := p_sched_travel_distance;
89: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
90: := p_sched_travel_duration;
91: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
92: := p_sched_travel_duration_uom;
93: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
94: := p_actual_travel_distance;
95: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

Line 93: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

89: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
90: := p_sched_travel_duration;
91: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
92: := p_sched_travel_duration_uom;
93: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
94: := p_actual_travel_distance;
95: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
96: := p_actual_travel_duration;
97: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

Line 95: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

91: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
92: := p_sched_travel_duration_uom;
93: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
94: := p_actual_travel_distance;
95: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
96: := p_actual_travel_duration;
97: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
98: := p_actual_travel_duration_uom;
99: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

Line 97: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

93: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
94: := p_actual_travel_distance;
95: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
96: := p_actual_travel_duration;
97: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
98: := p_actual_travel_duration_uom;
99: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
100: := p_actual_start_date;
101: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

Line 99: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

95: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
96: := p_actual_travel_duration;
97: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
98: := p_actual_travel_duration_uom;
99: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
100: := p_actual_start_date;
101: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
102: := p_actual_end_date;
103: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

Line 101: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

97: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
98: := p_actual_travel_duration_uom;
99: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
100: := p_actual_start_date;
101: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
102: := p_actual_end_date;
103: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
104: := p_palm_flag;
105: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

Line 103: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

99: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
100: := p_actual_start_date;
101: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
102: := p_actual_end_date;
103: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
104: := p_palm_flag;
105: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
106: := p_wince_flag;
107: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

Line 105: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

101: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
102: := p_actual_end_date;
103: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
104: := p_palm_flag;
105: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
106: := p_wince_flag;
107: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
108: := p_laptop_flag;
109: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

Line 107: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

103: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
104: := p_palm_flag;
105: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
106: := p_wince_flag;
107: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
108: := p_laptop_flag;
109: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
110: := p_device1_flag;
111: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

Line 109: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

105: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
106: := p_wince_flag;
107: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
108: := p_laptop_flag;
109: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
110: := p_device1_flag;
111: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
112: := p_device2_flag;
113: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

Line 111: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

107: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
108: := p_laptop_flag;
109: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
110: := p_device1_flag;
111: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
112: := p_device2_flag;
113: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
114: := p_device3_flag;
115: l_msg_data VARCHAR2(2000);

Line 113: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

109: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
110: := p_device1_flag;
111: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
112: := p_device2_flag;
113: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
114: := p_device3_flag;
115: l_msg_data VARCHAR2(2000);
116: l_msg_count NUMBER;
117: x CHAR;

Line 119: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE

115: l_msg_data VARCHAR2(2000);
116: l_msg_count NUMBER;
117: x CHAR;
118: l_rowid ROWID;
119: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
120: := p_resource_territory_id;
121: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
122: := p_assignment_status_id;
123: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

Line 121: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE

117: x CHAR;
118: l_rowid ROWID;
119: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
120: := p_resource_territory_id;
121: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
122: := p_assignment_status_id;
123: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
124: := p_shift_construct_id;
125: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

Line 123: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

119: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
120: := p_resource_territory_id;
121: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
122: := p_assignment_status_id;
123: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
124: := p_shift_construct_id;
125: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
126: := p_show_on_calendar;
127: l_category_id jtf_task_all_assignments.category_id%TYPE

Line 125: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

121: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
122: := p_assignment_status_id;
123: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
124: := p_shift_construct_id;
125: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
126: := p_show_on_calendar;
127: l_category_id jtf_task_all_assignments.category_id%TYPE
128: := p_category_id;
129: l_enable_workflow VARCHAR2(1) := p_enable_workflow;

Line 127: l_category_id jtf_task_all_assignments.category_id%TYPE

123: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
124: := p_shift_construct_id;
125: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
126: := p_show_on_calendar;
127: l_category_id jtf_task_all_assignments.category_id%TYPE
128: := p_category_id;
129: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
130: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
131:

Line 1260: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE

1256: l_api_name CONSTANT VARCHAR(30)
1257: := 'Update_Task_Assignment';
1258: l_return_status VARCHAR2(1)
1259: := fnd_api.g_ret_sts_success;
1260: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1261: := p_task_assignment_id;
1262: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1263: := p_resource_type_code;
1264: l_resource_id jtf_task_all_assignments.resource_id%TYPE

Line 1262: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE

1258: l_return_status VARCHAR2(1)
1259: := fnd_api.g_ret_sts_success;
1260: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1261: := p_task_assignment_id;
1262: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1263: := p_resource_type_code;
1264: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1265: := p_resource_id;
1266: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

Line 1264: l_resource_id jtf_task_all_assignments.resource_id%TYPE

1260: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1261: := p_task_assignment_id;
1262: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1263: := p_resource_type_code;
1264: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1265: := p_resource_id;
1266: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1267: := p_actual_effort;
1268: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

Line 1266: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

1262: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1263: := p_resource_type_code;
1264: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1265: := p_resource_id;
1266: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1267: := p_actual_effort;
1268: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1269: := p_actual_effort_uom;
1270: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

Line 1268: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

1264: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1265: := p_resource_id;
1266: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1267: := p_actual_effort;
1268: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1269: := p_actual_effort_uom;
1270: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1271: := p_schedule_flag;
1272: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

Line 1270: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

1266: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1267: := p_actual_effort;
1268: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1269: := p_actual_effort_uom;
1270: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1271: := p_schedule_flag;
1272: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1273: := p_alarm_type_code;
1274: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

Line 1272: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

1268: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1269: := p_actual_effort_uom;
1270: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1271: := p_schedule_flag;
1272: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1273: := p_alarm_type_code;
1274: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1275: := p_alarm_contact;
1276: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

Line 1274: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

1270: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1271: := p_schedule_flag;
1272: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1273: := p_alarm_type_code;
1274: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1275: := p_alarm_contact;
1276: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1277: := p_sched_travel_distance;
1278: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

Line 1276: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

1272: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1273: := p_alarm_type_code;
1274: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1275: := p_alarm_contact;
1276: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1277: := p_sched_travel_distance;
1278: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1279: := p_sched_travel_duration;
1280: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

Line 1278: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

1274: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1275: := p_alarm_contact;
1276: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1277: := p_sched_travel_distance;
1278: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1279: := p_sched_travel_duration;
1280: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1281: := p_sched_travel_duration_uom;
1282: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

Line 1280: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

1276: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1277: := p_sched_travel_distance;
1278: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1279: := p_sched_travel_duration;
1280: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1281: := p_sched_travel_duration_uom;
1282: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1283: := p_actual_travel_distance;
1284: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

Line 1282: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

1278: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1279: := p_sched_travel_duration;
1280: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1281: := p_sched_travel_duration_uom;
1282: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1283: := p_actual_travel_distance;
1284: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1285: := p_actual_travel_duration;
1286: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

Line 1284: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

1280: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1281: := p_sched_travel_duration_uom;
1282: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1283: := p_actual_travel_distance;
1284: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1285: := p_actual_travel_duration;
1286: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1287: := p_actual_travel_duration_uom;
1288: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

Line 1286: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

1282: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1283: := p_actual_travel_distance;
1284: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1285: := p_actual_travel_duration;
1286: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1287: := p_actual_travel_duration_uom;
1288: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1289: := p_actual_start_date;
1290: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

Line 1288: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

1284: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1285: := p_actual_travel_duration;
1286: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1287: := p_actual_travel_duration_uom;
1288: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1289: := p_actual_start_date;
1290: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1291: := p_actual_end_date;
1292: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

Line 1290: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

1286: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1287: := p_actual_travel_duration_uom;
1288: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1289: := p_actual_start_date;
1290: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1291: := p_actual_end_date;
1292: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1293: := p_palm_flag;
1294: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

Line 1292: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

1288: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1289: := p_actual_start_date;
1290: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1291: := p_actual_end_date;
1292: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1293: := p_palm_flag;
1294: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1295: := p_wince_flag;
1296: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

Line 1294: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

1290: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1291: := p_actual_end_date;
1292: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1293: := p_palm_flag;
1294: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1295: := p_wince_flag;
1296: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1297: := p_laptop_flag;
1298: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

Line 1296: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

1292: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1293: := p_palm_flag;
1294: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1295: := p_wince_flag;
1296: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1297: := p_laptop_flag;
1298: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1299: := p_device1_flag;
1300: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

Line 1298: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

1294: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1295: := p_wince_flag;
1296: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1297: := p_laptop_flag;
1298: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1299: := p_device1_flag;
1300: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1301: := p_device2_flag;
1302: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

Line 1300: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

1296: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1297: := p_laptop_flag;
1298: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1299: := p_device1_flag;
1300: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1301: := p_device2_flag;
1302: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
1303: := p_device3_flag;
1304: l_msg_data VARCHAR2(2000);

Line 1302: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

1298: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1299: := p_device1_flag;
1300: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1301: := p_device2_flag;
1302: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
1303: := p_device3_flag;
1304: l_msg_data VARCHAR2(2000);
1305: l_msg_count NUMBER;
1306: x CHAR;

Line 1308: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE

1304: l_msg_data VARCHAR2(2000);
1305: l_msg_count NUMBER;
1306: x CHAR;
1307: l_rowid ROWID;
1308: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1309: := p_resource_territory_id;
1310: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1311: := p_assignment_status_id;
1312: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

Line 1310: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE

1306: x CHAR;
1307: l_rowid ROWID;
1308: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1309: := p_resource_territory_id;
1310: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1311: := p_assignment_status_id;
1312: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1313: := p_shift_construct_id;
1314: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

Line 1312: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

1308: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1309: := p_resource_territory_id;
1310: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1311: := p_assignment_status_id;
1312: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1313: := p_shift_construct_id;
1314: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1315: := p_show_on_calendar;
1316: l_category_id jtf_task_all_assignments.category_id%TYPE

Line 1314: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

1310: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1311: := p_assignment_status_id;
1312: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1313: := p_shift_construct_id;
1314: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1315: := p_show_on_calendar;
1316: l_category_id jtf_task_all_assignments.category_id%TYPE
1317: := p_category_id;
1318: l_type varchar2(15) :='ASSIGNMENT';

Line 1316: l_category_id jtf_task_all_assignments.category_id%TYPE

1312: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1313: := p_shift_construct_id;
1314: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1315: := p_show_on_calendar;
1316: l_category_id jtf_task_all_assignments.category_id%TYPE
1317: := p_category_id;
1318: l_type varchar2(15) :='ASSIGNMENT';
1319: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1320: l_abort_workflow VARCHAR2(1) := p_abort_workflow;

Line 1535: FROM jtf_task_all_assignments

1531: p_attribute_category,
1532: fnd_api.g_miss_char, attribute_category,
1533: p_attribute_category
1534: ) attribute_category
1535: FROM jtf_task_all_assignments
1536: WHERE task_assignment_id = l_task_assignment_id;
1537:
1538: task_ass_rec task_ass_u%ROWTYPE;
1539: BEGIN

Line 2508: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE

2504: l_return_status VARCHAR2(1)
2505: := fnd_api.g_ret_sts_success;
2506: l_msg_data VARCHAR2(2000);
2507: l_msg_count NUMBER;
2508: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
2509: := p_task_assignment_id;
2510: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
2511: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
2512:

Line 2516: FROM jtf_task_all_assignments

2512:
2513: CURSOR ra_d
2514: IS
2515: SELECT 1
2516: FROM jtf_task_all_assignments
2517: WHERE task_assignment_id = l_task_assignment_id;
2518:
2519: x CHAR;
2520: BEGIN