APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_IN_UTILS

Line 42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 45: pay_in_utils.trace('**************************************************','********************');

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
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');

Line 46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
43:
44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;

Line 47: pay_in_utils.trace('p_assess_period',p_assess_period);

43:
44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;
51:

Line 48: pay_in_utils.trace('p_max_action_id',p_max_action_id);

44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;
51:
52: OPEN c_count;

Line 49: pay_in_utils.trace('**************************************************','********************');

45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;
51:
52: OPEN c_count;
53: FETCH c_count INTO l_count;

Line 62: pay_in_utils.trace('l_count',TO_CHAR(l_count));

58: CLOSE c_count;
59:
60:
61: IF g_debug THEN
62: pay_in_utils.trace('l_count',TO_CHAR(l_count));
63: END IF;
64: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
65:
66: RETURN TO_CHAR(l_count);

Line 64: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

60:
61: IF g_debug THEN
62: pay_in_utils.trace('l_count',TO_CHAR(l_count));
63: END IF;
64: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
65:
66: RETURN TO_CHAR(l_count);
67:
68: END challan_rec_count;

Line 109: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);

Line 112: pay_in_utils.trace('**************************************************','********************');

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_max_action_id',p_max_action_id);
115: pay_in_utils.trace('p_challan',p_challan);
116: pay_in_utils.trace('**************************************************','********************');

Line 113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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_max_action_id',p_max_action_id);
115: pay_in_utils.trace('p_challan',p_challan);
116: pay_in_utils.trace('**************************************************','********************');
117: END IF;

Line 114: pay_in_utils.trace('p_max_action_id',p_max_action_id);

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_max_action_id',p_max_action_id);
115: pay_in_utils.trace('p_challan',p_challan);
116: pay_in_utils.trace('**************************************************','********************');
117: END IF;
118:

Line 115: pay_in_utils.trace('p_challan',p_challan);

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_max_action_id',p_max_action_id);
115: pay_in_utils.trace('p_challan',p_challan);
116: pay_in_utils.trace('**************************************************','********************');
117: END IF;
118:
119: OPEN c_count;

Line 116: pay_in_utils.trace('**************************************************','********************');

112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_max_action_id',p_max_action_id);
115: pay_in_utils.trace('p_challan',p_challan);
116: pay_in_utils.trace('**************************************************','********************');
117: END IF;
118:
119: OPEN c_count;
120: FETCH c_count INTO l_count;

Line 130: pay_in_utils.trace('l_count',TO_CHAR(l_count));

126:
127:
128:
129: IF g_debug THEN
130: pay_in_utils.trace('l_count',TO_CHAR(l_count));
131: END IF;
132:
133: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
134:

Line 133: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

129: IF g_debug THEN
130: pay_in_utils.trace('l_count',TO_CHAR(l_count));
131: END IF;
132:
133: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
134:
135: RETURN TO_CHAR(l_count);
136:
137: END deductee_rec_count;

Line 189: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
192: pay_in_utils.trace('**************************************************','********************');
193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 192: pay_in_utils.trace('**************************************************','********************');

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
192: pay_in_utils.trace('**************************************************','********************');
193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
194: pay_in_utils.trace('p_assess_period',p_assess_period);
195: pay_in_utils.trace('p_max_action_id',p_max_action_id);
196: pay_in_utils.trace('**************************************************','********************');

Line 193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

189: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
190:
191: IF g_debug THEN
192: pay_in_utils.trace('**************************************************','********************');
193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
194: pay_in_utils.trace('p_assess_period',p_assess_period);
195: pay_in_utils.trace('p_max_action_id',p_max_action_id);
196: pay_in_utils.trace('**************************************************','********************');
197: END IF;

Line 194: pay_in_utils.trace('p_assess_period',p_assess_period);

190:
191: IF g_debug THEN
192: pay_in_utils.trace('**************************************************','********************');
193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
194: pay_in_utils.trace('p_assess_period',p_assess_period);
195: pay_in_utils.trace('p_max_action_id',p_max_action_id);
196: pay_in_utils.trace('**************************************************','********************');
197: END IF;
198:

Line 195: pay_in_utils.trace('p_max_action_id',p_max_action_id);

