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.PQP_GB_SWF_EXTRACT dependencies on FND_FILE

Line 106: FND_FILE.PUT_LINE(fnd_file.log,'');

102: ELSE
103: l_file_name := 'EST_'||p_lea_or_est_num||'.'||g_request_id;
104: END IF;
105: g_file_handle := utl_file.fopen (g_output_dir ,l_file_name,'w');
106: FND_FILE.PUT_LINE(fnd_file.log,'');
107: FND_FILE.PUT_LINE(fnd_file.log,'Writing File:'||l_file_name);
108: utl_file.put_line(g_file_handle, '');
109: WRITE_LINE('O','Message',null);
110:

Line 107: FND_FILE.PUT_LINE(fnd_file.log,'Writing File:'||l_file_name);

103: l_file_name := 'EST_'||p_lea_or_est_num||'.'||g_request_id;
104: END IF;
105: g_file_handle := utl_file.fopen (g_output_dir ,l_file_name,'w');
106: FND_FILE.PUT_LINE(fnd_file.log,'');
107: FND_FILE.PUT_LINE(fnd_file.log,'Writing File:'||l_file_name);
108: utl_file.put_line(g_file_handle, '');
109: WRITE_LINE('O','Message',null);
110:
111: hr_utility.trace('Leaving: '||l_proc);

Line 662: FND_FILE.PUT_LINE(fnd_file.log,'');

658:
659: BEGIN
660: hr_utility.trace('Entering: '||l_proc);
661:
662: FND_FILE.PUT_LINE(fnd_file.log,'');
663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);
665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);
666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);

Line 663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');

659: BEGIN
660: hr_utility.trace('Entering: '||l_proc);
661:
662: FND_FILE.PUT_LINE(fnd_file.log,'');
663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);
665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);
666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);
667: FND_FILE.PUT_LINE(fnd_file.log,' Serial Number: '|| p_serial_number);

Line 664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);

660: hr_utility.trace('Entering: '||l_proc);
661:
662: FND_FILE.PUT_LINE(fnd_file.log,'');
663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);
665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);
666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);
667: FND_FILE.PUT_LINE(fnd_file.log,' Serial Number: '|| p_serial_number);
668:

Line 665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);

661:
662: FND_FILE.PUT_LINE(fnd_file.log,'');
663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);
665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);
666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);
667: FND_FILE.PUT_LINE(fnd_file.log,' Serial Number: '|| p_serial_number);
668:
669: g_census_year := p_census_year;

Line 666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);

662: FND_FILE.PUT_LINE(fnd_file.log,'');
663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);
665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);
666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);
667: FND_FILE.PUT_LINE(fnd_file.log,' Serial Number: '|| p_serial_number);
668:
669: g_census_year := p_census_year;
670: g_output_dir := p_output_dir;

Line 667: FND_FILE.PUT_LINE(fnd_file.log,' Serial Number: '|| p_serial_number);

663: FND_FILE.PUT_LINE(fnd_file.log,'Parameters:');
664: FND_FILE.PUT_LINE(fnd_file.log,' Census Year: '|| p_census_year);
665: FND_FILE.PUT_LINE(fnd_file.log,' Request Id: '|| p_request_id);
666: FND_FILE.PUT_LINE(fnd_file.log,' Output Dir: '|| p_output_dir);
667: FND_FILE.PUT_LINE(fnd_file.log,' Serial Number: '|| p_serial_number);
668:
669: g_census_year := p_census_year;
670: g_output_dir := p_output_dir;
671: g_request_id := fnd_global.conc_request_id;

Line 680: FND_FILE.PUT_LINE(fnd_file.log,'');

676: fetch c_process_details into g_payroll_action_id,g_lea_number,g_census_date,
677: g_data_return_type,g_estab_number,g_exclude_absence,g_exclude_qual;
678: close c_process_details;
679:
680: FND_FILE.PUT_LINE(fnd_file.log,'');
681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');
682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);
683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);
684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);

Line 681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');

677: g_data_return_type,g_estab_number,g_exclude_absence,g_exclude_qual;
678: close c_process_details;
679:
680: FND_FILE.PUT_LINE(fnd_file.log,'');
681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');
682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);
683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);
684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);
685: FND_FILE.PUT_LINE(fnd_file.log,' Data Return Type: '|| g_data_return_type);

Line 682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);

678: close c_process_details;
679:
680: FND_FILE.PUT_LINE(fnd_file.log,'');
681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');
682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);
683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);
684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);
685: FND_FILE.PUT_LINE(fnd_file.log,' Data Return Type: '|| g_data_return_type);
686:

Line 683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);

679:
680: FND_FILE.PUT_LINE(fnd_file.log,'');
681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');
682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);
683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);
684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);
685: FND_FILE.PUT_LINE(fnd_file.log,' Data Return Type: '|| g_data_return_type);
686:
687: -- Get IANA Encoding

Line 684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);

680: FND_FILE.PUT_LINE(fnd_file.log,'');
681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');
682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);
683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);
684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);
685: FND_FILE.PUT_LINE(fnd_file.log,' Data Return Type: '|| g_data_return_type);
686:
687: -- Get IANA Encoding
688: g_iana_char_set := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

Line 685: FND_FILE.PUT_LINE(fnd_file.log,' Data Return Type: '|| g_data_return_type);

681: FND_FILE.PUT_LINE(fnd_file.log,'Process Details:');
682: FND_FILE.PUT_LINE(fnd_file.log,' Payroll Action ID: '|| g_payroll_action_id);
683: FND_FILE.PUT_LINE(fnd_file.log,' LEA Number: '|| g_lea_number);
684: FND_FILE.PUT_LINE(fnd_file.log,' Census Date: '|| g_census_date);
685: FND_FILE.PUT_LINE(fnd_file.log,' Data Return Type: '|| g_data_return_type);
686:
687: -- Get IANA Encoding
688: g_iana_char_set := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
689: IF g_iana_char_set is null THEN

Line 692: FND_FILE.PUT_LINE(fnd_file.log,' IANA Encoding: '|| g_iana_char_set);

688: g_iana_char_set := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
689: IF g_iana_char_set is null THEN
690: g_iana_char_set:='UTF-8';
691: END IF;
692: FND_FILE.PUT_LINE(fnd_file.log,' IANA Encoding: '|| g_iana_char_set);
693:
694: -- Bug#12586059
695:
696: -- IF g_data_return_type in ('TYPE1A','TYPE3','TYPE4') THEN

Line 768: FND_FILE.PUT_LINE(fnd_file.output,'Process Summary');

764: END LOOP;
765: END IF;
766:
767: -- Write Extract Summary
768: FND_FILE.PUT_LINE(fnd_file.output,'Process Summary');
769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');
770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);

Line 769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');

765: END IF;
766:
767: -- Write Extract Summary
768: FND_FILE.PUT_LINE(fnd_file.output,'Process Summary');
769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');
770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);

Line 770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);

766:
767: -- Write Extract Summary
768: FND_FILE.PUT_LINE(fnd_file.output,'Process Summary');
769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');
770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);

Line 771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);

767: -- Write Extract Summary
768: FND_FILE.PUT_LINE(fnd_file.output,'Process Summary');
769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');
770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);

Line 772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);

768: FND_FILE.PUT_LINE(fnd_file.output,'Process Summary');
769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');
770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);

Line 773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);

769: FND_FILE.PUT_LINE(fnd_file.output,'---------------');
770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);
777: FND_FILE.PUT_LINE(fnd_file.output,'');

Line 774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);

770: FND_FILE.PUT_LINE(fnd_file.output,' Request ID: '|| g_request_id);
771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);
777: FND_FILE.PUT_LINE(fnd_file.output,'');
778: FND_FILE.PUT_LINE(fnd_file.output,' Output Dir: '|| g_output_dir);

Line 775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);

771: FND_FILE.PUT_LINE(fnd_file.output,' Census Year: '|| g_census_year);
772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);
777: FND_FILE.PUT_LINE(fnd_file.output,'');
778: FND_FILE.PUT_LINE(fnd_file.output,' Output Dir: '|| g_output_dir);
779:

Line 776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);

772: FND_FILE.PUT_LINE(fnd_file.output,' LEA Number: '|| g_lea_number);
773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);
777: FND_FILE.PUT_LINE(fnd_file.output,'');
778: FND_FILE.PUT_LINE(fnd_file.output,' Output Dir: '|| g_output_dir);
779:
780: -- Bug#12586059

Line 777: FND_FILE.PUT_LINE(fnd_file.output,'');

773: FND_FILE.PUT_LINE(fnd_file.output,' Data Return Type: '|| g_data_return_type);
774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);
777: FND_FILE.PUT_LINE(fnd_file.output,'');
778: FND_FILE.PUT_LINE(fnd_file.output,' Output Dir: '|| g_output_dir);
779:
780: -- Bug#12586059
781:

Line 778: FND_FILE.PUT_LINE(fnd_file.output,' Output Dir: '|| g_output_dir);

774: FND_FILE.PUT_LINE(fnd_file.output,' Establishment Number: '|| g_estab_number);
775: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Absence Module: '|| g_exclude_absence);
776: FND_FILE.PUT_LINE(fnd_file.output,' Exclude Qualification Module: '|| g_exclude_qual);
777: FND_FILE.PUT_LINE(fnd_file.output,'');
778: FND_FILE.PUT_LINE(fnd_file.output,' Output Dir: '|| g_output_dir);
779:
780: -- Bug#12586059
781:
782: -- IF g_data_return_type in ('TYPE1A','TYPE3','TYPE4') then

Line 787: FND_FILE.PUT_LINE(fnd_file.output,' File Name: '||'LEA_'||g_lea_number||'.'||g_request_id);

783: IF g_data_return_type in ('TYPE1','TYPE3','TYPE4') then
784:
785: -- Bug#12586059
786:
787: FND_FILE.PUT_LINE(fnd_file.output,' File Name: '||'LEA_'||g_lea_number||'.'||g_request_id);
788:
789: -- Bug#12586059
790:
791: -- ELSIF g_data_return_type in ('TYPE1B','TYPE2') then

Line 796: FND_FILE.PUT_LINE(fnd_file.output,' File Name(s): '||'EST_.'||g_request_id);

792: ELSIF g_data_return_type = 'TYPE2' then
793:
794: -- Bug#12586059
795:
796: FND_FILE.PUT_LINE(fnd_file.output,' File Name(s): '||'EST_.'||g_request_id);
797: END IF;
798: FND_FILE.PUT_LINE(fnd_file.output,'');
799: IF (g_data_return_type <> 'TYPE4') THEN
800: FND_FILE.PUT_LINE(fnd_file.output,' Establishement Number No of Staff Processed');

Line 798: FND_FILE.PUT_LINE(fnd_file.output,'');

794: -- Bug#12586059
795:
796: FND_FILE.PUT_LINE(fnd_file.output,' File Name(s): '||'EST_.'||g_request_id);
797: END IF;
798: FND_FILE.PUT_LINE(fnd_file.output,'');
799: IF (g_data_return_type <> 'TYPE4') THEN
800: FND_FILE.PUT_LINE(fnd_file.output,' Establishement Number No of Staff Processed');
801: FND_FILE.PUT_LINE(fnd_file.output,' --------------------- ---------------------');
802:

Line 800: FND_FILE.PUT_LINE(fnd_file.output,' Establishement Number No of Staff Processed');

796: FND_FILE.PUT_LINE(fnd_file.output,' File Name(s): '||'EST_.'||g_request_id);
797: END IF;
798: FND_FILE.PUT_LINE(fnd_file.output,'');
799: IF (g_data_return_type <> 'TYPE4') THEN
800: FND_FILE.PUT_LINE(fnd_file.output,' Establishement Number No of Staff Processed');
801: FND_FILE.PUT_LINE(fnd_file.output,' --------------------- ---------------------');
802:
803: FOR l_eatab_staff in c_estab_staff_count LOOP
804: l_estab_count := l_estab_count + 1;

Line 801: FND_FILE.PUT_LINE(fnd_file.output,' --------------------- ---------------------');

797: END IF;
798: FND_FILE.PUT_LINE(fnd_file.output,'');
799: IF (g_data_return_type <> 'TYPE4') THEN
800: FND_FILE.PUT_LINE(fnd_file.output,' Establishement Number No of Staff Processed');
801: FND_FILE.PUT_LINE(fnd_file.output,' --------------------- ---------------------');
802:
803: FOR l_eatab_staff in c_estab_staff_count LOOP
804: l_estab_count := l_estab_count + 1;
805: FND_FILE.PUT(fnd_file.output, ' '|| lpad(l_eatab_staff.est_number,4));

