DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HXT_SEQNO

Line 2872: SELECT hxt_seqno.NEXTVAL

2868: g_sysdatetime := SYSDATE;
2869: g_user_id := fnd_global.user_id;
2870: g_login_id := fnd_global.login_id;
2871:
2872: SELECT hxt_seqno.NEXTVAL
2873: INTO l_error_seqno
2874: FROM DUAL;
2875:
2876: --

Line 3361: l_timecard_id := hxt_time_gen.get_hxt_seqno;

3357:
3358: g_batch_err_id := l_batch_id;
3359: --
3360: /* Generate a unique timecard id for the new timecard */
3361: l_timecard_id := hxt_time_gen.get_hxt_seqno;
3362:
3363: IF l_timecard_id = NULL
3364: THEN
3365: RAISE l_tim_id_creation_error;

Line 4581: l_hours_worked_id := hxt_time_gen.get_hxt_seqno;

4577: THEN
4578: hr_utility.set_location (l_proc, 50);
4579: END IF;
4580:
4581: l_hours_worked_id := hxt_time_gen.get_hxt_seqno;
4582:
4583: IF g_debug
4584: THEN
4585: hr_utility.TRACE ('l_hours_worked_id :' || l_hours_worked_id);

Line 4720: l_hours_worked_id := hxt_time_gen.Get_HXT_Seqno;

4716: /*Obtain a unique hours worked id*/
4717:
4718: /*
4719: IF i_time_summary_id IS NULL THEN
4720: l_hours_worked_id := hxt_time_gen.Get_HXT_Seqno;
4721: ELSE
4722: l_hours_worked_id := i_time_summary_id;
4723: END IF;
4724: --