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_HIERARCHIES_PKG dependencies on GCS_DATASET_CODES

Line 2319: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new

2315: FROM fem_datasets_tl
2316: WHERE language = userenv('LANG')
2317: AND dataset_name = l_base_display_code;
2318:
2319: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2320: -- dataset for the base balance types and datasets
2321: INSERT INTO gcs_dataset_codes
2322: (hierarchy_id,
2323: balance_type_code,

Line 2321: INSERT INTO gcs_dataset_codes

2317: AND dataset_name = l_base_display_code;
2318:
2319: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2320: -- dataset for the base balance types and datasets
2321: INSERT INTO gcs_dataset_codes
2322: (hierarchy_id,
2323: balance_type_code,
2324: dataset_code,
2325: creation_date,

Line 2358: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new

2354: FROM fem_datasets_tl
2355: WHERE language = userenv('LANG')
2356: AND dataset_name = l_analyze_display_code;
2357:
2358: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2359: -- dataset for analyze balance types and datasets
2360: INSERT INTO gcs_dataset_codes
2361: (hierarchy_id,
2362: balance_type_code,

Line 2360: INSERT INTO gcs_dataset_codes

2356: AND dataset_name = l_analyze_display_code;
2357:
2358: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2359: -- dataset for analyze balance types and datasets
2360: INSERT INTO gcs_dataset_codes
2361: (hierarchy_id,
2362: balance_type_code,
2363: dataset_code,
2364: creation_date,

Line 2518: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new

2514: FROM fem_datasets_tl
2515: WHERE language = userenv('LANG')
2516: AND dataset_name = l_base_display_code;
2517:
2518: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2519: -- dataset for the base balance types and datasets
2520: INSERT INTO gcs_dataset_codes
2521: (hierarchy_id,
2522: balance_type_code,

Line 2520: INSERT INTO gcs_dataset_codes

2516: AND dataset_name = l_base_display_code;
2517:
2518: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2519: -- dataset for the base balance types and datasets
2520: INSERT INTO gcs_dataset_codes
2521: (hierarchy_id,
2522: balance_type_code,
2523: dataset_code,
2524: creation_date,

Line 2557: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new

2553: FROM fem_datasets_tl
2554: WHERE language = userenv('LANG')
2555: AND dataset_name = l_analyze_display_code;
2556:
2557: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2558: -- dataset for analyze balance types and datasets
2559: INSERT INTO gcs_dataset_codes
2560: (hierarchy_id,
2561: balance_type_code,

Line 2559: INSERT INTO gcs_dataset_codes

2555: AND dataset_name = l_analyze_display_code;
2556:
2557: -- Create a row in gcs_dataset_codes for the hierarchy, balance type, and new
2558: -- dataset for analyze balance types and datasets
2559: INSERT INTO gcs_dataset_codes
2560: (hierarchy_id,
2561: balance_type_code,
2562: dataset_code,
2563: creation_date,

Line 2624: FROM gcs_dataset_codes gdc,

2620: SELECT gdc.balance_type_code,
2621: gdc.dataset_code,
2622: gtl.data_type_name BULK COLLECT
2623: INTO l_dataset_info
2624: FROM gcs_dataset_codes gdc,
2625: gcs_data_type_codes_b gtb,
2626: gcs_data_type_codes_tl gtl
2627: WHERE gdc.hierarchy_id = p_hierarchy_id
2628: AND INSTR(gdc.balance_type_code,gtb.data_type_code) > 0