1122: fnd_file.put_line(fnd_file.log, fnd_message.get);
1123:
1124: IF l_schsite_rowid IS NULL THEN
1125: BEGIN
1126: igs_uc_com_schsites_pkg.insert_row -- IGSXI11B.pls
1127: (
1128: x_rowid => l_schsite_rowid
1129: ,x_school => new_school_rec.school
1130: ,x_sitecode => NVL(new_school_rec.sitecode ,'A')
1148:
1149: ELSE
1150: -- update
1151: BEGIN
1152: igs_uc_com_schsites_pkg.update_row -- IGSXI11B.pls
1153: (
1154: x_rowid => l_schsite_rowid
1155: ,x_school => old_school_rec.school
1156: ,x_sitecode => NVL(new_school_rec.sitecode, 'A')