APPS.GL_DRM_INTEGRATION_PKG dependencies on GL_DRM_SEGVALUES_INTERFACE

Line 510: FROM gl_drm_segvalues_interface sv;

506: sv.start_date_active EFFECTIVE_FROM,
507: sv.end_date_active EFFECTIVE_TO,
508: sv.rollup_group ROLLUP_GROUP,
509: sv.hierarchy_level HIERARCHY_LEVEL
510: FROM gl_drm_segvalues_interface sv;
511:
512: -- cursor to fetch parent-child relationships from interface table
513: CURSOR c_drm_hierarchy_interface
514: IS

Line 522: gl_drm_segvalues_interface sv,

518: Decode(Upper(sv.summary_flag), 'YES','P','NO','C',sv.summary_flag) range_attribute,
519: Decode(Upper(svp.summary_flag), 'YES','Y','NO','N',svp.summary_flag) parent_summary
520: FROM
521: gl_drm_hierarchy_interface h,
522: gl_drm_segvalues_interface sv,
523: gl_drm_segvalues_interface svp
524: WHERE
525: h.depth > 1 AND /* 11843300 : Top Node depth is 1 and should be ignored */
526: h.value = sv.Value(+) AND

Line 523: gl_drm_segvalues_interface svp

519: Decode(Upper(svp.summary_flag), 'YES','Y','NO','N',svp.summary_flag) parent_summary
520: FROM
521: gl_drm_hierarchy_interface h,
522: gl_drm_segvalues_interface sv,
523: gl_drm_segvalues_interface svp
524: WHERE
525: h.depth > 1 AND /* 11843300 : Top Node depth is 1 and should be ignored */
526: h.value = sv.Value(+) AND
527: h.parent_value = svp.Value(+)

Line 729: log_message('No data in interface table: GL_DRM_SEGVALUES_INTERFACE');

725:
726: -- check if any values were exported
727: IF NOT g_flex_values_tbl.EXISTS(1)
728: THEN
729: log_message('No data in interface table: GL_DRM_SEGVALUES_INTERFACE');
730: raise_application_error(-20103,'No Segment Values were exported from Hyperion DRM');
731: END IF;
732:
733: log_message('Number of segment values : '||g_flex_values_tbl.COUNT);

Line 873: FROM gl_drm_segvalues_interface sv

869: 'S' ,DESC_S, 'SF' ,DESC_SF, 'SK' ,DESC_SK, 'SL' ,DESC_SL,
870: 'TH' ,DESC_TH, 'TR' ,DESC_TR, 'US' ,DESC_US, 'ZHS',DESC_ZHS,
871: 'ZHT',DESC_ZHT)
872: INTO l_s_flex_desc_tl
873: FROM gl_drm_segvalues_interface sv
874: WHERE sv.value = g_flex_values_tbl(i).flex_value;
875:
876: -- Check that translation was given.
877: IF l_s_flex_desc_tl IS NOT NULL

Line 1005: DELETE gl_drm_segvalues_interface;

1001: END IF;
1002: write_xml_tag(XT_docRoot,XML_TAG_CLOSE);
1003:
1004: -- empty interface tables
1005: DELETE gl_drm_segvalues_interface;
1006: DELETE gl_drm_hierarchy_interface;
1007: COMMIT;
1008:
1009: log_message('>>gl_drm_integration_pkg.gl_drm_import_process');

Line 1030: DELETE gl_drm_segvalues_interface;

1026: write_xml_element(XT_loadDone,XML_TEXT_NO);
1027: write_xml_tag(XT_docRoot,XML_TAG_CLOSE);
1028:
1029: -- empty interface tables
1030: DELETE gl_drm_segvalues_interface;
1031: DELETE gl_drm_hierarchy_interface;
1032: COMMIT;
1033: END gl_drm_import_process;
1034: