244:
245: BEGIN
246:
247: stmt_num := 0;
248: IF FND_PROFILE.VALUE('MRP_DEBUG') = 'Y' then
249: p_debug := 'Y';
250: else
251: p_debug :='N';
252: end if;
251: p_debug :='N';
252: end if;
253:
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;
252: end if;
253:
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;
253:
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:
1518: */
1519:
1520:
1521: stmt_num := 0;
1522: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);
1523: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);
1524: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);
1525:
1526: stmt_num := 1;
1519:
1520:
1521: stmt_num := 0;
1522: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);
1523: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);
1524: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);
1525:
1526: stmt_num := 1;
1527: update_stmt:= 'UPDATE' || table_name || ' SET REQUEST_ID = ' || req_id
1520:
1521: stmt_num := 0;
1522: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);
1523: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);
1524: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);
1525:
1526: stmt_num := 1;
1527: update_stmt:= 'UPDATE' || table_name || ' SET REQUEST_ID = ' || req_id
1528: ||', PROGRAM_ID = ' || prog_id ||', PROGRAM_APPLICATION_ID =' || resp_appl_id