eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_PF_REPORTS dependencies on DBMS_LOB

Line 271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

267:
268:
269:
270: l_tag := '';
271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
272:
273:
274: FOR rec_assignment IN csr_assignment
275: LOOP

Line 281: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

277: l_count := l_count + 1 ;
278: IF l_count < 21
279: THEN
280: l_tag := ''; --Employee Tag for the employees in Main Sheet
281: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
282: ELSE
283: l_tag := ''; --Employee Tag for the employees in Continous Sheet
284: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
285: END IF ;

Line 284: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

280: l_tag := ''; --Employee Tag for the employees in Main Sheet
281: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
282: ELSE
283: l_tag := ''; --Employee Tag for the employees in Continous Sheet
284: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
285: END IF ;
286:
287: l_tag := pay_in_xml_utils.getTag('c_2_sl_no',l_count);
288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

284: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
285: END IF ;
286:
287: l_tag := pay_in_xml_utils.getTag('c_2_sl_no',l_count);
288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
289:
290: l_tag := pay_in_xml_utils.getTag('c_2_pf_no',rec_assignment.pf_no);
291: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
292:

Line 291: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

287: l_tag := pay_in_xml_utils.getTag('c_2_sl_no',l_count);
288: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
289:
290: l_tag := pay_in_xml_utils.getTag('c_2_pf_no',rec_assignment.pf_no);
291: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
292:
293: l_tag := pay_in_xml_utils.getTag('c_2_nssn',rec_assignment.nssn);
294: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
295:

Line 294: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

290: l_tag := pay_in_xml_utils.getTag('c_2_pf_no',rec_assignment.pf_no);
291: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
292:
293: l_tag := pay_in_xml_utils.getTag('c_2_nssn',rec_assignment.nssn);
294: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
295:
296: /*
297: Incase of Hire Date and Term Date will show the DD value only if the Hire/Term Month is the
298: same as the reporting month.

Line 320: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

316: l_term_print_copy := NULL ;
317: END IF ;
318:
319: l_tag := pay_in_xml_utils.getTag('c_2_hiredate',l_hire_dd);
320: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
321:
322: l_tag := pay_in_xml_utils.getTag('c_2_emp_type',rec_assignment.emp_type);
323: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
324:

Line 323: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

319: l_tag := pay_in_xml_utils.getTag('c_2_hiredate',l_hire_dd);
320: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
321:
322: l_tag := pay_in_xml_utils.getTag('c_2_emp_type',rec_assignment.emp_type);
323: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
324:
325: l_tag := pay_in_xml_utils.getTag('c_2_term_date',l_term_dd);
326: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
327:

Line 326: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

322: l_tag := pay_in_xml_utils.getTag('c_2_emp_type',rec_assignment.emp_type);
323: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
324:
325: l_tag := pay_in_xml_utils.getTag('c_2_term_date',l_term_dd);
326: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
327:
328: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_report',l_term_print_copy);
329: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
330:

Line 329: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

325: l_tag := pay_in_xml_utils.getTag('c_2_term_date',l_term_dd);
326: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
327:
328: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_report',l_term_print_copy);
329: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
330:
331: /*Added following code for bug6504522*/
332: IF l_term_efile = 'SUP_ANN' THEN
333: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','1');

Line 334: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

330:
331: /*Added following code for bug6504522*/
332: IF l_term_efile = 'SUP_ANN' THEN
333: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','1');
334: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
335: ELSIF l_term_efile = 'RETIRE' THEN
336: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','2');
337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
338: ELSIF l_term_efile = 'DEATH' THEN

Line 337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

333: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','1');
334: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
335: ELSIF l_term_efile = 'RETIRE' THEN
336: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','2');
337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
338: ELSIF l_term_efile = 'DEATH' THEN
339: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','3');
340: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
341: ELSIF l_term_efile = 'PMT_DISABLE' OR

Line 340: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

336: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','2');
337: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
338: ELSIF l_term_efile = 'DEATH' THEN
339: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','3');
340: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
341: ELSIF l_term_efile = 'PMT_DISABLE' OR
342: l_term_efile = 'RESIGN' THEN
343: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','5');
344: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 344: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

340: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
341: ELSIF l_term_efile = 'PMT_DISABLE' OR
342: l_term_efile = 'RESIGN' THEN
343: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','5');
344: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
345: ELSIF l_term_efile = 'RETRENCH' THEN
346: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','6');
347: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
348: END IF ;

Line 347: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

343: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','5');
344: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
345: ELSIF l_term_efile = 'RETRENCH' THEN
346: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','6');
347: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
348: END IF ;
349:
350: IF rec_assignment.eps = 'FULL_FULL' THEN
351: l_tag := pay_in_xml_utils.getTag('c_2_eps','Y');

Line 352: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

348: END IF ;
349:
350: IF rec_assignment.eps = 'FULL_FULL' THEN
351: l_tag := pay_in_xml_utils.getTag('c_2_eps','Y');
352: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
353: ELSE
354: l_tag := pay_in_xml_utils.getTag('c_2_eps','N');
355: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
356: END IF ;

Line 355: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

