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_NO_EOY_ARCHIVE dependencies on FND_DATE

Line 1016: ,fnd_date.canonical_to_date(pay_no_eoy_archive.get_parameter(legislative_parameters, 'DATE')) report_date

1012: (p_payroll_action_id IN NUMBER) IS
1013: SELECT business_group_id
1014: ,legislative_parameters
1015: ,pay_no_eoy_archive.get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
1016: ,fnd_date.canonical_to_date(pay_no_eoy_archive.get_parameter(legislative_parameters, 'DATE')) report_date
1017: FROM pay_payroll_actions
1018: WHERE payroll_action_id = p_payroll_action_id;
1019: --
1020: l_parameter_rec csr_PARAMS%ROWTYPE;

Line 1093: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)

1089: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1090: AND hoi1.org_information_context = 'CLASS'
1091: AND o1.organization_id = hoi2.organization_id
1092: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
1093: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
1094: AND fnd_date.canonical_to_date(hoi2.org_information3);
1095: ---- Bug#9579261 fix starts
1096:
1097: CURSOR csr_Legal_Emp_PP(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

Line 1094: AND fnd_date.canonical_to_date(hoi2.org_information3);

1090: AND hoi1.org_information_context = 'CLASS'
1091: AND o1.organization_id = hoi2.organization_id
1092: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
1093: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
1094: AND fnd_date.canonical_to_date(hoi2.org_information3);
1095: ---- Bug#9579261 fix starts
1096:
1097: CURSOR csr_Legal_Emp_PP(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
1098: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE

Line 1113: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)

1109: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1110: AND hoi1.org_information_context = 'CLASS'
1111: AND o1.organization_id = hoi2.organization_id
1112: AND hoi2.org_information_context ='NO_PENSION_PROVIDER'
1113: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)
1114: AND fnd_date.canonical_to_date(hoi2.org_information2);
1115:
1116: CURSOR csr_pp_name(csr_v_pp_id hr_organization_units.organization_id%TYPE) IS
1117: SELECT o1.name name

Line 1114: AND fnd_date.canonical_to_date(hoi2.org_information2);

1110: AND hoi1.org_information_context = 'CLASS'
1111: AND o1.organization_id = hoi2.organization_id
1112: AND hoi2.org_information_context ='NO_PENSION_PROVIDER'
1113: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)
1114: AND fnd_date.canonical_to_date(hoi2.org_information2);
1115:
1116: CURSOR csr_pp_name(csr_v_pp_id hr_organization_units.organization_id%TYPE) IS
1117: SELECT o1.name name
1118: FROM hr_organization_units o1

Line 1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

1477: --
1478: -- Set balance contexts.
1479: --
1480: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1482: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1483: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1484: --
1485: --

Line 1908: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

1904: FETCH csr_PER INTO l_person_rec;
1905: CLOSE csr_PER;
1906: --
1907: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);
1908: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1909: --
1910: -- Seaman_PER_TU_YTD
1911: --
1912: l_bal_value := pay_balance_pkg.get_value

Line 1985: ,p_action_information14 => fnd_date.date_to_canonical(l_employment_start_date) --Changes 2007/2008

1981: ,p_action_information10 => l_per_addr2
1982: ,p_action_information11 => l_per_addr3
1983: ,p_action_information12 => l_per_postcode
1984: ,p_action_information13 => l_per_postoffice
1985: ,p_action_information14 => fnd_date.date_to_canonical(l_employment_start_date) --Changes 2007/2008
1986: ,p_action_information15 => fnd_date.date_to_canonical(l_employment_end_date) --Changes 2007/2008
1987: );
1988: END IF;
1989: l_person_id := l_asg_rec.person_id;

Line 1986: ,p_action_information15 => fnd_date.date_to_canonical(l_employment_end_date) --Changes 2007/2008

1982: ,p_action_information11 => l_per_addr3
1983: ,p_action_information12 => l_per_postcode
1984: ,p_action_information13 => l_per_postoffice
1985: ,p_action_information14 => fnd_date.date_to_canonical(l_employment_start_date) --Changes 2007/2008
1986: ,p_action_information15 => fnd_date.date_to_canonical(l_employment_end_date) --Changes 2007/2008
1987: );
1988: END IF;
1989: l_person_id := l_asg_rec.person_id;
1990: --

Line 2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));

2476: --
2477: -- Setup balance contexts.
2478: --
2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2484: --

