577: g_batch_ref := batch_ref;
578: g_batch_name := batch_name;
579: g_sysdate := TRUNC (SYSDATE);
580: g_sysdatetime := SYSDATE;
581: g_user_id := fnd_global.user_id;
582: g_login_id := fnd_global.login_id;
583:
584: IF g_debug
585: THEN
578: g_batch_name := batch_name;
579: g_sysdate := TRUNC (SYSDATE);
580: g_sysdatetime := SYSDATE;
581: g_user_id := fnd_global.user_id;
582: g_login_id := fnd_global.login_id;
583:
584: IF g_debug
585: THEN
586: hr_utility.set_location (l_proc, 30);
2865: BEGIN
2866: /* Initialize globals */
2867: g_sysdate := TRUNC (SYSDATE);
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
2866: /* Initialize globals */
2867: g_sysdate := TRUNC (SYSDATE);
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;
2983: /* Initialize globals */
2984: g_debug := hr_utility.debug_enabled;
2985: g_sysdate := TRUNC (SYSDATE);
2986: g_sysdatetime := SYSDATE;
2987: g_user_id := fnd_global.user_id;
2988: g_login_id := fnd_global.login_id;
2989:
2990: IF g_debug
2991: THEN
2984: g_debug := hr_utility.debug_enabled;
2985: g_sysdate := TRUNC (SYSDATE);
2986: g_sysdatetime := SYSDATE;
2987: g_user_id := fnd_global.user_id;
2988: g_login_id := fnd_global.login_id;
2989:
2990: IF g_debug
2991: THEN
2992: hr_utility.TRACE ('start re explode for loop');
5968: BEGIN
5969: /* Initialize globals */
5970: g_sysdate := TRUNC (SYSDATE);
5971: g_sysdatetime := SYSDATE;
5972: g_user_id := fnd_global.user_id;
5973: g_login_id := fnd_global.login_id;
5974:
5975: IF NVL (p_dt_update_mode, 'CORRECTION') = 'CORRECTION'
5976: THEN
5969: /* Initialize globals */
5970: g_sysdate := TRUNC (SYSDATE);
5971: g_sysdatetime := SYSDATE;
5972: g_user_id := fnd_global.user_id;
5973: g_login_id := fnd_global.login_id;
5974:
5975: IF NVL (p_dt_update_mode, 'CORRECTION') = 'CORRECTION'
5976: THEN
5977: -- Delete