191: IF g_debug THEN
192: pay_in_utils.trace('**************************************************','********************');
193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
194: pay_in_utils.trace('p_assess_period',p_assess_period);
195: pay_in_utils.trace('p_max_action_id',p_max_action_id);
196: pay_in_utils.trace('**************************************************','********************');
197: END IF;
198:
199: OPEN c_challan_tax_tot;

Line 196: pay_in_utils.trace('**************************************************','********************');

192: pay_in_utils.trace('**************************************************','********************');
193: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
194: pay_in_utils.trace('p_assess_period',p_assess_period);
195: pay_in_utils.trace('p_max_action_id',p_max_action_id);
196: pay_in_utils.trace('**************************************************','********************');
197: END IF;
198:
199: OPEN c_challan_tax_tot;
200: FETCH c_challan_tax_tot INTO l_tds,l_sur,l_ec,l_intr,l_oth;

Line 211: pay_in_utils.trace('l_total',SUBSTR(l_total,1,15));

207:
208:
209:
210: IF g_debug THEN
211: pay_in_utils.trace('l_total',SUBSTR(l_total,1,15));
212: END IF;
213:
214: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
215:

Line 214: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

210: IF g_debug THEN
211: pay_in_utils.trace('l_total',SUBSTR(l_total,1,15));
212: END IF;
213:
214: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
215:
216: RETURN SUBSTR(l_total,1,15);
217:
218: END gross_tot_tds_challan;

Line 241: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);
244: END IF;
245:

Line 243: pay_in_utils.trace('p_value',p_value);

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);
244: END IF;
245:
246: IF(NVL(p_value,0)=0) THEN
247: RETURN '0.00';

Line 256: pay_in_utils.trace('l_value',l_value);

252: l_value := SUBSTR(l_value,1,length(l_value)-2)||'.'||SUBSTR(l_value,length(l_value)-1,length(l_value));
253:
254:
255: IF g_debug THEN
256: pay_in_utils.trace('l_value',l_value);
257: END IF;
258:
259: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
260:

Line 259: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

255: IF g_debug THEN
256: pay_in_utils.trace('l_value',l_value);
257: END IF;
258:
259: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
260:
261: RETURN l_value;
262:
263: END get_format_value;

Line 314: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
317: pay_in_utils.trace('**************************************************','********************');
318: pay_in_utils.trace('p_challan_number',p_challan_number);

Line 317: pay_in_utils.trace('**************************************************','********************');

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
317: pay_in_utils.trace('**************************************************','********************');
318: pay_in_utils.trace('p_challan_number',p_challan_number);
319: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
320: pay_in_utils.trace('p_max_action_id',p_max_action_id);
321: pay_in_utils.trace('**************************************************','********************');

Line 318: pay_in_utils.trace('p_challan_number',p_challan_number);

314: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
315:
316: IF g_debug THEN
317: pay_in_utils.trace('**************************************************','********************');
318: pay_in_utils.trace('p_challan_number',p_challan_number);
319: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
320: pay_in_utils.trace('p_max_action_id',p_max_action_id);
321: pay_in_utils.trace('**************************************************','********************');
322: END IF;

Line 319: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

315:
316: IF g_debug THEN
317: pay_in_utils.trace('**************************************************','********************');
318: pay_in_utils.trace('p_challan_number',p_challan_number);
319: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
320: pay_in_utils.trace('p_max_action_id',p_max_action_id);
321: pay_in_utils.trace('**************************************************','********************');
322: END IF;
323:

Line 320: pay_in_utils.trace('p_max_action_id',p_max_action_id);

316: IF g_debug THEN
317: pay_in_utils.trace('**************************************************','********************');
318: pay_in_utils.trace('p_challan_number',p_challan_number);
319: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
320: pay_in_utils.trace('p_max_action_id',p_max_action_id);
321: pay_in_utils.trace('**************************************************','********************');
322: END IF;
323:
324:

Line 321: pay_in_utils.trace('**************************************************','********************');

317: pay_in_utils.trace('**************************************************','********************');
318: pay_in_utils.trace('p_challan_number',p_challan_number);
319: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
320: pay_in_utils.trace('p_max_action_id',p_max_action_id);
321: pay_in_utils.trace('**************************************************','********************');
322: END IF;
323:
324:
325: l_value29 :=0;

