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.AD_ZD_SEED dependencies on AD_ZD_SEED

Line 1: PACKAGE BODY AD_ZD_SEED AS

1: PACKAGE BODY AD_ZD_SEED AS
2: /* $Header: ADZDSMB.pls 120.73.12020000.17 2013/05/09 12:39:01 rahulshr ship $ */
3:
4: C_PACKAGE CONSTANT VARCHAR2(80) := 'ad.plsql.ad_zd_seed.';
5:

Line 4: C_PACKAGE CONSTANT VARCHAR2(80) := 'ad.plsql.ad_zd_seed.';

1: PACKAGE BODY AD_ZD_SEED AS
2: /* $Header: ADZDSMB.pls 120.73.12020000.17 2013/05/09 12:39:01 rahulshr ship $ */
3:
4: C_PACKAGE CONSTANT VARCHAR2(80) := 'ad.plsql.ad_zd_seed.';
5:
6: /*
7: ** --------------------------------------------------------------------
8: ** Edition Data Storage - Public Helper Functions

Line 141: and name = ad_zd_seed.eds_function(x_table_name)

137: begin
138: select 1 into l_dummy
139: from dba_source
140: where owner = ad_zd.apps_schema
141: and name = ad_zd_seed.eds_function(x_table_name)
142: and type = 'FUNCTION'
143: and instr(text, ad_zd.get_edition('PATCH')) <> 0;
144: l_retval := TRUE;
145: exception when no_data_found then

Line 258: and trigger_name <> ad_zd_seed.eds_trigger(x_tab_name)

254: select owner, trigger_name
255: from dba_triggers
256: where table_owner = x_tab_owner
257: and table_name in (x_tab_name, ad_zd_table.ev_view(x_tab_name))
258: and trigger_name <> ad_zd_seed.eds_trigger(x_tab_name)
259: and crossedition = 'NO';
260:
261: begin
262: for trgrec in c_trig_cur(x_owner, x_table_name) loop

Line 404: L_TRIG_NAME varchar2(30) := ad_zd_seed.eds_trigger(x_table_name);

400: X_SAVE_BODY in out nocopy varchar2)
401: is
402: C_MODULE varchar2(80) := c_package||'create_guard';
403: L_EV_NAME varchar2(30) := ad_zd_table.ev_view(x_table_name);
404: L_TRIG_NAME varchar2(30) := ad_zd_seed.eds_trigger(x_table_name);
405: L_TRIG_BODY varchar2(32000);
406: L_TRIG_STMT varchar2(32000);
407:
408: cursor C_TRIG_CUR (x_tab_owner varchar2, x_tab_name varchar2, x_trig_name varchar2) is

Line 472: L_POLICY_NAME varchar2(30) := ad_zd_seed.eds_policy;

468: X_EDITION_NAME in varchar2)
469: is
470: C_MODULE varchar2(80) := c_package||'create_policy';
471: L_CUR integer;
472: L_POLICY_NAME varchar2(30) := ad_zd_seed.eds_policy;
473: L_EV_NAME varchar2(30) := ad_zd_table.ev_view(x_table_name);
474: L_POLICY_FUNC varchar2(30) := ad_zd_seed.eds_function(x_table_name);
475: L_STMT varchar2(1000);
476: L_TEXT varchar2(4000);

Line 474: L_POLICY_FUNC varchar2(30) := ad_zd_seed.eds_function(x_table_name);

470: C_MODULE varchar2(80) := c_package||'create_policy';
471: L_CUR integer;
472: L_POLICY_NAME varchar2(30) := ad_zd_seed.eds_policy;
473: L_EV_NAME varchar2(30) := ad_zd_table.ev_view(x_table_name);
474: L_POLICY_FUNC varchar2(30) := ad_zd_seed.eds_function(x_table_name);
475: L_STMT varchar2(1000);
476: L_TEXT varchar2(4000);
477:
478: cursor C_POLICY_CUR (x_tab_owner varchar2, x_tab_name varchar2) is

Line 483: and policy_name = ad_zd_seed.eds_policy;

479: select policy_name
480: from dba_policies
481: where object_owner = x_tab_owner
482: and object_name = ad_zd_table.ev_view(x_tab_name)
483: and policy_name = ad_zd_seed.eds_policy;
484:
485: begin
486:
487: -- Install VPD Function

Line 528: L_TRIG_NAME varchar2(30) := ad_zd_seed.eds_fcet(x_table_name);

524: X_TABLE_NAME in varchar2,
525: X_COPY_DATA in boolean)
526: is
527: C_MODULE varchar2(80) := c_package||'create_sync';
528: L_TRIG_NAME varchar2(30) := ad_zd_seed.eds_fcet(x_table_name);
529: L_STMT varchar2(32767);
530: L_SAVE_STMT varchar2(32767); /* save data values */
531: L_OLD_KEY_STMT varchar2(3000); /* get old key values */
532: L_NEW_KEY_STMT varchar2(3000); /* get new key values */

Line 794: 'begin '||ad_zd.apps_schema||'.ad_zd_seed.upgrade('''||x_table_name||'''); end;',

790: select to_number(value) into v_parallel
791: from v$parameter where name='parallel_max_servers';
792:
793: ad_zd_parallel_exec.load('UPGRADE_SEED',
794: 'begin '||ad_zd.apps_schema||'.ad_zd_seed.upgrade('''||x_table_name||'''); end;',
795: true);
796: ad_zd_parallel_exec.load('COLLECT_STATS',
797: 'begin '||ad_zd.apps_schema||'.fnd_stats.gather_table_stats('''||l_table_owner||''','''||x_table_name||''', 100, '||v_parallel||'); end;',
798: true);

Line 858: where trigger_name = ad_zd_seed.eds_trigger(l_table_name)

854: -- Check if guard trigger exists
855: begin
856: select 'Y' into l_exists
857: from user_triggers
858: where trigger_name = ad_zd_seed.eds_trigger(l_table_name)
859: and table_owner = l_table_owner
860: and table_name = ad_zd_table.ev_view(l_table_name);
861:
862: log(c_module, 'WARNING', 'Cannot re-upgrade seed data table: '||x_table_name);

Line 977: ad_zd_seed.cleanup(l_table_name);

973:
974: -- Cleanup data copies
975: if (l_editions_enabled = 'Y') then
976: if ad_zd_table.is_seed(l_table_owner, l_table_name) = 'Y' then
977: ad_zd_seed.cleanup(l_table_name);
978: end if;
979: end if;
980:
981: -- Fix Constraints

Line 1052: l_fcet_name := ad_zd_seed.eds_fcet(x_table_name);

1048: l_stmt := 'drop trigger '|| '"'||ad_zd.apps_schema||'"."'||l_fcet_name||'"';
1049: exec(l_stmt, c_module, true);
1050:
1051: -- Drop EDS Sync Trigger (new style)
1052: l_fcet_name := ad_zd_seed.eds_fcet(x_table_name);
1053: l_stmt := 'drop trigger '|| '"'||ad_zd.apps_schema||'"."'||l_fcet_name||'"';
1054: exec(l_stmt, c_module, true);
1055:
1056: -- Drop EDS Guard Trigger (old style)

Line 1062: l_trig_name := ad_zd_seed.eds_trigger(x_table_name);

1058: l_stmt := 'drop trigger '|| '"'||ad_zd.apps_schema||'"."'||l_trig_name||'"';
1059: exec(l_stmt, c_module, true);
1060:
1061: -- Drop EDS Guard Trigger (new style)
1062: l_trig_name := ad_zd_seed.eds_trigger(x_table_name);
1063: l_stmt := 'drop trigger '|| '"'||ad_zd.apps_schema||'"."'||l_trig_name||'"';
1064: exec(l_stmt, c_module, true);
1065:
1066: -- Mark EDS Striping Column unused

Line 1178: open c_func_cur(ad_zd.apps_schema, ad_zd_seed.eds_function(x_table_name), l_edition);

1174:
1175: -- begin block to release lock on an exception
1176: begin
1177: -- If table is not yet prepared, then prepare it
1178: open c_func_cur(ad_zd.apps_schema, ad_zd_seed.eds_function(x_table_name), l_edition);
1179: fetch c_func_cur INTO l_text;
1180: if (c_func_cur%notfound) then
1181:
1182: log(c_module, 'EVENT', 'Prepare Table: '||l_table_owner||'.'||l_table_name);

Line 1193: exec('drop trigger '||ad_zd.apps_schema||'."'||ad_zd_seed.eds_fcet(l_table_name)||'"', c_module, TRUE);

1189: create_sync(l_table_owner, l_table_name, true);
1190: exception when others then
1191: log(c_module, 'EVENT', 'Prepare Failure, reversing actions');
1192: create_guard(l_table_owner, l_table_name, NULL, l_save_body);
1193: exec('drop trigger '||ad_zd.apps_schema||'."'||ad_zd_seed.eds_fcet(l_table_name)||'"', c_module, TRUE);
1194: alter_triggers(l_table_owner,l_table_name,'ENABLE');
1195: raise;
1196: end;
1197:

Line 1300: and obj.object_name = ad_zd_seed.eds_function(col.table_name)

1296: ( select oracle_username from system.fnd_oracle_userid
1297: where read_only_flag in ('A','E') )
1298: and col.table_name not like '%#'
1299: and col.column_name = 'ZD_EDITION_NAME'
1300: and obj.object_name = ad_zd_seed.eds_function(col.table_name)
1301: and obj.object_type = 'FUNCTION'
1302: and obj.edition_name = sys_context('userenv', 'current_edition_name')
1303: and obj.edition_name <> 'ORA$BASE'
1304: and exists

Line 1377: and obj.object_name = ad_zd_seed.eds_function(col.table_name)

1373: ( select oracle_username from system.fnd_oracle_userid
1374: where read_only_flag in ('A','E') )
1375: and col.table_name not like '%#'
1376: and col.column_name = 'ZD_EDITION_NAME'
1377: and obj.object_name = ad_zd_seed.eds_function(col.table_name)
1378: and obj.object_type = 'FUNCTION'
1379: and obj.edition_name > sys_context('userenv', 'current_edition_name')
1380: and exists
1381: ( select src.text from user_source_ae src

Line 1396: l_stmt := 'begin ad_zd_seed.cleanup('''||trec.table_name||'''); end;';

1392: end if;
1393:
1394: for trec in c_prepared_seed_tables loop
1395: log(c_module, 'STATEMENT', 'Store cleanup action for seed data table: '||trec.table_name);
1396: l_stmt := 'begin ad_zd_seed.cleanup('''||trec.table_name||'''); end;';
1397: ad_zd.load_ddl('CLEANUP', l_stmt);
1398: end loop;
1399:
1400: log(c_module, 'PROCEDURE', 'end');

Line 1404: END AD_ZD_SEED;

1400: log(c_module, 'PROCEDURE', 'end');
1401: end ABORT;
1402:
1403:
1404: END AD_ZD_SEED;