DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_GLOBAL

Line 778: req_id := fnd_global.conc_request_id;

774: if ( lengthb(message) > 240 ) then
775: fnd_file.put_line( fnd_file.log, message);
776: end if;
777:
778: req_id := fnd_global.conc_request_id;
779:
780: ret_str := set_status_autonomous(req_id, scode, message);
781:
782: -- if ret_str has some string that means some error otherwise return TRUE

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

1047: temp varchar2(100);
1048:
1049: begin
1050:
1051: if (fnd_global.conc_request_id > 0) then
1052:
1053: if ( fnd_adg_support.is_standby )
1054: then
1055: $if fnd_adg_compile_directive.enable_rpc

Line 1067: l_request_id := fnd_global.conc_request_id;

1063: (select distinct sid from v$mystat ) m
1064: Where P.Addr = S.Paddr
1065: and s.sid = m.sid;
1066:
1067: l_request_id := fnd_global.conc_request_id;
1068:
1069: update fnd_concurrent_requests_remote
1070: set ORACLE_SESSION_ID = csid,
1071: ORACLE_PROCESS_ID = csspid,

Line 1093: where request_id = fnd_global.conc_request_id;

1089: set ORACLE_SESSION_ID = csid,
1090: ORACLE_PROCESS_ID = csspid,
1091: OS_PROCESS_ID = cspid,
1092: NLS_CodeSet = codeset
1093: where request_id = fnd_global.conc_request_id;
1094: end if;
1095:
1096: -- DOING COMMIT HERE SO THAT GUI TOOLS GET THE SESSION INFO
1097: -- DURING PROGRAM EXECUTION.

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

1109: from FND_CONCURRENT_PROGRAMS P,
1110: FND_CONCURRENT_REQUESTS R
1111: WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
1112: And P.APPLICATION_ID = R.Program_APPLICATION_ID
1113: And R.request_id = fnd_global.conc_request_id;
1114: exception
1115: when others then
1116: optmode := null;
1117: program_name := null;

Line 1123: fnd_global.tag_db_session('cp', temp);

1119:
1120: select lower(application_short_name) || '/' || upper(program_name) into temp
1121: from fnd_application where application_id = temp;
1122:
1123: fnd_global.tag_db_session('cp', temp);
1124:
1125: mo_global.init('M');
1126: -- initialize Multi-Org Context
1127: if ( morg_cat = 'S' ) then

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

1133: Select plsql_log, plsql_out, plsql_dir
1134: Into plog, pout, pdir
1135: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R
1136: Where P.Concurrent_Process_ID = R.Controlling_Manager
1137: And R.Request_ID = fnd_global.conc_request_id;
1138:
1139: fnd_file.put_names(plog, pout, pdir);
1140: fnd_file_private.put_names(plog, pout, pdir);
1141:

Line 1161: where R.request_id = fnd_global.conc_request_id

1157: into que_rcg
1158: from fnd_concurrent_requests r,
1159: fnd_concurrent_processes p,
1160: fnd_concurrent_queues q
1161: where R.request_id = fnd_global.conc_request_id
1162: and R.controlling_manager = P.concurrent_process_id
1163: and Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID
1164: and Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID;
1165: exception

Line 1175: where R.request_id = fnd_global.conc_request_id

1171: select p.RESOURCE_CONSUMER_GROUP
1172: into prg_rcg
1173: from fnd_concurrent_programs P,
1174: fnd_concurrent_requests R
1175: where R.request_id = fnd_global.conc_request_id
1176: and r.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
1177: and R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID;
1178: exception
1179: when others then

Line 1207: req_id => fnd_global.conc_request_id);

1203: ret_val := fnd_debug.enable_db_rules(comp_type => dbg_comp,
1204: comp_name => program_name,
1205: comp_appl_id => null,
1206: comp_id => null,
1207: req_id => fnd_global.conc_request_id);
1208: end;
1209: end if;
1210: end if;
1211:

Line 1247: WHERE R.request_id = fnd_global.conc_request_id

1243: select P.Rollback_Segment
1244: into RBS
1245: from FND_CONCURRENT_PROGRAMS P,
1246: FND_CONCURRENT_REQUESTS R
1247: WHERE R.request_id = fnd_global.conc_request_id
1248: AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
1249: And R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;
1250:
1251: if RBS is not Null then

Line 1284: g_request_id := fnd_global.conc_request_id;

1280: --
1281: -- Use request id from global context if one exists, else
1282: -- use the one provided by the caller (security hole?)
1283: --
1284: g_request_id := fnd_global.conc_request_id;
1285:
1286: if (g_request_id is null) then
1287: g_request_id := Request_Id;
1288: end if;

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

1313: commit;
1314:
1315: -- if the context is concurrent program then set the rollback segment to
1316: -- program preferred
1317: if (fnd_global.conc_request_id > 0) then
1318: fnd_concurrent.set_preferred_rbs;
1319: end if;
1320:
1321: End AF_COMMIT;

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

1336: rollback;
1337:
1338: -- if the context is concurrent program then set the rollback segment to
1339: -- program preferred
1340: if (fnd_global.conc_request_id > 0) then
1341: fnd_concurrent.set_preferred_rbs;
1342: end if;
1343:
1344: End AF_ROLLBACK;

Line 1438: req_id := fnd_global.conc_request_id;

1434: if ( lengthb(lmessage) > 240 ) then
1435: fnd_file.put_line( fnd_file.log, lmessage);
1436: end if;
1437:
1438: req_id := fnd_global.conc_request_id;
1439:
1440: ret_str := set_status_autonomous(req_id, scode, lmessage, TRUE);
1441:
1442: -- if ret_str has some string that means some error otherwise return TRUE

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

1559: Select sysdate + (greatest(Max_Wait, 0)/86400)
1560: into end_of_time
1561: from dual;
1562:
1563: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)
1564: into parent_req_id
1565: from dual;
1566:
1567: if (parent_req_id = -1) then return TRUE; end if;

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

2539: when no_data_found then
2540: raise request_missing;
2541: end;
2542:
2543: if ( submitter <> fnd_global.user_id ) then
2544: raise no_privilege;
2545: end if;
2546:
2547: ret_val := FND_AMP_PRIVATE.cancel_request(request_id, message);

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

2751: and fcr.request_id = sr.request_id
2752: and sr.machine = lmachine
2753: and sr.client_process_id = lpid;
2754:
2755: fnd_global.bless_next_init('FND_PERMIT_0002');
2756: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,
2757: cloginid, progappid, cprogid, creqid, cprireqid);
2758:
2759: -- now delete the row, to avoid having to purge the table.

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

2752: and sr.machine = lmachine
2753: and sr.client_process_id = lpid;
2754:
2755: fnd_global.bless_next_init('FND_PERMIT_0002');
2756: FND_GLOBAL.INITIALIZE(session_id, userid, respid, respappid, secgrpid, siteid, loginid,
2757: cloginid, progappid, cprogid, creqid, cprireqid);
2758:
2759: -- now delete the row, to avoid having to purge the table.
2760: DELETE from fnd_cp_sql_requests where request_id = creqid;

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

2771: -- Initialize a default context:
2772: -- USER = ANONYMOUS (-1)
2773: -- RESP = System Administrator (20420)
2774: -- RESP APPL = System Administration (1)
2775: FND_GLOBAL.APPS_INITIALIZE(-1, 20420, 1);
2776: end if;
2777:
2778: end;
2779: end loop;

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

2780:
2781: -- The rest of the initialization used to be hardcoded into the SQL script by fdpsql().
2782: INIT_REQUEST;
2783:
2784: FND_PROFILE.PUT('SECURITY_GROUP_ID', FND_GLOBAL.SECURITY_GROUP_ID);
2785:
2786: SET_PREFERRED_RBS;
2787:
2788: exception

Line 2941: fnd_global.apps_initialize

2937: --check IF this program is not SRS-enabled and IF true let it pass through
2938: IF (check_user_privileges(p_user_name, 'RUNCONCPROG') > 0 AND (l_srs_flag = 'N' OR l_srs_flag = 'Q')) THEN
2939: l_ret_value := 1;
2940: ELSIF (l_srs_flag = 'Y') THEN
2941: fnd_global.apps_initialize
2942: (user_id => l_user_id,
2943: resp_id => p_resp_id,
2944: resp_appl_id => p_resp_appl_id,
2945: security_group_id => p_sec_group_id);