DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on HR_UTILITY

Line 102: g_debug := hr_utility.debug_enabled;

98: IS
99: l_procedure varchar2(100);
100:
101: BEGIN
102: g_debug := hr_utility.debug_enabled;
103: l_procedure := g_package||'init_form12ba_code';
104: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
105:
106: g_perq_record(1).perq_value1 := 0;

Line 198: g_debug := hr_utility.debug_enabled;

194: l_procedure VARCHAR2(100);
195: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
196: --
197: BEGIN
198: g_debug := hr_utility.debug_enabled;
199: l_procedure := g_package ||'get_max_context_id';
200: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
201:
202:

Line 268: g_debug := hr_utility.debug_enabled;

264: l_state_code hr_locations.loc_information16%TYPE;
265: l_details VARCHAR2(1000);
266:
267: BEGIN
268: g_debug := hr_utility.debug_enabled;
269: l_procedure := g_package ||'get_location_details';
270: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
271:
272:

Line 383: g_debug := hr_utility.debug_enabled;

379: l_location_zipcode hr_locations.postal_code%TYPE;
380: l_details VARCHAR2(1000);
381:
382: BEGIN
383: g_debug := hr_utility.debug_enabled;
384: l_procedure := g_package ||'get_location_details';
385: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
386:
387: IF g_debug THEN

Line 468: g_debug := hr_utility.debug_enabled;

464: l_tag VARCHAR2(10000);
465: l_procedure varchar2(100);
466:
467: BEGIN
468: g_debug := hr_utility.debug_enabled;
469: l_procedure := g_package ||'write_tag';
470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN

Line 612: g_debug := hr_utility.debug_enabled;

608: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
609:
610:
611: BEGIN
612: g_debug := hr_utility.debug_enabled;
613: l_procedure := g_package ||'build_gre_xml';
614: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
615:
616:

Line 788: g_debug := hr_utility.debug_enabled;

784: l_payroll_id NUMBER;
785: l_asg_end DATE;
786:
787: BEGIN
788: g_debug := hr_utility.debug_enabled;
789: l_procedure := g_package ||'build_employee_xml';
790: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
791:
792:

Line 1186: g_debug := hr_utility.debug_enabled;

1182: , input.name;
1183:
1184:
1185: BEGIN
1186: g_debug := hr_utility.debug_enabled;
1187: l_procedure := g_package ||'build_form16_xml';
1188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1189:
1190:

Line 1803: g_debug := hr_utility.debug_enabled;

1799:
1800: l_procedure varchar2(100);
1801:
1802: BEGIN
1803: g_debug := hr_utility.debug_enabled;
1804: l_procedure := g_package ||'build_form12ba_xml';
1805: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1806:
1807:

Line 1895: g_debug := hr_utility.debug_enabled;

1891:
1892: l_procedure varchar2(100);
1893:
1894: BEGIN
1895: g_debug := hr_utility.debug_enabled;
1896: l_procedure := g_package ||'build_form12ba_xml';
1897: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1898:
1899:

Line 1937: g_debug := hr_utility.debug_enabled;

1933: IS
1934: l_procedure varchar2(100);
1935:
1936: BEGIN
1937: g_debug := hr_utility.debug_enabled;
1938: l_procedure := g_package ||'fetch_xml';
1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1940:
1941: -- If Clobs exists return next clob else exit NULL

Line 1942: hr_utility.trace('Clob Count : ' || g_clob_cnt);

1938: l_procedure := g_package ||'fetch_xml';
1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1940:
1941: -- If Clobs exists return next clob else exit NULL
1942: hr_utility.trace('Clob Count : ' || g_clob_cnt);
1943: hr_utility.trace('Clob Fetch Count : ' || g_fetch_clob_cnt);
1944: IF (g_clob_cnt <> 0 ) AND (g_fetch_clob_cnt < g_clob_cnt) THEN
1945: g_fetch_clob_cnt := g_fetch_clob_cnt + 1;
1946: p_clob := g_clob(g_fetch_clob_cnt);

Line 1943: hr_utility.trace('Clob Fetch Count : ' || g_fetch_clob_cnt);

1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1940:
1941: -- If Clobs exists return next clob else exit NULL
1942: hr_utility.trace('Clob Count : ' || g_clob_cnt);
1943: hr_utility.trace('Clob Fetch Count : ' || g_fetch_clob_cnt);
1944: IF (g_clob_cnt <> 0 ) AND (g_fetch_clob_cnt < g_clob_cnt) THEN
1945: g_fetch_clob_cnt := g_fetch_clob_cnt + 1;
1946: p_clob := g_clob(g_fetch_clob_cnt);
1947: ELSE

Line 2077: g_debug := hr_utility.debug_enabled;

2073: AND legislation_code='IN'
2074: AND g_tax_end_date BETWEEN effective_start_date and effective_end_date;
2075:
2076: begin
2077: g_debug := hr_utility.debug_enabled;
2078: l_procedure := g_package ||'load_xml';
2079: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2080:
2081: