DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on FND_FILE

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

587:
588:
589:
590: -- Start of xml doc
591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
592:
593: -- P30File root ELEMENT
594: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);
595:

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

590: -- Start of xml doc
591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
592:
593: -- P30File root ELEMENT
594: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_start_tag);
595:
596: -- Bug 2659864 - 'This Report' Figure calculation logic changed to
597: -- (Curr P30 YTD value - Prev P30 YTD Value)
598:

Line 773: FND_FILE.PUT(FND_FILE.OUTPUT,l_employer_start_tag);

769:
770: END LOOP;
771:
772: -- Employer ELEMENT
773: FND_FILE.PUT(FND_FILE.OUTPUT,l_employer_start_tag);
774:
775: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_paye_number ||'" ');
776: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
777:

Line 775: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_paye_number ||'" ');

771:
772: -- Employer ELEMENT
773: FND_FILE.PUT(FND_FILE.OUTPUT,l_employer_start_tag);
774:
775: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_paye_number ||'" ');
776: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
777:
778: IF l_employer_add1 IS NOT NULL THEN
779: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');

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

772: -- Employer ELEMENT
773: FND_FILE.PUT(FND_FILE.OUTPUT,l_employer_start_tag);
774:
775: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_paye_number ||'" ');
776: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
777:
778: IF l_employer_add1 IS NOT NULL THEN
779: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
780: END IF;

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

775: FND_FILE.PUT(FND_FILE.OUTPUT,'number="' || l_employer_paye_number ||'" ');
776: FND_FILE.PUT(FND_FILE.OUTPUT,'name="' || l_employer_name ||'" ');
777:
778: IF l_employer_add1 IS NOT NULL THEN
779: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
780: END IF;
781:
782: IF l_employer_add2 IS NOT NULL THEN
783: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');

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

779: FND_FILE.PUT(FND_FILE.OUTPUT,'address1="' || l_employer_add1 ||'" ');
780: END IF;
781:
782: IF l_employer_add2 IS NOT NULL THEN
783: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
784: END IF;
785:
786: IF l_employer_add3 IS NOT NULL THEN
787: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');

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

783: FND_FILE.PUT(FND_FILE.OUTPUT,'address2="' || l_employer_add2 ||'" ');
784: END IF;
785:
786: IF l_employer_add3 IS NOT NULL THEN
787: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
788: END IF;
789:
790: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
791:

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

786: IF l_employer_add3 IS NOT NULL THEN
787: FND_FILE.PUT(FND_FILE.OUTPUT,'address3="' || l_employer_add3 ||'" ');
788: END IF;
789:
790: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
791:
792: IF l_employer_phone IS NOT NULL THEN
793: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || replace(replace(l_employer_phone,'('),')') ||'" ');
794: END IF;

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

789:
790: FND_FILE.PUT(FND_FILE.OUTPUT,'contact="' || l_employer_contact ||'" ');
791:
792: IF l_employer_phone IS NOT NULL THEN
793: FND_FILE.PUT(FND_FILE.OUTPUT,'phone="' || replace(replace(l_employer_phone,'('),')') ||'" ');
794: END IF;
795:
796:
797:

Line 798: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_employer_end_tag);

794: END IF;
795:
796:
797:
798: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_employer_end_tag);
799:
800: -- P30 ELEMENT
801: FND_FILE.PUT(FND_FILE.OUTPUT,l_p30_start_tag);
802:

Line 801: FND_FILE.PUT(FND_FILE.OUTPUT,l_p30_start_tag);

797:
798: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_employer_end_tag);
799:
800: -- P30 ELEMENT
801: FND_FILE.PUT(FND_FILE.OUTPUT,l_p30_start_tag);
802:
803: -- Get Start Date
804: OPEN cur_p30_start_date(p_p30_data_lock_process);
805: FETCH cur_p30_start_date INTO l_p30_start;

Line 820: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || l_period_type ||'" ');

816: ELSE
817: l_period_type := '1';
818: END IF;
819:
820: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || l_period_type ||'" ');
821: -- End bug 5119350
822: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || l_p30_start ||'" ');
823:
824: /* Bug 2502060 P30 XML FAILED REVENUE ON LINE VALIDATION

Line 822: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || l_p30_start ||'" ');

818: END IF;
819:
820: FND_FILE.PUT(FND_FILE.OUTPUT,'period="' || l_period_type ||'" ');
821: -- End bug 5119350
822: FND_FILE.PUT(FND_FILE.OUTPUT,'start="' || l_p30_start ||'" ');
823:
824: /* Bug 2502060 P30 XML FAILED REVENUE ON LINE VALIDATION
825: Change in requirement- Totals in PAYE and PRSI element to display
826: in whole Euros and with no ',' seperating the thousands.

Line 828: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999G999G999') ||'" ');

824: /* Bug 2502060 P30 XML FAILED REVENUE ON LINE VALIDATION
825: Change in requirement- Totals in PAYE and PRSI element to display
826: in whole Euros and with no ',' seperating the thousands.
827:
828: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999G999G999') ||'" ');
829: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999G999G999') ||'" ');
830:
831: */
832:

Line 829: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999G999G999') ||'" ');

825: Change in requirement- Totals in PAYE and PRSI element to display
826: in whole Euros and with no ',' seperating the thousands.
827:
828: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999G999G999') ||'" ');
829: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999G999G999') ||'" ');
830:
831: */
832:
833: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999999999') ||'" ');

Line 833: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999999999') ||'" ');

829: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999G999G999') ||'" ');
830:
831: */
832:
833: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999999999') ||'" ');
834: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999999999') ||'" ');
835: FND_FILE.PUT(FND_FILE.OUTPUT,'type="' || l_p30_type ||'" ');
836:
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_p30_end_tag);

Line 834: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999999999') ||'" ');

830:
831: */
832:
833: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999999999') ||'" ');
834: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999999999') ||'" ');
835: FND_FILE.PUT(FND_FILE.OUTPUT,'type="' || l_p30_type ||'" ');
836:
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_p30_end_tag);
838:

Line 835: FND_FILE.PUT(FND_FILE.OUTPUT,'type="' || l_p30_type ||'" ');

831: */
832:
833: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999999999') ||'" ');
834: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999999999') ||'" ');
835: FND_FILE.PUT(FND_FILE.OUTPUT,'type="' || l_p30_type ||'" ');
836:
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_p30_end_tag);
838:
839: -- End of ROOT P30File ELEMENT

Line 837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_p30_end_tag);

833: FND_FILE.PUT(FND_FILE.OUTPUT,'PAYE="' || to_char(l_p30_paye,'FM999999999') ||'" ');
834: FND_FILE.PUT(FND_FILE.OUTPUT,'PRSI="' || to_char(l_p30_prsi,'FM999999999') ||'" ');
835: FND_FILE.PUT(FND_FILE.OUTPUT,'type="' || l_p30_type ||'" ');
836:
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_p30_end_tag);
838:
839: -- End of ROOT P30File ELEMENT
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_end_tag);
841:

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

836:
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_p30_end_tag);
838:
839: -- End of ROOT P30File ELEMENT
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_root_end_tag);
841:
842: END generate_xml;
843:
844: END;