107: jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
108:
109: jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
110:
111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112: THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
109: jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
110:
111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112: THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117: IF(l_enable_audit = 'Y') THEN
110:
111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112: THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117: IF(l_enable_audit = 'Y') THEN
118: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
116: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117: IF(l_enable_audit = 'Y') THEN
118: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
119: p_api_version => 1,
120: p_init_msg_list => fnd_api.g_false,
121: p_commit => fnd_api.g_false,
122: p_object_version_number => 1,
123: p_task_id => x_task_id,
124: p_task_assignment_id => x_task_assignment_id,
117: IF(l_enable_audit = 'Y') THEN
118: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
119: p_api_version => 1,
120: p_init_msg_list => fnd_api.g_false,
121: p_commit => fnd_api.g_false,
122: p_object_version_number => 1,
123: p_task_id => x_task_id,
124: p_task_assignment_id => x_task_assignment_id,
125: p_new_resource_type_code => x_resource_type_code,
276: close c;
277:
278: jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: RAISE fnd_api.g_exc_unexpected_error;
284: END IF;
278: jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: RAISE fnd_api.g_exc_unexpected_error;
284: END IF;
285:
286:
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: RAISE fnd_api.g_exc_unexpected_error;
284: END IF;
285:
286:
287: end INSERT_ROW;
381: l_enable_audit varchar2(5);
382: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
383: := x_assignee_role;
384: begin
385: if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
386: l_assignee_role := 'ASSIGNEE';
387: end if;
388:
389: -- Added by SBARAT on 27/01/2006 for bug# 4661006
422: jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
423:
424: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
425:
426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427: THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: RAISE fnd_api.g_exc_unexpected_error;
430: END IF;
424: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
425:
426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427: THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: RAISE fnd_api.g_exc_unexpected_error;
430: END IF;
431:
432: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
425:
426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427: THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: RAISE fnd_api.g_exc_unexpected_error;
430: END IF;
431:
432: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
433: IF(l_enable_audit = 'Y') THEN
432: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
433: IF(l_enable_audit = 'Y') THEN
434: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
435: p_api_version => 1,
436: p_init_msg_list => fnd_api.g_false,
437: p_commit => fnd_api.g_false,
438: p_object_version_number => 1,
439: p_task_id => x_task_id,
440: p_task_assignment_id => x_task_assignment_id,
433: IF(l_enable_audit = 'Y') THEN
434: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
435: p_api_version => 1,
436: p_init_msg_list => fnd_api.g_false,
437: p_commit => fnd_api.g_false,
438: p_object_version_number => 1,
439: p_task_id => x_task_id,
440: p_task_assignment_id => x_task_assignment_id,
441: p_new_resource_type_code => x_resource_type_code,
515: RESOURCE_TERRITORY_ID = X_RESOURCE_TERRITORY_ID,
516: ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
517: SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
518: ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
519: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
520: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
521: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
522: BOOKING_START_DATE = X_BOOKING_START_DATE,
523: BOOKING_END_DATE = X_BOOKING_END_DATE,
516: ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
517: SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
518: ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
519: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
520: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
521: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
522: BOOKING_START_DATE = X_BOOKING_START_DATE,
523: BOOKING_END_DATE = X_BOOKING_END_DATE,
524: OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
529: end if;
530:
531: jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534: THEN
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
531: jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534: THEN
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539:
532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534: THEN
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539:
540: end UPDATE_ROW;
550: jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
551:
552: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
553: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;
552: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
553: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;
559: delete from jtf_task_all_assignments
560: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
553: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;
559: delete from jtf_task_all_assignments
560: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
561:
570: );
571: END IF;
572:
573: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575: THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;
572:
573: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575: THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;
579:
580: end DELETE_ROW;
573: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575: THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;
579:
580: end DELETE_ROW;
581: end ;