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:

Line 669: FROM hxt_add_assign_info_f

665:
666: CURSOR get_future_records
667: IS SELECT ROWIDTOCHAR(rowid),
668: id
669: FROM hxt_add_assign_info_f
670: WHERE id = p_id
671: AND effective_start_date > p_effective_date;
672:
673:

Line 786: UPDATE HXT_ADD_ASSIGN_INFO_F

782: ,p_effective_start_date => p_effective_start_date
783: );
784:
785:
786: UPDATE HXT_ADD_ASSIGN_INFO_F
787: SET--effective_start_date = p_effective_start_date
788: --,effective_end_date = p_effective_end_date
789: --,assignment_id = p_assignment_id
790: autogen_hours_yn = p_autogen_hours_yn

Line 854: /*UPDATE hxt_add_assign_info_f

850: ,p_autogen_hours_yn => p_autogen_hours_yn
851: ,p_effective_start_date => p_effective_date
852: );
853:
854: /*UPDATE hxt_add_assign_info_f
855: SET effective_end_date = p_effective_date - 1
856: WHERE rowid = p_rowid;
857: */
858: SELECT count(*) into l_count

Line 859: FROM hxt_add_assign_info_f

855: SET effective_end_date = p_effective_date - 1
856: WHERE rowid = p_rowid;
857: */
858: SELECT count(*) into l_count
859: FROM hxt_add_assign_info_f
860: WHERE assignment_id = p_assignment_id;
861:
862:
863: -- Bug 8327591

Line 885: DELETE from hxt_add_assign_info_f

881: -- Bug 8327591
882: -- Not required anymore.
883: -- We are doing it with the below FORALL statement.
884: /*
885: DELETE from hxt_add_assign_info_f
886: WHERE rowid = p_rowid_eot;
887: */
888:
889: FORALL i IN rowidtab.FIRST..rowidtab.LAST

Line 890: DELETE FROM hxt_add_assign_info_f

886: WHERE rowid = p_rowid_eot;
887: */
888:
889: FORALL i IN rowidtab.FIRST..rowidtab.LAST
890: DELETE FROM hxt_add_assign_info_f
891: WHERE rowid = chartorowid(rowidtab(i));
892:
893:
894:

Line 899: UPDATE hxt_add_assign_info_f aai

895: if g_debug then
896: hr_utility.trace('p_effective_date is :'||p_effective_date);
897: end if;
898:
899: UPDATE hxt_add_assign_info_f aai
900: SET aai.effective_end_date = p_effective_date - 1
901: WHERE aai.assignment_id = p_assignment_id
902: AND p_effective_date between aai.effective_start_date
903: and aai.effective_end_date;

Line 905: UPDATE hxt_add_assign_info_f

901: WHERE aai.assignment_id = p_assignment_id
902: AND p_effective_date between aai.effective_start_date
903: and aai.effective_end_date;
904: ELSE
905: UPDATE hxt_add_assign_info_f
906: SET effective_end_date = p_effective_date - 1
907: WHERE rowid = p_rowid;
908: END IF;
909:

Line 915: INSERT into HXT_ADD_ASSIGN_INFO_F

911: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',70);
912: hr_utility.trace('p_id is :'||p_id);
913: end if;
914:
915: INSERT into HXT_ADD_ASSIGN_INFO_F
916: (id
917: ,effective_start_date
918: ,effective_end_date
919: ,assignment_id