Line 347: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);

343: l_total_tax_values := l_value29||'^'||l_value30||'^'||l_value31||'^'||l_value32||'^'||l_value33||'^';
344:
345:
346: IF g_debug THEN
347: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
348: END IF;
349:
350: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
351:

Line 350: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

346: IF g_debug THEN
347: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
348: END IF;
349:
350: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
351:
352: RETURN l_total_tax_values;
353:
354: END get_24Q_tax_values;

Line 388: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
391: pay_in_utils.trace('**************************************************','********************');
392: pay_in_utils.trace('p_action_context_id',p_action_context_id);

Line 391: pay_in_utils.trace('**************************************************','********************');

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
391: pay_in_utils.trace('**************************************************','********************');
392: pay_in_utils.trace('p_action_context_id',p_action_context_id);
393: pay_in_utils.trace('p_source_id',p_source_id);
394: pay_in_utils.trace('**************************************************','********************');
395: END IF;

Line 392: pay_in_utils.trace('p_action_context_id',p_action_context_id);

388: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
389:
390: IF g_debug THEN
391: pay_in_utils.trace('**************************************************','********************');
392: pay_in_utils.trace('p_action_context_id',p_action_context_id);
393: pay_in_utils.trace('p_source_id',p_source_id);
394: pay_in_utils.trace('**************************************************','********************');
395: END IF;
396:

Line 393: pay_in_utils.trace('p_source_id',p_source_id);

389:
390: IF g_debug THEN
391: pay_in_utils.trace('**************************************************','********************');
392: pay_in_utils.trace('p_action_context_id',p_action_context_id);
393: pay_in_utils.trace('p_source_id',p_source_id);
394: pay_in_utils.trace('**************************************************','********************');
395: END IF;
396:
397: OPEN c_count;

Line 394: pay_in_utils.trace('**************************************************','********************');

390: IF g_debug THEN
391: pay_in_utils.trace('**************************************************','********************');
392: pay_in_utils.trace('p_action_context_id',p_action_context_id);
393: pay_in_utils.trace('p_source_id',p_source_id);
394: pay_in_utils.trace('**************************************************','********************');
395: END IF;
396:
397: OPEN c_count;
398: FETCH c_count INTO l_count;

Line 407: pay_in_utils.trace('l_count',TO_CHAR(l_count));

403: CLOSE c_count;
404:
405:
406: IF g_debug THEN
407: pay_in_utils.trace('l_count',TO_CHAR(l_count));
408: END IF;
409:
410: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
411:

Line 410: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

406: IF g_debug THEN
407: pay_in_utils.trace('l_count',TO_CHAR(l_count));
408: END IF;
409:
410: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
411:
412: RETURN TO_CHAR(l_count);
413:
414: END chapter_VIA_rec_count;

Line 463: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
466: pay_in_utils.trace('**************************************************','********************');
467: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 466: pay_in_utils.trace('**************************************************','********************');

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
466: pay_in_utils.trace('**************************************************','********************');
467: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
468: pay_in_utils.trace('p_assess_period',p_assess_period);
469: pay_in_utils.trace('**************************************************','********************');
470: END IF;

Line 467: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

463: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
464:
465: IF g_debug THEN
466: pay_in_utils.trace('**************************************************','********************');
467: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
468: pay_in_utils.trace('p_assess_period',p_assess_period);
469: pay_in_utils.trace('**************************************************','********************');
470: END IF;
471: OPEN c_count;

Line 468: pay_in_utils.trace('p_assess_period',p_assess_period);

464:
465: IF g_debug THEN
466: pay_in_utils.trace('**************************************************','********************');
467: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
468: pay_in_utils.trace('p_assess_period',p_assess_period);
469: pay_in_utils.trace('**************************************************','********************');
470: END IF;
471: OPEN c_count;
472: FETCH c_count INTO l_count;

Line 469: pay_in_utils.trace('**************************************************','********************');

465: IF g_debug THEN
466: pay_in_utils.trace('**************************************************','********************');
467: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
468: pay_in_utils.trace('p_assess_period',p_assess_period);
469: pay_in_utils.trace('**************************************************','********************');
470: END IF;
471: OPEN c_count;
472: FETCH c_count INTO l_count;
473: IF c_count%NOTFOUND THEN

Line 481: pay_in_utils.trace('l_count',TO_CHAR(l_count));

477: CLOSE c_count;
478:
479:
480: IF g_debug THEN
481: pay_in_utils.trace('l_count',TO_CHAR(l_count));
482: END IF;
483:
484: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
485:

Line 484: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

480: IF g_debug THEN
481: pay_in_utils.trace('l_count',TO_CHAR(l_count));
482: END IF;
483:
484: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
485:
486: RETURN TO_CHAR(l_count);
487:
488: END salary_rec_count;

Line 540: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
543: pay_in_utils.trace('**************************************************','********************');
544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 543: pay_in_utils.trace('**************************************************','********************');

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
543: pay_in_utils.trace('**************************************************','********************');
544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
545: pay_in_utils.trace('p_assess_year',p_assess_year);
546: pay_in_utils.trace('p_assignment_id',p_assignment_id);
547: pay_in_utils.trace('**************************************************','********************');

Line 544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

540: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
541:
542: IF g_debug THEN
543: pay_in_utils.trace('**************************************************','********************');
544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
545: pay_in_utils.trace('p_assess_year',p_assess_year);
546: pay_in_utils.trace('p_assignment_id',p_assignment_id);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;

Line 545: pay_in_utils.trace('p_assess_year',p_assess_year);

541:
542: IF g_debug THEN
543: pay_in_utils.trace('**************************************************','********************');
544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
545: pay_in_utils.trace('p_assess_year',p_assess_year);
546: pay_in_utils.trace('p_assignment_id',p_assignment_id);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;
549:

Line 546: pay_in_utils.trace('p_assignment_id',p_assignment_id);

542: IF g_debug THEN
543: pay_in_utils.trace('**************************************************','********************');
544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
545: pay_in_utils.trace('p_assess_year',p_assess_year);
546: pay_in_utils.trace('p_assignment_id',p_assignment_id);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;
549:
550: OPEN c_count;

Line 547: pay_in_utils.trace('**************************************************','********************');

543: pay_in_utils.trace('**************************************************','********************');
544: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
545: pay_in_utils.trace('p_assess_year',p_assess_year);
546: pay_in_utils.trace('p_assignment_id',p_assignment_id);
547: pay_in_utils.trace('**************************************************','********************');
548: END IF;
549:
550: OPEN c_count;
551: FETCH c_count INTO l_count;

Line 561: pay_in_utils.trace('l_count',TO_CHAR(l_count));

557:
558:
559:
560: IF g_debug THEN
561: pay_in_utils.trace('l_count',TO_CHAR(l_count));
562: END IF;
563:
564: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
565:

Line 564: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

560: IF g_debug THEN
561: pay_in_utils.trace('l_count',TO_CHAR(l_count));
562: END IF;
563:
564: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
565:
566: RETURN TO_CHAR(l_count);
567:
568: END deductee_salary_count;

Line 608: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
611: pay_in_utils.trace('**************************************************','********************');
612: pay_in_utils.trace('p_category',p_category);

Line 611: pay_in_utils.trace('**************************************************','********************');

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
611: pay_in_utils.trace('**************************************************','********************');
612: pay_in_utils.trace('p_category',p_category);
613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));

Line 612: pay_in_utils.trace('p_category',p_category);

608: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
609:
610: IF g_debug THEN
611: pay_in_utils.trace('**************************************************','********************');
612: pay_in_utils.trace('p_category',p_category);
613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));

Line 613: pay_in_utils.trace('p_component_name',p_component_name);

609:
610: IF g_debug THEN
611: pay_in_utils.trace('**************************************************','********************');
612: pay_in_utils.trace('p_category',p_category);
613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
617: pay_in_utils.trace('**************************************************','********************');

Line 614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));

610: IF g_debug THEN
611: pay_in_utils.trace('**************************************************','********************');
612: pay_in_utils.trace('p_category',p_category);
613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
617: pay_in_utils.trace('**************************************************','********************');
618: END IF;

Line 615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));

