599: g_batch_ref := batch_ref;
600: g_batch_name := batch_name;
601: g_sysdate := TRUNC (SYSDATE);
602: g_sysdatetime := SYSDATE;
603: g_user_id := fnd_global.user_id;
604: g_login_id := fnd_global.login_id;
605:
606: IF g_debug
607: THEN
600: g_batch_name := batch_name;
601: g_sysdate := TRUNC (SYSDATE);
602: g_sysdatetime := SYSDATE;
603: g_user_id := fnd_global.user_id;
604: g_login_id := fnd_global.login_id;
605:
606: IF g_debug
607: THEN
608: hr_utility.set_location (l_proc, 30);
2947: BEGIN
2948: /* Initialize globals */
2949: g_sysdate := TRUNC (SYSDATE);
2950: g_sysdatetime := SYSDATE;
2951: g_user_id := fnd_global.user_id;
2952: g_login_id := fnd_global.login_id;
2953:
2954: SELECT hxt_seqno.NEXTVAL
2955: INTO l_error_seqno
2948: /* Initialize globals */
2949: g_sysdate := TRUNC (SYSDATE);
2950: g_sysdatetime := SYSDATE;
2951: g_user_id := fnd_global.user_id;
2952: g_login_id := fnd_global.login_id;
2953:
2954: SELECT hxt_seqno.NEXTVAL
2955: INTO l_error_seqno
2956: FROM DUAL;
3114: /* Initialize globals */
3115: g_debug := hr_utility.debug_enabled;
3116: g_sysdate := TRUNC (SYSDATE);
3117: g_sysdatetime := SYSDATE;
3118: g_user_id := fnd_global.user_id;
3119: g_login_id := fnd_global.login_id;
3120:
3121: IF g_debug
3122: THEN
3115: g_debug := hr_utility.debug_enabled;
3116: g_sysdate := TRUNC (SYSDATE);
3117: g_sysdatetime := SYSDATE;
3118: g_user_id := fnd_global.user_id;
3119: g_login_id := fnd_global.login_id;
3120:
3121: IF g_debug
3122: THEN
3123: hr_utility.TRACE ('start re explode for loop');
6315: BEGIN
6316: /* Initialize globals */
6317: g_sysdate := TRUNC (SYSDATE);
6318: g_sysdatetime := SYSDATE;
6319: g_user_id := fnd_global.user_id;
6320: g_login_id := fnd_global.login_id;
6321:
6322: IF NVL (p_dt_update_mode, 'CORRECTION') = 'CORRECTION'
6323: THEN
6316: /* Initialize globals */
6317: g_sysdate := TRUNC (SYSDATE);
6318: g_sysdatetime := SYSDATE;
6319: g_user_id := fnd_global.user_id;
6320: g_login_id := fnd_global.login_id;
6321:
6322: IF NVL (p_dt_update_mode, 'CORRECTION') = 'CORRECTION'
6323: THEN
6324: -- Bug 7359347