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.GCS_DATA_TEMPLATE_UTIL_PKG dependencies on GCS_XML_UTILITY_PKG

Line 171: l_select_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;

167: END IF;
168:
169: -- JOB 1 : CONSTRUCT THE GCS/FEM ACTIVE DIMS SELECT/TABLE/WHERE/ORDER/GROUP LIST FOR MANIPULATION USE
170: -- select lists
171: l_select_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
172: l_select_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
173: l_select_list_dsload := gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;
174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;
175:

Line 172: l_select_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;

168:
169: -- JOB 1 : CONSTRUCT THE GCS/FEM ACTIVE DIMS SELECT/TABLE/WHERE/ORDER/GROUP LIST FOR MANIPULATION USE
170: -- select lists
171: l_select_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
172: l_select_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
173: l_select_list_dsload := gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;
174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;
175:
176: -- table lists

Line 173: l_select_list_dsload := gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;

169: -- JOB 1 : CONSTRUCT THE GCS/FEM ACTIVE DIMS SELECT/TABLE/WHERE/ORDER/GROUP LIST FOR MANIPULATION USE
170: -- select lists
171: l_select_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
172: l_select_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
173: l_select_list_dsload := gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;
174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;
175:
176: -- table lists
177: l_table_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_table_list;

Line 174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;

170: -- select lists
171: l_select_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
172: l_select_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
173: l_select_list_dsload := gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;
174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;
175:
176: -- table lists
177: l_table_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_table_list;
178: l_table_list_dstb := gcs_xml_utility_pkg.g_fem_dims_table_list_dstb;

Line 177: l_table_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_table_list;

173: l_select_list_dsload := gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;
174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;
175:
176: -- table lists
177: l_table_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_table_list;
178: l_table_list_dstb := gcs_xml_utility_pkg.g_fem_dims_table_list_dstb;
179: --fix 5351083
180: --l_table_list_dsload := gcs_xml_utility_pkg.g_fem_dims_table_list_dsload;
181: -- where lists

Line 178: l_table_list_dstb := gcs_xml_utility_pkg.g_fem_dims_table_list_dstb;

174: l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;
175:
176: -- table lists
177: l_table_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_table_list;
178: l_table_list_dstb := gcs_xml_utility_pkg.g_fem_dims_table_list_dstb;
179: --fix 5351083
180: --l_table_list_dsload := gcs_xml_utility_pkg.g_fem_dims_table_list_dsload;
181: -- where lists
182: l_where_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_where_clause;

Line 180: --l_table_list_dsload := gcs_xml_utility_pkg.g_fem_dims_table_list_dsload;

176: -- table lists
177: l_table_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_table_list;
178: l_table_list_dstb := gcs_xml_utility_pkg.g_fem_dims_table_list_dstb;
179: --fix 5351083
180: --l_table_list_dsload := gcs_xml_utility_pkg.g_fem_dims_table_list_dsload;
181: -- where lists
182: l_where_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_where_clause;
183: --fix 5351083
184: --l_where_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_where_clause;

Line 182: l_where_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_where_clause;

178: l_table_list_dstb := gcs_xml_utility_pkg.g_fem_dims_table_list_dstb;
179: --fix 5351083
180: --l_table_list_dsload := gcs_xml_utility_pkg.g_fem_dims_table_list_dsload;
181: -- where lists
182: l_where_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_where_clause;
183: --fix 5351083
184: --l_where_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_where_clause;
185: l_where_list_dstb :=gcs_xml_utility_pkg.g_fem_dims_dstb_where_clause;
186: -- group by lists

Line 184: --l_where_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_where_clause;

180: --l_table_list_dsload := gcs_xml_utility_pkg.g_fem_dims_table_list_dsload;
181: -- where lists
182: l_where_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_where_clause;
183: --fix 5351083
184: --l_where_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_where_clause;
185: l_where_list_dstb :=gcs_xml_utility_pkg.g_fem_dims_dstb_where_clause;
186: -- group by lists
187: --fix 5351083
188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;

Line 185: l_where_list_dstb :=gcs_xml_utility_pkg.g_fem_dims_dstb_where_clause;

181: -- where lists
182: l_where_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_where_clause;
183: --fix 5351083
184: --l_where_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_where_clause;
185: l_where_list_dstb :=gcs_xml_utility_pkg.g_fem_dims_dstb_where_clause;
186: -- group by lists
187: --fix 5351083
188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;

Line 188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;

184: --l_where_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_where_clause;
185: l_where_list_dstb :=gcs_xml_utility_pkg.g_fem_dims_dstb_where_clause;
186: -- group by lists
187: --fix 5351083
188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
190: l_gl_posted_group_list := gcs_xml_utility_pkg.g_fem_nonposted_group_stmnt;
191: -- element list
192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;

Line 189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;

185: l_where_list_dstb :=gcs_xml_utility_pkg.g_fem_dims_dstb_where_clause;
186: -- group by lists
187: --fix 5351083
188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
190: l_gl_posted_group_list := gcs_xml_utility_pkg.g_fem_nonposted_group_stmnt;
191: -- element list
192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;
193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;

Line 190: l_gl_posted_group_list := gcs_xml_utility_pkg.g_fem_nonposted_group_stmnt;

186: -- group by lists
187: --fix 5351083
188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
190: l_gl_posted_group_list := gcs_xml_utility_pkg.g_fem_nonposted_group_stmnt;
191: -- element list
192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;
193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;
194: --fix 5351083

Line 192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;

188: --l_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
190: l_gl_posted_group_list := gcs_xml_utility_pkg.g_fem_nonposted_group_stmnt;
191: -- element list
192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;
193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;
194: --fix 5351083
195: --l_element_list_dstb := gcs_xml_utility_pkg.p_element_list_dstb;
196: -- order by list

Line 193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;

189: l_dstb_group_by_list := gcs_xml_utility_pkg.g_group_by_stmnt;
190: l_gl_posted_group_list := gcs_xml_utility_pkg.g_fem_nonposted_group_stmnt;
191: -- element list
192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;
193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;
194: --fix 5351083
195: --l_element_list_dstb := gcs_xml_utility_pkg.p_element_list_dstb;
196: -- order by list
197: l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;

Line 195: --l_element_list_dstb := gcs_xml_utility_pkg.p_element_list_dstb;

191: -- element list
192: l_element_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_xml_elem;
193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;
194: --fix 5351083
195: --l_element_list_dstb := gcs_xml_utility_pkg.p_element_list_dstb;
196: -- order by list
197: l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
198: --Santosh -- bug 5234796
199: l_orderby_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_order_clause;

Line 197: l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;

193: l_element_list_dsload := gcs_xml_utility_pkg.g_fem_dims_xml_elem;
194: --fix 5351083
195: --l_element_list_dstb := gcs_xml_utility_pkg.p_element_list_dstb;
196: -- order by list
197: l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
198: --Santosh -- bug 5234796
199: l_orderby_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_order_clause;
200: l_orderby_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
201: -- special list for vs map

Line 199: l_orderby_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_order_clause;

195: --l_element_list_dstb := gcs_xml_utility_pkg.p_element_list_dstb;
196: -- order by list
197: l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
198: --Santosh -- bug 5234796
199: l_orderby_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_order_clause;
200: l_orderby_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
201: -- special list for vs map
202: l_vs_group_list := gcs_xml_utility_pkg.g_gcs_vsmp_xml_elem;
203:

Line 200: l_orderby_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;

196: -- order by list
197: l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;
198: --Santosh -- bug 5234796
199: l_orderby_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_order_clause;
200: l_orderby_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
201: -- special list for vs map
202: l_vs_group_list := gcs_xml_utility_pkg.g_gcs_vsmp_xml_elem;
203:
204: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 202: l_vs_group_list := gcs_xml_utility_pkg.g_gcs_vsmp_xml_elem;

198: --Santosh -- bug 5234796
199: l_orderby_list_dsload := gcs_xml_utility_pkg.g_fem_dims_dsload_order_clause;
200: l_orderby_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;
201: -- special list for vs map
202: l_vs_group_list := gcs_xml_utility_pkg.g_gcs_vsmp_xml_elem;
203:
204: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
205: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_select_list_gcs : '||l_select_list_gcs);
206: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_select_list_dstb : '||l_select_list_dstb);