APPS.RG_XBRL_PKG dependencies on RG_XBRL_MAP_ELEMENTS

Line 154: DELETE FROM RG_XBRL_MAP_ELEMENTS

150: RAISE Remove_tax_err;
151: RETURN;
152: END IF;
153: --
154: DELETE FROM RG_XBRL_MAP_ELEMENTS
155: WHERE taxonomy_id = p_taxonomy_id;
156: COMMIT;
157: --
158: DELETE FROM RG_XBRL_ELEMENTS

Line 813: INSERT INTO RG_XBRL_MAP_ELEMENTS

809: 'N', 'N', 0,
810: l_user_id,l_user_id,l_login_id,
811: l_date,l_date);
812: --
813: INSERT INTO RG_XBRL_MAP_ELEMENTS
814: (taxonomy_id,element_id,
815: enabled_flag,
816: CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
817: CREATION_DATE,LAST_UPDATE_DATE)

Line 832: -- into RG_XBRL_MAP_ELEMENTS using p_valid_str

828: dbms_lob.freetemporary(p_clob);
829: -- COMMIT;
830: --
831: -- add elements from imported taxonomies for the taxonomy_id
832: -- into RG_XBRL_MAP_ELEMENTS using p_valid_str
833: --
834: l_valid_str := SUBSTR(p_valid_str,1,LENGTH(p_valid_str));
835: IF LENGTH(l_valid_str) > 0
836: THEN

Line 869: INSERT INTO RG_XBRL_MAP_ELEMENTS

865: ' was not loaded');
866: RAISE Insert_tax_err;
867: EXIT;
868: ELSE
869: INSERT INTO RG_XBRL_MAP_ELEMENTS
870: (taxonomy_id,element_id,
871: enabled_flag,
872: CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,
873: CREATION_DATE,LAST_UPDATE_DATE)

Line 878: FROM RG_XBRL_MAP_ELEMENTS mel

874: ( SELECT p_taxonomy_id,
875: mel.element_id,mel.enabled_flag,
876: mel.CREATED_BY,mel.LAST_UPDATED_BY,mel.LAST_UPDATE_LOGIN,
877: mel.CREATION_DATE,mel.LAST_UPDATE_DATE
878: FROM RG_XBRL_MAP_ELEMENTS mel
879: WHERE mel.taxonomy_id = l_source_tax_id AND
880: mel.element_id NOT IN
881: (SELECT map.element_id
882: FROM RG_XBRL_MAP_ELEMENTS map

Line 882: FROM RG_XBRL_MAP_ELEMENTS map

878: FROM RG_XBRL_MAP_ELEMENTS mel
879: WHERE mel.taxonomy_id = l_source_tax_id AND
880: mel.element_id NOT IN
881: (SELECT map.element_id
882: FROM RG_XBRL_MAP_ELEMENTS map
883: WHERE map.taxonomy_id = p_taxonomy_id)
884: );
885: --COMMIT;
886: UPDATE RG_XBRL_TAXONOMIES