611: pay_in_utils.trace('**************************************************','********************');
612: pay_in_utils.trace('p_category',p_category);
613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
617: pay_in_utils.trace('**************************************************','********************');
618: END IF;
619:

Line 616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));

612: pay_in_utils.trace('p_category',p_category);
613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
617: pay_in_utils.trace('**************************************************','********************');
618: END IF;
619:
620: OPEN c_form24Q_values;

Line 617: pay_in_utils.trace('**************************************************','********************');

613: pay_in_utils.trace('p_component_name',p_component_name);
614: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
615: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
616: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
617: pay_in_utils.trace('**************************************************','********************');
618: END IF;
619:
620: OPEN c_form24Q_values;
621: FETCH c_form24Q_values INTO l_value1,l_value2;

Line 631: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);

627:
628: l_value1 := get_format_value(l_value1);
629: l_value2 := get_format_value(l_value2+l_value1);
630:
631: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);
632: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);
633:
634: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
635:

Line 632: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);

628: l_value1 := get_format_value(l_value1);
629: l_value2 := get_format_value(l_value2+l_value1);
630:
631: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);
632: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);
633:
634: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
635:
636: IF(p_segment_num=1) THEN

Line 634: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);

630:
631: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);
632: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);
633:
634: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
635:
636: IF(p_segment_num=1) THEN
637: RETURN l_value1;
638: ELSIF(p_segment_num=2) THEN

Line 672: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
675: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
676: END IF;

Line 675: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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
675: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
676: END IF;
677:
678: OPEN c_employer;
679: FETCH c_employer INTO l_emplr_class;

Line 688: pay_in_utils.trace('l_emplr_class',l_emplr_class);

684: CLOSE c_employer;
685:
686:
687: IF g_debug THEN
688: pay_in_utils.trace('l_emplr_class',l_emplr_class);
689: END IF;
690:
691: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
692:

Line 691: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

687: IF g_debug THEN
688: pay_in_utils.trace('l_emplr_class',l_emplr_class);
689: END IF;
690:
691: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
692:
693: RETURN l_emplr_class;
694:
695: END get_emplr_class;

Line 749: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
752: pay_in_utils.trace('**************************************************','********************');
753: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 752: pay_in_utils.trace('**************************************************','********************');

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
752: pay_in_utils.trace('**************************************************','********************');
753: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
754: pay_in_utils.trace('p_assess_period',p_assess_period);
755: pay_in_utils.trace('**************************************************','********************');
756: END IF;

Line 753: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

749: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
750:
751: IF g_debug THEN
752: pay_in_utils.trace('**************************************************','********************');
753: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
754: pay_in_utils.trace('p_assess_period',p_assess_period);
755: pay_in_utils.trace('**************************************************','********************');
756: END IF;
757: FOR i IN csr_get_max_cont_id

Line 754: pay_in_utils.trace('p_assess_period',p_assess_period);

750:
751: IF g_debug THEN
752: pay_in_utils.trace('**************************************************','********************');
753: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
754: pay_in_utils.trace('p_assess_period',p_assess_period);
755: pay_in_utils.trace('**************************************************','********************');
756: END IF;
757: FOR i IN csr_get_max_cont_id
758: LOOP

Line 755: pay_in_utils.trace('**************************************************','********************');

751: IF g_debug THEN
752: pay_in_utils.trace('**************************************************','********************');
753: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
754: pay_in_utils.trace('p_assess_period',p_assess_period);
755: pay_in_utils.trace('**************************************************','********************');
756: END IF;
757: FOR i IN csr_get_max_cont_id
758: LOOP
759: OPEN csr_income_details('F16 Gross Total Income',i.action_cont_id,i.sour_id);

Line 768: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15));

764:
765: l_total_value :=get_format_value(l_total_gross);
766:
767: IF g_debug THEN
768: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15));
769: END IF;
770:
771: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
772:

Line 771: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

767: IF g_debug THEN
768: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15));
769: END IF;
770:
771: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
772:
773: RETURN SUBSTR(l_total_value,1,15);
774:
775: END total_gross_tot_income;

Line 832: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
835: pay_in_utils.trace('**************************************************','********************');
836: pay_in_utils.trace('p_location_id ',p_location_id );

Line 835: pay_in_utils.trace('**************************************************','********************');

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
835: pay_in_utils.trace('**************************************************','********************');
836: pay_in_utils.trace('p_location_id ',p_location_id );
837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );

Line 836: pay_in_utils.trace('p_location_id ',p_location_id );

832: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
833:
834: IF g_debug THEN
835: pay_in_utils.trace('**************************************************','********************');
836: pay_in_utils.trace('p_location_id ',p_location_id );
837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
840: pay_in_utils.trace('p_person_type ',p_person_type );

Line 837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);

833:
834: IF g_debug THEN
835: pay_in_utils.trace('**************************************************','********************');
836: pay_in_utils.trace('p_location_id ',p_location_id );
837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
840: pay_in_utils.trace('p_person_type ',p_person_type );
841: pay_in_utils.trace('**************************************************','********************');

Line 838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );

834: IF g_debug THEN
835: pay_in_utils.trace('**************************************************','********************');
836: pay_in_utils.trace('p_location_id ',p_location_id );
837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
840: pay_in_utils.trace('p_person_type ',p_person_type );
841: pay_in_utils.trace('**************************************************','********************');
842: END IF;

Line 839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );

835: pay_in_utils.trace('**************************************************','********************');
836: pay_in_utils.trace('p_location_id ',p_location_id );
837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
840: pay_in_utils.trace('p_person_type ',p_person_type );
841: pay_in_utils.trace('**************************************************','********************');
842: END IF;
843:

Line 840: pay_in_utils.trace('p_person_type ',p_person_type );

836: pay_in_utils.trace('p_location_id ',p_location_id );
837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
840: pay_in_utils.trace('p_person_type ',p_person_type );
841: pay_in_utils.trace('**************************************************','********************');
842: END IF;
843:
844:

Line 841: pay_in_utils.trace('**************************************************','********************');

837: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
838: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
839: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
840: pay_in_utils.trace('p_person_type ',p_person_type );
841: pay_in_utils.trace('**************************************************','********************');
842: END IF;
843:
844:
845: OPEN csr_add;

Line 852: pay_in_utils.trace('3',RPAD('^',3,'^'));

848: CLOSE csr_add;
849: IF(p_segment_num=5 AND p_person_type='REP') THEN
850:
851: IF g_debug THEN
852: pay_in_utils.trace('3',RPAD('^',3,'^'));
853: END IF;
854:
855: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
856:

Line 855: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

851: IF g_debug THEN
852: pay_in_utils.trace('3',RPAD('^',3,'^'));
853: END IF;
854:
855: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
856:
857: RETURN RPAD('^',3,'^');
858: ELSE
859: IF g_debug THEN

Line 860: pay_in_utils.trace('2',RPAD('^',2,'^'));

856:
857: RETURN RPAD('^',3,'^');
858: ELSE
859: IF g_debug THEN
860: pay_in_utils.trace('2',RPAD('^',2,'^'));
861: END IF;
862: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);
863: RETURN RPAD('^',2,'^');
864: END IF;

Line 862: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);

858: ELSE
859: IF g_debug THEN
860: pay_in_utils.trace('2',RPAD('^',2,'^'));
861: END IF;
862: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);
863: RETURN RPAD('^',2,'^');
864: END IF;
865: END IF;
866: CLOSE csr_add;

Line 895: pay_in_utils.trace('p_address1',p_address1);

891: END IF;
892:
893: IF (p_segment_num=1) THEN
894: IF g_debug THEN
895: pay_in_utils.trace('p_address1',p_address1);
896: END IF;
897:
898: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
899:

Line 898: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);

894: IF g_debug THEN
895: pay_in_utils.trace('p_address1',p_address1);
896: END IF;
897:
898: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
899:
900: RETURN p_address1;
901: END IF;
902:

Line 930: pay_in_utils.trace('p_address2',p_address2);

926: END IF;
927:
928: IF (p_segment_num=2) THEN
929: IF g_debug THEN
930: pay_in_utils.trace('p_address2',p_address2);
931: END IF;
932: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,50);
933: RETURN p_address2;
934: END IF ;

Line 932: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,50);

928: IF (p_segment_num=2) THEN
929: IF g_debug THEN
930: pay_in_utils.trace('p_address2',p_address2);
931: END IF;
932: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,50);
933: RETURN p_address2;
934: END IF ;
935:
936: ---------Address3-------------------------

Line 956: pay_in_utils.trace('p_address3',p_address3);

952: p_address3 :=p_address3||l_state||l_pin;
953:
954: IF (p_segment_num=3) THEN
955: IF g_debug THEN
956: pay_in_utils.trace('p_address3',p_address3);
957: END IF;
958:
959: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
960:

Line 959: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);

955: IF g_debug THEN
956: pay_in_utils.trace('p_address3',p_address3);
957: END IF;
958:
959: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
960:
961: RETURN p_address3;
962: END IF ;
963:

Line 978: pay_in_utils.trace('p_address4',p_address4);

974: p_address4 :=l_email;
975:
976: IF (p_segment_num=4) THEN
977: IF g_debug THEN
978: pay_in_utils.trace('p_address4',p_address4);
979: END IF;
980: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,70);
981: RETURN p_address4;
982: END IF ;

Line 980: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,70);

976: IF (p_segment_num=4) THEN
977: IF g_debug THEN
978: pay_in_utils.trace('p_address4',p_address4);
979: END IF;
980: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,70);
981: RETURN p_address4;
982: END IF ;
983:
984: ---------Address5-------------------------

Line 1004: pay_in_utils.trace('p_address5',p_address5);

1000: END IF;
1001:
1002: IF (p_segment_num=5) THEN
1003: IF g_debug THEN
1004: pay_in_utils.trace('p_address5',p_address5);
1005: END IF;
1006: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,80);
1007: RETURN p_address5;
1008: END IF;

Line 1006: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,80);

1002: IF (p_segment_num=5) THEN
1003: IF g_debug THEN
1004: pay_in_utils.trace('p_address5',p_address5);
1005: END IF;
1006: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,80);
1007: RETURN p_address5;
1008: END IF;
1009:
1010:

Line 1043: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
1046: pay_in_utils.trace('**************************************************','********************');
1047: pay_in_utils.trace('p_person_id ',p_person_id );

Line 1046: pay_in_utils.trace('**************************************************','********************');

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
1046: pay_in_utils.trace('**************************************************','********************');
1047: pay_in_utils.trace('p_person_id ',p_person_id );
1048: pay_in_utils.trace('**************************************************','********************');
1049: END IF;
1050:

Line 1047: pay_in_utils.trace('p_person_id ',p_person_id );

1043: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1044:
1045: IF g_debug THEN
1046: pay_in_utils.trace('**************************************************','********************');
1047: pay_in_utils.trace('p_person_id ',p_person_id );
1048: pay_in_utils.trace('**************************************************','********************');
1049: END IF;
1050:
1051: OPEN csr_person_category;

Line 1048: pay_in_utils.trace('**************************************************','********************');

1044:
1045: IF g_debug THEN
1046: pay_in_utils.trace('**************************************************','********************');
1047: pay_in_utils.trace('p_person_id ',p_person_id );
1048: pay_in_utils.trace('**************************************************','********************');
1049: END IF;
1050:
1051: OPEN csr_person_category;
1052: FETCH csr_person_category INTO l_sex, l_age;

Line 1063: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

1059: ELSE
1060: l_emp_category := 'G';
1061: END IF;
1062:
1063: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1064:
1065: RETURN l_emp_category;
1066:
1067: IF g_debug THEN

Line 1068: pay_in_utils.trace('**************************************************','********************');

1064:
1065: RETURN l_emp_category;
1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('l_emp_category ',l_emp_category );
1070: pay_in_utils.trace('**************************************************','********************');
1071: END IF;
1072:

Line 1069: pay_in_utils.trace('l_emp_category ',l_emp_category );

1065: RETURN l_emp_category;
1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('l_emp_category ',l_emp_category );
1070: pay_in_utils.trace('**************************************************','********************');
1071: END IF;
1072:
1073: END get_emp_category;

Line 1070: pay_in_utils.trace('**************************************************','********************');

1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('l_emp_category ',l_emp_category );
1070: pay_in_utils.trace('**************************************************','********************');
1071: END IF;
1072:
1073: END get_emp_category;
1074: