DBA Data[Home] [Help]

APPS.OKC_OIE_PVT dependencies on FND_GLOBAL

Line 1202: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

1198: l_oie_rec.last_update_date,
1199: l_oie_rec.last_update_login,
1200: l_oie_rec.name,
1201: l_oie_rec.target_chr_id,
1202: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1203: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1204: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1205: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1206: l_oie_rec.jtot_object1_code,

Line 1203: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

1199: l_oie_rec.last_update_login,
1200: l_oie_rec.name,
1201: l_oie_rec.target_chr_id,
1202: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1203: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1204: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1205: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1206: l_oie_rec.jtot_object1_code,
1207: l_oie_rec.object1_id1,

Line 1204: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

1200: l_oie_rec.name,
1201: l_oie_rec.target_chr_id,
1202: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1203: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1204: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1205: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1206: l_oie_rec.jtot_object1_code,
1207: l_oie_rec.object1_id1,
1208: l_oie_rec.object1_id2,

Line 1205: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

1201: l_oie_rec.target_chr_id,
1202: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1203: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1204: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1205: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1206: l_oie_rec.jtot_object1_code,
1207: l_oie_rec.object1_id1,
1208: l_oie_rec.object1_id2,
1209: -- R12 Data Model Changes 4485150 Start

Line 1303: l_oiev_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1299: l_oiev_rec oiev_rec_type := p_oiev_rec;
1300: BEGIN
1301:
1302: l_oiev_rec.CREATION_DATE := SYSDATE;
1303: l_oiev_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1304: l_oiev_rec.LAST_UPDATE_DATE := l_oiev_rec.CREATION_DATE;
1305: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1306: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1307:

Line 1305: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1301:
1302: l_oiev_rec.CREATION_DATE := SYSDATE;
1303: l_oiev_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1304: l_oiev_rec.LAST_UPDATE_DATE := l_oiev_rec.CREATION_DATE;
1305: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1306: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1307:
1308: RETURN(l_oiev_rec);
1309:

Line 1306: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1302: l_oiev_rec.CREATION_DATE := SYSDATE;
1303: l_oiev_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1304: l_oiev_rec.LAST_UPDATE_DATE := l_oiev_rec.CREATION_DATE;
1305: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1306: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1307:
1308: RETURN(l_oiev_rec);
1309:
1310: END fill_who_columns;

Line 2117: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_oie_rec.request_id),

2113: LAST_UPDATE_LOGIN = l_def_oie_rec.last_update_login,
2114: NAME = l_def_oie_rec.name,
2115: TARGET_CHR_ID = l_def_oie_rec.target_chr_id,
2116:
2117: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_oie_rec.request_id),
2118: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_oie_rec.program_application_id),
2119: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_oie_rec.program_id),
2120: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_oie_rec.program_update_date,SYSDATE),
2121: JTOT_OBJECT1_CODE = l_def_oie_rec.jtot_object1_code,

Line 2118: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_oie_rec.program_application_id),

2114: NAME = l_def_oie_rec.name,
2115: TARGET_CHR_ID = l_def_oie_rec.target_chr_id,
2116:
2117: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_oie_rec.request_id),
2118: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_oie_rec.program_application_id),
2119: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_oie_rec.program_id),
2120: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_oie_rec.program_update_date,SYSDATE),
2121: JTOT_OBJECT1_CODE = l_def_oie_rec.jtot_object1_code,
2122: OBJECT1_ID1 = l_def_oie_rec.object1_id1,

Line 2119: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_oie_rec.program_id),

2115: TARGET_CHR_ID = l_def_oie_rec.target_chr_id,
2116:
2117: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_oie_rec.request_id),
2118: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_oie_rec.program_application_id),
2119: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_oie_rec.program_id),
2120: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_oie_rec.program_update_date,SYSDATE),
2121: JTOT_OBJECT1_CODE = l_def_oie_rec.jtot_object1_code,
2122: OBJECT1_ID1 = l_def_oie_rec.object1_id1,
2123: OBJECT1_ID2 = l_def_oie_rec.object1_id2,

Line 2120: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_oie_rec.program_update_date,SYSDATE),

2116:
2117: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_oie_rec.request_id),
2118: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_oie_rec.program_application_id),
2119: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_oie_rec.program_id),
2120: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_oie_rec.program_update_date,SYSDATE),
2121: JTOT_OBJECT1_CODE = l_def_oie_rec.jtot_object1_code,
2122: OBJECT1_ID1 = l_def_oie_rec.object1_id1,
2123: OBJECT1_ID2 = l_def_oie_rec.object1_id2,
2124: -- R12 Data Model Changes 4485150 Start

Line 2222: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2218: okc_debug.log('8900: Entered fill_who_columns', 2);
2219: END IF;
2220:
2221: l_oiev_rec.LAST_UPDATE_DATE := SYSDATE;
2222: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2223: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2224: RETURN(l_oiev_rec);
2225:
2226: END fill_who_columns;

Line 2223: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2219: END IF;
2220:
2221: l_oiev_rec.LAST_UPDATE_DATE := SYSDATE;
2222: l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2223: l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2224: RETURN(l_oiev_rec);
2225:
2226: END fill_who_columns;
2227: ----------------------------------