91: x_attribute14 => p_attribute14 ,
92: x_attribute15 => p_attribute15,
93: x_attribute_category => p_attribute_category ,
94: x_creation_date => SYSDATE,
95: x_created_by => jtf_task_utl.created_by,
96: x_last_update_date => SYSDATE,
97: x_last_updated_by => jtf_task_utl.updated_by,
98: x_last_update_login => jtf_task_utl.login_id
99: );
93: x_attribute_category => p_attribute_category ,
94: x_creation_date => SYSDATE,
95: x_created_by => jtf_task_utl.created_by,
96: x_last_update_date => SYSDATE,
97: x_last_updated_by => jtf_task_utl.updated_by,
98: x_last_update_login => jtf_task_utl.login_id
99: );
100:
101: OPEN c_jtf_task_dates (l_rowid);
94: x_creation_date => SYSDATE,
95: x_created_by => jtf_task_utl.created_by,
96: x_last_update_date => SYSDATE,
97: x_last_updated_by => jtf_task_utl.updated_by,
98: x_last_update_login => jtf_task_utl.login_id
99: );
100:
101: OPEN c_jtf_task_dates (l_rowid);
102: FETCH c_jtf_task_dates INTO x;
144: p_date_value IN DATE DEFAULT fnd_api.g_miss_date,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
149: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
149: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
149: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
149: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
148: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
149: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
149: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
150: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
151: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
152: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
153: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
154: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
155: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
163: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
156: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
163: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
164: )
157: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
163: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
164: )
165: IS
158: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
163: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
164: )
165: IS
166: l_api_version CONSTANT NUMBER := 1.0;
159: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
160: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
161: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
162: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
163: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
164: )
165: IS
166: l_api_version CONSTANT NUMBER := 1.0;
167: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DATES';
282: x_attribute15 => task_dates.attribute15 ,
283: x_attribute_category => task_dates.attribute_category,
284: x_date_value => l_date_value,
285: x_last_update_date => SYSDATE,
286: x_last_updated_by => jtf_task_utl.updated_by,
287: x_last_update_login => jtf_task_utl.login_id
288: );
289:
290: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
283: x_attribute_category => task_dates.attribute_category,
284: x_date_value => l_date_value,
285: x_last_update_date => SYSDATE,
286: x_last_updated_by => jtf_task_utl.updated_by,
287: x_last_update_login => jtf_task_utl.login_id
288: );
289:
290: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
291: THEN