APPS.RG_XBRL_PKG dependencies on RG_XBRL_TAXONOMIES

Line 52: FROM RG_XBRL_TAXONOMIES

48: BEGIN
49: BEGIN
50: SELECT taxonomy_id
51: INTO p_taxonomy_id
52: FROM RG_XBRL_TAXONOMIES
53: WHERE taxonomy_name = p_full_tax_name AND
54: ROWNUM = 1;
55: EXCEPTION
56: WHEN NO_DATA_FOUND

Line 118: FROM rg_xbrl_taxonomies v1

114: INTO l_parent_flag
115: FROM DUAL
116: WHERE EXISTS
117: (SELECT v1.taxonomy_id
118: FROM rg_xbrl_taxonomies v1
119: WHERE v1.taxonomy_id <> p_taxonomy_id AND
120: p_taxonomy_id IN
121: (SELECT DISTINCT v2.source_taxonomy_id
122: FROM rg_xbrl_map_v v2

Line 162: DELETE FROM RG_XBRL_TAXONOMIES

158: DELETE FROM RG_XBRL_ELEMENTS
159: WHERE taxonomy_id = p_taxonomy_id;
160: COMMIT;
161: --
162: DELETE FROM RG_XBRL_TAXONOMIES
163: WHERE taxonomy_id = p_taxonomy_id;
164: COMMIT;
165: --
166: END delete_taxonomy;

Line 237: FROM RG_XBRL_TAXONOMIES

233: --
234: BEGIN
235: SELECT taxonomy_id
236: INTO l_taxonomy_id
237: FROM RG_XBRL_TAXONOMIES
238: WHERE taxonomy_url = l_url;
239: EXCEPTION
240: WHEN NO_DATA_FOUND
241: THEN

Line 275: -- add one new row in Taxonomy Storage RG_XBRL_TAXONOMIES

271: SELECT RG_XBRL_TAXONOMY_S.NEXTVAL
272: INTO p_taxonomy_id
273: FROM dual;
274: --
275: -- add one new row in Taxonomy Storage RG_XBRL_TAXONOMIES
276: --
277: INSERT INTO RG_XBRL_TAXONOMIES
278: (TAXONOMY_ID,TAXONOMY_ALIAS,TAXONOMY_NAME,TAXONOMY_URL,TAXONOMY_DESCR,
279: TAXONOMY_IMPORT_FLAG,

Line 277: INSERT INTO RG_XBRL_TAXONOMIES

273: FROM dual;
274: --
275: -- add one new row in Taxonomy Storage RG_XBRL_TAXONOMIES
276: --
277: INSERT INTO RG_XBRL_TAXONOMIES
278: (TAXONOMY_ID,TAXONOMY_ALIAS,TAXONOMY_NAME,TAXONOMY_URL,TAXONOMY_DESCR,
279: TAXONOMY_IMPORT_FLAG,
280: CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,LAST_UPDATE_DATE)
281: VALUES (p_taxonomy_id, l_tax_file_name, p_full_tax_name,l_url,p_tax_descr,'N',

Line 437: FROM RG_XBRL_TAXONOMIES

433: --
434: BEGIN
435: SELECT taxonomy_id
436: INTO l_tax_id
437: FROM RG_XBRL_TAXONOMIES
438: WHERE taxonomy_url = l_namesp_str;
439: EXCEPTION
440: WHEN NO_DATA_FOUND
441: THEN

Line 851: FROM RG_XBRL_TAXONOMIES

847: l_cur_url := SUBSTR(l_valid_str,1,l_delim_pos-1);
848: l_source_tax_id := 0;
849: SELECT taxonomy_id
850: INTO l_source_tax_id
851: FROM RG_XBRL_TAXONOMIES
852: WHERE taxonomy_url = l_cur_url;
853: --
854: IF l_source_tax_id = 0
855: THEN

Line 886: UPDATE RG_XBRL_TAXONOMIES

882: FROM RG_XBRL_MAP_ELEMENTS map
883: WHERE map.taxonomy_id = p_taxonomy_id)
884: );
885: --COMMIT;
886: UPDATE RG_XBRL_TAXONOMIES
887: SET TAXONOMY_IMPORT_FLAG = 'Y'
888: WHERE taxonomy_id = p_taxonomy_id;
889: --COMMIT;
890: END IF;