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 PAY_IN_XML_UTILS

Line 287: l_tag := pay_in_xml_utils.getTag('c_2_sl_no',l_count);

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

Line 290: l_tag := pay_in_xml_utils.getTag('c_2_pf_no',rec_assignment.pf_no);

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

Line 293: l_tag := pay_in_xml_utils.getTag('c_2_nssn',rec_assignment.nssn);

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:
296: /*
297: Incase of Hire Date and Term Date will show the DD value only if the Hire/Term Month is the

Line 319: l_tag := pay_in_xml_utils.getTag('c_2_hiredate',l_hire_dd);

315: l_term_efile := NULL ;
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);

Line 322: l_tag := pay_in_xml_utils.getTag('c_2_emp_type',rec_assignment.emp_type);

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

Line 325: l_tag := pay_in_xml_utils.getTag('c_2_term_date',l_term_dd);

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

Line 328: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_report',l_term_print_copy);

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:
331: /*Added following code for bug6504522*/
332: IF l_term_efile = 'SUP_ANN' THEN

Line 333: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','1');

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

Line 336: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','2');

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

Line 339: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','3');

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
342: l_term_efile = 'RESIGN' THEN
343: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','5');

Line 343: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','5');

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

Line 346: l_tag := pay_in_xml_utils.getTag('c_2_term_reason_efile','6');

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 ;
349:
350: IF rec_assignment.eps = 'FULL_FULL' THEN

Line 351: l_tag := pay_in_xml_utils.getTag('c_2_eps','Y');

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

Line 354: l_tag := pay_in_xml_utils.getTag('c_2_eps','N');

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 ;
357:
358:

Line 368: l_tag := pay_in_xml_utils.getTag('c_2_emp_pf_con',format_number(rec_assignment_bal.bal_value));

364: LOOP
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));

Line 372: l_tag := pay_in_xml_utils.getTag('c_2_emp_vol_pf',format_number(rec_assignment_bal.bal_value));

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

Line 376: l_tag := pay_in_xml_utils.getTag('c_2_emplr_pf_con',format_number(rec_assignment_bal.bal_value));

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

Line 380: l_tag := pay_in_xml_utils.getTag('c_2_ref_adv_emp',format_number(rec_assignment_bal.bal_value));

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

Line 384: l_tag := pay_in_xml_utils.getTag('c_2_ref_adv_emplr',format_number(rec_assignment_bal.bal_value));

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

Line 388: l_tag := pay_in_xml_utils.getTag('c_2_non_con_per',rec_assignment_bal.bal_value);

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);
390: l_total_ncp := l_total_ncp + rec_assignment_bal.bal_value ;
391: ELSIF rec_assignment_bal.bal_name = 'EPS Contribution'
392: THEN

Line 393: l_tag := pay_in_xml_utils.getTag('c_2_eps_con',format_number(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));
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));

Line 397: l_tag := pay_in_xml_utils.getTag('c_2_pf_wages',format_number(rec_assignment_bal.bal_value));

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

Line 401: l_tag := pay_in_xml_utils.getTag('c_2_rec_overpay_emp',format_number(rec_assignment_bal.bal_value));

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

Line 405: l_tag := pay_in_xml_utils.getTag('c_2_rec_overpay_emplr',format_number(rec_assignment_bal.bal_value));

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

Line 409: l_tag := pay_in_xml_utils.getTag('c_2_ref_penalty_emp',format_number(rec_assignment_bal.bal_value));

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

Line 413: l_tag := pay_in_xml_utils.getTag('c_2_ref_penalty_emplr',format_number(rec_assignment_bal.bal_value));

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);
415:
416: ELSIF rec_assignment_bal.bal_name = 'Voluntary PF Percent'
417: THEN

Line 418: l_tag := pay_in_xml_utils.getTag('c_2_vol_pf_percent',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);
419: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
420: END IF ;
421:
422:

Line 499: l_tag := pay_in_xml_utils.getTag('c_3_total_pf_wages',format_number(l_total_pf_wages));

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

Line 502: l_tag := pay_in_xml_utils.getTag('c_3_total_epf',format_number(l_total_epf));

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

Line 505: l_tag := pay_in_xml_utils.getTag('c_3_epf_admin',format_number(l_epf_admin));

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