351: l_tag := pay_in_xml_utils.getTag('c_2_eps','Y');
352: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
353: ELSE
354: l_tag := pay_in_xml_utils.getTag('c_2_eps','N');
355: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
356: END IF ;
357:
358:
359: /*EXEM -> Exempted PF Organization

Line 369: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

365: IF rec_assignment_bal.bal_name = 'Employee Statutory PF Contribution' AND rec_assignment.pf_class <> 'EXEM'
366: THEN
367:
368: l_tag := pay_in_xml_utils.getTag('c_2_emp_pf_con',format_number(rec_assignment_bal.bal_value));
369: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
370: ELSIF rec_assignment_bal.bal_name = 'Employee Voluntary PF Contribution' AND rec_assignment.pf_class <> 'EXEM'
371: THEN
372: l_tag := pay_in_xml_utils.getTag('c_2_emp_vol_pf',format_number(rec_assignment_bal.bal_value));
373: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 373: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

369: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
370: ELSIF rec_assignment_bal.bal_name = 'Employee Voluntary PF Contribution' AND rec_assignment.pf_class <> 'EXEM'
371: THEN
372: l_tag := pay_in_xml_utils.getTag('c_2_emp_vol_pf',format_number(rec_assignment_bal.bal_value));
373: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
374: ELSIF rec_assignment_bal.bal_name = 'Employer PF Contribution' AND rec_assignment.pf_class <> 'EXEM'
375: THEN
376: l_tag := pay_in_xml_utils.getTag('c_2_emplr_pf_con',format_number(rec_assignment_bal.bal_value));
377: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 377: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

373: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
374: ELSIF rec_assignment_bal.bal_name = 'Employer PF Contribution' AND rec_assignment.pf_class <> 'EXEM'
375: THEN
376: l_tag := pay_in_xml_utils.getTag('c_2_emplr_pf_con',format_number(rec_assignment_bal.bal_value));
377: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
378: ELSIF rec_assignment_bal.bal_name = 'Refund of Advance Employee PF Share' AND rec_assignment.pf_class <> 'EXEM'
379: THEN
380: l_tag := pay_in_xml_utils.getTag('c_2_ref_adv_emp',format_number(rec_assignment_bal.bal_value));
381: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 381: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

377: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
378: ELSIF rec_assignment_bal.bal_name = 'Refund of Advance Employee PF Share' AND rec_assignment.pf_class <> 'EXEM'
379: THEN
380: l_tag := pay_in_xml_utils.getTag('c_2_ref_adv_emp',format_number(rec_assignment_bal.bal_value));
381: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
382: ELSIF rec_assignment_bal.bal_name = 'Refund of Advance Employer PF Share' AND rec_assignment.pf_class <> 'EXEM'
383: THEN
384: l_tag := pay_in_xml_utils.getTag('c_2_ref_adv_emplr',format_number(rec_assignment_bal.bal_value));
385: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 385: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

381: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
382: ELSIF rec_assignment_bal.bal_name = 'Refund of Advance Employer PF Share' AND rec_assignment.pf_class <> 'EXEM'
383: THEN
384: l_tag := pay_in_xml_utils.getTag('c_2_ref_adv_emplr',format_number(rec_assignment_bal.bal_value));
385: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
386: ELSIF rec_assignment_bal.bal_name = 'Non Contributory Period'
387: THEN
388: l_tag := pay_in_xml_utils.getTag('c_2_non_con_per',rec_assignment_bal.bal_value);
389: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 389: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

385: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
386: ELSIF rec_assignment_bal.bal_name = 'Non Contributory Period'
387: THEN
388: l_tag := pay_in_xml_utils.getTag('c_2_non_con_per',rec_assignment_bal.bal_value);
389: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
390: l_total_ncp := l_total_ncp + rec_assignment_bal.bal_value ;
391: ELSIF rec_assignment_bal.bal_name = 'EPS Contribution'
392: THEN
393: l_tag := pay_in_xml_utils.getTag('c_2_eps_con',format_number(rec_assignment_bal.bal_value));

Line 394: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

390: l_total_ncp := l_total_ncp + rec_assignment_bal.bal_value ;
391: ELSIF rec_assignment_bal.bal_name = 'EPS Contribution'
392: THEN
393: l_tag := pay_in_xml_utils.getTag('c_2_eps_con',format_number(rec_assignment_bal.bal_value));
394: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
395: ELSIF rec_assignment_bal.bal_name = 'PF Actual Salary'
396: THEN
397: l_tag := pay_in_xml_utils.getTag('c_2_pf_wages',format_number(rec_assignment_bal.bal_value));
398: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 398: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

394: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
395: ELSIF rec_assignment_bal.bal_name = 'PF Actual Salary'
396: THEN
397: l_tag := pay_in_xml_utils.getTag('c_2_pf_wages',format_number(rec_assignment_bal.bal_value));
398: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
399: ELSIF rec_assignment_bal.bal_name = 'Recovery of Over Payment of Employee PF Share'
400: THEN
401: l_tag := pay_in_xml_utils.getTag('c_2_rec_overpay_emp',format_number(rec_assignment_bal.bal_value));
402: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 402: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

398: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
399: ELSIF rec_assignment_bal.bal_name = 'Recovery of Over Payment of Employee PF Share'
400: THEN
401: l_tag := pay_in_xml_utils.getTag('c_2_rec_overpay_emp',format_number(rec_assignment_bal.bal_value));
402: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
403: ELSIF rec_assignment_bal.bal_name = 'Recovery of Over Payment of Employer PF Share'
404: THEN
405: l_tag := pay_in_xml_utils.getTag('c_2_rec_overpay_emplr',format_number(rec_assignment_bal.bal_value));
406: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 406: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

402: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
403: ELSIF rec_assignment_bal.bal_name = 'Recovery of Over Payment of Employer PF Share'
404: THEN
405: l_tag := pay_in_xml_utils.getTag('c_2_rec_overpay_emplr',format_number(rec_assignment_bal.bal_value));
406: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
407: ELSIF rec_assignment_bal.bal_name = 'Penalty Interest on Refund of Employee PF Share'
408: THEN
409: l_tag := pay_in_xml_utils.getTag('c_2_ref_penalty_emp',format_number(rec_assignment_bal.bal_value));
410: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 410: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

406: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
407: ELSIF rec_assignment_bal.bal_name = 'Penalty Interest on Refund of Employee PF Share'
408: THEN
409: l_tag := pay_in_xml_utils.getTag('c_2_ref_penalty_emp',format_number(rec_assignment_bal.bal_value));
410: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
411: ELSIF rec_assignment_bal.bal_name = 'Penalty Interest on Refund of Employer PF Share'
412: THEN
413: l_tag := pay_in_xml_utils.getTag('c_2_ref_penalty_emplr',format_number(rec_assignment_bal.bal_value));
414: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 414: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

410: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
411: ELSIF rec_assignment_bal.bal_name = 'Penalty Interest on Refund of Employer PF Share'
412: THEN
413: l_tag := pay_in_xml_utils.getTag('c_2_ref_penalty_emplr',format_number(rec_assignment_bal.bal_value));
414: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
415:
416: ELSIF rec_assignment_bal.bal_name = 'Voluntary PF Percent'
417: THEN
418: l_tag := pay_in_xml_utils.getTag('c_2_vol_pf_percent',rec_assignment_bal.bal_value);

Line 419: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

415:
416: ELSIF rec_assignment_bal.bal_name = 'Voluntary PF Percent'
417: THEN
418: l_tag := pay_in_xml_utils.getTag('c_2_vol_pf_percent',rec_assignment_bal.bal_value);
419: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
420: END IF ;
421:
422:
423:

Line 482: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

478:
479: IF l_count < 21
480: THEN
481: l_tag := '';
482: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
483: ELSE
484: l_tag := '';
485: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
486: END IF ;

Line 485: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

481: l_tag := '';
482: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
483: ELSE
484: l_tag := '';
485: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
486: END IF ;
487:
488: END LOOP ;
489:

Line 492: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

488: END LOOP ;
489:
490:
491: l_tag := '';
492: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
493:
494: p_total_ncp := l_total_ncp;
495:
496: l_tag := '';

Line 497: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

493:
494: p_total_ncp := l_total_ncp;
495:
496: l_tag := '';
497: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
498:
499: l_tag := pay_in_xml_utils.getTag('c_3_total_pf_wages',format_number(l_total_pf_wages));
500: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
501:

Line 500: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

496: l_tag := '';
497: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
498:
499: l_tag := pay_in_xml_utils.getTag('c_3_total_pf_wages',format_number(l_total_pf_wages));
500: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
501:
502: l_tag := pay_in_xml_utils.getTag('c_3_total_epf',format_number(l_total_epf));
503: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
504:

Line 503: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

499: l_tag := pay_in_xml_utils.getTag('c_3_total_pf_wages',format_number(l_total_pf_wages));
500: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
501:
502: l_tag := pay_in_xml_utils.getTag('c_3_total_epf',format_number(l_total_epf));
503: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
504:
505: l_tag := pay_in_xml_utils.getTag('c_3_epf_admin',format_number(l_epf_admin));
506: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
507:

Line 506: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

502: l_tag := pay_in_xml_utils.getTag('c_3_total_epf',format_number(l_total_epf));
503: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
504:
505: l_tag := pay_in_xml_utils.getTag('c_3_epf_admin',format_number(l_epf_admin));
506: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
507:
508: l_tag := pay_in_xml_utils.getTag('c_3_eps_con',format_number(l_eps_con));
509: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
510:

Line 509: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

505: l_tag := pay_in_xml_utils.getTag('c_3_epf_admin',format_number(l_epf_admin));
506: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
507:
508: l_tag := pay_in_xml_utils.getTag('c_3_eps_con',format_number(l_eps_con));
509: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
510:
511: l_tag := pay_in_xml_utils.getTag('c_3_edli_con',format_number(l_edli_con));
512: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
513:

Line 512: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

508: l_tag := pay_in_xml_utils.getTag('c_3_eps_con',format_number(l_eps_con));
509: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
510:
511: l_tag := pay_in_xml_utils.getTag('c_3_edli_con',format_number(l_edli_con));
512: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
513:
514: l_tag := pay_in_xml_utils.getTag('c_3_edli_admin',format_number(l_edli_admin));
515: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
516:

Line 515: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

511: l_tag := pay_in_xml_utils.getTag('c_3_edli_con',format_number(l_edli_con));
512: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
513:
514: l_tag := pay_in_xml_utils.getTag('c_3_edli_admin',format_number(l_edli_admin));
515: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
516:
517: l_tag := pay_in_xml_utils.getTag('c_3_epf_inspection',format_number(l_epf_inspection));
518: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
519:

Line 518: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

514: l_tag := pay_in_xml_utils.getTag('c_3_edli_admin',format_number(l_edli_admin));
515: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
516:
517: l_tag := pay_in_xml_utils.getTag('c_3_epf_inspection',format_number(l_epf_inspection));
518: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
519:
520: l_tag := pay_in_xml_utils.getTag('c_3_edli_inspection',format_number(l_edli_inspection));
521: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
522:

Line 521: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

517: l_tag := pay_in_xml_utils.getTag('c_3_epf_inspection',format_number(l_epf_inspection));
518: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
519:
520: l_tag := pay_in_xml_utils.getTag('c_3_edli_inspection',format_number(l_edli_inspection));
521: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
522:
523: l_tag := pay_in_xml_utils.getTag('c_3_rec_overpay',format_number(l_rec_overpay));
524: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
525:

Line 524: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

520: l_tag := pay_in_xml_utils.getTag('c_3_edli_inspection',format_number(l_edli_inspection));
521: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
522:
523: l_tag := pay_in_xml_utils.getTag('c_3_rec_overpay',format_number(l_rec_overpay));
524: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
525:
526: l_tag := pay_in_xml_utils.getTag('c_3_penal_int',format_number(l_penal_int));
527: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
528:

Line 527: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

523: l_tag := pay_in_xml_utils.getTag('c_3_rec_overpay',format_number(l_rec_overpay));
524: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
525:
526: l_tag := pay_in_xml_utils.getTag('c_3_penal_int',format_number(l_penal_int));
527: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
528:
529: OPEN csr_challan;
530: FETCH csr_challan INTO l_interest_on_sec,l_legal_charges,l_penalty;
531: CLOSE csr_challan;

Line 538: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

534: FETCH csr_pup_total_amount INTO l_pup;
535: CLOSE csr_pup_total_amount;
536:
537: l_tag := pay_in_xml_utils.getTag('c_3_int_on_sec',format_number(l_interest_on_sec));
538: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
539:
540: l_tag := pay_in_xml_utils.getTag('c_3_legal_charges',format_number(l_legal_charges));
541: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
542:

Line 541: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

537: l_tag := pay_in_xml_utils.getTag('c_3_int_on_sec',format_number(l_interest_on_sec));
538: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
539:
540: l_tag := pay_in_xml_utils.getTag('c_3_legal_charges',format_number(l_legal_charges));
541: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
542:
543: l_tag := pay_in_xml_utils.getTag('c_3_penalty',format_number(l_penalty));
544: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
545:

Line 544: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

540: l_tag := pay_in_xml_utils.getTag('c_3_legal_charges',format_number(l_legal_charges));
541: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
542:
543: l_tag := pay_in_xml_utils.getTag('c_3_penalty',format_number(l_penalty));
544: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
545:
546: l_tag := pay_in_xml_utils.getTag('c_3_pup',format_number(l_pup));
547: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
548:

Line 547: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

543: l_tag := pay_in_xml_utils.getTag('c_3_penalty',format_number(l_penalty));
544: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
545:
546: l_tag := pay_in_xml_utils.getTag('c_3_pup',format_number(l_pup));
547: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
548:
549: l_tag := '';
550: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
551:

Line 550: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

546: l_tag := pay_in_xml_utils.getTag('c_3_pup',format_number(l_pup));
547: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
548:
549: l_tag := '';
550: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
551:
552: -- Level3 Ends.
553:
554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 636: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

632: l_procedure := g_package ||'create_level4_xml';
633: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
634:
635: l_tag := '';
636: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
637:
638: FOR rec_challan IN csr_challan
639: LOOP
640:

Line 642: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

638: FOR rec_challan IN csr_challan
639: LOOP
640:
641: l_tag := '';
642: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
643:
644: l_tag := pay_in_xml_utils.getTag('c_4_payment_type',rec_challan.Payment_Type);
645: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
646:

Line 645: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

641: l_tag := '';
642: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
643:
644: l_tag := pay_in_xml_utils.getTag('c_4_payment_type',rec_challan.Payment_Type);
645: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
646:
647: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_no',rec_challan.Cheque_DD_No);
648: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
649:

Line 648: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

644: l_tag := pay_in_xml_utils.getTag('c_4_payment_type',rec_challan.Payment_Type);
645: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
646:
647: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_no',rec_challan.Cheque_DD_No);
648: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
649:
650: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_date',TO_CHAR(fnd_date.canonical_to_date(rec_challan.Cheque_DD_Date),'DD-MM-YYYY'));
651: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
652:

Line 651: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

647: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_no',rec_challan.Cheque_DD_No);
648: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
649:
650: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_date',TO_CHAR(fnd_date.canonical_to_date(rec_challan.Cheque_DD_Date),'DD-MM-YYYY'));
651: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
652:
653: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_dep_date',TO_CHAR(fnd_date.canonical_to_date(rec_challan.Cheque_DD_Dep_Date),'DD-MM-YYYY'));
654: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
655:

Line 654: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

650: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_date',TO_CHAR(fnd_date.canonical_to_date(rec_challan.Cheque_DD_Date),'DD-MM-YYYY'));
651: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
652:
653: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_dep_date',TO_CHAR(fnd_date.canonical_to_date(rec_challan.Cheque_DD_Dep_Date),'DD-MM-YYYY'));
654: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
655:
656: l_tag := pay_in_xml_utils.getTag('c_4_amount',format_number(rec_challan.Amount));
657: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
658:

Line 657: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

653: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_dep_date',TO_CHAR(fnd_date.canonical_to_date(rec_challan.Cheque_DD_Dep_Date),'DD-MM-YYYY'));
654: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
655:
656: l_tag := pay_in_xml_utils.getTag('c_4_amount',format_number(rec_challan.Amount));
657: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
658:
659: l_tag := pay_in_xml_utils.getTag('c_4_bank_code',replace_comma(rec_challan.Bank_Code));
660: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
661:

Line 660: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

656: l_tag := pay_in_xml_utils.getTag('c_4_amount',format_number(rec_challan.Amount));
657: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
658:
659: l_tag := pay_in_xml_utils.getTag('c_4_bank_code',replace_comma(rec_challan.Bank_Code));
660: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
661:
662: l_tag := pay_in_xml_utils.getTag('c_4_bank_name',replace_comma(rec_challan.Bank_Name));
663: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
664:

Line 663: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

659: l_tag := pay_in_xml_utils.getTag('c_4_bank_code',replace_comma(rec_challan.Bank_Code));
660: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
661:
662: l_tag := pay_in_xml_utils.getTag('c_4_bank_name',replace_comma(rec_challan.Bank_Name));
663: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
664:
665: l_tag := pay_in_xml_utils.getTag('c_4_branch_code',replace_comma(rec_challan.Branch_Code));
666: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
667:

Line 666: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

662: l_tag := pay_in_xml_utils.getTag('c_4_bank_name',replace_comma(rec_challan.Bank_Name));
663: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
664:
665: l_tag := pay_in_xml_utils.getTag('c_4_branch_code',replace_comma(rec_challan.Branch_Code));
666: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
667:
668: l_tag := pay_in_xml_utils.getTag('c_4_branch_name',replace_comma(rec_challan.Branch_Name));
669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
670:

Line 669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

665: l_tag := pay_in_xml_utils.getTag('c_4_branch_code',replace_comma(rec_challan.Branch_Code));
666: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
667:
668: l_tag := pay_in_xml_utils.getTag('c_4_branch_name',replace_comma(rec_challan.Branch_Name));
669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
670:
671: l_tag := pay_in_xml_utils.getTag('c_4_branch_add',replace_comma(rec_challan.Branch_Add));
672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
673:

Line 672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

668: l_tag := pay_in_xml_utils.getTag('c_4_branch_name',replace_comma(rec_challan.Branch_Name));
669: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
670:
671: l_tag := pay_in_xml_utils.getTag('c_4_branch_add',replace_comma(rec_challan.Branch_Add));
672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
673:
674: l_tag := pay_in_xml_utils.getTag('c_4_challan_ref',rec_challan.Challan_Ref);
675: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
676:

Line 675: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

671: l_tag := pay_in_xml_utils.getTag('c_4_branch_add',replace_comma(rec_challan.Branch_Add));
672: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
673:
674: l_tag := pay_in_xml_utils.getTag('c_4_challan_ref',rec_challan.Challan_Ref);
675: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
676:
677: l_tag := pay_in_xml_utils.getTag('c_4_dep_branch_code',replace_comma(rec_challan.Dep_Branch_Code));
678: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
679:

Line 678: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

674: l_tag := pay_in_xml_utils.getTag('c_4_challan_ref',rec_challan.Challan_Ref);
675: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
676:
677: l_tag := pay_in_xml_utils.getTag('c_4_dep_branch_code',replace_comma(rec_challan.Dep_Branch_Code));
678: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
679:
680: l_tag := pay_in_xml_utils.getTag('c_4_base_branch',replace_comma(rec_challan.Base_Branch_Code));
681: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
682:

Line 681: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

677: l_tag := pay_in_xml_utils.getTag('c_4_dep_branch_code',replace_comma(rec_challan.Dep_Branch_Code));
678: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
679:
680: l_tag := pay_in_xml_utils.getTag('c_4_base_branch',replace_comma(rec_challan.Base_Branch_Code));
681: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
682:
683: l_tag := pay_in_xml_utils.getTag('c_4_base_branch_name',replace_comma(rec_challan.Base_Branch_Name));
684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
685:

Line 684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

680: l_tag := pay_in_xml_utils.getTag('c_4_base_branch',replace_comma(rec_challan.Base_Branch_Code));
681: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
682:
683: l_tag := pay_in_xml_utils.getTag('c_4_base_branch_name',replace_comma(rec_challan.Base_Branch_Name));
684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
685:
686: l_tag := '';
687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
688:

Line 687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

683: l_tag := pay_in_xml_utils.getTag('c_4_base_branch_name',replace_comma(rec_challan.Base_Branch_Name));
684: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
685:
686: l_tag := '';
687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
688:
689: END LOOP ;
690:
691: l_tag := '';

Line 692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

688:
689: END LOOP ;
690:
691: l_tag := '';
692: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
693:
694: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
695:
696: EXCEPTION

Line 772: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

768: l_procedure := g_package ||'create_level5_xml';
769: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
770:
771: l_tag := '';
772: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
773:
774: FOR rec_challan IN csr_challan
775: LOOP
776: FOR rec_14B IN csr_14B(rec_challan.Challan_Ref)

Line 779: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

775: LOOP
776: FOR rec_14B IN csr_14B(rec_challan.Challan_Ref)
777: LOOP
778: l_tag := '';
779: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
780:
781: l_tag := pay_in_xml_utils.getTag('c_5_prev_mth',rec_14B.Prev_Mth);
782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
783:

Line 782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

778: l_tag := '';
779: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
780:
781: l_tag := pay_in_xml_utils.getTag('c_5_prev_mth',rec_14B.Prev_Mth);
782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
783:
784: l_tag := pay_in_xml_utils.getTag('c_5_prev_yr',rec_14B.Prev_Yr);
785: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
786:

Line 785: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

781: l_tag := pay_in_xml_utils.getTag('c_5_prev_mth',rec_14B.Prev_Mth);
782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
783:
784: l_tag := pay_in_xml_utils.getTag('c_5_prev_yr',rec_14B.Prev_Yr);
785: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
786:
787: l_tag := pay_in_xml_utils.getTag('c_5_epf_penal_damages',format_number(rec_14B.Penal_Damages_Due));
788: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
789:

Line 788: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

784: l_tag := pay_in_xml_utils.getTag('c_5_prev_yr',rec_14B.Prev_Yr);
785: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
786:
787: l_tag := pay_in_xml_utils.getTag('c_5_epf_penal_damages',format_number(rec_14B.Penal_Damages_Due));
788: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
789:
790: l_tag := pay_in_xml_utils.getTag('c_5_eps_penal_damages',format_number(rec_14B.EPS_Penal_Damages));
791: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
792:

Line 791: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

787: l_tag := pay_in_xml_utils.getTag('c_5_epf_penal_damages',format_number(rec_14B.Penal_Damages_Due));
788: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
789:
790: l_tag := pay_in_xml_utils.getTag('c_5_eps_penal_damages',format_number(rec_14B.EPS_Penal_Damages));
791: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
792:
793: l_tag := pay_in_xml_utils.getTag('c_5_edli_penal_damages',format_number(rec_14B.EDLI_Penal_Damages));
794: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
795:

Line 794: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

790: l_tag := pay_in_xml_utils.getTag('c_5_eps_penal_damages',format_number(rec_14B.EPS_Penal_Damages));
791: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
792:
793: l_tag := pay_in_xml_utils.getTag('c_5_edli_penal_damages',format_number(rec_14B.EDLI_Penal_Damages));
794: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
795:
796: l_tag := pay_in_xml_utils.getTag('c_5_epf_admin',format_number(rec_14B.EPF_Penal_Damages));
797: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
798:

Line 797: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

793: l_tag := pay_in_xml_utils.getTag('c_5_edli_penal_damages',format_number(rec_14B.EDLI_Penal_Damages));
794: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
795:
796: l_tag := pay_in_xml_utils.getTag('c_5_epf_admin',format_number(rec_14B.EPF_Penal_Damages));
797: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
798:
799: l_tag := pay_in_xml_utils.getTag('c_5_edli_admin',format_number(rec_14B.Edli_Admin));
800: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
801:

Line 800: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

796: l_tag := pay_in_xml_utils.getTag('c_5_epf_admin',format_number(rec_14B.EPF_Penal_Damages));
797: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
798:
799: l_tag := pay_in_xml_utils.getTag('c_5_edli_admin',format_number(rec_14B.Edli_Admin));
800: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
801:
802: l_tag := '';
803: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
804: END LOOP ;

Line 803: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

799: l_tag := pay_in_xml_utils.getTag('c_5_edli_admin',format_number(rec_14B.Edli_Admin));
800: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
801:
802: l_tag := '';
803: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
804: END LOOP ;
805: END LOOP ;
806:
807: l_tag := '';

Line 808: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

804: END LOOP ;
805: END LOOP ;
806:
807: l_tag := '';
808: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
809:
810:
811: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
812:

Line 888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

884: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
885:
886:
887: l_tag := '';
888: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
889:
890: FOR rec_challan IN csr_challan
891: LOOP
892: FOR rec_7Q IN csr_7Q(rec_challan.Challan_Ref)

Line 895: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

891: LOOP
892: FOR rec_7Q IN csr_7Q(rec_challan.Challan_Ref)
893: LOOP
894: l_tag := '';
895: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
896:
897: l_tag := pay_in_xml_utils.getTag('c_6_prev_mth',rec_7Q.Due_Mth);
898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
899:

Line 898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

894: l_tag := '';
895: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
896:
897: l_tag := pay_in_xml_utils.getTag('c_6_prev_mth',rec_7Q.Due_Mth);
898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
899:
900: l_tag := pay_in_xml_utils.getTag('c_6_prev_yr',rec_7Q.Due_Yr);
901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
902:

Line 901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

897: l_tag := pay_in_xml_utils.getTag('c_6_prev_mth',rec_7Q.Due_Mth);
898: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
899:
900: l_tag := pay_in_xml_utils.getTag('c_6_prev_yr',rec_7Q.Due_Yr);
901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
902:
903: l_tag := pay_in_xml_utils.getTag('c_6_epf_penal_damages',format_number(rec_7Q.EPF_Damages));
904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
905:

Line 904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

900: l_tag := pay_in_xml_utils.getTag('c_6_prev_yr',rec_7Q.Due_Yr);
901: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
902:
903: l_tag := pay_in_xml_utils.getTag('c_6_epf_penal_damages',format_number(rec_7Q.EPF_Damages));
904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
905:
906: l_tag := pay_in_xml_utils.getTag('c_6_eps_penal_damages',format_number(rec_7Q.EPS_Damages));
907: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
908:

Line 907: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

903: l_tag := pay_in_xml_utils.getTag('c_6_epf_penal_damages',format_number(rec_7Q.EPF_Damages));
904: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
905:
906: l_tag := pay_in_xml_utils.getTag('c_6_eps_penal_damages',format_number(rec_7Q.EPS_Damages));
907: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
908:
909: l_tag := pay_in_xml_utils.getTag('c_6_edli_penal_damages',format_number(rec_7Q.EDLI_Damages));
910: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
911:

Line 910: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

906: l_tag := pay_in_xml_utils.getTag('c_6_eps_penal_damages',format_number(rec_7Q.EPS_Damages));
907: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
908:
909: l_tag := pay_in_xml_utils.getTag('c_6_edli_penal_damages',format_number(rec_7Q.EDLI_Damages));
910: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
911:
912: l_tag := pay_in_xml_utils.getTag('c_6_epf_admin',format_number(rec_7Q.EPF_Admin));
913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
914:

Line 913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

909: l_tag := pay_in_xml_utils.getTag('c_6_edli_penal_damages',format_number(rec_7Q.EDLI_Damages));
910: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
911:
912: l_tag := pay_in_xml_utils.getTag('c_6_epf_admin',format_number(rec_7Q.EPF_Admin));
913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
914:
915: l_tag := pay_in_xml_utils.getTag('c_6_edli_admin',format_number(rec_7Q.Edli_Admin));
916: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
917:

Line 916: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

912: l_tag := pay_in_xml_utils.getTag('c_6_epf_admin',format_number(rec_7Q.EPF_Admin));
913: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
914:
915: l_tag := pay_in_xml_utils.getTag('c_6_edli_admin',format_number(rec_7Q.Edli_Admin));
916: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
917:
918: l_tag := '';
919: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
920: END LOOP ;

Line 919: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

915: l_tag := pay_in_xml_utils.getTag('c_6_edli_admin',format_number(rec_7Q.Edli_Admin));
916: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
917:
918: l_tag := '';
919: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
920: END LOOP ;
921: END LOOP ;
922:
923: l_tag := '';

Line 924: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

920: END LOOP ;
921: END LOOP ;
922:
923: l_tag := '';
924: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
925:
926:
927: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
928:

Line 1007: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1003: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1004:
1005:
1006: l_tag := '';
1007: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1008:
1009: FOR rec_challan IN csr_challan
1010: LOOP
1011: FOR rec_misc IN csr_misc(rec_challan.Challan_Ref)

Line 1014: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1010: LOOP
1011: FOR rec_misc IN csr_misc(rec_challan.Challan_Ref)
1012: LOOP
1013: l_tag := '';
1014: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1015:
1016: l_tag := pay_in_xml_utils.getTag('c_7_epf_pay',format_number(rec_misc.EPF_Misc_Pay));
1017: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1018:

Line 1017: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1013: l_tag := '';
1014: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1015:
1016: l_tag := pay_in_xml_utils.getTag('c_7_epf_pay',format_number(rec_misc.EPF_Misc_Pay));
1017: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1018:
1019: l_tag := pay_in_xml_utils.getTag('c_7_epf_rem',replace_comma(rec_misc.EPF_Rem));
1020: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1021:

Line 1020: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1016: l_tag := pay_in_xml_utils.getTag('c_7_epf_pay',format_number(rec_misc.EPF_Misc_Pay));
1017: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1018:
1019: l_tag := pay_in_xml_utils.getTag('c_7_epf_rem',replace_comma(rec_misc.EPF_Rem));
1020: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1021:
1022: l_tag := pay_in_xml_utils.getTag('c_7_eps_pay',format_number(rec_misc.EPS_Misc_Pay));
1023: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1024:

Line 1023: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1019: l_tag := pay_in_xml_utils.getTag('c_7_epf_rem',replace_comma(rec_misc.EPF_Rem));
1020: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1021:
1022: l_tag := pay_in_xml_utils.getTag('c_7_eps_pay',format_number(rec_misc.EPS_Misc_Pay));
1023: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1024:
1025: l_tag := pay_in_xml_utils.getTag('c_7_eps_rem',replace_comma(rec_misc.EPS_Rem));
1026: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1027:

Line 1026: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1022: l_tag := pay_in_xml_utils.getTag('c_7_eps_pay',format_number(rec_misc.EPS_Misc_Pay));
1023: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1024:
1025: l_tag := pay_in_xml_utils.getTag('c_7_eps_rem',replace_comma(rec_misc.EPS_Rem));
1026: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1027:
1028: l_tag := pay_in_xml_utils.getTag('c_7_edli_pay',format_number(rec_misc.EDLI_Misc_Pay));
1029: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1030:

Line 1029: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1025: l_tag := pay_in_xml_utils.getTag('c_7_eps_rem',replace_comma(rec_misc.EPS_Rem));
1026: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1027:
1028: l_tag := pay_in_xml_utils.getTag('c_7_edli_pay',format_number(rec_misc.EDLI_Misc_Pay));
1029: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1030:
1031: l_tag := pay_in_xml_utils.getTag('c_7_edli_rem',replace_comma(rec_misc.EDLI_Rem));
1032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1033:

Line 1032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1028: l_tag := pay_in_xml_utils.getTag('c_7_edli_pay',format_number(rec_misc.EDLI_Misc_Pay));
1029: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1030:
1031: l_tag := pay_in_xml_utils.getTag('c_7_edli_rem',replace_comma(rec_misc.EDLI_Rem));
1032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1033:
1034: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin',format_number(rec_misc.EPF_Admin));
1035: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1036:

Line 1035: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1031: l_tag := pay_in_xml_utils.getTag('c_7_edli_rem',replace_comma(rec_misc.EDLI_Rem));
1032: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1033:
1034: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin',format_number(rec_misc.EPF_Admin));
1035: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1036:
1037: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin_rem',replace_comma(rec_misc.EPF_Admin_Rem));
1038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1039:

Line 1038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1034: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin',format_number(rec_misc.EPF_Admin));
1035: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1036:
1037: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin_rem',replace_comma(rec_misc.EPF_Admin_Rem));
1038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1039:
1040: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin',format_number(rec_misc.EDLI_Admin));
1041: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1042:

Line 1041: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1037: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin_rem',replace_comma(rec_misc.EPF_Admin_Rem));
1038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1039:
1040: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin',format_number(rec_misc.EDLI_Admin));
1041: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1042:
1043: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin_rem',replace_comma(rec_misc.EDLI_Admin_Rem));
1044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1045:

Line 1044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1040: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin',format_number(rec_misc.EDLI_Admin));
1041: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1042:
1043: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin_rem',replace_comma(rec_misc.EDLI_Admin_Rem));
1044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1045:
1046: l_tag := '';
1047: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1048: END LOOP ;

Line 1047: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1043: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin_rem',replace_comma(rec_misc.EDLI_Admin_Rem));
1044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1045:
1046: l_tag := '';
1047: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1048: END LOOP ;
1049: END LOOP ;
1050:
1051: l_tag := '';

Line 1052: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1048: END LOOP ;
1049: END LOOP ;
1050:
1051: l_tag := '';
1052: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1053:
1054:
1055: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,20);
1056:

Line 1134: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1130: CLOSE csr_filer_id ;
1131:
1132:
1133: l_tag := '';
1134: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1135:
1136: l_sys_date:=to_char(SYSDATE,'DD-MM-YYYY');
1137: --System Date:
1138: l_tag :=pay_in_xml_utils.getTag('c_8_sys_date',l_sys_date);

Line 1139: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1135:
1136: l_sys_date:=to_char(SYSDATE,'DD-MM-YYYY');
1137: --System Date:
1138: l_tag :=pay_in_xml_utils.getTag('c_8_sys_date',l_sys_date);
1139: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1140:
1141: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_id',l_filer_license_id);
1142: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1143:

Line 1142: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1138: l_tag :=pay_in_xml_utils.getTag('c_8_sys_date',l_sys_date);
1139: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1140:
1141: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_id',l_filer_license_id);
1142: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1143:
1144: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_no',p_filer_license_no);
1145: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1146:

Line 1145: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1141: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_id',l_filer_license_id);
1142: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1143:
1144: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_no',p_filer_license_no);
1145: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1146:
1147: l_tag := pay_in_xml_utils.getTag('c_8_total_ncp',p_total_ncp);
1148: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1149:

Line 1148: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1144: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_no',p_filer_license_no);
1145: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1146:
1147: l_tag := pay_in_xml_utils.getTag('c_8_total_ncp',p_total_ncp);
1148: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1149:
1150: FOR rec_rep_details IN csr_rep_details
1151: LOOP
1152:

Line 1154: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1150: FOR rec_rep_details IN csr_rep_details
1151: LOOP
1152:
1153: l_tag := '';
1154: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1155:
1156: l_tag := pay_in_xml_utils.getTag('c_8_rep_name',rec_rep_details.rep_name);
1157: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1158:

Line 1157: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1153: l_tag := '';
1154: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1155:
1156: l_tag := pay_in_xml_utils.getTag('c_8_rep_name',rec_rep_details.rep_name);
1157: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1158:
1159: l_tag := pay_in_xml_utils.getTag('c_8_rep_pos',replace_comma(rec_rep_details.rep_pos));
1160: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1161:

Line 1160: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1156: l_tag := pay_in_xml_utils.getTag('c_8_rep_name',rec_rep_details.rep_name);
1157: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1158:
1159: l_tag := pay_in_xml_utils.getTag('c_8_rep_pos',replace_comma(rec_rep_details.rep_pos));
1160: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1161:
1162: l_tag := '';
1163: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1164:

Line 1163: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1159: l_tag := pay_in_xml_utils.getTag('c_8_rep_pos',replace_comma(rec_rep_details.rep_pos));
1160: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1161:
1162: l_tag := '';
1163: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1164:
1165: END LOOP ;
1166:
1167: l_tag := '';

Line 1168: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1164:
1165: END LOOP ;
1166:
1167: l_tag := '';
1168: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1169:
1170:
1171: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1172:

Line 1282: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1278: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1279:
1280:
1281: l_tag := '';
1282: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1283: --
1284: l_sys_date_time:= TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1285: --System Date:
1286: l_tag :=pay_in_xml_utils.getTag('c_sys_date',l_sys_date_time);

Line 1287: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1283: --
1284: l_sys_date_time:= TO_CHAR(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1285: --System Date:
1286: l_tag :=pay_in_xml_utils.getTag('c_sys_date',l_sys_date_time);
1287: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1288:
1289:
1290: OPEN csr_pf_org;
1291: FETCH csr_pf_org INTO l_business_no

Line 1303: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1299: l_year := SUBSTR(TRIM(l_mth_yr) , (LENGTH(TRIM(l_mth_yr)) - 4)+1);
1300: l_month := SUBSTR(TRIM(l_mth_yr) , 1 , (LENGTH(TRIM(l_mth_yr)) - 4));
1301:
1302: l_tag := pay_in_xml_utils.getTag('c_1_business_no',l_business_no);
1303: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1304:
1305: l_tag := pay_in_xml_utils.getTag('c_1_name_of_comp',replace_comma(l_reg_comp_name));
1306: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1307:

Line 1306: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1302: l_tag := pay_in_xml_utils.getTag('c_1_business_no',l_business_no);
1303: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1304:
1305: l_tag := pay_in_xml_utils.getTag('c_1_name_of_comp',replace_comma(l_reg_comp_name));
1306: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1307:
1308: l_tag := pay_in_xml_utils.getTag('c_1_month',LPAD(l_month,2,'0'));
1309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1310:

Line 1309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1305: l_tag := pay_in_xml_utils.getTag('c_1_name_of_comp',replace_comma(l_reg_comp_name));
1306: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1307:
1308: l_tag := pay_in_xml_utils.getTag('c_1_month',LPAD(l_month,2,'0'));
1309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1310:
1311: l_tag := pay_in_xml_utils.getTag('c_1_year',l_year);
1312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1313:

Line 1312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1308: l_tag := pay_in_xml_utils.getTag('c_1_month',LPAD(l_month,2,'0'));
1309: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1310:
1311: l_tag := pay_in_xml_utils.getTag('c_1_year',l_year);
1312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1313:
1314: l_tag := pay_in_xml_utils.getTag('c_1_return_type',l_return_type);
1315: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1316:

Line 1315: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1311: l_tag := pay_in_xml_utils.getTag('c_1_year',l_year);
1312: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1313:
1314: l_tag := pay_in_xml_utils.getTag('c_1_return_type',l_return_type);
1315: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1316:
1317: l_pup := 'N';
1318: FOR rec_challan IN csr_challan(l_action_context_id)
1319: LOOP

Line 1328: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1324: END IF ;
1325: END LOOP ;
1326:
1327: l_tag := pay_in_xml_utils.getTag('c_1_pup',l_pup);
1328: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1329:
1330: pay_in_utils.set_location(g_debug,'Calling : create_level2_3_xml',1);
1331: create_level2_3_xml(p_business_number => p_business_number
1332: ,p_pf_arc_ref_no => p_pf_arc_ref_no

Line 1370: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1366: ,p_filer_license_no => p_filer_license_no
1367: );
1368:
1369: l_tag := '';
1370: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1371:
1372:
1373:
1374: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 1483: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);

1479: IF l_month = 3 THEN
1480: l_year := l_year - 1 ;
1481: END IF ;
1482:
1483: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1484: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1485: --
1486: l_tag :='';
1487: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1484: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

1480: l_year := l_year - 1 ;
1481: END IF ;
1482:
1483: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1484: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1485: --
1486: l_tag :='';
1487: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1488:

Line 1487: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1483: dbms_lob.createtemporary(g_xml_data,FALSE,DBMS_LOB.CALL);
1484: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
1485: --
1486: l_tag :='';
1487: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1488:
1489: l_tag := '';
1490: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1491:

Line 1490: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1486: l_tag :='';
1487: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1488:
1489: l_tag := '';
1490: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1491:
1492: FOR rec_pf_bus_no IN csr_pf_bus_no(l_month||l_year)
1493: LOOP
1494: create_level1_xml(p_business_number => rec_pf_bus_no.bus_no

Line 1508: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

1504: END LOOP ;
1505:
1506:
1507: l_tag := '';
1508: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1509:
1510:
1511: p_xml := g_xml_data;
1512: