APPS.GCS_HIERARCHIES_PKG dependencies on FEM_DATASETS_TL

Line 2315: FROM fem_datasets_tl

2311: p_ver_disp_cd => 'Default',
2312: p_dataset_desc => l_base_description);
2313: SELECT dataset_code
2314: INTO l_base_ds_code
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

Line 2354: FROM fem_datasets_tl

2350: p_ver_disp_cd => 'Default',
2351: p_dataset_desc => l_analyze_description);
2352: SELECT dataset_code
2353: INTO l_analyze_ds_code
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

Line 2514: FROM fem_datasets_tl

2510: p_ver_disp_cd => 'Default',
2511: p_dataset_desc => l_base_description);
2512: SELECT dataset_code
2513: INTO l_base_ds_code
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

Line 2553: FROM fem_datasets_tl

2549: p_ver_disp_cd => 'Default',
2550: p_dataset_desc => l_analyze_description);
2551: SELECT dataset_code
2552: INTO l_analyze_ds_code
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

Line 2655: UPDATE fem_datasets_tl

2651: UPDATE fem_datasets_b
2652: SET dataset_display_code = l_display_code
2653: WHERE dataset_code = l_dataset_code;
2654:
2655: UPDATE fem_datasets_tl
2656: SET dataset_name = l_display_code,
2657: description = l_description
2658: WHERE dataset_code = l_dataset_code
2659: AND language = userenv('LANG');