254: stmt_num := 1;
255: user_id := nvl(FND_PROFILE.Value('USER_ID'),-1);
256: resp_id :=nvl(FND_PROFILE.value('RESP_ID'),-1);
257: resp_appl_id := nvl(FND_PROFILE.Value('RESP_APPL_ID'),-1);
258: req_id := FND_GLOBAL.CONC_REQUEST_ID;
259: prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
260: prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
261:
262:
255: user_id := nvl(FND_PROFILE.Value('USER_ID'),-1);
256: resp_id :=nvl(FND_PROFILE.value('RESP_ID'),-1);
257: resp_appl_id := nvl(FND_PROFILE.Value('RESP_APPL_ID'),-1);
258: req_id := FND_GLOBAL.CONC_REQUEST_ID;
259: prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
260: prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
261:
262:
263:
256: resp_id :=nvl(FND_PROFILE.value('RESP_ID'),-1);
257: resp_appl_id := nvl(FND_PROFILE.Value('RESP_APPL_ID'),-1);
258: req_id := FND_GLOBAL.CONC_REQUEST_ID;
259: prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
260: prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
261:
262:
263:
264: stmt_num :=2;