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.11.12010000.4 2008/09/19 17:23:24 asrajago ship $ */
3: --
4: --
5: g_debug BOOLEAN := hr_utility.debug_enabled;

Line 183: ('HXT_OTC_RETRIEVAL_INTERFACE.get_employee_number',

179: --
180: IF g_debug
181: THEN
182: hr_utility.set_location
183: ('HXT_OTC_RETRIEVAL_INTERFACE.get_employee_number',
184: 1
185: );
186: END IF;
187:

Line 213: ('HXT_OTC_RETRIEVAL_INTERFACE.employee_number',

209: --
210: IF g_debug
211: THEN
212: hr_utility.set_location
213: ('HXT_OTC_RETRIEVAL_INTERFACE.employee_number',
214: 2
215: );
216: hr_utility.TRACE ('Employee Number is ' || l_employee_number);
217: hr_utility.TRACE ('Full Name is ' || l_full_name);

Line 582: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';

578: l_base_elt_id NUMBER;
579: l_earn_policy_id NUMBER;
580: l_retcode NUMBER (9);
581: c_proc VARCHAR2 (100)
582: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';
583:
584: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
585: IS
586: SELECT egr.element_type_id

Line 881: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';

877: l_retcode NUMBER (9);
878: l_ipv_name VARCHAR2 (80);
879: l_trans_ipv_name VARCHAR2 (30);
880: c_proc VARCHAR2 (100)
881: := 'HXT_OTC_RETRIEVAL_INTERFACE.parse_attributes';
882:
883: --2223669
884: CURSOR c_input_value_name (
885: p_ele_type_id IN NUMBER,

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

1225: CURSOR get_debug
1226: IS
1227: SELECT 'X'
1228: FROM hxc_debug
1229: WHERE UPPER (process) = 'HXT_OTC_RETRIEVAL_INTERFACE'
1230: AND TRUNC (debug_date) <= SYSDATE;
1231:
1232: CURSOR csr_created_timecards (p_batch_ref VARCHAR2)
1233: IS

Line 1421: := 'HXT_OTC_RETRIEVAL_INTERFACE.transfer_to_otm';

1417: e_retrieval_error EXCEPTION;
1418: e_not_retrievable EXCEPTION;
1419: --
1420: c_proc VARCHAR2 (100)
1421: := 'HXT_OTC_RETRIEVAL_INTERFACE.transfer_to_otm';
1422:
1423: l_element_id NUMBER;
1424: l_tim_id NUMBER;
1425:

Line 1444: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',

1440: --
1441: IF g_debug
1442: THEN
1443: hr_utility.set_location
1444: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',
1445: 1
1446: );
1447: END IF;
1448:

Line 1480: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',

1476: --
1477: IF g_debug
1478: THEN
1479: hr_utility.set_location
1480: ('HXT_OTC_RETRIEVAL_INTERFACE.get_ele_type_id',
1481: 2
1482: );
1483: END IF;
1484:

Line 1929: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

1925: --
1926: IF g_debug
1927: THEN
1928: hr_utility.set_location
1929: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
1930: 1
1931: );
1932: END IF;
1933:

Line 1967: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

1963: --
1964: IF g_debug
1965: THEN
1966: hr_utility.set_location
1967: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
1968: 2
1969: );
1970: END IF;
1971:

Line 1985: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

1981: --
1982: IF g_debug
1983: THEN
1984: hr_utility.set_location
1985: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
1986: 3
1987: );
1988: END IF;
1989:

Line 2019: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2015: --
2016: IF g_debug
2017: THEN
2018: hr_utility.set_location
2019: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2020: 4
2021: );
2022: END IF;
2023: --

Line 2036: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',

2032: --
2033: IF g_debug
2034: THEN
2035: hr_utility.set_location
2036: ('HXT_OTC_RETRIEVAL_INTERFACE.get_batch_info',
2037: 5
2038: );
2039: END IF;
2040:

Line 3816: END hxt_otc_retrieval_interface;

3812: END chk_need_re_explosion ;
3813:
3814: --
3815: ------------------------------------------------------------------------
3816: END hxt_otc_retrieval_interface;