eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_ADG_UTILITY dependencies on FND_ADG_CONTROL

Line 16: G_CACHED_CONTROL_REC fnd_adg_control%rowtype;

12: G_MAGIC_SWITCH_ENABLED boolean := false;
13:
14: G_ENABLE_CONTROL_CACHE boolean := false;
15: G_CONTROL_CACHE_LOADED boolean := false;
16: G_CACHED_CONTROL_REC fnd_adg_control%rowtype;
17:
18: /* RPC state */
19:
20: C_RPC_SYSTEM_ENABLED constant number := 1;

Line 112: function is_rpc_state(p_rec fnd_adg_control%rowtype,

108: end;
109:
110: /*==========================================================================*/
111:
112: function is_rpc_state(p_rec fnd_adg_control%rowtype,
113: p_flag number
114: ) return boolean
115: as
116: begin

Line 129: procedure set_rpc_state(p_rec in out nocopy fnd_adg_control%rowtype,

125: end;
126:
127: /*==========================================================================*/
128:
129: procedure set_rpc_state(p_rec in out nocopy fnd_adg_control%rowtype,
130: p_flag number)
131: as
132: begin
133:

Line 143: procedure clr_rpc_state(p_rec in out nocopy fnd_adg_control%rowtype,

139: end;
140:
141: /*==========================================================================*/
142:
143: procedure clr_rpc_state(p_rec in out nocopy fnd_adg_control%rowtype,
144: p_flag number)
145: as
146: begin
147:

Line 207: procedure init_adg_control(p_rec in out nocopy fnd_adg_control%rowtype)

203: end;
204:
205: /*==========================================================================*/
206:
207: procedure init_adg_control(p_rec in out nocopy fnd_adg_control%rowtype)
208: as
209: begin
210:
211: p_rec.control_key := C_CONTROL_KEY;

Line 279: l_rec fnd_adg_control%rowtype;

275:
276: procedure auto_init_adg
277: as
278: PRAGMA AUTONOMOUS_TRANSACTION;
279: l_rec fnd_adg_control%rowtype;
280: begin
281:
282: init_adg_control(l_rec);
283:

Line 286: insert into fnd_adg_control values l_rec;

282: init_adg_control(l_rec);
283:
284: begin
285:
286: insert into fnd_adg_control values l_rec;
287:
288: exception
289: when DUP_VAL_ON_INDEX then
290: commit;

Line 304: function get_adg_control return fnd_adg_control%rowtype

300: end;
301:
302: /*==========================================================================*/
303:
304: function get_adg_control return fnd_adg_control%rowtype
305: as
306: l_adg_control_rec fnd_adg_control%rowtype;
307: begin
308:

Line 306: l_adg_control_rec fnd_adg_control%rowtype;

302: /*==========================================================================*/
303:
304: function get_adg_control return fnd_adg_control%rowtype
305: as
306: l_adg_control_rec fnd_adg_control%rowtype;
307: begin
308:
309: if ( G_ENABLE_CONTROL_CACHE and G_CONTROL_CACHE_LOADED )
310: then

Line 319: from fnd_adg_control a

315: begin
316:
317: select a.*
318: into l_adg_control_rec
319: from fnd_adg_control a
320: where a.control_key = C_CONTROL_KEY;
321:
322: exception
323: when no_data_found then

Line 329: from fnd_adg_control a

325: auto_init_adg;
326:
327: select a.*
328: into l_adg_control_rec
329: from fnd_adg_control a
330: where a.control_key = C_CONTROL_KEY;
331:
332: end;
333:

Line 346: function get_and_lock_adg_control return fnd_adg_control%rowtype

342: end;
343:
344: /*==========================================================================*/
345:
346: function get_and_lock_adg_control return fnd_adg_control%rowtype
347: as
348: l_adg_control_rec fnd_adg_control%rowtype;
349: begin
350:

Line 348: l_adg_control_rec fnd_adg_control%rowtype;

344: /*==========================================================================*/
345:
346: function get_and_lock_adg_control return fnd_adg_control%rowtype
347: as
348: l_adg_control_rec fnd_adg_control%rowtype;
349: begin
350:
351: -- Updates always disable cache
352:

Line 357: from fnd_adg_control a

353: disable_control_cache;
354:
355: select a.*
356: into l_adg_control_rec
357: from fnd_adg_control a
358: where a.control_key = C_CONTROL_KEY
359: for update of a.control_key;
360:
361: return l_adg_control_rec;

Line 396: l_rec fnd_adg_control%rowtype;

392: /*==========================================================================*/
393:
394: procedure check_rpc_state(p_state_on boolean)
395: as
396: l_rec fnd_adg_control%rowtype;
397: l_compile_state boolean;
398:
399: begin
400:

Line 435: l_rec fnd_adg_control%rowtype;

431: /*==========================================================================*/
432:
433: procedure check_adg_state(p_state_on boolean)
434: as
435: l_rec fnd_adg_control%rowtype;
436: begin
437:
438: l_rec := get_adg_control;
439:

Line 469: l_rec fnd_adg_control%rowtype;

465: /*==========================================================================*/
466:
467: procedure set_session_simulated_stdby
468: as
469: l_rec fnd_adg_control%rowtype;
470:
471: cursor c1 is select a.service_name
472: from v$session a
473: where a.sid = ( select distinct b.sid from v$mystat b);

Line 511: l_rec fnd_adg_control%rowtype;

507: /*==========================================================================*/
508:
509: procedure set_commit_wait_enabled
510: as
511: l_rec fnd_adg_control%rowtype;
512: begin
513:
514: G_SESS_COMMIT_WAIT_ENABLED := false;
515:

Line 577: procedure set_adg_control(p_rec in out nocopy fnd_adg_control%rowtype)

573: end;
574:
575: /*==========================================================================*/
576:
577: procedure set_adg_control(p_rec in out nocopy fnd_adg_control%rowtype)
578: as
579: begin
580:
581: p_rec.enable_adg_support := 'N';

Line 643: l_rec fnd_adg_control%rowtype;

639:
640: procedure create_adg_control(p_commit boolean default true,
641: p_ignore_row_exists boolean default false)
642: as
643: l_rec fnd_adg_control%rowtype;
644: begin
645:
646: init_adg_control(l_rec);
647:

Line 648: insert into fnd_adg_control values l_rec;

644: begin
645:
646: init_adg_control(l_rec);
647:
648: insert into fnd_adg_control values l_rec;
649:
650: if ( p_commit )
651: then
652: commit;

Line 669: procedure update_adg_control(p_adg_control_rec fnd_adg_control%rowtype,

665: end;
666:
667: /*==========================================================================*/
668:
669: procedure update_adg_control(p_adg_control_rec fnd_adg_control%rowtype,
670: p_commit boolean default true)
671: as
672: begin
673:

Line 674: update fnd_adg_control a

670: p_commit boolean default true)
671: as
672: begin
673:
674: update fnd_adg_control a
675: set row = p_adg_control_rec
676: where a.control_key = C_CONTROL_KEY;
677:
678: if ( p_commit )

Line 691: l_rec fnd_adg_control%rowtype;

687: procedure clean_adg_control(p_commit boolean default true,
688: p_clean_all boolean default false,
689: p_create_on_demand boolean default false)
690: as
691: l_rec fnd_adg_control%rowtype;
692: begin
693:
694: -- Dummy get_adg_control. This ensure that on a fresh system
695: -- we auto_init the required data.

Line 724: function find_primary_to_standby(p_rec fnd_adg_control%rowtype,

720: end;
721:
722: /*==========================================================================*/
723:
724: function find_primary_to_standby(p_rec fnd_adg_control%rowtype,
725: p_standby_number number,
726: p_connstr varchar2) return boolean
727: as
728: begin

Line 770: procedure set_cm_class_data(p_rec in out nocopy fnd_adg_control%rowtype,

766: end;
767:
768: /*==========================================================================*/
769:
770: procedure set_cm_class_data(p_rec in out nocopy fnd_adg_control%rowtype,
771: p_standby_number number,
772: p_req_class_app_id number,
773: p_req_class_id number )
774: as

Line 801: procedure get_cm_class_data(p_rec in fnd_adg_control%rowtype,

797: end;
798:
799: /*==========================================================================*/
800:
801: procedure get_cm_class_data(p_rec in fnd_adg_control%rowtype,
802: p_standby_number number,
803: p_req_class_app_id in out nocopy number,
804: p_req_class_id in out nocopy number )
805: as

Line 833: p_rec in fnd_adg_control%rowtype,

829:
830: /*==========================================================================*/
831:
832: procedure get_connection_data(p_type number,
833: p_rec in fnd_adg_control%rowtype,
834: p_standby_number number,
835: p_link_name in out nocopy varchar2,
836: p_link_owner in out nocopy varchar2,
837: p_link_connstr in out nocopy varchar2,

Line 903: p_rec in out nocopy fnd_adg_control%rowtype,

899:
900: /*==========================================================================*/
901:
902: procedure set_connection_valid(p_type number,
903: p_rec in out nocopy fnd_adg_control%rowtype,
904: p_status boolean,
905: p_standby_number number)
906: as
907: begin

Line 976: p_rec fnd_adg_control%rowtype,

972:
973: /*==========================================================================*/
974:
975: procedure match_connection_data(p_type number,
976: p_rec fnd_adg_control%rowtype,
977: p_standby_number number,
978: p_link_name varchar2,
979: p_link_owner varchar2,
980: p_link_connstr varchar2,

Line 1051: p_rec fnd_adg_control%rowtype,

1047:
1048: /*==========================================================================*/
1049:
1050: procedure check_connection_data(p_type number,
1051: p_rec fnd_adg_control%rowtype,
1052: p_standby_number number,
1053: p_link_name varchar2,
1054: p_link_owner varchar2,
1055: p_link_connstr varchar2)

Line 1099: p_rec in out nocopy fnd_adg_control%rowtype,

1095:
1096: /*==========================================================================*/
1097:
1098: procedure set_connection_data(p_type number,
1099: p_rec in out nocopy fnd_adg_control%rowtype,
1100: p_standby_number number,
1101: p_link_name varchar2,
1102: p_link_owner varchar2,
1103: p_link_connstr varchar2)

Line 1338: l_rec fnd_adg_control%rowtype;

1334: procedure do_process_adg_violations(p_logoff boolean,
1335: p_application_id number default null,
1336: p_concurrent_program_id number default null)
1337: as
1338: l_rec fnd_adg_control%rowtype;
1339:
1340: l_adg_violations number := 0;
1341: l_trace_fno utl_file.file_type;
1342: l_trace_rec varchar2(32767);

Line 1557: l_rec fnd_adg_control%rowtype;

1553: /*==========================================================================*/
1554:
1555: procedure clone_clean(p_commit boolean default true)
1556: as
1557: l_rec fnd_adg_control%rowtype;
1558: begin
1559:
1560: -- Dummy get_adg_control. This ensure that on a fresh system
1561: -- we auto_init the required data.

Line 1583: l_rec fnd_adg_control%rowtype;

1579: /*==========================================================================*/
1580:
1581: procedure clean_all(p_commit boolean default true)
1582: as
1583: l_rec fnd_adg_control%rowtype;
1584: begin
1585:
1586: -- Dummy get_adg_control. This ensure that on a fresh system
1587: -- we auto_init the required data.

Line 1612: l_rec fnd_adg_control%rowtype;

1608: /*==========================================================================*/
1609:
1610: function get_standby_to_primary_dblink return varchar2
1611: as
1612: l_rec fnd_adg_control%rowtype;
1613: begin
1614:
1615: check_standby_support;
1616:

Line 1630: l_rec fnd_adg_control%rowtype;

1626: p_check_valid boolean default false,
1627: p_check_available boolean default false)
1628: return boolean
1629: as
1630: l_rec fnd_adg_control%rowtype;
1631:
1632: l_standby_number number := 0;
1633: l_found_connection boolean := false;
1634:

Line 1736: l_rec fnd_adg_control%rowtype;

1732: p_req_class_app_id out nocopy number,
1733: p_req_class_id out nocopy number
1734: )
1735: as
1736: l_rec fnd_adg_control%rowtype;
1737: l_link_name varchar2(128);
1738: l_link_owner varchar2(30);
1739: l_link_valid varchar2(10);
1740: l_connstr varchar2(255);

Line 1805: l_rec fnd_adg_control%rowtype;

1801: from all_db_links a
1802: where a.owner = upper(p_link_owner)
1803: and a.DB_LINK = upper(p_link_name);
1804:
1805: l_rec fnd_adg_control%rowtype;
1806:
1807: found_db_link boolean := false;
1808: l_connstr1 varchar2(2000);
1809:

Line 1912: l_rec fnd_adg_control%rowtype;

1908:
1909: procedure clear_connection(p_type number,
1910: p_standby_number number default null)
1911: as
1912: l_rec fnd_adg_control%rowtype;
1913:
1914: found_db_link boolean := false;
1915: l_connstr1 varchar2(2000);
1916:

Line 1961: l_rec fnd_adg_control%rowtype;

1957:
1958: procedure validate_connection(p_type number,
1959: p_standby_number number default null)
1960: as
1961: l_rec fnd_adg_control%rowtype;
1962: l_link_name varchar2(128);
1963: l_link_owner varchar2(30);
1964: l_link_valid varchar2(10);
1965: l_connstr varchar2(255);

Line 2022: l_rec fnd_adg_control%rowtype;

2018: p_connstr out nocopy varchar2,
2019: p_standby_number number default null
2020: )
2021: as
2022: l_rec fnd_adg_control%rowtype;
2023: l_link_name varchar2(128);
2024: l_link_owner varchar2(30);
2025: l_link_valid varchar2(10);
2026: l_connstr varchar2(255);

Line 2061: l_rec fnd_adg_control%rowtype;

2057: procedure get_standby_cm_class (p_standby_number number,
2058: p_req_class_app_id out nocopy number,
2059: p_req_class_id out nocopy number )
2060: as
2061: l_rec fnd_adg_control%rowtype;
2062: begin
2063:
2064: check_standby_number(p_standby_number);
2065:

Line 2081: l_rec fnd_adg_control%rowtype;

2077: procedure register_standby_cm_class (p_standby_number number,
2078: p_req_class_app_id number,
2079: p_req_class_id number )
2080: as
2081: l_rec fnd_adg_control%rowtype;
2082: begin
2083:
2084: check_standby_support;
2085:

Line 2120: l_rec fnd_adg_control%rowtype;

2116: p_trace_directory_obj
2117: varchar2 default null)
2118:
2119: as
2120: l_rec fnd_adg_control%rowtype;
2121: l_dir_obj_ok number;
2122: begin
2123:
2124: check_standby_support;

Line 2185: l_rec fnd_adg_control%rowtype;

2181: /*==========================================================================*/
2182:
2183: procedure validate_adg_support(p_no_standby_systems number default null)
2184: as
2185: l_rec fnd_adg_control%rowtype;
2186: l_no_standby_systems number;
2187: begin
2188:
2189: check_standby_support;

Line 2221: l_rec fnd_adg_control%rowtype;

2217: /*==========================================================================*/
2218:
2219: procedure enable_adg_support
2220: as
2221: l_rec fnd_adg_control%rowtype;
2222: begin
2223:
2224: check_standby_support;
2225:

Line 2247: l_rec fnd_adg_control%rowtype;

2243: /*==========================================================================*/
2244:
2245: procedure disable_adg_support
2246: as
2247: l_rec fnd_adg_control%rowtype;
2248: begin
2249:
2250: check_standby_support;
2251:

Line 2284: l_rec fnd_adg_control%rowtype;

2280: p_debug_rpc number default null,
2281: p_debug_slave_rpc number default null
2282: )
2283: as
2284: l_rec fnd_adg_control%rowtype;
2285: begin
2286:
2287: check_standby_support;
2288:

Line 2366: l_rec fnd_adg_control%rowtype;

2362: /*==========================================================================*/
2363:
2364: procedure prepare_for_rpc_system
2365: as
2366: l_rec fnd_adg_control%rowtype;
2367: begin
2368:
2369: check_standby_support;
2370:

Line 2406: l_rec fnd_adg_control%rowtype;

2402: /*==========================================================================*/
2403:
2404: procedure switch_rpc_system_on
2405: as
2406: l_rec fnd_adg_control%rowtype;
2407: begin
2408:
2409: check_standby_support;
2410:

Line 2455: l_rec fnd_adg_control%rowtype;

2451: /*==========================================================================*/
2452:
2453: procedure switch_rpc_system_off
2454: as
2455: l_rec fnd_adg_control%rowtype;
2456: begin
2457:
2458: check_standby_support;
2459:

Line 2477: l_rec fnd_adg_control%rowtype;

2473: /*==========================================================================*/
2474:
2475: procedure resync_compile_directive
2476: as
2477: l_rec fnd_adg_control%rowtype;
2478: l_compile_state boolean;
2479: l_rpc_state boolean;
2480: begin
2481:

Line 2507: l_rec fnd_adg_control%rowtype;

2503: /*==========================================================================*/
2504:
2505: procedure compile_rpc_dependents
2506: as
2507: l_rec fnd_adg_control%rowtype;
2508: begin
2509:
2510: check_standby_support;
2511:

Line 2560: l_rec fnd_adg_control%rowtype;

2556: /*==========================================================================*/
2557:
2558: function is_adg_support_enabled return boolean
2559: as
2560: l_rec fnd_adg_control%rowtype;
2561: begin
2562:
2563: l_rec := get_adg_control;
2564:

Line 2627: l_rec fnd_adg_control%rowtype;

2623: /*==========================================================================*/
2624:
2625: function is_runtime_validate_timestamp return boolean
2626: as
2627: l_rec fnd_adg_control%rowtype;
2628: begin
2629:
2630: l_rec := get_adg_control;
2631:

Line 2645: l_rec fnd_adg_control%rowtype;

2641: /*==========================================================================*/
2642:
2643: function is_always_collect_primary_data return boolean
2644: as
2645: l_rec fnd_adg_control%rowtype;
2646: begin
2647:
2648: l_rec := get_adg_control;
2649:

Line 2663: l_rec fnd_adg_control%rowtype;

2659: /*==========================================================================*/
2660:
2661: function is_enable_redirect_if_valid return boolean
2662: as
2663: l_rec fnd_adg_control%rowtype;
2664: begin
2665:
2666: l_rec := get_adg_control;
2667:

Line 2681: l_rec fnd_adg_control%rowtype;

2677: /*==========================================================================*/
2678:
2679: function is_standby_error_checking return boolean
2680: as
2681: l_rec fnd_adg_control%rowtype;
2682: begin
2683:
2684: l_rec := get_adg_control;
2685:

Line 2699: l_rec fnd_adg_control%rowtype;

2695: /*==========================================================================*/
2696:
2697: function is_automatic_redirection return boolean
2698: as
2699: l_rec fnd_adg_control%rowtype;
2700: begin
2701:
2702: l_rec := get_adg_control;
2703:

Line 2717: l_rec fnd_adg_control%rowtype;

2713: /*==========================================================================*/
2714:
2715: function get_standby_error_threshold return number
2716: as
2717: l_rec fnd_adg_control%rowtype;
2718: begin
2719:
2720: l_rec := get_adg_control;
2721:

Line 2730: l_rec fnd_adg_control%rowtype;

2726: /*==========================================================================*/
2727:
2728: function get_simulation_error_threshold return number
2729: as
2730: l_rec fnd_adg_control%rowtype;
2731: begin
2732:
2733: l_rec := get_adg_control;
2734:

Line 2743: l_rec fnd_adg_control%rowtype;

2739: /*==========================================================================*/
2740:
2741: function is_simulated_standby_enabled return boolean
2742: as
2743: l_rec fnd_adg_control%rowtype;
2744: begin
2745:
2746: l_rec := get_adg_control;
2747:

Line 2773: l_rec fnd_adg_control%rowtype;

2769: /*==========================================================================*/
2770:
2771: function is_auto_simulation_enabled return boolean
2772: as
2773: l_rec fnd_adg_control%rowtype;
2774: begin
2775:
2776: l_rec := get_adg_control;
2777:

Line 2846: l_rec fnd_adg_control%rowtype;

2842:
2843: procedure get_rpc_debug(p_debug_rpc out nocopy number,
2844: p_debug_slave_rpc out nocopy number)
2845: as
2846: l_rec fnd_adg_control%rowtype;
2847: begin
2848:
2849: l_rec := get_adg_control;
2850:

Line 2860: l_rec fnd_adg_control%rowtype;

2856: /*==========================================================================*/
2857:
2858: function get_max_commit_wait_time return number
2859: as
2860: l_rec fnd_adg_control%rowtype;
2861: begin
2862:
2863: l_rec := get_adg_control;
2864: