135:
136:
137: IF (X_Mode = 'R') THEN
138:
139: -- Select the titles and messages from gl_lookups
140: SELECT description
141: INTO title
142: FROM GL_LOOKUPS
143: WHERE lookup_type = 'CONSOLIDATION_VIEWER'
138:
139: -- Select the titles and messages from gl_lookups
140: SELECT description
141: INTO title
142: FROM GL_LOOKUPS
143: WHERE lookup_type = 'CONSOLIDATION_VIEWER'
144: AND lookup_code = 'CHV_TITLE';
145:
146: SELECT description
144: AND lookup_code = 'CHV_TITLE';
145:
146: SELECT description
147: INTO gcs_title
148: FROM GL_LOOKUPS
149: WHERE lookup_type = 'CONSOLIDATION_VIEWER'
150: AND lookup_code = 'FEATURE_NAME';
151:
152: SELECT description
150: AND lookup_code = 'FEATURE_NAME';
151:
152: SELECT description
153: INTO gcs_message
154: FROM GL_LOOKUPS
155: WHERE lookup_type = 'CONSOLIDATION_VIEWER'
156: AND lookup_code = 'FEATURE_MESSAGE';
157:
158: -- Print html to the browser if the procedure is called in 'Run' mode.