Line 805: FND_FILE.PUT(fnd_file.output, ' '|| lpad(l_eatab_staff.est_number,4));

801: FND_FILE.PUT_LINE(fnd_file.output,' --------------------- ---------------------');
802:
803: FOR l_eatab_staff in c_estab_staff_count LOOP
804: l_estab_count := l_estab_count + 1;
805: FND_FILE.PUT(fnd_file.output, ' '|| lpad(l_eatab_staff.est_number,4));
806: IF (l_eatab_staff.est_number is not null) then
807: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
808: ELSE
809: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );

Line 807: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );

803: FOR l_eatab_staff in c_estab_staff_count LOOP
804: l_estab_count := l_estab_count + 1;
805: FND_FILE.PUT(fnd_file.output, ' '|| lpad(l_eatab_staff.est_number,4));
806: IF (l_eatab_staff.est_number is not null) then
807: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
808: ELSE
809: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
810: END IF;
811: END LOOP;

Line 809: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );

805: FND_FILE.PUT(fnd_file.output, ' '|| lpad(l_eatab_staff.est_number,4));
806: IF (l_eatab_staff.est_number is not null) then
807: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
808: ELSE
809: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
810: END IF;
811: END LOOP;
812: FND_FILE.PUT_LINE(fnd_file.output,'');
813: FND_FILE.PUT_LINE(fnd_file.output,'');

Line 812: FND_FILE.PUT_LINE(fnd_file.output,'');

808: ELSE
809: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
810: END IF;
811: END LOOP;
812: FND_FILE.PUT_LINE(fnd_file.output,'');
813: FND_FILE.PUT_LINE(fnd_file.output,'');
814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);
815: ELSE
816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));

Line 813: FND_FILE.PUT_LINE(fnd_file.output,'');

809: FND_FILE.PUT_LINE(fnd_file.output,' '||l_eatab_staff.staff_count );
810: END IF;
811: END LOOP;
812: FND_FILE.PUT_LINE(fnd_file.output,'');
813: FND_FILE.PUT_LINE(fnd_file.output,'');
814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);
815: ELSE
816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));
817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));

Line 814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);

810: END IF;
811: END LOOP;
812: FND_FILE.PUT_LINE(fnd_file.output,'');
813: FND_FILE.PUT_LINE(fnd_file.output,'');
814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);
815: ELSE
816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));
817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));
818: FND_FILE.PUT_LINE(fnd_file.output,' Total FTE- part Time Educational Psychologists: '|| round(nvl(g_edu_psy_fte,0),1));

Line 816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));

812: FND_FILE.PUT_LINE(fnd_file.output,'');
813: FND_FILE.PUT_LINE(fnd_file.output,'');
814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);
815: ELSE
816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));
817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));
818: FND_FILE.PUT_LINE(fnd_file.output,' Total FTE- part Time Educational Psychologists: '|| round(nvl(g_edu_psy_fte,0),1));
819: END IF;
820: hr_utility.trace('Leaving: '||l_proc);

Line 817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));

813: FND_FILE.PUT_LINE(fnd_file.output,'');
814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);
815: ELSE
816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));
817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));
818: FND_FILE.PUT_LINE(fnd_file.output,' Total FTE- part Time Educational Psychologists: '|| round(nvl(g_edu_psy_fte,0),1));
819: END IF;
820: hr_utility.trace('Leaving: '||l_proc);
821:

Line 818: FND_FILE.PUT_LINE(fnd_file.output,' Total FTE- part Time Educational Psychologists: '|| round(nvl(g_edu_psy_fte,0),1));

814: FND_FILE.PUT_LINE(fnd_file.output,' Total No of Establishments processed: '|| l_estab_count);
815: ELSE
816: FND_FILE.PUT_LINE(fnd_file.output,' Full Time Educational Psychologists Count: '|| nvl(g_edu_psy_ft,0));
817: FND_FILE.PUT_LINE(fnd_file.output,' Part Time Educational Psychologists Count: '|| nvl(g_edu_psy_pt,0));
818: FND_FILE.PUT_LINE(fnd_file.output,' Total FTE- part Time Educational Psychologists: '|| round(nvl(g_edu_psy_fte,0),1));
819: END IF;
820: hr_utility.trace('Leaving: '||l_proc);
821:
822: EXCEPTION