APPS.HXT_TIME_GEN dependencies on HXT_SEQNO

Line 781: g_sub_loc := 'Get_hxt_Seqno';

777: -- PUBLIC procedure to create timecard record.
778: l_tim_id NUMBER;
779: BEGIN
780: -- Get next sequence number
781: g_sub_loc := 'Get_hxt_Seqno';
782: l_tim_id := get_hxt_seqno;
783: -- Insert timecard
784: g_sub_loc := 'INSERT into hxt_timecards';
785:

Line 782: l_tim_id := get_hxt_seqno;

778: l_tim_id NUMBER;
779: BEGIN
780: -- Get next sequence number
781: g_sub_loc := 'Get_hxt_Seqno';
782: l_tim_id := get_hxt_seqno;
783: -- Insert timecard
784: g_sub_loc := 'INSERT into hxt_timecards';
785:
786: INSERT INTO hxt_timecards_f

Line 905: g_sub_loc := 'Get_hxt_Seqno';

901: l_hol_yn := 'N';
902: END IF;
903:
904: -- Get ID
905: g_sub_loc := 'Get_hxt_Seqno';
906: l_hrw_id := get_hxt_seqno;
907:
908: IF l_hrw_id IS NULL
909: THEN -- C257 C261 by BC

Line 906: l_hrw_id := get_hxt_seqno;

902: END IF;
903:
904: -- Get ID
905: g_sub_loc := 'Get_hxt_Seqno';
906: l_hrw_id := get_hxt_seqno;
907:
908: IF l_hrw_id IS NULL
909: THEN -- C257 C261 by BC
910: RAISE l_seq_exceptn;

Line 1084: FUNCTION get_hxt_seqno

1080: END create_hrw;
1081:
1082:
1083: ------------------------------------------------------------------
1084: FUNCTION get_hxt_seqno
1085: RETURN NUMBER
1086: IS
1087: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1088: CURSOR cur_id

Line 1087: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.

1083: ------------------------------------------------------------------
1084: FUNCTION get_hxt_seqno
1085: RETURN NUMBER
1086: IS
1087: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1088: CURSOR cur_id
1089: IS
1090: SELECT hxt_seqno.NEXTVAL
1091: FROM DUAL;

Line 1090: SELECT hxt_seqno.NEXTVAL

1086: IS
1087: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1088: CURSOR cur_id
1089: IS
1090: SELECT hxt_seqno.NEXTVAL
1091: FROM DUAL;
1092:
1093: l_nextval NUMBER;
1094: BEGIN

Line 1108: END get_hxt_seqno;

1104: fnd_message.set_name ('HXT', 'HXT_39283_AG_ERR_GET_SEQNO2');
1105: g_autogen_error := '';
1106: g_sqlerrm := SQLERRM;
1107: RAISE g_form_level_error;
1108: END get_hxt_seqno;
1109:
1110:
1111: ------------------------------------------------------------------
1112: FUNCTION get_next_batch_id