APPS.HXT_GEN_AAI dependencies on HXT_ADD_ASSIGN_INFO_F

Line 401: FROM hxt_add_assign_info_f aai

397:
398: /* Cursor to Check for the Duplicate row */
399: CURSOR dup_aai IS
400: SELECT '1'
401: FROM hxt_add_assign_info_f aai
402: WHERE aai.assignment_id = p_assignment_id;
403: l_duplicate_row VARCHAR2(1);
404:
405: /* Cursor to Create unique ID for AAI row */

Line 474: INSERT into HXT_ADD_ASSIGN_INFO_F

470: if g_debug then
471: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',70);
472: end if;
473:
474: INSERT into HXT_ADD_ASSIGN_INFO_F
475: (id
476: ,effective_start_date
477: ,effective_end_date
478: ,assignment_id

Line 651: FROM hxt_add_assign_info_f

647: --p_attribute1 .. p_attribute30 -attribute values.
648:
649: CURSOR c2 is
650: SELECT rowid,effective_start_date,effective_end_date
651: FROM hxt_add_assign_info_f
652: WHERE id = p_id
653: AND effective_start_date = p_effective_start_date;
654:
655: CURSOR c_delete_rec_eot is

Line 657: FROM hxt_add_assign_info_f

653: AND effective_start_date = p_effective_start_date;
654:
655: CURSOR c_delete_rec_eot is
656: SELECT rowid
657: FROM hxt_add_assign_info_f
658: WHERE id = p_id
659: AND effective_end_date = hr_general.end_of_time;
660:
661: /* Cursor to Create unique ID for AAI row */

Line 712: UPDATE HXT_ADD_ASSIGN_INFO_F

708: if g_debug then
709: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',40);
710: end if;
711:
712: UPDATE HXT_ADD_ASSIGN_INFO_F
713: SET--effective_start_date = p_effective_start_date
714: --,effective_end_date = p_effective_end_date
715: --,assignment_id = p_assignment_id
716: autogen_hours_yn = p_autogen_hours_yn

Line 767: /*UPDATE hxt_add_assign_info_f

763: if g_debug then
764: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',50);
765: end if;
766:
767: /*UPDATE hxt_add_assign_info_f
768: SET effective_end_date = p_effective_date - 1
769: WHERE rowid = p_rowid;
770: */
771: SELECT count(*) into l_count

Line 772: FROM hxt_add_assign_info_f

768: SET effective_end_date = p_effective_date - 1
769: WHERE rowid = p_rowid;
770: */
771: SELECT count(*) into l_count
772: FROM hxt_add_assign_info_f
773: WHERE assignment_id = p_assignment_id;
774:
775: IF (l_count >1) AND (p_effective_date < p_effective_start_date) THEN
776: if g_debug then

Line 779: DELETE from hxt_add_assign_info_f

775: IF (l_count >1) AND (p_effective_date < p_effective_start_date) THEN
776: if g_debug then
777: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',60);
778: end if;
779: DELETE from hxt_add_assign_info_f
780: WHERE rowid = p_rowid_eot;
781:
782: if g_debug then
783: hr_utility.trace('p_effective_date is :'||p_effective_date);

Line 786: UPDATE hxt_add_assign_info_f aai

782: if g_debug then
783: hr_utility.trace('p_effective_date is :'||p_effective_date);
784: end if;
785:
786: UPDATE hxt_add_assign_info_f aai
787: SET aai.effective_end_date = p_effective_date - 1
788: WHERE aai.assignment_id = p_assignment_id
789: AND p_effective_date between aai.effective_start_date
790: and aai.effective_end_date;

Line 792: UPDATE hxt_add_assign_info_f

788: WHERE aai.assignment_id = p_assignment_id
789: AND p_effective_date between aai.effective_start_date
790: and aai.effective_end_date;
791: ELSE
792: UPDATE hxt_add_assign_info_f
793: SET effective_end_date = p_effective_date - 1
794: WHERE rowid = p_rowid;
795: END IF;
796:

Line 802: INSERT into HXT_ADD_ASSIGN_INFO_F

798: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',70);
799: hr_utility.trace('p_id is :'||p_id);
800: end if;
801:
802: INSERT into HXT_ADD_ASSIGN_INFO_F
803: (id
804: ,effective_start_date
805: ,effective_end_date
806: ,assignment_id