DBA Data[Home] [Help]

APPS.OKL_CLD_PVT dependencies on FND_GLOBAL

Line 1268: l_cldv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1264: ) RETURN cldv_rec_type IS
1265: l_cldv_rec cldv_rec_type := p_cldv_rec;
1266: BEGIN
1267: l_cldv_rec.CREATION_DATE := SYSDATE;
1268: l_cldv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1269: l_cldv_rec.LAST_UPDATE_DATE := l_cldv_rec.CREATION_DATE;
1270: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1271: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1272: RETURN(l_cldv_rec);

Line 1270: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1266: BEGIN
1267: l_cldv_rec.CREATION_DATE := SYSDATE;
1268: l_cldv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1269: l_cldv_rec.LAST_UPDATE_DATE := l_cldv_rec.CREATION_DATE;
1270: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1271: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1272: RETURN(l_cldv_rec);
1273: END fill_who_columns;
1274: ------------------------------------------------

Line 1271: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1267: l_cldv_rec.CREATION_DATE := SYSDATE;
1268: l_cldv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1269: l_cldv_rec.LAST_UPDATE_DATE := l_cldv_rec.CREATION_DATE;
1270: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1271: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1272: RETURN(l_cldv_rec);
1273: END fill_who_columns;
1274: ------------------------------------------------
1275: -- Set_Attributes for:OKL_CHECKLIST_DETAILS_V --

Line 1287: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),

1283: x_cldv_rec := p_cldv_rec;
1284: x_cldv_rec.OBJECT_VERSION_NUMBER := 1;
1285:
1286: -- concurrent program columns
1287: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1288: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1289: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1290: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1291: INTO x_cldv_rec.REQUEST_ID

Line 1288: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),

1284: x_cldv_rec.OBJECT_VERSION_NUMBER := 1;
1285:
1286: -- concurrent program columns
1287: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1288: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1289: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1290: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1291: INTO x_cldv_rec.REQUEST_ID
1292: ,x_cldv_rec.PROGRAM_APPLICATION_ID

Line 1289: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),

1285:
1286: -- concurrent program columns
1287: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1288: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1289: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1290: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1291: INTO x_cldv_rec.REQUEST_ID
1292: ,x_cldv_rec.PROGRAM_APPLICATION_ID
1293: ,x_cldv_rec.PROGRAM_ID

Line 1290: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)

1286: -- concurrent program columns
1287: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1288: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1289: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1290: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1291: INTO x_cldv_rec.REQUEST_ID
1292: ,x_cldv_rec.PROGRAM_APPLICATION_ID
1293: ,x_cldv_rec.PROGRAM_ID
1294: ,x_cldv_rec.PROGRAM_UPDATE_DATE

Line 2257: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2253: ) RETURN cldv_rec_type IS
2254: l_cldv_rec cldv_rec_type := p_cldv_rec;
2255: BEGIN
2256: l_cldv_rec.LAST_UPDATE_DATE := SYSDATE;
2257: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2258: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2259: RETURN(l_cldv_rec);
2260: END fill_who_columns;
2261: ----------------------------------

Line 2258: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2254: l_cldv_rec cldv_rec_type := p_cldv_rec;
2255: BEGIN
2256: l_cldv_rec.LAST_UPDATE_DATE := SYSDATE;
2257: l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2258: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2259: RETURN(l_cldv_rec);
2260: END fill_who_columns;
2261: ----------------------------------
2262: -- FUNCTION populate_new_record --