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 923: ,fnd_date.canonical_to_date(pay_no_eoy_archive.get_parameter(legislative_parameters, 'DATE')) report_date

919: (p_payroll_action_id IN NUMBER) IS
920: SELECT business_group_id
921: ,legislative_parameters
922: ,pay_no_eoy_archive.get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
923: ,fnd_date.canonical_to_date(pay_no_eoy_archive.get_parameter(legislative_parameters, 'DATE')) report_date
924: FROM pay_payroll_actions
925: WHERE payroll_action_id = p_payroll_action_id;
926: --
927: l_parameter_rec csr_PARAMS%ROWTYPE;

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

996: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
997: AND hoi1.org_information_context = 'CLASS'
998: AND o1.organization_id = hoi2.organization_id
999: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
1000: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
1001: AND fnd_date.canonical_to_date(hoi2.org_information3);
1002: --
1003: --
1004:

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

997: AND hoi1.org_information_context = 'CLASS'
998: AND o1.organization_id = hoi2.organization_id
999: AND hoi2.org_information_context ='NO_NI_EXEMPTION_LIMIT'
1000: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
1001: AND fnd_date.canonical_to_date(hoi2.org_information3);
1002: --
1003: --
1004:
1005: CURSOR csr_REPCODE

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

1299: --
1300: -- Set balance contexts.
1301: --
1302: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1303: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1304: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1305: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1306: --
1307: --

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

1722: FETCH csr_PER INTO l_person_rec;
1723: CLOSE csr_PER;
1724: --
1725: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);
1726: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1727: --
1728: -- Seaman_PER_TU_YTD
1729: --
1730: l_bal_value := pay_balance_pkg.get_value

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

2205: --
2206: -- Setup balance contexts.
2207: --
2208: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2209: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2210: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2211: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2212: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2213: --

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

2939: --
2940: -- Setup balance contexts.
2941: --
2942: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);
2943: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
2944: --
2945: --
2946: -- Retrieve balance for:-
2947: --

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

3207: l_xml_element_count := l_xml_element_count + 1;
3208: --
3209: g_xml_element_table(l_xml_element_count).tagname := 'REP_PERIOD';
3210: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(l_legemp_rec.effective_date,'DD-MON-YYYY');
3211: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(l_legemp_rec.effective_date);
3212: l_xml_element_count := l_xml_element_count + 1;
3213: --
3214: --
3215: -- Loop for each person within legal employer.

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

3275: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3276: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
3277: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1), lg_format_mask);
3278: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
3279: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
3280:
3281: ELSE
3282: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info1;
3283: END IF;

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

3300: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3301: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
3302: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);
3303: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
3304: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
3305: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');
3306: ELSE
3307: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
3308: END IF;

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

3301: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
3302: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);
3303: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
3304: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
3305: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');
3306: ELSE
3307: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
3308: END IF;
3309: l_xml_element_count := l_xml_element_count + 1;

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

3325: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3326: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
3327: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);
3328: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
3329: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
3330: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');
3331: ELSE
3332: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
3333: END IF;

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

3326: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
3327: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);
3328: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
3329: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
3330: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');
3331: ELSE
3332: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
3333: END IF;
3334: l_xml_element_count := l_xml_element_count + 1;

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

3350: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3351: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
3352: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);
3353: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
3354: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
3355: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');
3356: ELSE
3357: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
3358: END IF;

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

3351: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
3352: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);
3353: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
3354: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
3355: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');
3356: ELSE
3357: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
3358: END IF;
3359: l_xml_element_count := l_xml_element_count + 1;

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

3375: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3376: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
3377: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);
3378: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
3379: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
3380: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');
3381: ELSE
3382: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
3383: END IF;

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

3376: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
3377: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);
3378: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
3379: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
3380: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');
3381: ELSE
3382: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
3383: END IF;
3384: l_xml_element_count := l_xml_element_count + 1;

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

3400: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3401: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
3402: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);
3403: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
3404: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
3405: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');
3406: ELSE
3407: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
3408: END IF;

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

3401: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
3402: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);
3403: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
3404: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
3405: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');
3406: ELSE
3407: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
3408: END IF;
3409: l_xml_element_count := l_xml_element_count + 1;

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

3815: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';
3816: l_xml_element_count := l_xml_element_count + 1;
3817: --
3818: g_xml_element_table(l_xml_element_count).tagname := 'EFFECTIVE_DATE';
3819: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(l_le_si_rec.effective_date);
3820: l_xml_element_count := l_xml_element_count + 1;
3821: -- ORID-16513 - 2007/2008 Changes
3822: g_xml_element_table(l_xml_element_count).tagname := 'TAX_OFFICE';
3823: g_xml_element_table(l_xml_element_count).tagvalue := l_le_si_rec.le_tax_muncipality;

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

5448: FETCH csr_PER_FIX_CODE_ADDL_INFO_IND INTO addl_info;
5449: CLOSE csr_PER_FIX_CODE_ADDL_INFO_IND;
5450: --
5451: IF rec_per_fix_code.info1_dtype IN ('D') AND addl_info <> 0 THEN
5452: addl_info := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(addl_info));
5453: END IF;
5454: --
5455: END IF;
5456: --

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

5521: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5522: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
5523: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1), lg_format_mask);
5524: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
5525: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
5526: ELSE
5527: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info1;
5528: END IF;
5529: l_xml_element_count := l_xml_element_count + 1;

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

5545: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5546: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
5547: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);
5548: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
5549: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
5550: ELSE
5551: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
5552: END IF;
5553: l_xml_element_count := l_xml_element_count + 1;

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

5569: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5570: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
5571: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);
5572: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
5573: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
5574: ELSE
5575: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
5576: END IF;
5577: l_xml_element_count := l_xml_element_count + 1;

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

5593: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5594: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
5595: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);
5596: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
5597: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
5598: ELSE
5599: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
5600: END IF;
5601: l_xml_element_count := l_xml_element_count + 1;

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

5617: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5618: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
5619: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);
5620: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
5621: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
5622: ELSE
5623: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
5624: END IF;
5625: l_xml_element_count := l_xml_element_count + 1;

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

5641: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5642: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
5643: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);
5644: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
5645: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
5646: ELSE
5647: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
5648: END IF;
5649: l_xml_element_count := l_xml_element_count + 1;

Line 6192: g_fixed_code(rec_fixed_code).Addl_Value := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(addl_info));

6188: FETCH csr_PER_FIX_CODE_ADDL_INFO_IND INTO addl_info;
6189: CLOSE csr_PER_FIX_CODE_ADDL_INFO_IND;
6190: --
6191: IF rec_per_fix_code.info1_dtype IN ('D') AND addl_info <> '0' THEN
6192: g_fixed_code(rec_fixed_code).Addl_Value := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(addl_info));
6193: END IF;
6194: --
6195: END IF;
6196: --

Line 6478: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6474: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop2-datadef-25438';
6475: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6476: 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);
6477: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6478: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6479: ELSE
6480: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6481: END IF;
6482: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25438"';

Line 6495: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6491: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAntall-datadef-25439';
6492: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6493: 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);
6494: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6495: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6496: ELSE
6497: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6498: END IF;
6499: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25439"';

Line 6513: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6509: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode1-datadef-25440';
6510: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6511: 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);
6512: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6513: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6514: ELSE
6515: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6516: END IF;
6517: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25440"';

Line 6531: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6527: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode2-datadef-25441';
6528: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6529: 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);
6530: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6531: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6532: ELSE
6533: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6534: END IF;
6535: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25441"';

Line 6549: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6545: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAr-datadef-25442';
6546: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6547: 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);
6548: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6549: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6550: ELSE
6551: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6552: END IF;
6553: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25442"';

Line 6567: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6563: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop3-datadef-25443 ';
6564: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6565: 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);
6566: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6567: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6568: ELSE
6569: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6570: END IF;
6571: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25443"';

Line 6585: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6581: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettFraDato-datadef-25444';
6582: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6583: 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);
6584: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6585: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6586: ELSE
6587: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6588: END IF;
6589: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25444"';

Line 6603: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6599: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettTilDato-datadef-25445';
6600: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6601: 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);
6602: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6603: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6604: ELSE
6605: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6606: END IF;
6607: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25445"';

Line 6621: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6617: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop4-datadef-25446';
6618: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6619: 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);
6620: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6621: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6622: ELSE
6623: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6624: END IF;
6625: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25446"';

Line 6639: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6635: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop5-datadef-25447';
6636: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6637: 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);
6638: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6639: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6640: ELSE
6641: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6642: END IF;
6643: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25447"';

Line 6657: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6653: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning1-datadef-25448';
6654: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6655: 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);
6656: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6657: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6658: ELSE
6659: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6660: END IF;
6661: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25448"';

Line 6675: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6671: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning2-datadef-25449';
6672: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6673: 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);
6674: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6675: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6676: ELSE
6677: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6678: END IF;
6679: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25449"';

Line 6693: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));

6689: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning3-datadef-25450';
6690: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6691: 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);
6692: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6693: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6694: ELSE
6695: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
6696: END IF;
6697: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="25450"';