Line 508: l_tag := pay_in_xml_utils.getTag('c_3_eps_con',format_number(l_eps_con));

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

Line 511: l_tag := pay_in_xml_utils.getTag('c_3_edli_con',format_number(l_edli_con));

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

Line 514: l_tag := pay_in_xml_utils.getTag('c_3_edli_admin',format_number(l_edli_admin));

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

Line 517: l_tag := pay_in_xml_utils.getTag('c_3_epf_inspection',format_number(l_epf_inspection));

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

Line 520: l_tag := pay_in_xml_utils.getTag('c_3_edli_inspection',format_number(l_edli_inspection));

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

Line 523: l_tag := pay_in_xml_utils.getTag('c_3_rec_overpay',format_number(l_rec_overpay));

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

Line 526: l_tag := pay_in_xml_utils.getTag('c_3_penal_int',format_number(l_penal_int));

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:
529: OPEN csr_challan;
530: FETCH csr_challan INTO l_interest_on_sec,l_legal_charges,l_penalty;

Line 537: l_tag := pay_in_xml_utils.getTag('c_3_int_on_sec',format_number(l_interest_on_sec));

533: OPEN csr_pup_total_amount ;
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);

Line 540: l_tag := pay_in_xml_utils.getTag('c_3_legal_charges',format_number(l_legal_charges));

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

Line 543: l_tag := pay_in_xml_utils.getTag('c_3_penalty',format_number(l_penalty));

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

Line 546: l_tag := pay_in_xml_utils.getTag('c_3_pup',format_number(l_pup));

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:
549: l_tag := '';
550: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 644: l_tag := pay_in_xml_utils.getTag('c_4_payment_type',rec_challan.Payment_Type);

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

Line 647: l_tag := pay_in_xml_utils.getTag('c_4_cheque_dd_no',rec_challan.Cheque_DD_No);

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

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

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

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

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

Line 656: l_tag := pay_in_xml_utils.getTag('c_4_amount',format_number(rec_challan.Amount));

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

Line 659: l_tag := pay_in_xml_utils.getTag('c_4_bank_code',replace_comma(rec_challan.Bank_Code));

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

Line 662: l_tag := pay_in_xml_utils.getTag('c_4_bank_name',replace_comma(rec_challan.Bank_Name));

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

Line 665: l_tag := pay_in_xml_utils.getTag('c_4_branch_code',replace_comma(rec_challan.Branch_Code));

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

Line 668: l_tag := pay_in_xml_utils.getTag('c_4_branch_name',replace_comma(rec_challan.Branch_Name));

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

Line 671: l_tag := pay_in_xml_utils.getTag('c_4_branch_add',replace_comma(rec_challan.Branch_Add));

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

Line 674: l_tag := pay_in_xml_utils.getTag('c_4_challan_ref',rec_challan.Challan_Ref);

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

Line 677: l_tag := pay_in_xml_utils.getTag('c_4_dep_branch_code',replace_comma(rec_challan.Dep_Branch_Code));

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

Line 680: l_tag := pay_in_xml_utils.getTag('c_4_base_branch',replace_comma(rec_challan.Base_Branch_Code));

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

Line 683: l_tag := pay_in_xml_utils.getTag('c_4_base_branch_name',replace_comma(rec_challan.Base_Branch_Name));

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:
686: l_tag := '';
687: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 781: l_tag := pay_in_xml_utils.getTag('c_5_prev_mth',rec_14B.Prev_Mth);

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

Line 784: l_tag := pay_in_xml_utils.getTag('c_5_prev_yr',rec_14B.Prev_Yr);

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

Line 787: l_tag := pay_in_xml_utils.getTag('c_5_epf_penal_damages',format_number(rec_14B.Penal_Damages_Due));

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

Line 790: l_tag := pay_in_xml_utils.getTag('c_5_eps_penal_damages',format_number(rec_14B.EPS_Penal_Damages));

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

Line 793: l_tag := pay_in_xml_utils.getTag('c_5_edli_penal_damages',format_number(rec_14B.EDLI_Penal_Damages));

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

Line 796: l_tag := pay_in_xml_utils.getTag('c_5_epf_admin',format_number(rec_14B.EPF_Penal_Damages));

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

