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 1522: req_id := nvl(FND_PROFILE.value('CONC_REQUEST_ID'),-1);

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;

Line 1523: prog_id := nvl(FND_PROFILE.value('CONC_PROGRAM_ID'),-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

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

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