APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_OTC_RETRIEVAL_INTERFACE

Line 1: PACKAGE BODY hxt_otc_retrieval_interface AS

1: PACKAGE BODY hxt_otc_retrieval_interface AS
2: /* $Header: hxtotcri.pkb 120.23.12020000.3 2013/04/04 15:17:25 asrajago ship $ */
3: --
4: --
5: g_debug BOOLEAN := hr_utility.debug_enabled;

Line 684: ('HXT_OTC_RETRIEVAL_INTERFACE.get_employee_number',

680: --
681: IF g_debug
682: THEN
683: hr_utility.set_location
684: ('HXT_OTC_RETRIEVAL_INTERFACE.get_employee_number',
685: 1
686: );
687: END IF;
688:

Line 714: ('HXT_OTC_RETRIEVAL_INTERFACE.employee_number',

710: --
711: IF g_debug
712: THEN
713: hr_utility.set_location
714: ('HXT_OTC_RETRIEVAL_INTERFACE.employee_number',
715: 2
716: );
717: hr_utility.TRACE ('Employee Number is ' || l_employee_number);
718: hr_utility.TRACE ('Full Name is ' || l_full_name);

Line 1088: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';

1084: l_base_elt_id NUMBER;
1085: l_earn_policy_id NUMBER;
1086: l_retcode NUMBER (9);
1087: c_proc VARCHAR2 (100)
1088: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';
1089:
1090: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
1091: IS
1092: SELECT egr.element_type_id

Line 1398: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';

1394: l_retcode NUMBER (9);
1395: l_ipv_name VARCHAR2 (80);
1396: l_trans_ipv_name VARCHAR2 (30);
1397: c_proc VARCHAR2 (100)
1398: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';
1399:
1400: --2223669
1401: CURSOR c_input_value_name (
1402: p_ele_type_id IN NUMBER,

Line 1817: WHERE UPPER (process) = 'HXT_OTC_RETRIEVAL_INTERFACE'

1813: CURSOR get_debug
1814: IS
1815: SELECT 'X'
1816: FROM hxc_debug
1817: WHERE UPPER (process) = 'HXT_OTC_RETRIEVAL_INTERFACE'
1818: AND TRUNC (debug_date) <= SYSDATE;
1819:
1820: CURSOR csr_created_timecards (p_batch_ref VARCHAR2)
1821: IS

Line 2011: := 'HXT_OTC_RETRIEVAL_INTERFACE.transfer_to_otm';

2007: e_retrieval_error EXCEPTION;
2008: e_not_retrievable EXCEPTION;
2009: --
2010: c_proc VARCHAR2 (100)
2011: := 'HXT_OTC_RETRIEVAL_INTERFACE.transfer_to_otm';
2012:
2013: l_element_id NUMBER;
2014: l_tim_id NUMBER;
2015:

Line 2039: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',

2035: --
2036: IF g_debug
2037: THEN
2038: hr_utility.set_location
2039: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',
2040: 1
2041: );
2042: END IF;
2043:

Line 2075: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',

2071: --
2072: IF g_debug
2073: THEN
2074: hr_utility.set_location
2075: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',
2076: 2
2077: );
2078: END IF;
2079:

Line 2583: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2579: --
2580: IF g_debug
2581: THEN
2582: hr_utility.set_location
2583: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2584: 1
2585: );
2586: END IF;
2587:

Line 2621: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2617: --
2618: IF g_debug
2619: THEN
2620: hr_utility.set_location
2621: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2622: 2
2623: );
2624: END IF;
2625:

Line 2639: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2635: --
2636: IF g_debug
2637: THEN
2638: hr_utility.set_location
2639: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2640: 3
2641: );
2642: END IF;
2643:

Line 2673: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2669: --
2670: IF g_debug
2671: THEN
2672: hr_utility.set_location
2673: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2674: 4
2675: );
2676: END IF;
2677: --

Line 2690: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2686: --
2687: IF g_debug
2688: THEN
2689: hr_utility.set_location
2690: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2691: 5
2692: );
2693: END IF;
2694:

Line 4604: END hxt_otc_retrieval_interface;

4600: END chk_need_re_explosion ;
4601:
4602: --
4603: ------------------------------------------------------------------------
4604: END hxt_otc_retrieval_interface;