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.HZ_MIXNM_WEBUI_UTILITY dependencies on DBMS_SQL

Line 1060: l_data_sources_tab dbms_sql.Varchar2_Table;

1056: str VARCHAR2(255);
1057: l_sql VARCHAR2(1000);
1058: l_data_sources_old VARCHARList;
1059: l_meaning_old VARCHARList;
1060: l_data_sources_tab dbms_sql.Varchar2_Table;
1061: l_meaning_tab dbms_sql.Varchar2_Table;
1062: l_id_tab dbms_sql.Number_Table;
1063:
1064: BEGIN

Line 1061: l_meaning_tab dbms_sql.Varchar2_Table;

1057: l_sql VARCHAR2(1000);
1058: l_data_sources_old VARCHARList;
1059: l_meaning_old VARCHARList;
1060: l_data_sources_tab dbms_sql.Varchar2_Table;
1061: l_meaning_tab dbms_sql.Varchar2_Table;
1062: l_id_tab dbms_sql.Number_Table;
1063:
1064: BEGIN
1065:

Line 1062: l_id_tab dbms_sql.Number_Table;

1058: l_data_sources_old VARCHARList;
1059: l_meaning_old VARCHARList;
1060: l_data_sources_tab dbms_sql.Varchar2_Table;
1061: l_meaning_tab dbms_sql.Varchar2_Table;
1062: l_id_tab dbms_sql.Number_Table;
1063:
1064: BEGIN
1065:
1066: -- find the data sources for all of the attributes in the given group.

Line 1114: c := dbms_sql.open_cursor;

1110: IF j = 15 OR i = p_entity_attr_id_tab.COUNT
1111: THEN
1112: str := SUBSTR(str, 1, LENGTH(str)-1);
1113:
1114: c := dbms_sql.open_cursor;
1115: l_sql := 'SELECT UNIQUE content_source_type, '||
1116: ' hz_utility_v2pub.Get_LookupMeaning( '||
1117: ' ''AR_LOOKUPS'', ''CONTENT_SOURCE_TYPE'', '||
1118: ' content_source_type ) meaning '||

Line 1121: dbms_sql.parse(c, l_sql, dbms_sql.native);

1117: ' ''AR_LOOKUPS'', ''CONTENT_SOURCE_TYPE'', '||
1118: ' content_source_type ) meaning '||
1119: 'FROM hz_select_data_sources '||
1120: 'WHERE entity_attr_id IN ('||str||') ';
1121: dbms_sql.parse(c, l_sql, dbms_sql.native);
1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);
1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);

Line 1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);

1118: ' content_source_type ) meaning '||
1119: 'FROM hz_select_data_sources '||
1120: 'WHERE entity_attr_id IN ('||str||') ';
1121: dbms_sql.parse(c, l_sql, dbms_sql.native);
1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);
1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);

Line 1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);

1119: 'FROM hz_select_data_sources '||
1120: 'WHERE entity_attr_id IN ('||str||') ';
1121: dbms_sql.parse(c, l_sql, dbms_sql.native);
1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);
1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);
1127: dbms_sql.column_value(c, 2, l_meaning_tab);

Line 1124: l_count := dbms_sql.execute(c);

1120: 'WHERE entity_attr_id IN ('||str||') ';
1121: dbms_sql.parse(c, l_sql, dbms_sql.native);
1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);
1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);
1127: dbms_sql.column_value(c, 2, l_meaning_tab);
1128: dbms_sql.close_cursor(c);

Line 1125: l_count := dbms_sql.fetch_rows(c);

1121: dbms_sql.parse(c, l_sql, dbms_sql.native);
1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);
1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);
1127: dbms_sql.column_value(c, 2, l_meaning_tab);
1128: dbms_sql.close_cursor(c);
1129:

Line 1126: dbms_sql.column_value(c, 1, l_data_sources_tab);

1122: dbms_sql.define_array(c, 1, l_data_sources_tab, 30, 1);
1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);
1127: dbms_sql.column_value(c, 2, l_meaning_tab);
1128: dbms_sql.close_cursor(c);
1129:
1130: IF l_data_sources_old.COUNT = 0 THEN

Line 1127: dbms_sql.column_value(c, 2, l_meaning_tab);

1123: dbms_sql.define_array(c, 2, l_meaning_tab, 30, 1);
1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);
1127: dbms_sql.column_value(c, 2, l_meaning_tab);
1128: dbms_sql.close_cursor(c);
1129:
1130: IF l_data_sources_old.COUNT = 0 THEN
1131: FOR i IN 1..l_data_sources_tab.COUNT LOOP

Line 1128: dbms_sql.close_cursor(c);

1124: l_count := dbms_sql.execute(c);
1125: l_count := dbms_sql.fetch_rows(c);
1126: dbms_sql.column_value(c, 1, l_data_sources_tab);
1127: dbms_sql.column_value(c, 2, l_meaning_tab);
1128: dbms_sql.close_cursor(c);
1129:
1130: IF l_data_sources_old.COUNT = 0 THEN
1131: FOR i IN 1..l_data_sources_tab.COUNT LOOP
1132: l_data_sources_old(i) := l_data_sources_tab(i);