DBA Data[Home] [Help]

APPS.OKL_CBL_PVT dependencies on FND_GLOBAL

Line 1194: l_cblv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1190: ) RETURN cblv_rec_type IS
1191: l_cblv_rec cblv_rec_type := p_cblv_rec;
1192: BEGIN
1193: l_cblv_rec.CREATION_DATE := SYSDATE;
1194: l_cblv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1195: l_cblv_rec.LAST_UPDATE_DATE := l_cblv_rec.CREATION_DATE;
1196: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1197: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1198: RETURN(l_cblv_rec);

Line 1196: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1192: BEGIN
1193: l_cblv_rec.CREATION_DATE := SYSDATE;
1194: l_cblv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1195: l_cblv_rec.LAST_UPDATE_DATE := l_cblv_rec.CREATION_DATE;
1196: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1197: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1198: RETURN(l_cblv_rec);
1199: END fill_who_columns;
1200: ------------------------------------------------

Line 1197: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1193: l_cblv_rec.CREATION_DATE := SYSDATE;
1194: l_cblv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1195: l_cblv_rec.LAST_UPDATE_DATE := l_cblv_rec.CREATION_DATE;
1196: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1197: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1198: RETURN(l_cblv_rec);
1199: END fill_who_columns;
1200: ------------------------------------------------
1201: -- Set_Attributes for:OKL_CONTRACT_BALANCES_V --

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

1210: x_cblv_rec.OBJECT_VERSION_NUMBER := 1;
1211: --start code added by dkagrawa on 20 OCT 2005
1212: IF (x_cblv_rec.request_id IS NULL OR x_cblv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1213: SELECT
1214: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1215: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1216: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1217: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1218: INTO

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

1211: --start code added by dkagrawa on 20 OCT 2005
1212: IF (x_cblv_rec.request_id IS NULL OR x_cblv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1213: SELECT
1214: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1215: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1216: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1217: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1218: INTO
1219: x_cblv_rec.request_id,

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

1212: IF (x_cblv_rec.request_id IS NULL OR x_cblv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1213: SELECT
1214: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1215: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1216: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1217: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1218: INTO
1219: x_cblv_rec.request_id,
1220: x_cblv_rec.program_application_id,

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

1213: SELECT
1214: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1215: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1216: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1217: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1218: INTO
1219: x_cblv_rec.request_id,
1220: x_cblv_rec.program_application_id,
1221: x_cblv_rec.program_id,

Line 2191: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2187: ) RETURN cblv_rec_type IS
2188: l_cblv_rec cblv_rec_type := p_cblv_rec;
2189: BEGIN
2190: l_cblv_rec.LAST_UPDATE_DATE := SYSDATE;
2191: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2192: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2193: RETURN(l_cblv_rec);
2194: END fill_who_columns;
2195: ----------------------------------

Line 2192: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2188: l_cblv_rec cblv_rec_type := p_cblv_rec;
2189: BEGIN
2190: l_cblv_rec.LAST_UPDATE_DATE := SYSDATE;
2191: l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2192: l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2193: RETURN(l_cblv_rec);
2194: END fill_who_columns;
2195: ----------------------------------
2196: -- FUNCTION populate_new_record --

Line 2398: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

2394: x_cblv_rec := p_cblv_rec;
2395: --start code added by dkagrawa on 20 OCT 2005
2396: IF (x_cblv_rec.request_id IS NULL OR x_cblv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2397: SELECT
2398: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2399: x_cblv_rec.request_id),
2400: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2401: x_cblv_rec.program_application_id),
2402: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

2396: IF (x_cblv_rec.request_id IS NULL OR x_cblv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2397: SELECT
2398: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2399: x_cblv_rec.request_id),
2400: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2401: x_cblv_rec.program_application_id),
2402: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2403: x_cblv_rec.program_id),
2404: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

2398: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2399: x_cblv_rec.request_id),
2400: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2401: x_cblv_rec.program_application_id),
2402: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2403: x_cblv_rec.program_id),
2404: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2405: NULL,x_cblv_rec.program_update_date,SYSDATE)
2406: INTO

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

2400: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2401: x_cblv_rec.program_application_id),
2402: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2403: x_cblv_rec.program_id),
2404: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2405: NULL,x_cblv_rec.program_update_date,SYSDATE)
2406: INTO
2407: x_cblv_rec.request_id,
2408: x_cblv_rec.program_application_id,