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_IE_P60XML dependencies on FND_NUMBER

Line 631: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.Q1_grosspay_usc,0)) ,'99999990.99')),10,' ')||'';

627: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_address_line3 ||'';
628: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_loc_name ||'';
629: /* 10277535 end */
630: --11857084
631: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.Q1_grosspay_usc,0)) ,'99999990.99')),10,' ')||'';
632: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_usc_ded ,0)) ,'99999990.99')),10,' ')||'';
633: --11857084
634: --14659262
635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';

Line 632: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_usc_ded ,0)) ,'99999990.99')),10,' ')||'';

628: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''|| l_er_loc_name ||'';
629: /* 10277535 end */
630: --11857084
631: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.Q1_grosspay_usc,0)) ,'99999990.99')),10,' ')||'';
632: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_usc_ded ,0)) ,'99999990.99')),10,' ')||'';
633: --11857084
634: --14659262
635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';
636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';

Line 635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';

631: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl(p60.Q1_grosspay_usc,0)) ,'99999990.99')),10,' ')||'';
632: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_usc_ded ,0)) ,'99999990.99')),10,' ')||'';
633: --11857084
634: --14659262
635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';
636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';

Line 636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';

632: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_usc_ded ,0)) ,'99999990.99')),10,' ')||'';
633: --11857084
634: --14659262
635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';
636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';
640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';

Line 637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';

633: --11857084
634: --14659262
635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';
636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';
640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';
641: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_USC ,0)) ,'99999990.99')),10,' ')||'';

Line 638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';

634: --14659262
635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';
636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';
640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';
641: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_USC ,0)) ,'99999990.99')),10,' ')||'';
642: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||p60.Q1_USC_Refund_Deduction||'';

Line 639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';

635: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Illness_Benefit ,0)) ,'99999990.99')),10,' ')||'';
636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';
640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';
641: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_USC ,0)) ,'99999990.99')),10,' ')||'';
642: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||p60.Q1_USC_Refund_Deduction||'';
643: --14659262

Line 640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';

636: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';
640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';
641: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_USC ,0)) ,'99999990.99')),10,' ')||'';
642: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||p60.Q1_USC_Refund_Deduction||'';
643: --14659262
644: -- Bug No: 6474486 : New tag Q1_Employer_PhoneNo is added to the RTF template.

Line 641: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_USC ,0)) ,'99999990.99')),10,' ')||'';

637: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_Pay_USC ,0)) ,'99999990.99')),10,' ')||'';
638: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_pay_USC ,0)) ,'99999990.99')),10,' ')||'';
639: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Total_USC ,0)) ,'99999990.99')),10,' ')||'';
640: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Previous_Emp_USC ,0)) ,'99999990.99')),10,' ')||'';
641: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||lpad(trim(to_char(fnd_number.canonical_to_number(nvl( p60.Q1_Present_USC ,0)) ,'99999990.99')),10,' ')||'';
642: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||p60.Q1_USC_Refund_Deduction||'';
643: --14659262
644: -- Bug No: 6474486 : New tag Q1_Employer_PhoneNo is added to the RTF template.
645: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || ''||p60.Q1_Employer_PhoneNo||'';