DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on FND_PROFILE

Line 248: IF FND_PROFILE.VALUE('MRP_DEBUG') = 'Y' then

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;

Line 255: user_id := nvl(FND_PROFILE.Value('USER_ID'),-1);

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;

Line 256: resp_id :=nvl(FND_PROFILE.value('RESP_ID'),-1);

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;

Line 257: resp_appl_id := nvl(FND_PROFILE.Value('RESP_APPL_ID'),-1);

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:

Line 1479: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);

1475: */
1476:
1477:
1478: stmt_num := 0;
1479: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);
1480: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);
1481: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);
1482:
1483: stmt_num := 1;

Line 1480: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);

1476:
1477:
1478: stmt_num := 0;
1479: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);
1480: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);
1481: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);
1482:
1483: stmt_num := 1;
1484: update_stmt:= 'UPDATE' || table_name || ' SET REQUEST_ID = ' || req_id

Line 1481: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);

1477:
1478: stmt_num := 0;
1479: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);
1480: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-1);
1481: resp_appl_id := nvl(FND_PROFILE.value('RESP_APPL_ID'),-1);
1482:
1483: stmt_num := 1;
1484: update_stmt:= 'UPDATE' || table_name || ' SET REQUEST_ID = ' || req_id
1485: ||', PROGRAM_ID = ' || prog_id ||', PROGRAM_APPLICATION_ID =' || resp_appl_id