[Home] [Help]
1: PACKAGE BODY hxc_deposit_wrapper_utilities AS
2: /* $Header: hxcdpwrut.pkb 120.17 2010/08/19 10:50:20 bbayragi ship $ */
3:
4:
5: g_separator VARCHAR2(2) := '|';
3:
4:
5: g_separator VARCHAR2(2) := '|';
6: g_pref_sep VARCHAR2(2) := '#';
7: g_package VARCHAR2(50) := 'hxc_deposit_wrapper_utilities';
8:
9: g_debug boolean :=hr_utility.debug_enabled;
10:
11: -- globals for caching the hours type poplist
408: PAEXPITDFFC - 1221233 is obtained by using the function get_paexpitdff_code
409: Else the usual process is followed */
410:
411: l_pa_context_code :=
412: HXC_DEPOSIT_WRAPPER_UTILITIES.get_dupdff_code('PAEXPITDFF - ' || p_system_linkage);
413:
414:
415: -- Get the corresponding context name
416:
423: if (p_expenditure_type <> 'NO_PROJECTS') then
424:
425: -- l_pa_context_code := 'PAEXPITDFF - '||p_expenditure_type;
426: l_pa_context_code :=
427: HXC_DEPOSIT_WRAPPER_UTILITIES.get_dupdff_code('PAEXPITDFF - ' || p_expenditure_type);
428:
429: l_pa_context_name := fetch_context_name(l_pa_context_code);
430:
431: end if;
2514: g_debug:=hr_utility.debug_enabled;
2515: l_time_diff := 24*60*(sysdate - g_ht_time);
2516:
2517: IF g_debug THEN
2518: hr_utility.trace(' In HXC_DEPOSIT_WRAPPER_UTILITIES.TIMECARD_HOURS_TYPE_LIST procedure');
2519:
2520: hr_utility.trace(' ****************Initial Information************************ ');
2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');
3165: PROCEDURE maintain_errors (
3166: p_translated_bb_ids_tab hxc_self_service_time_deposit.translate_bb_ids_tab
3167: , p_translated_ta_ids_tab hxc_self_service_time_deposit.translate_ta_ids_tab
3168: , p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
3169: , p_transactions IN OUT NOCOPY hxc_deposit_wrapper_utilities.t_transaction ) IS
3170:
3171: l_msg_ind BINARY_INTEGER;
3172: l_tbb_id NUMBER;
3173: l_ta_id NUMBER;
3605: end if;
3606:
3607: end replace_resource_id;
3608:
3609: END hxc_deposit_wrapper_utilities;
3610: