APPS.HXT_TIME_GEN dependencies on HXT_UTIL

Line 594: WHERE wsh.week_day = hxt_util.get_week_day(a_date)

590: sht.late_stop, sht.hours
591: FROM hxt_shifts sht,
592: hxt_weekly_work_schedules wws,
593: hxt_work_shifts wsh
594: WHERE wsh.week_day = hxt_util.get_week_day(a_date)
595: AND wws.id = wsh.tws_id
596: AND a_date BETWEEN wws.date_from AND NVL (wws.date_to, a_date)
597: AND wws.id = a_work_id
598: AND sht.id = wsh.sht_id;

Line 697: hxt_util.DEBUG (g_autogen_error);

693: THEN
694: fnd_message.set_name ('HXT', 'HXT_39368_GEN_WRK_PLAN_ERR');
695: fnd_message.set_token ('SQLERR', SQLERRM);
696: g_autogen_error := '';
697: hxt_util.DEBUG (g_autogen_error);
698: g_sqlerrm := SQLERRM;
699: call_gen_error (NULL, g_autogen_error, g_sqlerrm);
700: g_errors := TRUE; --SPR C389
701: END gen_work_plan;

Line 1047: g_sub_loc := 'HXT_UTIL.Get_Next_Seqno';

1043: RAISE l_seq_exceptn;
1044: END IF;
1045:
1046: -- Get next available line seqno
1047: g_sub_loc := 'HXT_UTIL.Get_Next_Seqno';
1048:
1049: IF g_sub_loc IS NULL
1050: THEN -- C257 C261 by BC
1051: RAISE l_seq_exceptn;

Line 1054: l_seqno := hxt_util.get_next_seqno (a_tim_id, a_date_worked);

1050: THEN -- C257 C261 by BC
1051: RAISE l_seq_exceptn;
1052: END IF;
1053:
1054: l_seqno := hxt_util.get_next_seqno (a_tim_id, a_date_worked);
1055:
1056: IF l_seqno IS NULL
1057: THEN -- C257 C261 by BC
1058: RAISE l_seq_exceptn;

Line 1282: hxt_util.gen_error (

1278: -- PRIVATE procedure to create error table entries for this package
1279: -- Parameters for call to Gen_Error:
1280: BEGIN
1281: -- Insert into error table
1282: hxt_util.gen_error (
1283: g_asm_rec.batch_id,
1284: g_asm_rec.tim_id,
1285: NULL,
1286: g_time_period_id,