Line 799: l_tag := pay_in_xml_utils.getTag('c_5_edli_admin',format_number(rec_14B.Edli_Admin));

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:
802: l_tag := '';
803: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 897: l_tag := pay_in_xml_utils.getTag('c_6_prev_mth',rec_7Q.Due_Mth);

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

Line 900: l_tag := pay_in_xml_utils.getTag('c_6_prev_yr',rec_7Q.Due_Yr);

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

Line 903: l_tag := pay_in_xml_utils.getTag('c_6_epf_penal_damages',format_number(rec_7Q.EPF_Damages));

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

Line 906: l_tag := pay_in_xml_utils.getTag('c_6_eps_penal_damages',format_number(rec_7Q.EPS_Damages));

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

Line 909: l_tag := pay_in_xml_utils.getTag('c_6_edli_penal_damages',format_number(rec_7Q.EDLI_Damages));

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

Line 912: l_tag := pay_in_xml_utils.getTag('c_6_epf_admin',format_number(rec_7Q.EPF_Admin));

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

Line 915: l_tag := pay_in_xml_utils.getTag('c_6_edli_admin',format_number(rec_7Q.Edli_Admin));

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:
918: l_tag := '';
919: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1016: l_tag := pay_in_xml_utils.getTag('c_7_epf_pay',format_number(rec_misc.EPF_Misc_Pay));

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

Line 1019: l_tag := pay_in_xml_utils.getTag('c_7_epf_rem',replace_comma(rec_misc.EPF_Rem));

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

Line 1022: l_tag := pay_in_xml_utils.getTag('c_7_eps_pay',format_number(rec_misc.EPS_Misc_Pay));

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

Line 1025: l_tag := pay_in_xml_utils.getTag('c_7_eps_rem',replace_comma(rec_misc.EPS_Rem));

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

Line 1028: l_tag := pay_in_xml_utils.getTag('c_7_edli_pay',format_number(rec_misc.EDLI_Misc_Pay));

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

Line 1031: l_tag := pay_in_xml_utils.getTag('c_7_edli_rem',replace_comma(rec_misc.EDLI_Rem));

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

Line 1034: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin',format_number(rec_misc.EPF_Admin));

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

Line 1037: l_tag := pay_in_xml_utils.getTag('c_7_epf_admin_rem',replace_comma(rec_misc.EPF_Admin_Rem));

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

Line 1040: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin',format_number(rec_misc.EDLI_Admin));

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

Line 1043: l_tag := pay_in_xml_utils.getTag('c_7_edli_admin_rem',replace_comma(rec_misc.EDLI_Admin_Rem));

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:
1046: l_tag := '';
1047: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1138: l_tag :=pay_in_xml_utils.getTag('c_8_sys_date',l_sys_date);

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

Line 1141: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_id',l_filer_license_id);

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

Line 1144: l_tag :=pay_in_xml_utils.getTag('c_8_filer_license_no',p_filer_license_no);

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

Line 1147: l_tag := pay_in_xml_utils.getTag('c_8_total_ncp',p_total_ncp);

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:
1150: FOR rec_rep_details IN csr_rep_details
1151: LOOP

Line 1156: l_tag := pay_in_xml_utils.getTag('c_8_rep_name',rec_rep_details.rep_name);

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

Line 1159: l_tag := pay_in_xml_utils.getTag('c_8_rep_pos',replace_comma(rec_rep_details.rep_pos));

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:
1162: l_tag := '';
1163: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1286: l_tag :=pay_in_xml_utils.getTag('c_sys_date',l_sys_date_time);

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);
1287: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
1288:
1289:
1290: OPEN csr_pf_org;

Line 1302: l_tag := pay_in_xml_utils.getTag('c_1_business_no',l_business_no);

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

Line 1305: l_tag := pay_in_xml_utils.getTag('c_1_name_of_comp',replace_comma(l_reg_comp_name));

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

Line 1308: l_tag := pay_in_xml_utils.getTag('c_1_month',LPAD(l_month,2,'0'));

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

Line 1311: l_tag := pay_in_xml_utils.getTag('c_1_year',l_year);

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

Line 1314: l_tag := pay_in_xml_utils.getTag('c_1_return_type',l_return_type);

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:
1317: l_pup := 'N';
1318: FOR rec_challan IN csr_challan(l_action_context_id)

Line 1327: l_tag := pay_in_xml_utils.getTag('c_1_pup',l_pup);

1323: EXIT ;
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