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_XFER_COMPONENTS_PKG dependencies on RG_XBRL_ELEMENTS

Line 3046: ' RG_XBRL_ELEMENTS'||'@'|| G_LinkName || ' elm,' ||

3042:
3043: /* build all childs of the parent taxonomy */
3044: SQLString := 'SELECT DISTINCT tax.taxonomy_id,tax.taxonomy_alias '||
3045: 'FROM RG_XBRL_TAXONOMIES'||'@'|| G_LinkName || ' tax,' ||
3046: ' RG_XBRL_ELEMENTS'||'@'|| G_LinkName || ' elm,' ||
3047: ' RG_XBRL_MAP_ELEMENTS'||'@'|| G_LinkName || ' map ' ||
3048: 'WHERE map.element_id = elm.element_id AND ' ||
3049: ' elm.taxonomy_id = tax.taxonomy_id AND ' ||
3050: ' map.enabled_flag = ''Y'' AND ' ||

Line 3109: /* populate multiple rows in rg_xbrl_elements */

3105: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3106: ExecuteValue := DBMS_SQL.execute(CursorId);
3107: DBMS_SQL.close_cursor(CursorId);
3108:
3109: /* populate multiple rows in rg_xbrl_elements */
3110: SQLString :=
3111: 'SELECT ' ||
3112: ' element_identifier, ' ||
3113: ' element_name, element_type, element_group, ' ||

Line 3116: 'FROM RG_XBRL_ELEMENTS@' || G_LinkName ||

3112: ' element_identifier, ' ||
3113: ' element_name, element_type, element_group, ' ||
3114: ' element_descr, element_label, parent_identifier, ' ||
3115: ' has_child_flag, has_parent_flag, hierarchy_level ' ||
3116: 'FROM RG_XBRL_ELEMENTS@' || G_LinkName ||
3117: ' WHERE taxonomy_id = ' || to_char(parent_tax_id);
3118:
3119: RG_XFER_UTILS_PKG.display_string(SQLString);
3120:

Line 3152: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');

3148: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3149: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3151: --
3152: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3153: --
3154: INSERT INTO RG_XBRL_ELEMENTS (
3155: TAXONOMY_ID, ELEMENT_ID, ELEMENT_IDENTIFIER,
3156: ELEMENT_NAME, ELEMENT_TYPE, ELEMENT_GROUP,

Line 3154: INSERT INTO RG_XBRL_ELEMENTS (

3150: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3151: --
3152: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3153: --
3154: INSERT INTO RG_XBRL_ELEMENTS (
3155: TAXONOMY_ID, ELEMENT_ID, ELEMENT_IDENTIFIER,
3156: ELEMENT_NAME, ELEMENT_TYPE, ELEMENT_GROUP,
3157: ELEMENT_DESCR, ELEMENT_LABEL, PARENT_IDENTIFIER,
3158: PARENT_ID, HAS_CHILD_FLAG, HAS_PARENT_FLAG, HIERARCHY_LEVEL,

Line 3185: ' FROM RG_XBRL_ELEMENTS ' ||

3181: ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
3182: ' element_id, ''Y'',' ||
3183: ' SYSDATE,' || to_char(l_user_id) || ',' ||
3184: ' SYSDATE,' || to_char(l_user_id) || ',' || to_char(l_login_id) ||
3185: ' FROM RG_XBRL_ELEMENTS ' ||
3186: ' WHERE taxonomy_id = ' || to_char(dest_taxonomy_id);
3187:
3188: RG_XFER_UTILS_PKG.display_string(SQLString);
3189:

Line 3251: /* populate multiple rows in rg_xbrl_elements */

3247: DBMS_SQL.parse(CursorId, SQLString, DBMS_SQL.v7);
3248: ExecuteValue := DBMS_SQL.execute(CursorId);
3249: DBMS_SQL.close_cursor(CursorId);
3250:
3251: /* populate multiple rows in rg_xbrl_elements */
3252:
3253: SQLString :=
3254: 'SELECT ' ||
3255: ' element_identifier, element_name, element_type, element_group,' ||

Line 3258: ' FROM RG_XBRL_ELEMENTS@' || G_LinkName ||

3254: 'SELECT ' ||
3255: ' element_identifier, element_name, element_type, element_group,' ||
3256: ' element_descr, element_label, parent_identifier,' ||
3257: ' has_child_flag, has_parent_flag, hierarchy_level' ||
3258: ' FROM RG_XBRL_ELEMENTS@' || G_LinkName ||
3259: ' WHERE taxonomy_id = ' || to_char(parent_tax_id);
3260:
3261: RG_XFER_UTILS_PKG.display_string(SQLString);
3262:

Line 3294: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');

3290: DBMS_SQL.column_value(CursorId, 8, src_has_child_flag);
3291: DBMS_SQL.column_value(CursorId, 9, src_has_parent_flag);
3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3293: --
3294: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3295: --
3296: INSERT INTO RG_XBRL_ELEMENTS (
3297: TAXONOMY_ID, ELEMENT_ID, ELEMENT_IDENTIFIER,
3298: ELEMENT_NAME, ELEMENT_TYPE, ELEMENT_GROUP,

Line 3296: INSERT INTO RG_XBRL_ELEMENTS (

3292: DBMS_SQL.column_value(CursorId, 10, src_hierarchy_level);
3293: --
3294: cur_elem_id := RG_XFER_UTILS_PKG.get_new_id('rg_xbrl_elements_s');
3295: --
3296: INSERT INTO RG_XBRL_ELEMENTS (
3297: TAXONOMY_ID, ELEMENT_ID, ELEMENT_IDENTIFIER,
3298: ELEMENT_NAME, ELEMENT_TYPE, ELEMENT_GROUP,
3299: ELEMENT_DESCR, ELEMENT_LABEL, PARENT_IDENTIFIER,
3300: PARENT_ID, HAS_CHILD_FLAG, HAS_PARENT_FLAG, HIERARCHY_LEVEL,

Line 3327: ' FROM RG_XBRL_ELEMENTS ' ||

3323: ') SELECT ' || to_char(dest_taxonomy_id) || ',' ||
3324: ' element_id, ''Y'',' ||
3325: ' SYSDATE,' || TO_CHAR(l_user_id) || ',' ||
3326: ' SYSDATE,' || TO_CHAR(l_user_id) || ',' || TO_CHAR(l_login_id) ||
3327: ' FROM RG_XBRL_ELEMENTS ' ||
3328: ' WHERE taxonomy_id = ' || to_char(dest_taxonomy_id);
3329:
3330: RG_XFER_UTILS_PKG.display_string(SQLString);
3331: