36: l_count NUMBER;
37: l_procedure varchar2(100);
38:
39: BEGIN
40: g_debug := hr_utility.debug_enabled;
41: l_procedure := g_package ||'challan_rec_count';
42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
43:
44: IF g_debug THEN
103: l_count NUMBER;
104: l_procedure varchar2(100);
105:
106: BEGIN
107: g_debug := hr_utility.debug_enabled;
108: l_procedure := g_package ||'deductee_rec_count';
109: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
110:
111: IF g_debug THEN
183: l_total VARCHAR2(20);
184: l_procedure varchar2(100);
185:
186: BEGIN
187: g_debug := hr_utility.debug_enabled;
188: l_procedure := g_package ||'gross_tot_tds_challan';
189: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
190:
191: IF g_debug THEN
235: l_value_temp VARCHAR2(20);
236: l_procedure varchar2(100);
237:
238: BEGIN
239: g_debug := hr_utility.debug_enabled;
240: l_procedure := g_package ||'get_format_value';
241: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
242: IF g_debug THEN
243: pay_in_utils.trace('p_value',p_value);
308: l_total_tax_values VARCHAR2(100);
309: l_procedure varchar2(100);
310:
311: BEGIN
312: g_debug := hr_utility.debug_enabled;
313: l_procedure := g_package ||'gross_tot_tds_challan';
314: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
315:
316: IF g_debug THEN
382: l_count NUMBER;
383: l_procedure varchar2(100);
384:
385: BEGIN
386: g_debug := hr_utility.debug_enabled;
387: l_procedure := g_package ||'chapter_VIA_rec_count';
388: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
389:
390: IF g_debug THEN
457: l_count NUMBER;
458: l_procedure varchar2(100);
459:
460: BEGIN
461: g_debug := hr_utility.debug_enabled;
462: l_procedure := g_package ||'salary_rec_count';
463: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
464:
465: IF g_debug THEN
534: l_count NUMBER;
535: l_procedure varchar2(100);
536:
537: BEGIN
538: g_debug := hr_utility.debug_enabled;
539: l_procedure := g_package ||'deductee_salary_count';
540: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
541:
542: IF g_debug THEN
602: l_value2 VARCHAR2(20);
603: l_procedure varchar2(100);
604:
605: BEGIN
606: g_debug := hr_utility.debug_enabled;
607: l_procedure := g_package ||'get_24Q_values';
608: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
609:
610: IF g_debug THEN
666: l_emplr_class VARCHAR2(150);
667: l_procedure varchar2(100);
668:
669: BEGIN
670: g_debug := hr_utility.debug_enabled;
671: l_procedure := g_package ||'get_emplr_class';
672: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
673:
674: IF g_debug THEN
743: l_total_value VARCHAR2(20);
744: l_procedure varchar2(100);
745:
746: BEGIN
747: g_debug := hr_utility.debug_enabled;
748: l_procedure := g_package ||'total_gross_tot_income';
749: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
750:
751: IF g_debug THEN
826: p_address5 VARCHAR2(60);
827: l_procedure varchar2(100);
828:
829: BEGIN
830: g_debug := hr_utility.debug_enabled;
831: l_procedure := g_package ||'get_location_details';
832: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
833:
834: IF g_debug THEN
1037: l_age VARCHAR2(100);
1038: l_emp_category VARCHAR2(100);
1039:
1040: BEGIN
1041: g_debug := hr_utility.debug_enabled;
1042: l_procedure := g_package ||'get_emp_category';
1043: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1044:
1045: IF g_debug THEN