APPS.HZ_MIXNM_WEBUI_UTILITY dependencies on HZ_SELECT_DATA_SOURCES

Line 982: UPDATE hz_select_data_sources

978:
979: -- set data sources and ranking.
980:
981: FOR k IN l_start..l_end LOOP
982: UPDATE hz_select_data_sources
983: SET ranking = p_ranking_tab(k),
984: last_update_login = hz_utility_v2pub.last_update_login,
985: last_update_date = SYSDATE,
986: last_updated_by = hz_utility_v2pub.last_updated_by

Line 1047: FROM hz_select_data_sources s, hz_orig_systems_vl o

1043: p_entity_attr_id NUMBER
1044: ) IS
1045: SELECT s.content_source_type, s.ranking,
1046: o.orig_system_name meaning
1047: FROM hz_select_data_sources s, hz_orig_systems_vl o
1048: WHERE s.entity_attr_id = p_entity_attr_id
1049: and o.orig_system = s.content_source_type
1050: ORDER BY ranking;
1051:

Line 1080: ' FROM hz_select_data_sources '||

1076:
1077: l_sql := 'SELECT ''Y'' '||
1078: 'FROM ( '||
1079: ' SELECT COUNT(*) total '||
1080: ' FROM hz_select_data_sources '||
1081: ' WHERE entity_attr_id IN ('||str||') '||
1082: ' GROUP BY content_source_type';
1083: --IF p_entity_type = 'profile' THEN
1084: l_sql := l_sql||', ranking';

Line 1119: 'FROM hz_select_data_sources '||

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 '||
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);

Line 1215: UPDATE hz_select_data_sources

1211:
1212: -- set the data source for all of the attributes in the given group.
1213:
1214: FORALL j IN 1..p_data_sources_tab.COUNT
1215: UPDATE hz_select_data_sources
1216: SET ranking = p_ranking_tab(j),
1217: last_update_login = hz_utility_v2pub.last_update_login,
1218: last_update_date = SYSDATE,
1219: last_updated_by = hz_utility_v2pub.last_updated_by