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.RG_XBRL_PKG dependencies on RG_XBRL_ELEMENTS

Line 158: DELETE FROM RG_XBRL_ELEMENTS

154: DELETE FROM RG_XBRL_MAP_ELEMENTS
155: WHERE taxonomy_id = p_taxonomy_id;
156: COMMIT;
157: --
158: DELETE FROM RG_XBRL_ELEMENTS
159: WHERE taxonomy_id = p_taxonomy_id;
160: COMMIT;
161: --
162: DELETE FROM RG_XBRL_TAXONOMIES

Line 285: -- add multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS

281: VALUES (p_taxonomy_id, l_tax_file_name, p_full_tax_name,l_url,p_tax_descr,'N',
282: l_user_id,l_user_id,l_login_id,l_date,l_date);
283: -- COMMIT;
284: --
285: -- add multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS
286: --
287: insert_tax_clob(p_taxonomy_id, l_file_name, l_valid_import_str);
288: COMMIT;
289: --

Line 290: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS

286: --
287: insert_tax_clob(p_taxonomy_id, l_file_name, l_valid_import_str);
288: COMMIT;
289: --
290: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS
291: --
292: update_lbl_clob(l_tax_file_name, p_taxonomy_id,l_file_name_l);
293: --
294: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS

Line 294: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS

290: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS
291: --
292: update_lbl_clob(l_tax_file_name, p_taxonomy_id,l_file_name_l);
293: --
294: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS
295: --
296: update_dfn_clob(l_tax_file_name, p_taxonomy_id, l_file_name_d);
297: --
298: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS

Line 298: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS

294: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS
295: --
296: update_dfn_clob(l_tax_file_name, p_taxonomy_id, l_file_name_d);
297: --
298: -- update multiple rows in Taxonomy Elements Storage RG_XBRL_ELEMENTS
299: --
300: update_flags(p_taxonomy_id);
301: --
302: --

Line 312: UPDATE RG_XBRL_ELEMENTS t2

308: IS
309: l_taxonomy_id NUMBER := 0;
310: BEGIN
311: --
312: UPDATE RG_XBRL_ELEMENTS t2
313: SET t2.parent_id =
314: (SELECT t1.element_id
315: FROM RG_XBRL_ELEMENTS t1
316: WHERE t1.element_identifier = t2.parent_identifier AND

Line 315: FROM RG_XBRL_ELEMENTS t1

311: --
312: UPDATE RG_XBRL_ELEMENTS t2
313: SET t2.parent_id =
314: (SELECT t1.element_id
315: FROM RG_XBRL_ELEMENTS t1
316: WHERE t1.element_identifier = t2.parent_identifier AND
317: t1.taxonomy_id = p_taxonomy_id)
318: WHERE t2.taxonomy_id = p_taxonomy_id;
319: COMMIT;

Line 321: UPDATE RG_XBRL_ELEMENTS

317: t1.taxonomy_id = p_taxonomy_id)
318: WHERE t2.taxonomy_id = p_taxonomy_id;
319: COMMIT;
320: --
321: UPDATE RG_XBRL_ELEMENTS
322: SET has_parent_flag = 'Y'
323: WHERE taxonomy_id = p_taxonomy_id AND
324: parent_identifier IS NOT NULL;
325: COMMIT;

Line 327: UPDATE RG_XBRL_ELEMENTS t2

323: WHERE taxonomy_id = p_taxonomy_id AND
324: parent_identifier IS NOT NULL;
325: COMMIT;
326: --
327: UPDATE RG_XBRL_ELEMENTS t2
328: SET t2.has_child_flag = 'Y'
329: WHERE t2.taxonomy_id = p_taxonomy_id AND
330: t2.element_identifier IN
331: (SELECT t1.parent_identifier

Line 332: FROM RG_XBRL_ELEMENTS t1

328: SET t2.has_child_flag = 'Y'
329: WHERE t2.taxonomy_id = p_taxonomy_id AND
330: t2.element_identifier IN
331: (SELECT t1.parent_identifier
332: FROM RG_XBRL_ELEMENTS t1
333: WHERE t1.taxonomy_id = p_taxonomy_id);
334: COMMIT;
335: --
336: UPDATE RG_XBRL_ELEMENTS

Line 336: UPDATE RG_XBRL_ELEMENTS

332: FROM RG_XBRL_ELEMENTS t1
333: WHERE t1.taxonomy_id = p_taxonomy_id);
334: COMMIT;
335: --
336: UPDATE RG_XBRL_ELEMENTS
337: SET hierarchy_level = 3
338: WHERE taxonomy_id = p_taxonomy_id AND
339: (has_child_flag = 'Y' AND has_parent_flag = 'N');
340: COMMIT;

