89: p_import_types_rec.ATTRIBUTE14),
90: DECODE(p_import_types_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
91: p_import_types_rec.ATTRIBUTE15),
92: Sysdate,
93: fnd_global.user_id,
94: Sysdate,
95: fnd_global.user_id,
96: fnd_global.login_id
97: from dual;
91: p_import_types_rec.ATTRIBUTE15),
92: Sysdate,
93: fnd_global.user_id,
94: Sysdate,
95: fnd_global.user_id,
96: fnd_global.login_id
97: from dual;
98:
99: END insert_row;
92: Sysdate,
93: fnd_global.user_id,
94: Sysdate,
95: fnd_global.user_id,
96: fnd_global.login_id
97: from dual;
98:
99: END insert_row;
100:
198: FND_API.G_MISS_CHAR,
199: oldrec.ATTRIBUTE15,
200: p_import_types_rec.ATTRIBUTE15),
201: LAST_UPDATE_DATE = Sysdate,
202: LAST_UPDATED_BY = fnd_global.user_id,
203: LAST_UPDATE_LOGIN = fnd_global.login_id
204: WHERE import_type_id = p_import_types_rec.import_type_id;
205:
206: IF (SQL%ROWCOUNT=0) THEN
199: oldrec.ATTRIBUTE15,
200: p_import_types_rec.ATTRIBUTE15),
201: LAST_UPDATE_DATE = Sysdate,
202: LAST_UPDATED_BY = fnd_global.user_id,
203: LAST_UPDATE_LOGIN = fnd_global.login_id
204: WHERE import_type_id = p_import_types_rec.import_type_id;
205:
206: IF (SQL%ROWCOUNT=0) THEN
207: RAISE NO_DATA_FOUND;
330: FND_API.G_MISS_CHAR,
331: oldrec.ATTRIBUTE15,
332: p_import_types_rec.ATTRIBUTE15),
333: LAST_UPDATE_DATE = Sysdate,
334: LAST_UPDATED_BY = fnd_global.user_id,
335: LAST_UPDATE_LOGIN = fnd_global.login_id
336: WHERE import_type_id = p_import_types_rec.import_type_id;
337:
338: IF (SQL%ROWCOUNT=0) THEN
331: oldrec.ATTRIBUTE15,
332: p_import_types_rec.ATTRIBUTE15),
333: LAST_UPDATE_DATE = Sysdate,
334: LAST_UPDATED_BY = fnd_global.user_id,
335: LAST_UPDATE_LOGIN = fnd_global.login_id
336: WHERE import_type_id = p_import_types_rec.import_type_id;
337:
338: IF (SQL%ROWCOUNT=0) THEN
339: RAISE NO_DATA_FOUND;