APPS.FND_CTL dependencies on FND_GLOBAL

Line 35: if ((fnd_global.conc_request_id <= 0) and

31: if trace_opt is not null then
32: sql_stmt := 'ALTER SESSION SET SQL_TRACE = '|| trace_opt ;
33: EXECUTE IMMEDIATE sql_stmt ;
34: end if;
35: if ((fnd_global.conc_request_id <= 0) and
36: (oltp_opt_mode is not null)) then
37: sql_stmt := 'ALTER SESSION SET OPTIMIZER_MODE = '|| oltp_opt_mode ;
38: EXECUTE IMMEDIATE sql_stmt ;
39: end if;

Line 40: if ((fnd_global.conc_request_id > 0) and

36: (oltp_opt_mode is not null)) then
37: sql_stmt := 'ALTER SESSION SET OPTIMIZER_MODE = '|| oltp_opt_mode ;
38: EXECUTE IMMEDIATE sql_stmt ;
39: end if;
40: if ((fnd_global.conc_request_id > 0) and
41: (conc_opt_mode is not null)) then
42: sql_stmt := 'ALTER SESSION SET OPTIMIZER_MODE = '|| conc_opt_mode ;
43: EXECUTE IMMEDIATE sql_stmt ;
44: end if;

Line 54: user_name := substr(replace(fnd_global.user_name,'''',' '),1,30);

50: EXECUTE IMMEDIATE event_stmt ;
51: end if;
52: --get all the env stuff here (if trace_opt is true )
53: if ( upper(trace_opt) = 'TRUE' or upper(logmode) = 'LOG' ) then
54: user_name := substr(replace(fnd_global.user_name,'''',' '),1,30);
55: conc_program_id := fnd_global.conc_program_id;
56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);
57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);
58: conc_request_id := fnd_global.conc_request_id;

Line 55: conc_program_id := fnd_global.conc_program_id;

51: end if;
52: --get all the env stuff here (if trace_opt is true )
53: if ( upper(trace_opt) = 'TRUE' or upper(logmode) = 'LOG' ) then
54: user_name := substr(replace(fnd_global.user_name,'''',' '),1,30);
55: conc_program_id := fnd_global.conc_program_id;
56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);
57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);
58: conc_request_id := fnd_global.conc_request_id;
59: if fnd_global.conc_request_id > 0 then

Line 56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);

52: --get all the env stuff here (if trace_opt is true )
53: if ( upper(trace_opt) = 'TRUE' or upper(logmode) = 'LOG' ) then
54: user_name := substr(replace(fnd_global.user_name,'''',' '),1,30);
55: conc_program_id := fnd_global.conc_program_id;
56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);
57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);
58: conc_request_id := fnd_global.conc_request_id;
59: if fnd_global.conc_request_id > 0 then
60: BEGIN

Line 57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);

53: if ( upper(trace_opt) = 'TRUE' or upper(logmode) = 'LOG' ) then
54: user_name := substr(replace(fnd_global.user_name,'''',' '),1,30);
55: conc_program_id := fnd_global.conc_program_id;
56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);
57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);
58: conc_request_id := fnd_global.conc_request_id;
59: if fnd_global.conc_request_id > 0 then
60: BEGIN
61: SELECT substr(replace(user_concurrent_program_name,'''',' '),1,240),

Line 58: conc_request_id := fnd_global.conc_request_id;

54: user_name := substr(replace(fnd_global.user_name,'''',' '),1,30);
55: conc_program_id := fnd_global.conc_program_id;
56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);
57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);
58: conc_request_id := fnd_global.conc_request_id;
59: if fnd_global.conc_request_id > 0 then
60: BEGIN
61: SELECT substr(replace(user_concurrent_program_name,'''',' '),1,240),
62: substr(concurrent_program_name,1,30)

Line 59: if fnd_global.conc_request_id > 0 then

55: conc_program_id := fnd_global.conc_program_id;
56: resp_name := substr(replace(fnd_global.resp_name,'''',' '),1,100);
57: application_short_name := substr(replace(fnd_global.application_short_name,'''',' '),1,50);
58: conc_request_id := fnd_global.conc_request_id;
59: if fnd_global.conc_request_id > 0 then
60: BEGIN
61: SELECT substr(replace(user_concurrent_program_name,'''',' '),1,240),
62: substr(concurrent_program_name,1,30)
63: INTO user_conc_program_name, conc_program_name

Line 66: AND APPLICATION_ID = fnd_global.prog_appl_id;

62: substr(concurrent_program_name,1,30)
63: INTO user_conc_program_name, conc_program_name
64: FROM FND_CONCURRENT_PROGRAMS_VL
65: WHERE concurrent_program_id = conc_program_id
66: AND APPLICATION_ID = fnd_global.prog_appl_id;
67: EXCEPTION
68: WHEN OTHERS THEN
69: NULL;
70: END;