Line 342: UPDATE RG_XBRL_ELEMENTS

338: WHERE taxonomy_id = p_taxonomy_id AND
339: (has_child_flag = 'Y' AND has_parent_flag = 'N');
340: COMMIT;
341: --
342: UPDATE RG_XBRL_ELEMENTS
343: SET hierarchy_level = 1
344: WHERE taxonomy_id = p_taxonomy_id AND
345: (has_child_flag = 'N' AND has_parent_flag = 'Y');
346: COMMIT;

Line 348: UPDATE RG_XBRL_ELEMENTS

344: WHERE taxonomy_id = p_taxonomy_id AND
345: (has_child_flag = 'N' AND has_parent_flag = 'Y');
346: COMMIT;
347: --
348: UPDATE RG_XBRL_ELEMENTS
349: SET hierarchy_level = 2
350: WHERE taxonomy_id = p_taxonomy_id AND
351: (has_child_flag = 'Y' AND has_parent_flag = 'Y');
352: COMMIT;

Line 792: SELECT RG_XBRL_ELEMENTS_S.NEXTVAL

788: IF l_exec = 1
789: THEN
790: IF INSTR(l_elem_group,'item',1,1) > 0
791: THEN
792: SELECT RG_XBRL_ELEMENTS_S.NEXTVAL
793: INTO l_elem_id
794: FROM dual;
795: --
796: INSERT INTO RG_XBRL_ELEMENTS

Line 796: INSERT INTO RG_XBRL_ELEMENTS

792: SELECT RG_XBRL_ELEMENTS_S.NEXTVAL
793: INTO l_elem_id
794: FROM dual;
795: --
796: INSERT INTO RG_XBRL_ELEMENTS
797: (taxonomy_id,element_id,
798: element_identifier,element_descr,
799: element_name,element_type,
800: element_group,

Line 942: FROM RG_XBRL_ELEMENTS t1

938: CURSOR tax_el_storage (tax_id number) IS
939: SELECT element_id,
940: element_identifier,
941: element_label
942: FROM RG_XBRL_ELEMENTS t1
943: WHERE t1.taxonomy_id = tax_id
944: FOR UPDATE;
945: --
946: BEGIN

Line 1013: UPDATE RG_XBRL_ELEMENTS

1009: --
1010: l_label :=
1011: dbms_lob.SUBSTR(l_clob,l_left_br_pos-l_right_br_pos-1, l_right_br_pos+1);
1012: --
1013: UPDATE RG_XBRL_ELEMENTS
1014: SET element_label = l_label
1015: WHERE CURRENT OF tax_el_storage;
1016: END LOOP;
1017: CLOSE tax_el_storage;

Line 1053: FROM RG_XBRL_ELEMENTS t1

1049: CURSOR tax_el_storage (tax_id number) IS
1050: SELECT element_id,
1051: element_identifier,
1052: parent_identifier
1053: FROM RG_XBRL_ELEMENTS t1
1054: WHERE t1.taxonomy_id = tax_id
1055: FOR UPDATE;
1056: --
1057: BEGIN

Line 1099: UPDATE RG_XBRL_ELEMENTS

1095: THEN
1096: l_element_defn_parent := SUBSTR(l_parent_descr,1,LENGTH(l_parent_descr));
1097: END IF;
1098: --
1099: UPDATE RG_XBRL_ELEMENTS
1100: SET parent_identifier = l_element_defn_parent
1101: WHERE CURRENT OF tax_el_storage;
1102: END LOOP;
1103: CLOSE tax_el_storage;