DBA Data[Home] [Help]

APPS.OKL_IDX_PVT dependencies on FND_GLOBAL

Line 1175: l_idxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1171: ) RETURN idxv_rec_type IS
1172: l_idxv_rec idxv_rec_type := p_idxv_rec;
1173: BEGIN
1174: l_idxv_rec.CREATION_DATE := SYSDATE;
1175: l_idxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1176: l_idxv_rec.LAST_UPDATE_DATE := SYSDATE;
1177: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1178: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1179: RETURN(l_idxv_rec);

Line 1177: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1173: BEGIN
1174: l_idxv_rec.CREATION_DATE := SYSDATE;
1175: l_idxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1176: l_idxv_rec.LAST_UPDATE_DATE := SYSDATE;
1177: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1178: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1179: RETURN(l_idxv_rec);
1180: END fill_who_columns;
1181: --------------------------------------

Line 1178: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1174: l_idxv_rec.CREATION_DATE := SYSDATE;
1175: l_idxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1176: l_idxv_rec.LAST_UPDATE_DATE := SYSDATE;
1177: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1178: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1179: RETURN(l_idxv_rec);
1180: END fill_who_columns;
1181: --------------------------------------
1182: -- Set_Attributes for:OKL_INDICES_V --

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

1189: BEGIN
1190: x_idxv_rec := p_idxv_rec;
1191: x_idxv_rec.OBJECT_VERSION_NUMBER := 1;
1192:
1193: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1194: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1195: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1196: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1197: INTO x_idxv_rec.REQUEST_ID

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

1190: x_idxv_rec := p_idxv_rec;
1191: x_idxv_rec.OBJECT_VERSION_NUMBER := 1;
1192:
1193: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1194: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1195: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1196: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1197: INTO x_idxv_rec.REQUEST_ID
1198: ,x_idxv_rec.PROGRAM_APPLICATION_ID

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

1191: x_idxv_rec.OBJECT_VERSION_NUMBER := 1;
1192:
1193: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1194: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1195: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1196: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1197: INTO x_idxv_rec.REQUEST_ID
1198: ,x_idxv_rec.PROGRAM_APPLICATION_ID
1199: ,x_idxv_rec.PROGRAM_ID

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

1192:
1193: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1194: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1195: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1196: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1197: INTO x_idxv_rec.REQUEST_ID
1198: ,x_idxv_rec.PROGRAM_APPLICATION_ID
1199: ,x_idxv_rec.PROGRAM_ID
1200: ,x_idxv_rec.PROGRAM_UPDATE_DATE

Line 1936: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1932: ) RETURN idxv_rec_type IS
1933: l_idxv_rec idxv_rec_type := p_idxv_rec;
1934: BEGIN
1935: l_idxv_rec.LAST_UPDATE_DATE := SYSDATE;
1936: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1937: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1938: RETURN(l_idxv_rec);
1939: END fill_who_columns;
1940: ----------------------------------

Line 1937: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1933: l_idxv_rec idxv_rec_type := p_idxv_rec;
1934: BEGIN
1935: l_idxv_rec.LAST_UPDATE_DATE := SYSDATE;
1936: l_idxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1937: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1938: RETURN(l_idxv_rec);
1939: END fill_who_columns;
1940: ----------------------------------
1941: -- FUNCTION populate_new_record --

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

2091: BEGIN
2092:
2093: x_idxv_rec := p_idxv_rec;
2094:
2095: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2096: x_idxv_rec.request_id),
2097: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2098: x_idxv_rec.PROGRAM_APPLICATION_ID),
2099: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),

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

2093: x_idxv_rec := p_idxv_rec;
2094:
2095: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2096: x_idxv_rec.request_id),
2097: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2098: x_idxv_rec.PROGRAM_APPLICATION_ID),
2099: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2100: x_idxv_rec.PROGRAM_ID),
2101: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE),NULL,

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

2095: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2096: x_idxv_rec.request_id),
2097: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2098: x_idxv_rec.PROGRAM_APPLICATION_ID),
2099: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2100: x_idxv_rec.PROGRAM_ID),
2101: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE),NULL,
2102: x_idxv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2103: INTO x_idxv_rec.REQUEST_ID

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

2097: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2098: x_idxv_rec.PROGRAM_APPLICATION_ID),
2099: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2100: x_idxv_rec.PROGRAM_ID),
2101: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE),NULL,
2102: x_idxv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
2103: INTO x_idxv_rec.REQUEST_ID
2104: ,x_idxv_rec.PROGRAM_APPLICATION_ID
2105: ,x_idxv_rec.PROGRAM_ID