Line 3292: and (fnd_date.canonical_to_date(rep_cde.action_information12)+1 = fnd_date.canonical_to_date(pai2.action_information11)

3288: and pai2.ACTION_INFORMATION1= 'ASG_REP_CODE_INFO'
3289: and pai2.ACTION_INFORMATION2= '113-A'
3290: and pai2.action_information13 = rep_cde.action_information13
3291: and pai2.action_information14 = rep_cde.action_information14
3292: and (fnd_date.canonical_to_date(rep_cde.action_information12)+1 = fnd_date.canonical_to_date(pai2.action_information11)
3293: or fnd_date.canonical_to_date(rep_cde.action_information11)-1 = fnd_date.canonical_to_date(pai2.action_information12))
3294: )
3295: GROUP BY asg_act.action_information2
3296: ,asg_act.action_information5

Line 3293: or fnd_date.canonical_to_date(rep_cde.action_information11)-1 = fnd_date.canonical_to_date(pai2.action_information12))

3289: and pai2.ACTION_INFORMATION2= '113-A'
3290: and pai2.action_information13 = rep_cde.action_information13
3291: and pai2.action_information14 = rep_cde.action_information14
3292: and (fnd_date.canonical_to_date(rep_cde.action_information12)+1 = fnd_date.canonical_to_date(pai2.action_information11)
3293: or fnd_date.canonical_to_date(rep_cde.action_information11)-1 = fnd_date.canonical_to_date(pai2.action_information12))
3294: )
3295: GROUP BY asg_act.action_information2
3296: ,asg_act.action_information5
3297: ,asg_act.action_information6

Line 3346: and (fnd_date.canonical_to_date(rep_cde.action_information12)+1 = fnd_date.canonical_to_date(pai2.action_information11)

3342: and pai2.ACTION_INFORMATION1= 'ASG_REP_CODE_INFO'
3343: and pai2.ACTION_INFORMATION2= '113-A'
3344: and pai2.action_information13 = rep_cde.action_information13
3345: and pai2.action_information14 = rep_cde.action_information14
3346: and (fnd_date.canonical_to_date(rep_cde.action_information12)+1 = fnd_date.canonical_to_date(pai2.action_information11)
3347: or fnd_date.canonical_to_date(rep_cde.action_information11)-1 = fnd_date.canonical_to_date(pai2.action_information12)));
3348: --
3349: /* bug 16084022 end */
3350: CURSOR csr_SUM_CODES

Line 3347: or fnd_date.canonical_to_date(rep_cde.action_information11)-1 = fnd_date.canonical_to_date(pai2.action_information12)));

3343: and pai2.ACTION_INFORMATION2= '113-A'
3344: and pai2.action_information13 = rep_cde.action_information13
3345: and pai2.action_information14 = rep_cde.action_information14
3346: and (fnd_date.canonical_to_date(rep_cde.action_information12)+1 = fnd_date.canonical_to_date(pai2.action_information11)
3347: or fnd_date.canonical_to_date(rep_cde.action_information11)-1 = fnd_date.canonical_to_date(pai2.action_information12)));
3348: --
3349: /* bug 16084022 end */
3350: CURSOR csr_SUM_CODES
3351: (p_payroll_action_id IN NUMBER) IS

Line 3469: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

3465: --
3466: -- Setup balance contexts.
3467: --
3468: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);
3469: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
3470: --
3471: --
3472: -- Retrieve balance for:-
3473: --

Line 3833: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(l_legemp_rec.effective_date);

3829: l_xml_element_count := l_xml_element_count + 1;
3830: --
3831: g_xml_element_table(l_xml_element_count).tagname := 'REP_PERIOD';
3832: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(l_legemp_rec.effective_date,'DD-MON-YYYY');
3833: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(l_legemp_rec.effective_date);
3834: l_xml_element_count := l_xml_element_count + 1;
3835: --
3836: --
3837: -- Loop for each person within legal employer.

Line 3901: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));

3897: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3898: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
3899: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1));
3900: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
3901: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
3902:
3903: ELSE
3904: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info1;
3905: END IF;

Line 3926: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));

3922: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3923: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
3924: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2));
3925: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
3926: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
3927: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');
3928: ELSE
3929: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
3930: END IF;

Line 3927: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');

3923: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
3924: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2));
3925: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
3926: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
3927: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');
3928: ELSE
3929: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
3930: END IF;
3931: l_xml_element_count := l_xml_element_count + 1;

Line 3951: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));

3947: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3948: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
3949: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3));
3950: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
3951: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
3952: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');
3953: ELSE
3954: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
3955: END IF;

Line 3952: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');

3948: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
3949: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3));
3950: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
3951: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
3952: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');
3953: ELSE
3954: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
3955: END IF;
3956: l_xml_element_count := l_xml_element_count + 1;

Line 3976: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));

3972: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3973: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
3974: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4));
3975: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
3976: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
3977: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');
3978: ELSE
3979: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
3980: END IF;

Line 3977: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');

3973: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
3974: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4));
3975: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
3976: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
3977: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');
3978: ELSE
3979: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
3980: END IF;
3981: l_xml_element_count := l_xml_element_count + 1;

Line 4001: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));

3997: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3998: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
3999: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5));
4000: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
4001: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
4002: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');
4003: ELSE
4004: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
4005: END IF;

Line 4002: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');

3998: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
3999: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5));
4000: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
4001: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
4002: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');
4003: ELSE
4004: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
4005: END IF;
4006: l_xml_element_count := l_xml_element_count + 1;

Line 4026: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));

4022: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4023: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
4024: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6));
4025: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
4026: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
4027: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');
4028: ELSE
4029: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
4030: END IF;

Line 4027: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');

4023: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
4024: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6));
4025: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
4026: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
4027: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');
4028: ELSE
4029: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
4030: END IF;
4031: l_xml_element_count := l_xml_element_count + 1;

Line 4051: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));

4047: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4048: IF l_summ_code_rec.info7_dtype IN ('M','A','N') THEN
4049: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info7));
4050: ELSIF l_summ_code_rec.info7_dtype = 'D' AND l_summ_code_rec.info7 <> '0' THEN
4051: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));
4052: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info7),'DD-MM-YYYY');
4053: ELSE
4054: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info7;
4055: END IF;

Line 4052: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info7),'DD-MM-YYYY');

4048: IF l_summ_code_rec.info7_dtype IN ('M','A','N') THEN
4049: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info7));
4050: ELSIF l_summ_code_rec.info7_dtype = 'D' AND l_summ_code_rec.info7 <> '0' THEN
4051: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));
4052: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info7),'DD-MM-YYYY');
4053: ELSE
4054: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info7;
4055: END IF;
4056: l_xml_element_count := l_xml_element_count + 1;

Line 4076: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));

4072: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4073: IF l_summ_code_rec.info8_dtype IN ('M','A','N') THEN
4074: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info8));
4075: ELSIF l_summ_code_rec.info8_dtype = 'D' AND l_summ_code_rec.info8 <> '0' THEN
4076: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));
4077: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info8),'DD-MM-YYYY');
4078: ELSE
4079: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info8;
4080: END IF;

Line 4077: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info8),'DD-MM-YYYY');

4073: IF l_summ_code_rec.info8_dtype IN ('M','A','N') THEN
4074: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info8));
4075: ELSIF l_summ_code_rec.info8_dtype = 'D' AND l_summ_code_rec.info8 <> '0' THEN
4076: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));
4077: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info8),'DD-MM-YYYY');
4078: ELSE
4079: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info8;
4080: END IF;
4081: l_xml_element_count := l_xml_element_count + 1;

Line 4101: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));

4097: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4098: IF l_summ_code_rec.info9_dtype IN ('M','A','N') THEN
4099: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info9));
4100: ELSIF l_summ_code_rec.info9_dtype = 'D' AND l_summ_code_rec.info9 <> '0' THEN
4101: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));
4102: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info9),'DD-MM-YYYY');
4103: ELSE
4104: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info9;
4105: END IF;

Line 4102: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info9),'DD-MM-YYYY');

4098: IF l_summ_code_rec.info9_dtype IN ('M','A','N') THEN
4099: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info9));
4100: ELSIF l_summ_code_rec.info9_dtype = 'D' AND l_summ_code_rec.info9 <> '0' THEN
4101: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));
4102: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info9),'DD-MM-YYYY');
4103: ELSE
4104: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info9;
4105: END IF;
4106: l_xml_element_count := l_xml_element_count + 1;

Line 4126: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));

4122: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4123: IF l_summ_code_rec.info10_dtype IN ('M','A','N') THEN
4124: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info10));
4125: ELSIF l_summ_code_rec.info10_dtype = 'D' AND l_summ_code_rec.info10 <> '0' THEN
4126: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));
4127: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info10),'DD-MM-YYYY');
4128: ELSE
4129: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info10;
4130: END IF;

Line 4127: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info10),'DD-MM-YYYY');

4123: IF l_summ_code_rec.info10_dtype IN ('M','A','N') THEN
4124: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info10));
4125: ELSIF l_summ_code_rec.info10_dtype = 'D' AND l_summ_code_rec.info10 <> '0' THEN
4126: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));
4127: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info10),'DD-MM-YYYY');
4128: ELSE
4129: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info10;
4130: END IF;
4131: l_xml_element_count := l_xml_element_count + 1;

Line 4572: -- g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(l_le_si_rec.effective_date);

4568: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';
4569: l_xml_element_count := l_xml_element_count + 1;
4570:
4571: g_xml_element_table(l_xml_element_count).tagname := 'YEAR'; --Bug 14671801
4572: -- g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(l_le_si_rec.effective_date);
4573: g_xml_element_table(l_xml_element_count).tagvalue := to_char(l_le_si_rec.effective_date,'YYYY');
4574: l_xml_element_count := l_xml_element_count + 1;
4575: -- ORID-16513 - 2007/2008 Changes
4576: g_xml_element_table(l_xml_element_count).tagname := 'TAX_OFFICE';

Line 6438: addl_info := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(addl_info));

6434: FETCH csr_PER_FIX_CODE_ADDL_INFO_IND INTO addl_info;
6435: CLOSE csr_PER_FIX_CODE_ADDL_INFO_IND;
6436: --
6437: IF rec_per_fix_code.info1_dtype IN ('D') AND addl_info <> 0 THEN
6438: addl_info := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(addl_info));
6439: END IF;
6440: --
6441: END IF;
6442: --

Line 6512: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));

6508: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6509: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
6510: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1));
6511: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
6512: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
6513: ELSE
6514: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info1;
6515: END IF;
6516: l_xml_element_count := l_xml_element_count + 1;

Line 6536: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));

6532: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6533: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
6534: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2));
6535: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
6536: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
6537: ELSE
6538: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
6539: END IF;
6540: l_xml_element_count := l_xml_element_count + 1;

Line 6561: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));

6557: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6558: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
6559: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3));
6560: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
6561: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
6562: ELSE
6563: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
6564: END IF;
6565: l_xml_element_count := l_xml_element_count + 1;

Line 6585: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));

6581: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6582: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
6583: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4));
6584: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
6585: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
6586: ELSE
6587: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
6588: END IF;
6589: l_xml_element_count := l_xml_element_count + 1;

Line 6609: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));

6605: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6606: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
6607: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5));
6608: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
6609: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
6610: ELSE
6611: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
6612: END IF;
6613: l_xml_element_count := l_xml_element_count + 1;

Line 6633: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));

6629: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6630: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
6631: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6));
6632: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
6633: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
6634: ELSE
6635: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
6636: END IF;
6637: l_xml_element_count := l_xml_element_count + 1;

Line 6657: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));

6653: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6654: IF l_summ_code_rec.info7_dtype IN ('M','A','N') THEN
6655: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info7));
6656: ELSIF l_summ_code_rec.info7_dtype = 'D' AND l_summ_code_rec.info7 <> '0' THEN
6657: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));
6658: ELSE
6659: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info7;
6660: END IF;
6661: l_xml_element_count := l_xml_element_count + 1;

Line 6681: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));

6677: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6678: IF l_summ_code_rec.info8_dtype IN ('M','A','N') THEN
6679: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info8));
6680: ELSIF l_summ_code_rec.info8_dtype = 'D' AND l_summ_code_rec.info8 <> '0' THEN
6681: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));
6682: ELSE
6683: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info8;
6684: END IF;
6685: l_xml_element_count := l_xml_element_count + 1;

Line 6705: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));

6701: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6702: IF l_summ_code_rec.info9_dtype IN ('M','A','N') THEN
6703: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info9));
6704: ELSIF l_summ_code_rec.info9_dtype = 'D' AND l_summ_code_rec.info9 <> '0' THEN
6705: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));
6706: ELSE
6707: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info9;
6708: END IF;
6709: l_xml_element_count := l_xml_element_count + 1;

Line 6729: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));

6725: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6726: IF l_summ_code_rec.info10_dtype IN ('M','A','N') THEN
6727: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info10));
6728: ELSIF l_summ_code_rec.info10_dtype = 'D' AND l_summ_code_rec.info10 <> '0' THEN
6729: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));
6730: ELSE
6731: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info10;
6732: END IF;
6733: l_xml_element_count := l_xml_element_count + 1;

Line 7311: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_person_rec.employment_start_date),'YYYY-MM-DD');

7307: l_xml_element_count := l_xml_element_count + 1;
7308: --
7309: --g_xml_element_table(l_xml_element_count).tagname := 'EMPLOYED_START_DATE';
7310: g_xml_element_table(l_xml_element_count).tagname := 'ArbeidsforholdStartdato-datadef-23170';
7311: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_person_rec.employment_start_date),'YYYY-MM-DD');
7312: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="23170"';
7313: g_xml_element_table(l_xml_element_count).tagtype := 'A';
7314: l_xml_element_count := l_xml_element_count + 1;
7315: --

Line 7318: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_person_rec.employment_end_date),'YYYY-MM-DD');

7314: l_xml_element_count := l_xml_element_count + 1;
7315: --
7316: --g_xml_element_table(l_xml_element_count).tagname := 'EMPLOYED_END_DATE';
7317: g_xml_element_table(l_xml_element_count).tagname := 'ArbeidsforholdSluttdato-datadef-23171';
7318: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_person_rec.employment_end_date),'YYYY-MM-DD');
7319: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="23171"';
7320: g_xml_element_table(l_xml_element_count).tagtype := 'A';
7321: l_xml_element_count := l_xml_element_count + 1;
7322: --

Line 7453: g_fixed_code(rec_fixed_code).Addl_Value :=to_char(fnd_date.canonical_to_date(addl_info),'yyyy-mm-dd');

7449: FETCH csr_PER_FIX_CODE_ADDL_INFO_IND INTO addl_info;
7450: CLOSE csr_PER_FIX_CODE_ADDL_INFO_IND;
7451: --
7452: IF rec_per_fix_code.info1_dtype IN ('D') AND addl_info <> '0' THEN
7453: g_fixed_code(rec_fixed_code).Addl_Value :=to_char(fnd_date.canonical_to_date(addl_info),'yyyy-mm-dd');
7454: END IF;
7455: --
7456: END IF;
7457: --

Line 7801: g_xml_element_table(l_xml_element_count).tagvalue :=to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7797: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop2-datadef-25438';
7798: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7799: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7800: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7801: g_xml_element_table(l_xml_element_count).tagvalue :=to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7802: ELSE
7803: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7804: END IF;
7805: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25438"';

Line 7819: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7815: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAntall-datadef-25439';
7816: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7817: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
7818: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7819: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7820: ELSE
7821: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7822: END IF;
7823: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25439"';

Line 7838: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7834: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode1-datadef-25440';
7835: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7836: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
7837: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7838: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7839: ELSE
7840: -- open csr_country_code(g_summary_code_orid(l_summ_var).info_data);
7841: -- fetch csr_country_code into l_country_code;
7842: -- if csr_country_code%notfound then

Line 7864: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7860: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode2-datadef-25441';
7861: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7862: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
7863: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7864: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7865: ELSE
7866: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7867: END IF;
7868: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25441"';

Line 7882: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7878: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAr-datadef-25442';
7879: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7880: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
7881: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7882: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7883: ELSE
7884: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7885: END IF;
7886: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25442"';

Line 7901: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7897: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop3-datadef-25443 ';
7898: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7899: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7900: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7901: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7902: ELSE
7903: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7904: END IF;
7905: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25443"';

Line 7922: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7918: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7919: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7920:
7921: -- g_xml_element_table(l_xml_element_count).tagvalue := to_date(g_summary_code_orid(l_summ_var).info_data);
7922: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7923: ELSE
7924: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7925: END IF;
7926: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25444"';

Line 7941: -- g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

7937: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettTilDato-datadef-25445';
7938: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7939: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7940: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7941: -- g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
7942: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7943: ELSE
7944: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7945: END IF;

Line 7942: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7938: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7939: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7940: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7941: -- g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
7942: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7943: ELSE
7944: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7945: END IF;
7946: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25445"';

Line 7961: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7957: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop4-datadef-25446';
7958: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7959: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7960: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7961: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7962: ELSE
7963: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7964: END IF;
7965: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25446"';

Line 7980: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7976: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop5-datadef-25447';
7977: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7978: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7979: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7980: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7981: ELSE
7982: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7983: END IF;
7984: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25447"';

Line 7999: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

7995: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning1-datadef-25448';
7996: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7997: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
7998: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7999: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
8000: ELSE
8001: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
8002: END IF;
8003: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25448"';

Line 8018: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

8014: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning2-datadef-25449';
8015: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
8016: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
8017: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
8018: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
8019: ELSE
8020: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
8021: END IF;
8022: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25449"';

Line 8036: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');

8032: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning3-datadef-25450';
8033: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
8034: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data));
8035: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
8036: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
8037: ELSE
8038: g_xml_element_table(l_xml_element_count).tagvalue := NVL(g_summary_code_orid(l_summ_var).info_data,'0');
8039: END IF;
8040: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25450"';