APPS.HXT_TIME_GEN dependencies on HXT_SEQNO

Line 914: g_sub_loc := 'Get_hxt_Seqno';

910: -- PUBLIC procedure to create timecard record.
911: l_tim_id NUMBER;
912: BEGIN
913: -- Get next sequence number
914: g_sub_loc := 'Get_hxt_Seqno';
915: l_tim_id := get_hxt_seqno;
916: -- Insert timecard
917: g_sub_loc := 'INSERT into hxt_timecards';
918:

Line 915: l_tim_id := get_hxt_seqno;

911: l_tim_id NUMBER;
912: BEGIN
913: -- Get next sequence number
914: g_sub_loc := 'Get_hxt_Seqno';
915: l_tim_id := get_hxt_seqno;
916: -- Insert timecard
917: g_sub_loc := 'INSERT into hxt_timecards';
918:
919: INSERT INTO hxt_timecards_f

Line 1038: g_sub_loc := 'Get_hxt_Seqno';

1034: l_hol_yn := 'N';
1035: END IF;
1036:
1037: -- Get ID
1038: g_sub_loc := 'Get_hxt_Seqno';
1039: l_hrw_id := get_hxt_seqno;
1040:
1041: IF l_hrw_id IS NULL
1042: THEN -- C257 C261 by BC

Line 1039: l_hrw_id := get_hxt_seqno;

1035: END IF;
1036:
1037: -- Get ID
1038: g_sub_loc := 'Get_hxt_Seqno';
1039: l_hrw_id := get_hxt_seqno;
1040:
1041: IF l_hrw_id IS NULL
1042: THEN -- C257 C261 by BC
1043: RAISE l_seq_exceptn;

Line 1217: FUNCTION get_hxt_seqno

1213: END create_hrw;
1214:
1215:
1216: ------------------------------------------------------------------
1217: FUNCTION get_hxt_seqno
1218: RETURN NUMBER
1219: IS
1220: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1221: CURSOR cur_id

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

1216: ------------------------------------------------------------------
1217: FUNCTION get_hxt_seqno
1218: RETURN NUMBER
1219: IS
1220: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1221: CURSOR cur_id
1222: IS
1223: SELECT hxt_seqno.NEXTVAL
1224: FROM DUAL;

Line 1223: SELECT hxt_seqno.NEXTVAL

1219: IS
1220: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1221: CURSOR cur_id
1222: IS
1223: SELECT hxt_seqno.NEXTVAL
1224: FROM DUAL;
1225:
1226: l_nextval NUMBER;
1227: BEGIN

Line 1241: END get_hxt_seqno;

1237: fnd_message.set_name ('HXT', 'HXT_39283_AG_ERR_GET_SEQNO2');
1238: g_autogen_error := '';
1239: g_sqlerrm := SQLERRM;
1240: RAISE g_form_level_error;
1241: END get_hxt_seqno;
1242:
1243:
1244: ------------------------------------------------------------------
1245: FUNCTION get_next_batch_id