125: p_imp_headers_rec.ATTRIBUTE14),
126: DECODE(p_imp_headers_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
127: p_imp_headers_rec.ATTRIBUTE15),
128: Sysdate,
129: fnd_global.user_id,
130: Sysdate,
131: fnd_global.user_id,
132: fnd_global.login_id
133: from dual;
127: p_imp_headers_rec.ATTRIBUTE15),
128: Sysdate,
129: fnd_global.user_id,
130: Sysdate,
131: fnd_global.user_id,
132: fnd_global.login_id
133: from dual;
134:
135: END insert_row;
128: Sysdate,
129: fnd_global.user_id,
130: Sysdate,
131: fnd_global.user_id,
132: fnd_global.login_id
133: from dual;
134:
135: END insert_row;
136:
282: FND_API.G_MISS_CHAR,
283: oldrec.ATTRIBUTE15,
284: p_imp_headers_rec.ATTRIBUTE15),
285: LAST_UPDATE_DATE = Sysdate,
286: LAST_UPDATED_BY = fnd_global.user_id,
287: LAST_UPDATE_LOGIN = fnd_global.login_id
288: WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
289:
290: IF (SQL%ROWCOUNT=0) THEN
283: oldrec.ATTRIBUTE15,
284: p_imp_headers_rec.ATTRIBUTE15),
285: LAST_UPDATE_DATE = Sysdate,
286: LAST_UPDATED_BY = fnd_global.user_id,
287: LAST_UPDATE_LOGIN = fnd_global.login_id
288: WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
289:
290: IF (SQL%ROWCOUNT=0) THEN
291: RAISE NO_DATA_FOUND;
462: FND_API.G_MISS_CHAR,
463: oldrec.ATTRIBUTE15,
464: p_imp_headers_rec.ATTRIBUTE15),
465: LAST_UPDATE_DATE = Sysdate,
466: LAST_UPDATED_BY = fnd_global.user_id,
467: LAST_UPDATE_LOGIN = fnd_global.login_id
468: WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
469:
470: IF (SQL%ROWCOUNT=0) THEN
463: oldrec.ATTRIBUTE15,
464: p_imp_headers_rec.ATTRIBUTE15),
465: LAST_UPDATE_DATE = Sysdate,
466: LAST_UPDATED_BY = fnd_global.user_id,
467: LAST_UPDATE_LOGIN = fnd_global.login_id
468: WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
469:
470: IF (SQL%ROWCOUNT=0) THEN
471: RAISE NO_DATA_FOUND;