DBA Data[Home] [Help]

APPS.OKL_CLH_PVT dependencies on FND_GLOBAL

Line 1241: l_clhv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1237: ) RETURN clhv_rec_type IS
1238: l_clhv_rec clhv_rec_type := p_clhv_rec;
1239: BEGIN
1240: l_clhv_rec.CREATION_DATE := SYSDATE;
1241: l_clhv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_clhv_rec.LAST_UPDATE_DATE := l_clhv_rec.CREATION_DATE;
1243: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_clhv_rec);

Line 1243: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1239: BEGIN
1240: l_clhv_rec.CREATION_DATE := SYSDATE;
1241: l_clhv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_clhv_rec.LAST_UPDATE_DATE := l_clhv_rec.CREATION_DATE;
1243: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_clhv_rec);
1246: END fill_who_columns;
1247: -----------------------------------------

Line 1244: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1240: l_clhv_rec.CREATION_DATE := SYSDATE;
1241: l_clhv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1242: l_clhv_rec.LAST_UPDATE_DATE := l_clhv_rec.CREATION_DATE;
1243: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1244: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1245: RETURN(l_clhv_rec);
1246: END fill_who_columns;
1247: -----------------------------------------
1248: -- Set_Attributes for:OKL_CHECKLISTS_V --

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

1256: x_clhv_rec := p_clhv_rec;
1257: x_clhv_rec.OBJECT_VERSION_NUMBER := 1;
1258:
1259: -- concurrent program columns
1260: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1261: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1262: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1263: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1264: INTO x_clhv_rec.REQUEST_ID

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

1257: x_clhv_rec.OBJECT_VERSION_NUMBER := 1;
1258:
1259: -- concurrent program columns
1260: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1261: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1262: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1263: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1264: INTO x_clhv_rec.REQUEST_ID
1265: ,x_clhv_rec.PROGRAM_APPLICATION_ID

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

1258:
1259: -- concurrent program columns
1260: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1261: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1262: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1263: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1264: INTO x_clhv_rec.REQUEST_ID
1265: ,x_clhv_rec.PROGRAM_APPLICATION_ID
1266: ,x_clhv_rec.PROGRAM_ID

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

1259: -- concurrent program columns
1260: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1261: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1262: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1263: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1264: INTO x_clhv_rec.REQUEST_ID
1265: ,x_clhv_rec.PROGRAM_APPLICATION_ID
1266: ,x_clhv_rec.PROGRAM_ID
1267: ,x_clhv_rec.PROGRAM_UPDATE_DATE

Line 2233: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2229: ) RETURN clhv_rec_type IS
2230: l_clhv_rec clhv_rec_type := p_clhv_rec;
2231: BEGIN
2232: l_clhv_rec.LAST_UPDATE_DATE := SYSDATE;
2233: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2234: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2235: RETURN(l_clhv_rec);
2236: END fill_who_columns;
2237: ----------------------------------

Line 2234: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2230: l_clhv_rec clhv_rec_type := p_clhv_rec;
2231: BEGIN
2232: l_clhv_rec.LAST_UPDATE_DATE := SYSDATE;
2233: l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2234: l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2235: RETURN(l_clhv_rec);
2236: END fill_who_columns;
2237: ----------------------------------
2238: -- FUNCTION populate_new_record --