');
935: ,p_output_file_type
936: ));
937:
938: IF p_output_file_type ='HTML' THEN
939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
941: END IF;
942:
943: /* Write the column Header */
Line 940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
936: ));
937:
938: IF p_output_file_type ='HTML' THEN
939: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
941: END IF;
942:
943: /* Write the column Header */
944:
Line 945: fnd_file.put_line(fnd_file.output,formated_header_sec2( p_output_file_type));
941: END IF;
942:
943: /* Write the column Header */
944:
945: fnd_file.put_line(fnd_file.output,formated_header_sec2( p_output_file_type));
946:
947: IF p_output_file_type ='HTML' THEN
948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
949: END IF;
Line 948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
944:
945: fnd_file.put_line(fnd_file.output,formated_header_sec2( p_output_file_type));
946:
947: IF p_output_file_type ='HTML' THEN
948: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
949: END IF;
950:
951: For i in c_seeded_att( lvc_legislation_code ) loop
952: hr_utility.trace( 'Attribute name :- ' || i.attribute_name);
Line 984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
980: if p_output_file_type ='HTML' then
981: lv_data_row := '
' || lv_data_row || '
' ;
982: end if;
983: hr_utility.trace(lv_data_row);
984: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
985:
986:
987: END LOOP ; /* c_seeded_att */
988:
Line 1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1018: if p_output_file_type ='HTML' then
1019: lv_data_row := '
' || lv_data_row || '
' ;
1020: end if;
1021: hr_utility.trace(lv_data_row);
1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1023:
1024:
1025: END LOOP ; /* c_userdef_att */
1026:
Line 1028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1024:
1025: END LOOP ; /* c_userdef_att */
1026:
1027: IF p_output_file_type ='HTML' THEN
1028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1029: END IF;
1030:
1031:
1032:
Line 1040: fnd_file.put_line(fnd_file.output, formated_header_string(
1036:
1037: IF p_attribute_balance = 'Y' THEN
1038:
1039: FOR i in 1..4 LOOP
1040: fnd_file.put_line(fnd_file.output, formated_header_string(
1041: ' '
1042: ,p_output_file_type
1043: ));
1044: END LOOP;
Line 1046: fnd_file.put_line(fnd_file.output, formated_header_string(
1042: ,p_output_file_type
1043: ));
1044: END LOOP;
1045:
1046: fnd_file.put_line(fnd_file.output, formated_header_string(
1047: gv_title_sec3 || ' '
1048: ,p_output_file_type
1049: ));
1050:
Line 1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1048: ,p_output_file_type
1049: ));
1050:
1051: IF p_output_file_type ='HTML' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1054: END IF;
1055:
1056: /* Write the column Header */
Line 1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1049: ));
1050:
1051: IF p_output_file_type ='HTML' THEN
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1054: END IF;
1055:
1056: /* Write the column Header */
1057:
Line 1058: fnd_file.put_line(fnd_file.output,formated_header_sec3( p_output_file_type));
1054: END IF;
1055:
1056: /* Write the column Header */
1057:
1058: fnd_file.put_line(fnd_file.output,formated_header_sec3( p_output_file_type));
1059:
1060: IF p_output_file_type ='HTML' THEN
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1062: END IF;
Line 1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1057:
1058: fnd_file.put_line(fnd_file.output,formated_header_sec3( p_output_file_type));
1059:
1060: IF p_output_file_type ='HTML' THEN
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1062: END IF;
1063:
1064: For i in c_seeded_att( lvc_legislation_code ) loop
1065: hr_utility.trace( 'Attribute name :- ' || i.attribute_name);
Line 1082: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1078: if p_output_file_type ='HTML' then
1079: lv_data_row := '
' || lv_data_row || '
' ;
1080: end if;
1081: hr_utility.trace(lv_data_row);
1082: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1083: END LOOP;
1084:
1085: END LOOP ; /* c_seeded_att */
1086:
Line 1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1101: if p_output_file_type ='HTML' then
1102: lv_data_row := '
' || lv_data_row || '
' ;
1103: end if;
1104: hr_utility.trace(lv_data_row);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1106: END LOOP;
1107:
1108: END LOOP ; /* c_userdef_att */
1109:
Line 1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1107:
1108: END LOOP ; /* c_userdef_att */
1109:
1110: IF p_output_file_type ='HTML' THEN
1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1112:
1113: END IF;
1114:
1115: END IF ; /* IF p_attribute_balance = 'Y' */
Line 1129: fnd_file.put_line(fnd_file.output, formated_header_string(
1125: lvn_count := lvn_count +1;
1126: /* Print only first time */
1127: IF lvn_count = 1 THEN
1128:
1129: fnd_file.put_line(fnd_file.output, formated_header_string(
1130: gv_title_sec4 || ' '
1131: ,p_output_file_type
1132: ));
1133:
Line 1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1133:
1134:
1135:
1136: IF p_output_file_type ='HTML' THEN
1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1139: END IF;
1140:
1141: /* Write the column Header */
Line 1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1134:
1135:
1136: IF p_output_file_type ='HTML' THEN
1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1139: END IF;
1140:
1141: /* Write the column Header */
1142:
Line 1143: fnd_file.put_line(fnd_file.output,formated_header_sec4( p_output_file_type));
1139: END IF;
1140:
1141: /* Write the column Header */
1142:
1143: fnd_file.put_line(fnd_file.output,formated_header_sec4( p_output_file_type));
1144:
1145: IF p_output_file_type ='HTML' THEN
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1147: END IF;
Line 1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1142:
1143: fnd_file.put_line(fnd_file.output,formated_header_sec4( p_output_file_type));
1144:
1145: IF p_output_file_type ='HTML' THEN
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1147: END IF;
1148:
1149: END IF; /* lvn_count */
1150:
Line 1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1160: if p_output_file_type ='HTML' then
1161: lv_data_row := '
' || lv_data_row || '
' ;
1162: end if;
1163: hr_utility.trace(lv_data_row);
1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1165:
1166:
1167: END LOOP; /* c_attrib_details */
1168:
Line 1171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1167: END LOOP; /* c_attrib_details */
1168:
1169:
1170: IF p_output_file_type ='HTML' THEN
1171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1172: END IF;
1173:
1174: IF p_output_file_type ='HTML' THEN
1175: UPDATE fnd_concurrent_requests