DBA Data[Home] [Help]

APPS.OKC_QCL_PVT dependencies on FND_GLOBAL

Line 376: if fnd_global.user_id = 1 then

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);

Line 1463: l_qclv_rec.CREATED_BY := FND_GLOBAL.USER_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;

Line 1466: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_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: ---------------------------------------------

Line 1467: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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 --

Line 2464: l_qclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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: ----------------------------------

Line 2465: l_qclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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 --