372: OKC_QA_CHECK_LISTS_V
373: where
374: id >= 11000 AND id < 50000;
375: BEGIN
376: if fnd_global.user_id = 1 then
377: open seed_c;
378: fetch seed_c into l_id;
379: close seed_c;
380: return(l_id);
1459: ) RETURN qclv_rec_type IS
1460: l_qclv_rec qclv_rec_type := p_qclv_rec;
1461: BEGIN
1462: l_qclv_rec.CREATION_DATE := SYSDATE;
1463: l_qclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1464: --l_qclv_rec.LAST_UPDATE_DATE := SYSDATE;
1465: l_qclv_rec.LAST_UPDATE_DATE := l_qclv_rec.CREATION_DATE;
1466: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1467: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1462: l_qclv_rec.CREATION_DATE := SYSDATE;
1463: l_qclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1464: --l_qclv_rec.LAST_UPDATE_DATE := SYSDATE;
1465: l_qclv_rec.LAST_UPDATE_DATE := l_qclv_rec.CREATION_DATE;
1466: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1467: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1468: RETURN(l_qclv_rec);
1469: END fill_who_columns;
1470: ---------------------------------------------
1463: l_qclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1464: --l_qclv_rec.LAST_UPDATE_DATE := SYSDATE;
1465: l_qclv_rec.LAST_UPDATE_DATE := l_qclv_rec.CREATION_DATE;
1466: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1467: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1468: RETURN(l_qclv_rec);
1469: END fill_who_columns;
1470: ---------------------------------------------
1471: -- Set_Attributes for:OKC_QA_CHECK_LISTS_V --
2460: ) RETURN qclv_rec_type IS
2461: l_qclv_rec qclv_rec_type := p_qclv_rec;
2462: BEGIN
2463: l_qclv_rec.LAST_UPDATE_DATE := SYSDATE;
2464: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2465: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2466: RETURN(l_qclv_rec);
2467: END fill_who_columns;
2468: ----------------------------------
2461: l_qclv_rec qclv_rec_type := p_qclv_rec;
2462: BEGIN
2463: l_qclv_rec.LAST_UPDATE_DATE := SYSDATE;
2464: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2465: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2466: RETURN(l_qclv_rec);
2467: END fill_who_columns;
2468: ----------------------------------
2469: -- FUNCTION populate_new_record --