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.

[Home] [Help]

APPS.GCS_TEMPLATES_DYNAMIC_PKG dependencies on GCS_HIERARCHIES_B

Line 35: FROM gcs_hierarchies_b hb

31: -- Used to obtain hierarchy information
32: CURSOR hierarchy_c
33: IS
34: SELECT hb.balance_by_org_flag, hb.column_name
35: FROM gcs_hierarchies_b hb
36: WHERE hb.hierarchy_id = p_hierarchy_id;
37:
38: org_tracking_flag VARCHAR2 (1);
39: secondary_dimension_column VARCHAR2 (30);

Line 113: || 'FROM gcs_hierarchies_b hb '

109: fnd_log.STRING (fnd_log.level_statement,
110: g_pkg_name || '.' || l_api_name,
111: 'SELECT hb.balance_by_org_flag, hb.column_name'
112: || g_nl
113: || 'FROM gcs_hierarchies_b hb '
114: || g_nl
115: || 'WHERE hb.hierarchy_id = '
116: || p_hierarchy_id
117: );

Line 139: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '

135: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
136: THEN
137: fnd_log.STRING (fnd_log.level_statement,
138: g_pkg_name || '.' || l_api_name,
139: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '
140: || ' WHERE hierarchy_id = ' || p_hierarchy_id
141: || ' AND INTERCOMPANY_ORG_TYPE_CODE = ''SPECIFIC_VALUE''');
142: END IF;
143:

Line 567: FROM gcs_hierarchies_b hb

563: -- Used to obtain hierarchy information
564: CURSOR hierarchy_c
565: IS
566: SELECT hb.balance_by_org_flag, hb.column_name
567: FROM gcs_hierarchies_b hb
568: WHERE hb.hierarchy_id = p_hierarchy_id;
569:
570: org_tracking_flag VARCHAR2 (1);
571: secondary_dimension_column VARCHAR2 (30);

Line 603: || 'FROM gcs_hierarchies_b hb '

599: fnd_log.STRING (fnd_log.level_statement,
600: g_pkg_name || '.' || l_api_name,
601: 'SELECT hb.balance_by_org_flag, hb.column_name'
602: || g_nl
603: || 'FROM gcs_hierarchies_b hb '
604: || g_nl
605: || 'WHERE hb.hierarchy_id = '
606: || p_hierarchy_id
607: );

Line 639: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '

635: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
636: THEN
637: fnd_log.STRING (fnd_log.level_statement,
638: g_pkg_name || '.' || l_api_name,
639: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '
640: || ' WHERE hierarchy_id = ' || p_hierarchy_id
641: || ' AND INTERCOMPANY_ORG_TYPE_CODE = ''SPECIFIC_VALUE''');
642: END IF;
643:

Line 1074: FROM gcs_hierarchies_b hb

1070: -- Used to obtain hierarchy information
1071: CURSOR hierarchy_c
1072: IS
1073: SELECT hb.balance_by_org_flag, hb.column_name
1074: FROM gcs_hierarchies_b hb
1075: WHERE hb.hierarchy_id = p_hierarchy_id;
1076:
1077: -- Used to get the category cdoe
1078: CURSOR category_c

Line 1160: || 'FROM gcs_hierarchies_b hb '

1156: fnd_log.STRING (fnd_log.level_statement,
1157: g_pkg_name || '.' || l_api_name,
1158: 'SELECT hb.balance_by_org_flag, hb.column_name'
1159: || g_nl
1160: || 'FROM gcs_hierarchies_b hb '
1161: || g_nl
1162: || 'WHERE hb.hierarchy_id = '
1163: || p_hierarchy_id
1164: );

Line 1209: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '

1205: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1206: THEN
1207: fnd_log.STRING (fnd_log.level_statement,
1208: g_pkg_name || '.' || l_api_name,
1209: 'SELECT specific_intercompany_id FROM gcs_hierarchies_b '
1210: || ' WHERE hierarchy_id = ' || p_hierarchy_id
1211: || ' AND INTERCOMPANY_ORG_TYPE_CODE = ''SPECIFIC_VALUE''');
1212: END IF;
1213: