34:
35: BEGIN
36: g_debug := hr_utility.debug_enabled;
37: l_procedure := g_package ||'challan_rec_count';
38: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
37: l_procedure := g_package ||'challan_rec_count';
38: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
38: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
46:
39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
46:
47: OPEN c_count;
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
46:
47: OPEN c_count;
48: FETCH c_count INTO l_count;
52: END IF;
53: CLOSE c_count;
54:
55: IF g_debug THEN
56: pay_in_utils.trace('l_count',TO_CHAR(l_count));
57: END IF;
58:
59: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
60:
55: IF g_debug THEN
56: pay_in_utils.trace('l_count',TO_CHAR(l_count));
57: END IF;
58:
59: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
60:
61: RETURN TO_CHAR(l_count);
62:
63: END challan_rec_count;
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
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
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
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
109: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
110:
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
117:
110:
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
117:
118: OPEN c_count;
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
117:
118: OPEN c_count;
119: FETCH c_count INTO l_count;
125:
126:
127:
128: IF g_debug THEN
129: pay_in_utils.trace('l_count',TO_CHAR(l_count));
130: END IF;
131:
132: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
133:
128: IF g_debug THEN
129: pay_in_utils.trace('l_count',TO_CHAR(l_count));
130: END IF;
131:
132: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
133:
134: RETURN TO_CHAR(l_count);
135:
136: END deductee_rec_count;
179:
180: BEGIN
181: g_debug := hr_utility.debug_enabled;
182: l_procedure := g_package ||'perq_rec_count';
183: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
182: l_procedure := g_package ||'perq_rec_count';
183: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
183: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
191:
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
191:
192: OPEN c_count;
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
191:
192: OPEN c_count;
193: FETCH c_count INTO l_count;
199:
200:
201:
202: IF g_debug THEN
203: pay_in_utils.trace('l_count',TO_CHAR(l_count));
204: END IF;
205:
206: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
207:
202: IF g_debug THEN
203: pay_in_utils.trace('l_count',TO_CHAR(l_count));
204: END IF;
205:
206: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
207:
208: RETURN TO_CHAR(l_count);
209:
210: END perq_rec_count;
250:
251: BEGIN
252: g_debug := hr_utility.debug_enabled;
253: l_procedure := g_package ||'gross_tot_tds_challan';
254: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
253: l_procedure := g_package ||'gross_tot_tds_challan';
254: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
254: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
262:
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
262:
263: OPEN c_challan_tax_tot;
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
262:
263: OPEN c_challan_tax_tot;
264: FETCH c_challan_tax_tot INTO l_tds,l_sur,l_ec,l_intr,l_oth;
272: l_tot := NVL(l_tot,0) * 100;
273:
274:
275: IF g_debug THEN
276: pay_in_utils.trace('l_tot',TO_CHAR(l_tot));
277: END IF;
278: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
279:
280: RETURN TO_CHAR(l_tot);
274:
275: IF g_debug THEN
276: pay_in_utils.trace('l_tot',TO_CHAR(l_tot));
277: END IF;
278: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
279:
280: RETURN TO_CHAR(l_tot);
281:
282:
333:
334: BEGIN
335: g_debug := hr_utility.debug_enabled;
336: l_procedure := g_package ||'gross_tot_tds_deductee';
337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
336: l_procedure := g_package ||'gross_tot_tds_deductee';
337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
345:
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
345:
346: FOR i IN csr_get_max_cont_id
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
345:
346: FOR i IN csr_get_max_cont_id
347: LOOP
354:
355: l_tds := l_tds * 100;
356:
357: IF g_debug THEN
358: pay_in_utils.trace('l_tds',TO_CHAR(l_tds));
359: END IF;
360: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
361: RETURN TO_CHAR(l_tds);
362:
356:
357: IF g_debug THEN
358: pay_in_utils.trace('l_tds',TO_CHAR(l_tds));
359: END IF;
360: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
361: RETURN TO_CHAR(l_tds);
362:
363: END gross_tot_tds_deductee;
364:
402:
403: BEGIN
404: g_debug := hr_utility.debug_enabled;
405: l_procedure := g_package ||'get_eoy_values';
406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
405: l_procedure := g_package ||'get_eoy_values';
406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
417: END IF;
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
417: END IF;
418:
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
417: END IF;
418:
419: OPEN c_form24_values;
428: l_ai3 := TO_CHAR(TO_NUMBER(l_ai3) * 100);
429: l_ai4 := TO_CHAR(TO_NUMBER(l_ai4) * 100);
430: l_ai5 := TO_CHAR(TO_NUMBER(l_ai5) * 100);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
429: l_ai4 := TO_CHAR(TO_NUMBER(l_ai4) * 100);
430: l_ai5 := TO_CHAR(TO_NUMBER(l_ai5) * 100);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
430: l_ai5 := TO_CHAR(TO_NUMBER(l_ai5) * 100);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
439:
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
439:
440: IF p_segment_num = 2 THEN
441: RETURN l_ai2;
442: ELSIF p_segment_num = 3 THEN
485:
486: BEGIN
487: g_debug := hr_utility.debug_enabled;
488: l_procedure := g_package ||'get_tde_remarks';
489: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
490:
491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
489: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
490:
491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
490:
491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499:
500: OPEN c_remarks;
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499:
500: OPEN c_remarks;
501: FETCH c_remarks INTO l_remarks;
505: END IF;
506: CLOSE c_remarks;
507:
508: IF g_debug THEN
509: pay_in_utils.trace('l_remarks',l_remarks);
510: END IF;
511:
512: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
513:
508: IF g_debug THEN
509: pay_in_utils.trace('l_remarks',l_remarks);
510: END IF;
511:
512: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
513:
514: RETURN l_remarks;
515:
516: END get_tde_remarks;
540:
541: BEGIN
542: g_debug := hr_utility.debug_enabled;
543: l_procedure := g_package ||'get_emplr_class';
544: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
545:
546: IF g_debug THEN
547: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
548: END IF;
543: l_procedure := g_package ||'get_emplr_class';
544: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
545:
546: IF g_debug THEN
547: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
548: END IF;
549:
550: OPEN c_employer;
551: FETCH c_employer INTO l_emplr_class;
556: CLOSE c_employer;
557:
558:
559: IF g_debug THEN
560: pay_in_utils.trace('l_emplr_class',l_emplr_class);
561: END IF;
562: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
563:
564: RETURN l_emplr_class;
558:
559: IF g_debug THEN
560: pay_in_utils.trace('l_emplr_class',l_emplr_class);
561: END IF;
562: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
563:
564: RETURN l_emplr_class;
565:
566: END get_emplr_class;
605:
606: BEGIN
607: g_debug := hr_utility.debug_enabled;
608: l_procedure := g_package ||'get_location_details';
609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610:
611: IF g_debug THEN
612: pay_in_utils.trace('p_location_id',p_location_id);
613: END IF;
608: l_procedure := g_package ||'get_location_details';
609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610:
611: IF g_debug THEN
612: pay_in_utils.trace('p_location_id',p_location_id);
613: END IF;
614:
615: OPEN csr_add;
616: FETCH csr_add INTO l_add_1, l_add_2, l_add_3, l_add_4, l_add_5, l_state, l_pin;
659: p_address := p_address||l_state||l_pin;
660:
661:
662: IF g_debug THEN
663: pay_in_utils.trace('p_address',p_address);
664: END IF;
665:
666: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
667:
662: IF g_debug THEN
663: pay_in_utils.trace('p_address',p_address);
664: END IF;
665:
666: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
667:
668:
669: RETURN p_address;
670: