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.IGI_SLS_OBJECTS_PKG dependencies on AD_TSPACE_UTIL

Line 56: ad_tspace_util.is_new_ts_mode(check_ts_mode);

52: l_user := 'IGI';
53: errbuf := 'Normal Completion';
54: retcode := 0;
55:
56: ad_tspace_util.is_new_ts_mode(check_ts_mode);
57: ad_tspace_util.get_tablespace_name('IGI', 'TRANSACTION_TABLES', 'Y', check_tspace_exists, physical_tspace_name);
58:
59: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN
60:

Line 57: ad_tspace_util.get_tablespace_name('IGI', 'TRANSACTION_TABLES', 'Y', check_tspace_exists, physical_tspace_name);

53: errbuf := 'Normal Completion';
54: retcode := 0;
55:
56: ad_tspace_util.is_new_ts_mode(check_ts_mode);
57: ad_tspace_util.get_tablespace_name('IGI', 'TRANSACTION_TABLES', 'Y', check_tspace_exists, physical_tspace_name);
58:
59: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN
60:
61:

Line 122: ad_tspace_util.is_new_ts_mode(check_ts_mode);

118: l_user := 'IGI';
119: errbuf :='Normal Completion';
120: retcode := 0;
121:
122: ad_tspace_util.is_new_ts_mode(check_ts_mode);
123: ad_tspace_util.get_tablespace_name('IGI', 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);
124:
125: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN
126:

Line 123: ad_tspace_util.get_tablespace_name('IGI', 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);

119: errbuf :='Normal Completion';
120: retcode := 0;
121:
122: ad_tspace_util.is_new_ts_mode(check_ts_mode);
123: ad_tspace_util.get_tablespace_name('IGI', 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);
124:
125: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN
126:
127: l_sql_inx:='BEGIN '||l_user||'.apps_ddl.apps_ddl ('||'''CREATE INDEX '||sls_tab||'_N1 ON '||l_user||'.'||sls_tab||' (SLS_SEC_GRP) TABLESPACE '||physical_tspace_name||''''||');END;';

Line 1039: ad_tspace_util.is_new_ts_mode(check_ts_mode);

1035: from fnd_product_installations fpi, fnd_oracle_userid foui
1036: where foui.oracle_id = fpi.oracle_id
1037: and foui.oracle_username = schema_name;
1038:
1039: ad_tspace_util.is_new_ts_mode(check_ts_mode);
1040: l_app_short_name := ad_tspace_util.get_product_short_name(l_app_id);
1041: ad_tspace_util.get_tablespace_name(l_app_short_name, 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);
1042:
1043: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN

Line 1040: l_app_short_name := ad_tspace_util.get_product_short_name(l_app_id);

1036: where foui.oracle_id = fpi.oracle_id
1037: and foui.oracle_username = schema_name;
1038:
1039: ad_tspace_util.is_new_ts_mode(check_ts_mode);
1040: l_app_short_name := ad_tspace_util.get_product_short_name(l_app_id);
1041: ad_tspace_util.get_tablespace_name(l_app_short_name, 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);
1042:
1043: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN
1044:

Line 1041: ad_tspace_util.get_tablespace_name(l_app_short_name, 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);

1037: and foui.oracle_username = schema_name;
1038:
1039: ad_tspace_util.is_new_ts_mode(check_ts_mode);
1040: l_app_short_name := ad_tspace_util.get_product_short_name(l_app_id);
1041: ad_tspace_util.get_tablespace_name(l_app_short_name, 'TRANSACTION_INDEXES', 'Y', check_tspace_exists, physical_tspace_name);
1042:
1043: If (check_ts_mode = 'Y') and (check_tspace_exists = 'Y') THEN
1044:
1045: l_sql_inx:= 'BEGIN '||schema_name||'.apps_ddl.apps_ddl ('||'''CREATE INDEX '||sls_tab||'_GRP_N1 ON '||schema_name||'.'||sec_tab||' (IGI_SLS_SEC_GROUP) TABLESPACE '||physical_tspace_name||''''||');END;';