DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on HR_UTILITY

Line 97: g_debug := hr_utility.debug_enabled;

93: IS
94: l_procedure varchar2(100);
95:
96: BEGIN
97: g_debug := hr_utility.debug_enabled;
98: l_procedure := g_package||'init_form12ba_code';
99: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
100:
101: g_perq_record(1).perq_value1 := 0;

Line 193: g_debug := hr_utility.debug_enabled;

189: l_procedure VARCHAR2(100);
190: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
191: --
192: BEGIN
193: g_debug := hr_utility.debug_enabled;
194: l_procedure := g_package ||'get_max_context_id';
195: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
196:
197:

Line 263: g_debug := hr_utility.debug_enabled;

259: l_state_code hr_locations.loc_information16%TYPE;
260: l_details VARCHAR2(1000);
261:
262: BEGIN
263: g_debug := hr_utility.debug_enabled;
264: l_procedure := g_package ||'get_location_details';
265: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
266:
267:

Line 378: g_debug := hr_utility.debug_enabled;

374: l_location_zipcode hr_locations.postal_code%TYPE;
375: l_details VARCHAR2(1000);
376:
377: BEGIN
378: g_debug := hr_utility.debug_enabled;
379: l_procedure := g_package ||'get_location_details';
380: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
381:
382: IF g_debug THEN

Line 463: g_debug := hr_utility.debug_enabled;

459: l_tag VARCHAR2(10000);
460: l_procedure varchar2(100);
461:
462: BEGIN
463: g_debug := hr_utility.debug_enabled;
464: l_procedure := g_package ||'write_tag';
465: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
466:
467: IF g_debug THEN

Line 720: g_debug := hr_utility.debug_enabled;

716: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
717:
718:
719: BEGIN
720: g_debug := hr_utility.debug_enabled;
721: l_procedure := g_package ||'build_gre_xml';
722: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
723:
724:

Line 906: g_debug := hr_utility.debug_enabled;

902: l_payroll_id NUMBER;
903: l_asg_end DATE;
904:
905: BEGIN
906: g_debug := hr_utility.debug_enabled;
907: l_procedure := g_package ||'build_employee_xml';
908: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
909:
910:

Line 1321: g_debug := hr_utility.debug_enabled;

1317: AND action_context_id = p_action_context_id
1318: AND source_id = p_source_id;
1319:
1320: BEGIN
1321: g_debug := hr_utility.debug_enabled;
1322: l_procedure := g_package ||'build_form16_xml';
1323: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1324:
1325:

Line 2050: g_debug := hr_utility.debug_enabled;

2046:
2047: l_procedure varchar2(100);
2048:
2049: BEGIN
2050: g_debug := hr_utility.debug_enabled;
2051: l_procedure := g_package ||'build_form12ba_xml';
2052: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2053:
2054:

Line 2142: g_debug := hr_utility.debug_enabled;

2138:
2139: l_procedure varchar2(100);
2140:
2141: BEGIN
2142: g_debug := hr_utility.debug_enabled;
2143: l_procedure := g_package ||'build_form12ba_xml';
2144: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2145:
2146:

Line 2184: g_debug := hr_utility.debug_enabled;

2180: IS
2181: l_procedure varchar2(100);
2182:
2183: BEGIN
2184: g_debug := hr_utility.debug_enabled;
2185: l_procedure := g_package ||'fetch_xml';
2186: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2187:
2188: -- If Clobs exists return next clob else exit NULL

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

2185: l_procedure := g_package ||'fetch_xml';
2186: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2187:
2188: -- If Clobs exists return next clob else exit NULL
2189: hr_utility.trace('Clob Count : ' || g_clob_cnt);
2190: hr_utility.trace('Clob Fetch Count : ' || g_fetch_clob_cnt);
2191: IF (g_clob_cnt <> 0 ) AND (g_fetch_clob_cnt < g_clob_cnt) THEN
2192: g_fetch_clob_cnt := g_fetch_clob_cnt + 1;
2193: p_clob := g_clob(g_fetch_clob_cnt);

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

2186: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2187:
2188: -- If Clobs exists return next clob else exit NULL
2189: hr_utility.trace('Clob Count : ' || g_clob_cnt);
2190: hr_utility.trace('Clob Fetch Count : ' || g_fetch_clob_cnt);
2191: IF (g_clob_cnt <> 0 ) AND (g_fetch_clob_cnt < g_clob_cnt) THEN
2192: g_fetch_clob_cnt := g_fetch_clob_cnt + 1;
2193: p_clob := g_clob(g_fetch_clob_cnt);
2194: ELSE

Line 2232: g_debug := hr_utility.debug_enabled;

2228: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2229:
2230:
2231: BEGIN
2232: g_debug := hr_utility.debug_enabled;
2233: l_procedure := g_package ||'get_gre_details';
2234: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2235:
2236: IF g_debug THEN

Line 2381: g_debug := hr_utility.debug_enabled;

2377: AND g_tax_end_date BETWEEN effective_start_date and effective_end_date;
2378:
2379: begin
2380:
2381: g_debug := hr_utility.debug_enabled;
2382: l_procedure := g_package ||'load_xml';
2383: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2384:
2385:

Line 2639: g_debug := hr_utility.debug_enabled;

2635: AND g_tax_end_date BETWEEN effective_start_date and effective_end_date;
2636:
2637: begin
2638:
2639: g_debug := hr_utility.debug_enabled;
2640: l_procedure := g_package ||'load_xml_burst';
2641: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2642:
2643: