DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on FND_FILE

Line 3948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

3944: )
3945: ) THEN
3946: IF once_per_run = 'N' THEN
3947: -- Start of xml doc
3948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
3949: -- P45File root ELEMENT
3950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);
3951: -- Get Employer Address
3952: OPEN cur_employer_address(p_p45_archive_process);

Line 3950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);

3946: IF once_per_run = 'N' THEN
3947: -- Start of xml doc
3948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
3949: -- P45File root ELEMENT
3950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);
3951: -- Get Employer Address
3952: OPEN cur_employer_address(p_p45_archive_process);
3953: FETCH cur_employer_address INTO l_employer_add1
3954: ,l_employer_add2

Line 3961: FND_FILE.PUT(FND_FILE.OUTPUT,'

3957: ,l_employer_phone
3958: ,l_employer_name;
3959: CLOSE cur_employer_address;
3960: -- Employer ELEMENT
3961: FND_FILE.PUT(FND_FILE.OUTPUT,' 3962: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
3963: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
3964: IF l_employer_add1 IS NOT NULL THEN
3965: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');

Line 3962: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');

3958: ,l_employer_name;
3959: CLOSE cur_employer_address;
3960: -- Employer ELEMENT
3961: FND_FILE.PUT(FND_FILE.OUTPUT,' 3962: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
3963: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
3964: IF l_employer_add1 IS NOT NULL THEN
3965: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
3966: END IF;

Line 3963: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');

3959: CLOSE cur_employer_address;
3960: -- Employer ELEMENT
3961: FND_FILE.PUT(FND_FILE.OUTPUT,' 3962: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
3963: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
3964: IF l_employer_add1 IS NOT NULL THEN
3965: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
3966: END IF;
3967: IF l_employer_add2 IS NOT NULL THEN

Line 3965: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');

3961: FND_FILE.PUT(FND_FILE.OUTPUT,' 3962: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_number ||'" ');
3963: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
3964: IF l_employer_add1 IS NOT NULL THEN
3965: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
3966: END IF;
3967: IF l_employer_add2 IS NOT NULL THEN
3968: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
3969: END IF;

Line 3968: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');

3964: IF l_employer_add1 IS NOT NULL THEN
3965: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
3966: END IF;
3967: IF l_employer_add2 IS NOT NULL THEN
3968: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
3969: END IF;
3970: IF l_employer_add3 IS NOT NULL THEN
3971: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
3972: END IF;

Line 3971: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');

3967: IF l_employer_add2 IS NOT NULL THEN
3968: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
3969: END IF;
3970: IF l_employer_add3 IS NOT NULL THEN
3971: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
3972: END IF;
3973: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
3974: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
3975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 3973: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');

3969: END IF;
3970: IF l_employer_add3 IS NOT NULL THEN
3971: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
3972: END IF;
3973: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
3974: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
3975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
3976: -- End of Employer
3977: once_per_run := 'Y';

Line 3974: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');

3970: IF l_employer_add3 IS NOT NULL THEN
3971: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
3972: END IF;
3973: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
3974: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
3975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
3976: -- End of Employer
3977: once_per_run := 'Y';
3978: END IF;

Line 3975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

3971: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
3972: END IF;
3973: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
3974: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || l_employer_phone ||'" ');
3975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
3976: -- End of Employer
3977: once_per_run := 'Y';
3978: END IF;
3979: IF p45_rec.supp_flag = 'N' THEN

Line 3980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

3976: -- End of Employer
3977: once_per_run := 'Y';
3978: END IF;
3979: IF p45_rec.supp_flag = 'N' THEN
3980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3981: ELSE
3982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3983: END IF;
3984: -- Employee

Line 3982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

3978: END IF;
3979: IF p45_rec.supp_flag = 'N' THEN
3980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3981: ELSE
3982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3983: END IF;
3984: -- Employee
3985: FND_FILE.PUT(FND_FILE.OUTPUT,' 3986: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional

Line 3985: FND_FILE.PUT(FND_FILE.OUTPUT,'

3981: ELSE
3982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
3983: END IF;
3984: -- Employee
3985: FND_FILE.PUT(FND_FILE.OUTPUT,' 3986: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional
3987: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' || cur_p45_emp_details_rec.ppsn ||'" ');
3988: ppsn_flag := 1;
3989: ELSE

Line 3987: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' || cur_p45_emp_details_rec.ppsn ||'" ');

3983: END IF;
3984: -- Employee
3985: FND_FILE.PUT(FND_FILE.OUTPUT,' 3986: IF cur_p45_emp_details_rec.ppsn IS NOT NULL THEN -- Optional
3987: FND_FILE.PUT(FND_FILE.OUTPUT,'ppsn="' || cur_p45_emp_details_rec.ppsn ||'" ');
3988: ppsn_flag := 1;
3989: ELSE
3990: ppsn_flag := 0;
3991: END IF;

Line 3994: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || cur_p45_emp_details_rec.surname ||'" ');

3990: ppsn_flag := 0;
3991: END IF;
3992:
3993: -- required
3994: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || cur_p45_emp_details_rec.surname ||'" ');
3995: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || cur_p45_emp_details_rec.firstname ||'" ');
3996: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
3997: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || cur_p45_emp_details_rec.works ||'" ');
3998: END IF;

Line 3995: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || cur_p45_emp_details_rec.firstname ||'" ');

3991: END IF;
3992:
3993: -- required
3994: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || cur_p45_emp_details_rec.surname ||'" ');
3995: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || cur_p45_emp_details_rec.firstname ||'" ');
3996: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
3997: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || cur_p45_emp_details_rec.works ||'" ');
3998: END IF;
3999:

Line 3997: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || cur_p45_emp_details_rec.works ||'" ');

3993: -- required
3994: FND_FILE.PUT(FND_FILE.OUTPUT,'surname="' || cur_p45_emp_details_rec.surname ||'" ');
3995: FND_FILE.PUT(FND_FILE.OUTPUT,'firstnames="' || cur_p45_emp_details_rec.firstname ||'" ');
3996: IF cur_p45_emp_details_rec.works IS NOT NULL THEN -- Optional
3997: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || cur_p45_emp_details_rec.works ||'" ');
3998: END IF;
3999:
4000: IF cur_p45_emp_details_rec.dob IS NOT NULL THEN -- Optional
4001: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');

Line 4001: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');

3997: FND_FILE.PUT(FND_FILE.OUTPUT,'works="' || cur_p45_emp_details_rec.works ||'" ');
3998: END IF;
3999:
4000: IF cur_p45_emp_details_rec.dob IS NOT NULL THEN -- Optional
4001: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');
4002: END IF;
4003:
4004: IF cur_p45_emp_address_rec.address1 IS NOT NULL THEN -- Optional
4005: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_address_rec.address1 ||'" ');

Line 4005: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_address_rec.address1 ||'" ');

4001: FND_FILE.PUT(FND_FILE.OUTPUT,'dob="' || cur_p45_emp_details_rec.dob ||'" ');
4002: END IF;
4003:
4004: IF cur_p45_emp_address_rec.address1 IS NOT NULL THEN -- Optional
4005: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_address_rec.address1 ||'" ');
4006: ELSIF cur_p45_emp_address_rec.address1 IS NULL and ppsn_flag = 0 THEN
4007: -- Enter the employee details in the log
4008: warn_status := 1;
4009: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );

Line 4009: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );

4005: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || cur_p45_emp_address_rec.address1 ||'" ');
4006: ELSIF cur_p45_emp_address_rec.address1 IS NULL and ppsn_flag = 0 THEN
4007: -- Enter the employee details in the log
4008: warn_status := 1;
4009: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );
4010: END IF;
4011:
4012: IF cur_p45_emp_address_rec.address2 IS NOT NULL THEN -- Optional
4013: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_address_rec.address2 ||'" ');

Line 4013: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_address_rec.address2 ||'" ');

4009: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 1 missing for employee' );
4010: END IF;
4011:
4012: IF cur_p45_emp_address_rec.address2 IS NOT NULL THEN -- Optional
4013: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_address_rec.address2 ||'" ');
4014: ELSIF cur_p45_emp_address_rec.address2 IS NULL and ppsn_flag = 0 THEN
4015: -- Enter the employee details in the log
4016: warn_status := 1;
4017: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');

Line 4017: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');

4013: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || cur_p45_emp_address_rec.address2 ||'" ');
4014: ELSIF cur_p45_emp_address_rec.address2 IS NULL and ppsn_flag = 0 THEN
4015: -- Enter the employee details in the log
4016: warn_status := 1;
4017: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');
4018: END IF;
4019:
4020: IF cur_p45_emp_address_rec.address3 IS NOT NULL THEN -- Optional
4021: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_address_rec.address3 ||'" ');

Line 4021: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_address_rec.address3 ||'" ');

4017: Fnd_file.put_line(FND_FILE.LOG,'Employee '|| cur_p45_emp_details_rec.works||' : PPSN and Address Line 2 missing for employee');
4018: END IF;
4019:
4020: IF cur_p45_emp_address_rec.address3 IS NOT NULL THEN -- Optional
4021: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_address_rec.address3 ||'" ');
4022: END IF;
4023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4024: -- Employment
4025: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4019:
4020: IF cur_p45_emp_address_rec.address3 IS NOT NULL THEN -- Optional
4021: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_address_rec.address3 ||'" ');
4022: END IF;
4023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4024: -- Employment
4025: FND_FILE.PUT(FND_FILE.OUTPUT,' 4026: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
4027: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');

Line 4025: FND_FILE.PUT(FND_FILE.OUTPUT,'

4021: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || cur_p45_emp_address_rec.address3 ||'" ');
4022: END IF;
4023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4024: -- Employment
4025: FND_FILE.PUT(FND_FILE.OUTPUT,' 4026: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
4027: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
4028: END IF;
4029: -- required

Line 4027: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');

4023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4024: -- Employment
4025: FND_FILE.PUT(FND_FILE.OUTPUT,' 4026: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
4027: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
4028: END IF;
4029: -- required
4030: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
4031: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');

Line 4030: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');

4026: IF cur_p45_emp_details_rec.start1 IS NOT NULL THEN -- Optional
4027: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
4028: END IF;
4029: -- required
4030: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
4031: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
4032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4033: -- Pay
4034: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4031: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');

4027: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || cur_p45_emp_details_rec.start1 ||'" ');
4028: END IF;
4029: -- required
4030: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
4031: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
4032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4033: -- Pay
4034: FND_FILE.PUT(FND_FILE.OUTPUT,' 4035: -- required

Line 4032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4028: END IF;
4029: -- required
4030: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
4031: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
4032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4033: -- Pay
4034: FND_FILE.PUT(FND_FILE.OUTPUT,' 4035: -- required
4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');

Line 4034: FND_FILE.PUT(FND_FILE.OUTPUT,'

4030: FND_FILE.PUT(FND_FILE.OUTPUT,'end="' || cur_p45_emp_details_rec.end1 ||'" ');
4031: FND_FILE.PUT(FND_FILE.OUTPUT,'unit="' || l_employment_unit ||'" ');
4032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4033: -- Pay
4034: FND_FILE.PUT(FND_FILE.OUTPUT,' 4035: -- required
4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
4037: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');

Line 4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');

4032: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4033: -- Pay
4034: FND_FILE.PUT(FND_FILE.OUTPUT,' 4035: -- required
4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
4037: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
4039: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
4040:

Line 4037: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');

4033: -- Pay
4034: FND_FILE.PUT(FND_FILE.OUTPUT,' 4035: -- required
4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
4037: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
4039: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
4040:
4041: IF p45_rec.emergency_tax = 'Y' THEN

Line 4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');

4034: FND_FILE.PUT(FND_FILE.OUTPUT,' 4035: -- required
4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
4037: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
4039: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
4040:
4041: IF p45_rec.emergency_tax = 'Y' THEN
4042: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');

Line 4039: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');

4035: -- required
4036: FND_FILE.PUT(FND_FILE.OUTPUT,'freq="' || p45_rec.freq ||'" ');
4037: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || p45_rec.period ||'" ');
4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
4039: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
4040:
4041: IF p45_rec.emergency_tax = 'Y' THEN
4042: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
4043: ELSE

Line 4042: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');

4038: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcredit="' || cur_p45_ie_emp_details_rec.taxcredit ||'" ');
4039: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoff="' || cur_p45_ie_emp_details_rec.cutoff ||'" ');
4040:
4041: IF p45_rec.emergency_tax = 'Y' THEN
4042: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
4043: ELSE
4044: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
4045: END IF;
4046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 4044: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');

4040:
4041: IF p45_rec.emergency_tax = 'Y' THEN
4042: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
4043: ELSE
4044: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
4045: END IF;
4046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4047:
4048: IF p45_rec.supp_flag = 'N' THEN

Line 4046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4042: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'true' ||'" ');
4043: ELSE
4044: FND_FILE.PUT(FND_FILE.OUTPUT,'emergency="' || 'false' ||'" ');
4045: END IF;
4046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4047:
4048: IF p45_rec.supp_flag = 'N' THEN
4049: -- Tax Details for Normal P45 Run
4050: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4050: FND_FILE.PUT(FND_FILE.OUTPUT,'

4046: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4047:
4048: IF p45_rec.supp_flag = 'N' THEN
4049: -- Tax Details for Normal P45 Run
4050: FND_FILE.PUT(FND_FILE.OUTPUT,' 4051: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
4052: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
4053: END IF;
4054: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional

Line 4052: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');

4048: IF p45_rec.supp_flag = 'N' THEN
4049: -- Tax Details for Normal P45 Run
4050: FND_FILE.PUT(FND_FILE.OUTPUT,' 4051: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
4052: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
4053: END IF;
4054: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
4055: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
4056: END IF;

Line 4055: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');

4051: IF cur_p45_paye_prsi_rec.totalpay IS NOT NULL THEN -- Optional
4052: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || cur_p45_paye_prsi_rec.totalpay ||'" ');
4053: END IF;
4054: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
4055: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
4056: END IF;
4057: IF cur_p45_paye_prsi_rec.thispay IS NOT NULL THEN -- Optional
4058: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
4059: END IF;

Line 4058: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');

4054: IF cur_p45_paye_prsi_rec.totaltax IS NOT NULL THEN -- Optional
4055: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || cur_p45_paye_prsi_rec.totaltax ||'" ');
4056: END IF;
4057: IF cur_p45_paye_prsi_rec.thispay IS NOT NULL THEN -- Optional
4058: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
4059: END IF;
4060: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
4061: -- for bug 5401393, negative tax should not be displayed with - sign.
4062: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');

Line 4062: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');

4058: FND_FILE.PUT(FND_FILE.OUTPUT,'thispay="' || cur_p45_paye_prsi_rec.thispay ||'" ');
4059: END IF;
4060: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
4061: -- for bug 5401393, negative tax should not be displayed with - sign.
4062: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
4063: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
4064: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
4065: ELSE
4066: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');

Line 4064: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');

4060: IF cur_p45_paye_prsi_rec.thistax IS NOT NULL THEN -- Optional
4061: -- for bug 5401393, negative tax should not be displayed with - sign.
4062: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
4063: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
4064: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
4065: ELSE
4066: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');
4067: END IF;
4068: END IF;

Line 4066: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');

4062: FND_FILE.PUT(FND_FILE.OUTPUT,'thistax="' || abs(cur_p45_paye_prsi_rec.thistax) ||'" ');
4063: IF cur_p45_paye_prsi_rec.thistax < 0 THEN
4064: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="true" ');
4065: ELSE
4066: FND_FILE.PUT(FND_FILE.OUTPUT,'thistaxrefunded="false" ');
4067: END IF;
4068: END IF;
4069:
4070: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional

Line 4071: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');

4067: END IF;
4068: END IF;
4069:
4070: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional
4071: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
4072: END IF;
4073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4074: -- PRSI
4075: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4069:
4070: IF cur_p45_paye_prsi_rec.lumpsum IS NOT NULL THEN -- Optional
4071: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
4072: END IF;
4073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4074: -- PRSI
4075: FND_FILE.PUT(FND_FILE.OUTPUT,' 4076: -- Bug 5005788
4077: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);

Line 4075: FND_FILE.PUT(FND_FILE.OUTPUT,'

4071: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || cur_p45_paye_prsi_rec.lumpsum ||'" ');
4072: END IF;
4073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4074: -- PRSI
4075: FND_FILE.PUT(FND_FILE.OUTPUT,' 4076: -- Bug 5005788
4077: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
4078: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
4079: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional

Line 4078: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');

4074: -- PRSI
4075: FND_FILE.PUT(FND_FILE.OUTPUT,' 4076: -- Bug 5005788
4077: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
4078: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
4079: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
4080: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
4081: END IF;
4082: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');

Line 4080: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');

4076: -- Bug 5005788
4077: l_total_prsi := NVL(cur_p45_paye_prsi_rec.employerprsi,0) + NVL(cur_p45_paye_prsi_rec.employeeprsi,0);
4078: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
4079: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
4080: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
4081: END IF;
4082: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
4083: ELSE
4084: -- Tax Details for P45 Supp Run

Line 4082: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');

4078: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_total_prsi,0) ||'" ');
4079: IF cur_p45_paye_prsi_rec.employeeprsi IS NOT NULL THEN -- Optional
4080: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(cur_p45_paye_prsi_rec.employeeprsi,0) ||'" ');
4081: END IF;
4082: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
4083: ELSE
4084: -- Tax Details for P45 Supp Run
4085: FND_FILE.PUT(FND_FILE.OUTPUT,' 4086: IF l_supp_totalpay IS NOT NULL THEN -- Optional

Line 4085: FND_FILE.PUT(FND_FILE.OUTPUT,'

4081: END IF;
4082: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(cur_p45_paye_prsi_rec.totalweeks,0) ||'" ');
4083: ELSE
4084: -- Tax Details for P45 Supp Run
4085: FND_FILE.PUT(FND_FILE.OUTPUT,' 4086: IF l_supp_totalpay IS NOT NULL THEN -- Optional
4087: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');
4088: END IF;
4089: IF l_supp_totaltax IS NOT NULL THEN -- Optional

Line 4087: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');

4083: ELSE
4084: -- Tax Details for P45 Supp Run
4085: FND_FILE.PUT(FND_FILE.OUTPUT,' 4086: IF l_supp_totalpay IS NOT NULL THEN -- Optional
4087: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');
4088: END IF;
4089: IF l_supp_totaltax IS NOT NULL THEN -- Optional
4090: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');
4091: END IF;

Line 4090: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');

4086: IF l_supp_totalpay IS NOT NULL THEN -- Optional
4087: FND_FILE.PUT(FND_FILE.OUTPUT,'totalpay="' || l_supp_totalpay ||'" ');
4088: END IF;
4089: IF l_supp_totaltax IS NOT NULL THEN -- Optional
4090: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');
4091: END IF;
4092: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
4093: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
4094: END IF;

Line 4093: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');

4089: IF l_supp_totaltax IS NOT NULL THEN -- Optional
4090: FND_FILE.PUT(FND_FILE.OUTPUT,'totaltax="' || l_supp_totaltax ||'" ');
4091: END IF;
4092: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
4093: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
4094: END IF;
4095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4096: -- PRSI details for P45 Supp Run
4097: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4091: END IF;
4092: IF l_supp_lumpsum IS NOT NULL THEN -- Optional
4093: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
4094: END IF;
4095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4096: -- PRSI details for P45 Supp Run
4097: FND_FILE.PUT(FND_FILE.OUTPUT,' 4098: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
4099: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional

Line 4097: FND_FILE.PUT(FND_FILE.OUTPUT,'

4093: FND_FILE.PUT(FND_FILE.OUTPUT,'lumpsum="' || l_supp_lumpsum ||'" ');
4094: END IF;
4095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4096: -- PRSI details for P45 Supp Run
4097: FND_FILE.PUT(FND_FILE.OUTPUT,' 4098: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
4099: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
4100: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
4101: END IF;

Line 4098: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');

4094: END IF;
4095: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4096: -- PRSI details for P45 Supp Run
4097: FND_FILE.PUT(FND_FILE.OUTPUT,' 4098: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
4099: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
4100: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
4101: END IF;
4102: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');

Line 4100: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');

4096: -- PRSI details for P45 Supp Run
4097: FND_FILE.PUT(FND_FILE.OUTPUT,' 4098: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
4099: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
4100: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
4101: END IF;
4102: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');
4103: END IF;
4104: -- PRSIClass for main P45

Line 4102: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');

4098: FND_FILE.PUT(FND_FILE.OUTPUT,'total="' || NVL(l_supp_totalprsi,0) ||'" ');
4099: IF l_supp_employeeprsi IS NOT NULL THEN -- Optional
4100: FND_FILE.PUT(FND_FILE.OUTPUT,'employee="' || NVL(l_supp_employeeprsi,0) ||'" ');
4101: END IF;
4102: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || NVL(l_supp_totalweeks,0) ||'" ');
4103: END IF;
4104: -- PRSIClass for main P45
4105: IF cur_p45_ie_emp_details_rec.prsi_class IS NOT NULL OR
4106: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR

Line 4108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');

4104: -- PRSIClass for main P45
4105: IF cur_p45_ie_emp_details_rec.prsi_class IS NOT NULL OR
4106: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR
4107: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
4108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
4109: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
4110: FND_FILE.PUT(FND_FILE.OUTPUT,' 4111: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');

Line 4110: FND_FILE.PUT(FND_FILE.OUTPUT,'

4106: ( NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0 and p45_rec.supp_flag <> 'Y' ) OR
4107: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
4108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
4109: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
4110: FND_FILE.PUT(FND_FILE.OUTPUT,' 4111: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4114: END IF;

Line 4111: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

4107: ( NVL(l_supp_classA_weeks,0) <> 0 and p45_rec.supp_flag <> 'N' ) THEN
4108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
4109: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
4110: FND_FILE.PUT(FND_FILE.OUTPUT,' 4111: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4114: END IF;
4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN

Line 4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');

4108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'>');
4109: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
4110: FND_FILE.PUT(FND_FILE.OUTPUT,' 4111: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4114: END IF;
4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
4116: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

4109: IF (NVL(cur_p45_paye_prsi_rec.totalaweeks,0) <> 0) and p45_rec.supp_flag <> 'Y' THEN -- Bug 5015438
4110: FND_FILE.PUT(FND_FILE.OUTPUT,' 4111: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4114: END IF;
4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
4116: FND_FILE.PUT(FND_FILE.OUTPUT,' 4117: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

Line 4116: FND_FILE.PUT(FND_FILE.OUTPUT,'

4112: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || cur_p45_paye_prsi_rec.totalaweeks ||'" ');
4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4114: END IF;
4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
4116: FND_FILE.PUT(FND_FILE.OUTPUT,' 4117: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4118: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
4119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4120: END IF;

Line 4117: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');

4113: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4114: END IF;
4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
4116: FND_FILE.PUT(FND_FILE.OUTPUT,' 4117: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4118: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
4119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4120: END IF;
4121: vfrom:=1;

Line 4118: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');

4114: END IF;
4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
4116: FND_FILE.PUT(FND_FILE.OUTPUT,' 4117: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4118: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
4119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4120: END IF;
4121: vfrom:=1;
4122: vto:=length(cur_p45_ie_emp_details_rec.prsi_class);

Line 4119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

4115: IF (NVL(l_supp_classA_weeks,0) <> 0 ) and p45_rec.supp_flag <> 'N' THEN
4116: FND_FILE.PUT(FND_FILE.OUTPUT,' 4117: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || 'A' ||'" ');
4118: FND_FILE.PUT(FND_FILE.OUTPUT,'weeks="' || l_supp_classA_weeks ||'" ');
4119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4120: END IF;
4121: vfrom:=1;
4122: vto:=length(cur_p45_ie_emp_details_rec.prsi_class);
4123: LOOP

Line 4128: FND_FILE.PUT(FND_FILE.OUTPUT,'

4124: vfound:= instr(cur_p45_ie_emp_details_rec.prsi_class,',',vfrom,1);
4125: IF (vfound > 0 ) THEN
4126: vto:=vfound-vfrom;
4127: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
4128: FND_FILE.PUT(FND_FILE.OUTPUT,' 4129: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
4130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4131: vfrom:=vfound+1;
4132: ELSE

Line 4129: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');

4125: IF (vfound > 0 ) THEN
4126: vto:=vfound-vfrom;
4127: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
4128: FND_FILE.PUT(FND_FILE.OUTPUT,' 4129: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
4130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4131: vfrom:=vfound+1;
4132: ELSE
4133: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);

Line 4130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

4126: vto:=vfound-vfrom;
4127: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom,vto);
4128: FND_FILE.PUT(FND_FILE.OUTPUT,' 4129: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
4130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4131: vfrom:=vfound+1;
4132: ELSE
4133: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
4134: IF v_prsi_class IS NOT NULL THEN

Line 4135: FND_FILE.PUT(FND_FILE.OUTPUT,'

4131: vfrom:=vfound+1;
4132: ELSE
4133: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
4134: IF v_prsi_class IS NOT NULL THEN
4135: FND_FILE.PUT(FND_FILE.OUTPUT,' 4136: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
4137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4138: END IF;
4139: EXIT;

Line 4136: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');

4132: ELSE
4133: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
4134: IF v_prsi_class IS NOT NULL THEN
4135: FND_FILE.PUT(FND_FILE.OUTPUT,' 4136: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
4137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4138: END IF;
4139: EXIT;
4140: END IF;

Line 4137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

4133: v_prsi_class:= substr(cur_p45_ie_emp_details_rec.prsi_class,vfrom);
4134: IF v_prsi_class IS NOT NULL THEN
4135: FND_FILE.PUT(FND_FILE.OUTPUT,' 4136: FND_FILE.PUT(FND_FILE.OUTPUT,'class="' || v_prsi_class ||'" ');
4137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4138: END IF;
4139: EXIT;
4140: END IF;
4141: END LOOP;

Line 4142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4138: END IF;
4139: EXIT;
4140: END IF;
4141: END LOOP;
4142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4143: ELSE
4144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4145: END IF;
4146: IF p45_rec.supp_flag = 'N' THEN

Line 4144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');

4140: END IF;
4141: END LOOP;
4142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4143: ELSE
4144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4145: END IF;
4146: IF p45_rec.supp_flag = 'N' THEN
4147: -- Disability
4148: FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4148: FND_FILE.PUT(FND_FILE.OUTPUT,'

4144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'/>');
4145: END IF;
4146: IF p45_rec.supp_flag = 'N' THEN
4147: -- Disability
4148: FND_FILE.PUT(FND_FILE.OUTPUT,' 4149: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
4150: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
4151: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
4152: END IF;

Line 4149: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');

4145: END IF;
4146: IF p45_rec.supp_flag = 'N' THEN
4147: -- Disability
4148: FND_FILE.PUT(FND_FILE.OUTPUT,' 4149: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
4150: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
4151: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
4152: END IF;
4153: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional

Line 4151: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');

4147: -- Disability
4148: FND_FILE.PUT(FND_FILE.OUTPUT,' 4149: FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || nvl(cur_p45_emp_soc_details_rec.benefit,0) ||'" ');
4150: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
4151: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
4152: END IF;
4153: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional
4154: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
4155: END IF;

Line 4154: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');

4150: IF cur_p45_emp_soc_details_rec.taxcreditreduction IS NOT NULL THEN -- Optional
4151: FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || cur_p45_emp_soc_details_rec.taxcreditreduction ||'" ');
4152: END IF;
4153: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional
4154: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
4155: END IF;
4156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4157: -- Deceased
4158:

Line 4156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4152: END IF;
4153: IF cur_p45_emp_soc_details_rec.cutoffreduction IS NOT NULL THEN -- Optional
4154: FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || cur_p45_emp_soc_details_rec.cutoffreduction ||'" ');
4155: END IF;
4156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4157: -- Deceased
4158:
4159: FND_FILE.PUT(FND_FILE.OUTPUT,' 4160: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional

Line 4159: FND_FILE.PUT(FND_FILE.OUTPUT,'

4155: END IF;
4156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4157: -- Deceased
4158:
4159: FND_FILE.PUT(FND_FILE.OUTPUT,' 4160: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
4161: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
4162: END IF;
4163: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 4161: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');

4157: -- Deceased
4158:
4159: FND_FILE.PUT(FND_FILE.OUTPUT,' 4160: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
4161: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
4162: END IF;
4163: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4164:
4165: IF cur_p45_emp_details_rec.deceased = 'Y' THEN

Line 4163: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4159: FND_FILE.PUT(FND_FILE.OUTPUT,' 4160: IF cur_p45_emp_soc_details_rec.noncumulative IS NOT NULL THEN -- Optional
4161: FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || cur_p45_emp_soc_details_rec.noncumulative ||'" ');
4162: END IF;
4163: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4164:
4165: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4167: END IF;

Line 4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4162: END IF;
4163: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4164:
4165: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4167: END IF;
4168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4169: ELSE
4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,'

Line 4168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4164:
4165: IF cur_p45_emp_details_rec.deceased = 'Y' THEN
4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4167: END IF;
4168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4169: ELSE
4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');

Line 4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,'

4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4167: END IF;
4168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4169: ELSE
4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');

Line 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');

4167: END IF;
4168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4169: ELSE
4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

Line 4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');

4168: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4169: ELSE
4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');

4169: ELSE
4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4177: END IF;

Line 4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');

4170: -- FND_FILE.PUT(FND_FILE.OUTPUT,' 4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4177: END IF;
4178: END IF;

Line 4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');

4171: -- FND_FILE.PUT(FND_FILE.OUTPUT,'benefit="' || p45_rec.benefit ||'" ');
4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4177: END IF;
4178: END IF;
4179: END LOOP;

Line 4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

4172: -- FND_FILE.PUT(FND_FILE.OUTPUT,'taxcreditreduction="' || p45_rec.taxcreditreduction ||'" ');
4173: -- FND_FILE.PUT(FND_FILE.OUTPUT,'cutoffreduction="' || p45_rec.cutoffreduction ||'" ');
4174: -- FND_FILE.PUT(FND_FILE.OUTPUT,'noncumulative="' || p45_rec.noncumulative ||'" ');
4175: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' />');
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
4177: END IF;
4178: END IF;
4179: END LOOP;
4180: IF once_per_run = 'Y' THEN

Line 4182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_end_tag);

4178: END IF;
4179: END LOOP;
4180: IF once_per_run = 'Y' THEN
4181: -- End of ROOT P45File ELEMENT
4182: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_end_tag);
4183: END IF;
4184: IF warn_status =1 then
4185: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS
4186: (