DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_GLOBAL

Line 709: req_id := fnd_global.conc_request_id;

705: if ( lengthb(message) > 240 ) then
706: fnd_file.put_line( fnd_file.log, message);
707: end if;
708:
709: req_id := fnd_global.conc_request_id;
710:
711: ret_str := set_status_autonomous(req_id, scode, message);
712:
713: -- if ret_str has some string that means some error otherwise return TRUE

Line 979: if (fnd_global.conc_request_id > 0) then

975: morg_cat varchar2(1) := null;
976: orgid number;
977: begin
978:
979: if (fnd_global.conc_request_id > 0) then
980:
981: Select P.PID, P.SPID, AUDSID, PROCESS,
982: substr(userenv('LANGUAGE'),
983: instr( userenv('LANGUAGE'), '.') + 1)

Line 994: where request_id = fnd_global.conc_request_id;

990: set ORACLE_SESSION_ID = csid,
991: ORACLE_PROCESS_ID = csspid,
992: OS_PROCESS_ID = cspid,
993: NLS_CodeSet = codeset
994: where request_id = fnd_global.conc_request_id;
995:
996: -- DOING COMMIT HERE SO THAT GUI TOOLS GET THE SESSION INFO
997: -- DURING PROGRAM EXECUTION.
998:

Line 1013: And R.request_id = fnd_global.conc_request_id;

1009: from FND_CONCURRENT_PROGRAMS P,
1010: FND_CONCURRENT_REQUESTS R
1011: WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
1012: And P.APPLICATION_ID = R.Program_APPLICATION_ID
1013: And R.request_id = fnd_global.conc_request_id;
1014: exception
1015: when others then
1016: optmode := null;
1017: program_name := null;

Line 1032: And R.Request_ID = fnd_global.conc_request_id;

1028: Select plsql_log, plsql_out, plsql_dir
1029: Into plog, pout, pdir
1030: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R
1031: Where P.Concurrent_Process_ID = R.Controlling_Manager
1032: And R.Request_ID = fnd_global.conc_request_id;
1033:
1034: fnd_file.put_names(plog, pout, pdir);
1035: fnd_file_private.put_names(plog, pout, pdir);
1036:

Line 1056: where R.request_id = fnd_global.conc_request_id

1052: into que_rcg
1053: from fnd_concurrent_requests r,
1054: fnd_concurrent_processes p,
1055: fnd_concurrent_queues q
1056: where R.request_id = fnd_global.conc_request_id
1057: and R.controlling_manager = P.concurrent_process_id
1058: and Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID
1059: and Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID;
1060: exception

Line 1070: where R.request_id = fnd_global.conc_request_id

1066: select p.RESOURCE_CONSUMER_GROUP
1067: into prg_rcg
1068: from fnd_concurrent_programs P,
1069: fnd_concurrent_requests R
1070: where R.request_id = fnd_global.conc_request_id
1071: and r.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
1072: and R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID;
1073: exception
1074: when others then

Line 1100: req_id => fnd_global.conc_request_id);

1096: ret_val := fnd_debug.enable_db_rules(comp_type => dbg_comp,
1097: comp_name => program_name,
1098: comp_appl_id => null,
1099: comp_id => null,
1100: req_id => fnd_global.conc_request_id);
1101: end;
1102: end if;
1103:
1104: return;

Line 1138: WHERE R.request_id = fnd_global.conc_request_id

1134: select P.Rollback_Segment
1135: into RBS
1136: from FND_CONCURRENT_PROGRAMS P,
1137: FND_CONCURRENT_REQUESTS R
1138: WHERE R.request_id = fnd_global.conc_request_id
1139: AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
1140: And R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;
1141:
1142: if RBS is not Null then

Line 1175: g_request_id := fnd_global.conc_request_id;

1171: --
1172: -- Use request id from global context if one exists, else
1173: -- use the one provided by the caller (security hole?)
1174: --
1175: g_request_id := fnd_global.conc_request_id;
1176:
1177: if (g_request_id is null) then
1178: g_request_id := Request_Id;
1179: end if;

Line 1208: if (fnd_global.conc_request_id > 0) then

1204: commit;
1205:
1206: -- if the context is concurrent program then set the rollback segment to
1207: -- program preferred
1208: if (fnd_global.conc_request_id > 0) then
1209: fnd_concurrent.set_preferred_rbs;
1210: end if;
1211:
1212: End AF_COMMIT;

Line 1231: if (fnd_global.conc_request_id > 0) then

1227: rollback;
1228:
1229: -- if the context is concurrent program then set the rollback segment to
1230: -- program preferred
1231: if (fnd_global.conc_request_id > 0) then
1232: fnd_concurrent.set_preferred_rbs;
1233: end if;
1234:
1235: End AF_ROLLBACK;

Line 1329: req_id := fnd_global.conc_request_id;

1325: if ( lengthb(lmessage) > 240 ) then
1326: fnd_file.put_line( fnd_file.log, lmessage);
1327: end if;
1328:
1329: req_id := fnd_global.conc_request_id;
1330:
1331: ret_str := set_status_autonomous(req_id, scode, lmessage, TRUE);
1332:
1333: -- if ret_str has some string that means some error otherwise return TRUE

Line 1454: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)

1450: Select sysdate + (greatest(Max_Wait, 0)/86400)
1451: into end_of_time
1452: from dual;
1453:
1454: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)
1455: into parent_req_id
1456: from dual;
1457:
1458: if (parent_req_id = -1) then return TRUE; end if;

Line 2434: if ( submitter <> fnd_global.user_id ) then

2430: when no_data_found then
2431: raise request_missing;
2432: end;
2433:
2434: if ( submitter <> fnd_global.user_id ) then
2435: raise no_privilege;
2436: end if;
2437:
2438: ret_val := FND_AMP_PRIVATE.cancel_request(request_id, message);

Line 2646: fnd_global.bless_next_init('FND_PERMIT_0002');

2642: and fcr.request_id = sr.request_id
2643: and sr.machine = lmachine
2644: and sr.client_process_id = lpid;
2645:
2646: fnd_global.bless_next_init('FND_PERMIT_0002');
2647: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,
2648: cloginid, progappid, cprogid, creqid, cprireqid);
2649:
2650: -- now delete the row, to avoid having to purge the table.

Line 2647: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,

2643: and sr.machine = lmachine
2644: and sr.client_process_id = lpid;
2645:
2646: fnd_global.bless_next_init('FND_PERMIT_0002');
2647: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,
2648: cloginid, progappid, cprogid, creqid, cprireqid);
2649:
2650: -- now delete the row, to avoid having to purge the table.
2651: DELETE from fnd_cp_sql_requests where request_id = creqid;

Line 2666: FND_GLOBAL.APPS_INITIALIZE(-1, 20420, 1);

2662: -- Initialize a default context:
2663: -- USER = ANONYMOUS (-1)
2664: -- RESP = System Administrator (20420)
2665: -- RESP APPL = System Administration (1)
2666: FND_GLOBAL.APPS_INITIALIZE(-1, 20420, 1);
2667: end if;
2668:
2669: end;
2670: end loop;

Line 2675: FND_PROFILE.PUT('SECURITY_GROUP_ID', FND_GLOBAL.SECURITY_GROUP_ID);

2671:
2672: -- The rest of the initialization used to be hardcoded into the SQL script by fdpsql().
2673: INIT_REQUEST;
2674:
2675: FND_PROFILE.PUT('SECURITY_GROUP_ID', FND_GLOBAL.SECURITY_GROUP_ID);
2676:
2677: SET_PREFERRED_RBS;
2678:
2679: exception

Line 2821: fnd_global.apps_initialize

2817: --check IF this program is not SRS-enabled and IF true let it pass through
2818: IF (check_user_privileges(p_user_name, 'RUNCONCPROG') > 0 AND (l_srs_flag = 'N' OR l_srs_flag = 'Q')) THEN
2819: l_ret_value := 1;
2820: ELSIF (l_srs_flag = 'Y') THEN
2821: fnd_global.apps_initialize
2822: (user_id => l_user_id,
2823: resp_id => p_resp_id,
2824: resp_appl_id => p_resp_appl_id,
2825: security_group_id => p_sec_group_id);