940: -- Set the return status to success
941: x_return_status := FND_API.G_RET_STS_SUCCESS;
942:
943: --Derive the concurrent program who column values.
944: l_request_id := fnd_global.conc_request_id;
945: l_program_id := fnd_global.conc_program_id;
946: l_program_application_id := fnd_global.prog_appl_id;
947: IF (l_request_id = -1) THEN
948: l_request_id := NULL;
941: x_return_status := FND_API.G_RET_STS_SUCCESS;
942:
943: --Derive the concurrent program who column values.
944: l_request_id := fnd_global.conc_request_id;
945: l_program_id := fnd_global.conc_program_id;
946: l_program_application_id := fnd_global.prog_appl_id;
947: IF (l_request_id = -1) THEN
948: l_request_id := NULL;
949: l_program_id := NULL;
942:
943: --Derive the concurrent program who column values.
944: l_request_id := fnd_global.conc_request_id;
945: l_program_id := fnd_global.conc_program_id;
946: l_program_application_id := fnd_global.prog_appl_id;
947: IF (l_request_id = -1) THEN
948: l_request_id := NULL;
949: l_program_id := NULL;
950: l_program_application_id := NULL;
1259: l_sca_re_rec.attribute17,
1260: l_sca_re_rec.attribute18,
1261: l_sca_re_rec.attribute19,
1262: l_sca_re_rec.attribute20,
1263: NVL(FND_GLOBAL.USER_ID,-1),
1264: SYSDATE,
1265: NVL(FND_GLOBAL.USER_ID,-1),
1266: SYSDATE,
1267: NVL(FND_GLOBAL.LOGIN_ID,-1),
1261: l_sca_re_rec.attribute19,
1262: l_sca_re_rec.attribute20,
1263: NVL(FND_GLOBAL.USER_ID,-1),
1264: SYSDATE,
1265: NVL(FND_GLOBAL.USER_ID,-1),
1266: SYSDATE,
1267: NVL(FND_GLOBAL.LOGIN_ID,-1),
1268: l_request_id,
1269: l_program_application_id,
1263: NVL(FND_GLOBAL.USER_ID,-1),
1264: SYSDATE,
1265: NVL(FND_GLOBAL.USER_ID,-1),
1266: SYSDATE,
1267: NVL(FND_GLOBAL.LOGIN_ID,-1),
1268: l_request_id,
1269: l_program_application_id,
1270: l_program_id,
1271: l_program_update_date,
1332: l_sca_re_rec.re_max_submission_dt,
1333: l_sca_re_rec.re_min_submission_dt,
1334: l_sca_re_rec.re_research_topic,
1335: l_sca_re_rec.re_industry_links,
1336: NVL(FND_GLOBAL.USER_ID,-1),
1337: SYSDATE,
1338: NVL(FND_GLOBAL.USER_ID,-1),
1339: SYSDATE,
1340: NVL(FND_GLOBAL.LOGIN_ID,-1),
1334: l_sca_re_rec.re_research_topic,
1335: l_sca_re_rec.re_industry_links,
1336: NVL(FND_GLOBAL.USER_ID,-1),
1337: SYSDATE,
1338: NVL(FND_GLOBAL.USER_ID,-1),
1339: SYSDATE,
1340: NVL(FND_GLOBAL.LOGIN_ID,-1),
1341: l_request_id,
1342: l_program_application_id,
1336: NVL(FND_GLOBAL.USER_ID,-1),
1337: SYSDATE,
1338: NVL(FND_GLOBAL.USER_ID,-1),
1339: SYSDATE,
1340: NVL(FND_GLOBAL.LOGIN_ID,-1),
1341: l_request_id,
1342: l_program_application_id,
1343: l_program_id,
1344: l_program_update_date,