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.
299: */
300:
301: IF TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.hire_date),'MMYYYY')) = p_month||p_year
302: THEN
303: l_hire_dd := TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.hire_date),'DD'));
304: ELSE
305: l_hire_dd := NULL ;
299: */
300:
301: IF TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.hire_date),'MMYYYY')) = p_month||p_year
302: THEN
303: l_hire_dd := TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.hire_date),'DD'));
304: ELSE
305: l_hire_dd := NULL ;
306: END IF ;
307:
304: ELSE
305: l_hire_dd := NULL ;
306: END IF ;
307:
308: IF TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.term_date),'MMYYYY')) = p_month||p_year
309: THEN
310: l_term_dd := TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.term_date),'DD'));
311: l_term_efile := rec_assignment.efile_term_reason ;
312: l_term_print_copy := rec_assignment.report_term_reason ;
306: END IF ;
307:
308: IF TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.term_date),'MMYYYY')) = p_month||p_year
309: THEN
310: l_term_dd := TO_NUMBER(TO_CHAR(fnd_date.canonical_to_date(rec_assignment.term_date),'DD'));
311: l_term_efile := rec_assignment.efile_term_reason ;
312: l_term_print_copy := rec_assignment.report_term_reason ;
313: ELSE
314: l_term_dd := NULL ;
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);
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);