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.FEM_ADMIN_UTIL_PKG dependencies on FEM_ADMIN_UTIL_PKG

Line 1: PACKAGE BODY FEM_Admin_Util_Pkg AS

1: PACKAGE BODY FEM_Admin_Util_Pkg AS
2: -- $Header: fem_adm_utl.plb 120.18 2008/02/06 23:15:26 ghall ship $
3:
4: -------------------------------
5: -- Declare Package Variables --

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_ADMIN_UTIL_PKG';

8: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
9: c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10: c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
11: c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_ADMIN_UTIL_PKG';
13:
14: bad_gvsc_id EXCEPTION;
15: e_unexp EXCEPTION;
16: e_error EXCEPTION;

Line 28: 'fem.plsql.fem_admin_util_pkg.trunc_table_class_log_tables';

24:
25: PROCEDURE Trunc_Table_Class_Log_Tables (
26: p_tab_name IN VARCHAR2) IS
27: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
28: 'fem.plsql.fem_admin_util_pkg.trunc_table_class_log_tables';
29: BEGIN
30:
31: BEGIN
32: DELETE FROM fem_tab_class_status_gt

Line 75: 'fem.plsql.fem_admin_util_pkg.log_table_class_error';

71: p_token4 IN VARCHAR2 DEFAULT NULL,
72: p_value4 IN VARCHAR2 DEFAULT NULL
73: ) IS
74: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
75: 'fem.plsql.fem_admin_util_pkg.log_table_class_error';
76:
77: TYPE msg_array IS VARRAY(8) OF VARCHAR2(2000);
78: tokens_values msg_array;
79:

Line 150: 'fem.plsql.fem_admin_util_pkg.log_table_class_status';

146: p_tab_name IN VARCHAR2,
147: p_tab_class_cd IN VARCHAR2,
148: p_passed_validation IN VARCHAR2) IS
149: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
150: 'fem.plsql.fem_admin_util_pkg.log_table_class_status';
151: BEGIN
152:
153: INSERT INTO fem_tab_class_status_gt
154: (TABLE_NAME, TABLE_CLASSIFICATION_CODE, VALID_FLAG)

Line 187: 'fem.plsql.fem_admin_util_pkg.create_data_loader_rule';

183: p_tab_class_cd IN VARCHAR2
184: ) RETURN VARCHAR2
185: AS
186: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
187: 'fem.plsql.fem_admin_util_pkg.create_data_loader_rule';
188:
189: v_count INTEGER;
190: v_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
191: v_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;

Line 365: 'fem.plsql.fem_admin_util_pkg.validate_prop_col_req';

361: p_col_req_type IN VARCHAR2,
362: x_passed_validation OUT NOCOPY VARCHAR2
363: ) IS
364: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
365: 'fem.plsql.fem_admin_util_pkg.validate_prop_col_req';
366:
367: TYPE CurTyp IS REF CURSOR;
368: cols_cv CurTyp;
369:

Line 717: 'fem.plsql.fem_admin_util_pkg.validate_pk_cols_not_null';

713: p_tab_owner IN VARCHAR2,
714: p_db_tab_name IN VARCHAR2,
715: x_passed_validation OUT NOCOPY VARCHAR2) IS
716: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
717: 'fem.plsql.fem_admin_util_pkg.validate_pk_cols_not_null';
718:
719: CURSOR c_null_cols (p_tab_name VARCHAR2, p_owner VARCHAR2) IS
720: SELECT a.column_name
721: FROM all_tab_columns a, fem_tab_column_prop p

Line 795: 'fem.plsql.fem_admin_util_pkg.validate_editable';

791: p_tab_name IN VARCHAR2,
792: p_tab_class_cd IN VARCHAR2,
793: x_passed_validation OUT NOCOPY VARCHAR2) IS
794: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
795: 'fem.plsql.fem_admin_util_pkg.validate_editable';
796:
797: v_obj_type USER_OBJECTS.object_type%TYPE;
798: v_count NUMBER;
799: BEGIN

Line 878: 'fem.plsql.fem_admin_util_pkg.validate_table_name_restriction';

874: p_tab_name IN VARCHAR2,
875: p_tab_class_cd IN VARCHAR2,
876: x_passed_validation OUT NOCOPY VARCHAR2) IS
877: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
878: 'fem.plsql.fem_admin_util_pkg.validate_table_name_restriction';
879: BEGIN
880: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
881: FEM_ENGINES_PKG.TECH_MESSAGE(
882: p_severity => FND_LOG.level_procedure,

Line 959: 'fem.plsql.fem_admin_util_pkg.validate_data_loader';

955: p_tab_owner IN VARCHAR2,
956: p_db_tab_name IN VARCHAR2,
957: x_passed_validation OUT NOCOPY VARCHAR2) IS
958: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
959: 'fem.plsql.fem_admin_util_pkg.validate_data_loader';
960:
961: CURSOR c_uniq_idx(p_owner VARCHAR2, p_name VARCHAR2) IS
962: SELECT index_name
963: FROM all_indexes

Line 1502: 'fem.plsql.fem_admin_util_pkg.delete_obj_tuning_options';

1498: p_object_id IN NUMBER
1499: ) IS
1500:
1501: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1502: 'fem.plsql.fem_admin_util_pkg.delete_obj_tuning_options';
1503: C_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Obj_Tuning_Options';
1504:
1505: v_process_ds_cd NUMBER;
1506:

Line 1674: 'fem.plsql.fem_admin_util_pkg.validate_column_req';

1670: x_passed_validation OUT NOCOPY VARCHAR2
1671: )
1672: IS
1673: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1674: 'fem.plsql.fem_admin_util_pkg.validate_column_req';
1675:
1676: -- Cursor to fetch all registered columns that match
1677: -- those in FEM_COLUMN_REQUIREMNT_B
1678: CURSOR c_req_col (p_owner VARCHAR2, p_syn_name VARCHAR2,

Line 1838: 'fem.plsql.fem_admin_util_pkg.validate_processing_key_idx';

1834: x_passed_validation OUT NOCOPY VARCHAR2
1835: )
1836: IS
1837: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1838: 'fem.plsql.fem_admin_util_pkg.validate_processing_key_idx';
1839:
1840: v_count NUMBER;
1841: v_idx_name FEM_TABLES_B.proc_key_index_name%TYPE;
1842: v_idx_owner FEM_TABLES_B.proc_key_index_owner%TYPE;

Line 2026: 'fem.plsql.fem_admin_util_pkg.validate_ogl_dimcol';

2022: p_tab_name IN VARCHAR2,
2023: p_tab_class_cd IN VARCHAR2,
2024: x_passed_validation OUT NOCOPY VARCHAR2) IS
2025: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2026: 'fem.plsql.fem_admin_util_pkg.validate_ogl_dimcol';
2027:
2028: CURSOR c_dimcol (p_name VARCHAR2) IS
2029: SELECT column_name, dimension_id
2030: FROM fem_tab_columns_b

Line 2186: 'fem.plsql.fem_admin_util_pkg.validate_tab_class';

2182: x_passed_validation OUT NOCOPY VARCHAR2
2183: )
2184: IS
2185: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2186: 'fem.plsql.fem_admin_util_pkg.validate_tab_class';
2187:
2188: CURSOR c_class_prop (p_class VARCHAR2) IS
2189: SELECT p.table_property_code, p.property_type, p.column_req_type
2190: FROM fem_table_class_prop c, fem_table_properties p

Line 2284: IF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT') THEN

2280: -- Run other specified procedures for this table class
2281: FOR r IN c_procedure (p_tab_class_cd) LOOP
2282: v_procedure := r.stored_procedure_name;
2283:
2284: IF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT') THEN
2285: Validate_Table_Name_Restrict (
2286: p_tab_name => p_tab_name,
2287: p_tab_class_cd => p_tab_class_cd,
2288: x_passed_validation => v_passed_valid_out);

Line 2289: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE') THEN

2285: Validate_Table_Name_Restrict (
2286: p_tab_name => p_tab_name,
2287: p_tab_class_cd => p_tab_class_cd,
2288: x_passed_validation => v_passed_valid_out);
2289: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE') THEN
2290: Validate_Editable (
2291: p_tab_name => p_tab_name,
2292: p_tab_class_cd => p_tab_class_cd,
2293: x_passed_validation => v_passed_valid_out);

Line 2294: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER') THEN

2290: Validate_Editable (
2291: p_tab_name => p_tab_name,
2292: p_tab_class_cd => p_tab_class_cd,
2293: x_passed_validation => v_passed_valid_out);
2294: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER') THEN
2295: Validate_Data_Loader (
2296: p_tab_name => p_tab_name,
2297: p_tab_class_cd => p_tab_class_cd,
2298: p_tab_owner => v_tab_owner,

Line 2301: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PK_COLS_NOT_NULL') THEN

2297: p_tab_class_cd => p_tab_class_cd,
2298: p_tab_owner => v_tab_owner,
2299: p_db_tab_name => v_db_tab_name,
2300: x_passed_validation => v_passed_valid_out);
2301: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PK_COLS_NOT_NULL') THEN
2302: Validate_PK_Cols_Not_Null (
2303: p_tab_name => p_tab_name,
2304: p_tab_class_cd => p_tab_class_cd,
2305: p_tab_owner => v_tab_owner,

Line 2308: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_OGL_DIMCOL') THEN

2304: p_tab_class_cd => p_tab_class_cd,
2305: p_tab_owner => v_tab_owner,
2306: p_db_tab_name => v_db_tab_name,
2307: x_passed_validation => v_passed_valid_out);
2308: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_OGL_DIMCOL') THEN
2309: Validate_OGL_Dimcol (
2310: p_tab_name => p_tab_name,
2311: p_tab_class_cd => p_tab_class_cd,
2312: x_passed_validation => v_passed_valid_out);

Line 2313: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PROCESSING_KEY_IDX') THEN

2309: Validate_OGL_Dimcol (
2310: p_tab_name => p_tab_name,
2311: p_tab_class_cd => p_tab_class_cd,
2312: x_passed_validation => v_passed_valid_out);
2313: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PROCESSING_KEY_IDX') THEN
2314: Validate_Processing_Key_Idx (
2315: p_tab_name => p_tab_name,
2316: p_tab_class_cd => p_tab_class_cd,
2317: p_tab_owner => v_tab_owner,

Line 2369: 'fem.plsql.fem_admin_util_pkg.validate_tab_class_assignmt';

2365: p_tab_name IN VARCHAR2
2366: )
2367: IS
2368: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2369: 'fem.plsql.fem_admin_util_pkg.validate_tab_class_assignmt';
2370: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Tab_Class_Assignmt';
2371:
2372: v_passed_validation VARCHAR2(1);
2373: v_tab_class_cd VARCHAR2(30);

Line 2494: 'fem.plsql.fem_admin_util_pkg.validate_obj_class_assignmt';

2490: p_obj_type IN VARCHAR2
2491: )
2492: IS
2493: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2494: 'fem.plsql.fem_admin_util_pkg.validate_obj_class_assignmt';
2495: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_obj_Class_Assignmt';
2496:
2497: v_passed_validation VARCHAR2(1);
2498: v_tab_class_cd VARCHAR2(30);

Line 2502: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',

2498: v_tab_class_cd VARCHAR2(30);
2499:
2500: /* Select only those classifications for which properties do not need validation
2501: EXCEPT(
2502: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',
2503: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',
2504: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')
2505: */
2506:

Line 2503: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',

2499:
2500: /* Select only those classifications for which properties do not need validation
2501: EXCEPT(
2502: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',
2503: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',
2504: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')
2505: */
2506:
2507: CURSOR c_table_classes IS

Line 2504: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')

2500: /* Select only those classifications for which properties do not need validation
2501: EXCEPT(
2502: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',
2503: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',
2504: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')
2505: */
2506:
2507: CURSOR c_table_classes IS
2508: SELECT lookup_code

Line 2518: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',

2514: fem_table_prop_stp ftps
2515: where ftcp.table_classification_code = flv.lookup_code
2516: and ftcp.table_property_code = ftps.table_property_code
2517: and ftps.stored_procedure_name in(
2518: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',
2519: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',
2520: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')
2521: );
2522:

Line 2519: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',

2515: where ftcp.table_classification_code = flv.lookup_code
2516: and ftcp.table_property_code = ftps.table_property_code
2517: and ftps.stored_procedure_name in(
2518: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',
2519: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',
2520: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')
2521: );
2522:
2523: BEGIN

Line 2520: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')

2516: and ftcp.table_property_code = ftps.table_property_code
2517: and ftps.stored_procedure_name in(
2518: 'FEM_ADMIN_UTIL_PKG.VALIDATE_TABLE_NAME_RESTRICT',
2519: 'FEM_ADMIN_UTIL_PKG.VALIDATE_DATA_LOADER',
2520: 'FEM_ADMIN_UTIL_PKG.VALIDATE_EDITABLE')
2521: );
2522:
2523: BEGIN
2524:

Line 2649: 'fem.plsql.fem_admin_util_pkg.Get_Table_Owner_for_View';

2645: -- Returns the underlying table name and table owner for a specified user defined view for the selected index.
2646: -- =========================================================================
2647:
2648: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2649: 'fem.plsql.fem_admin_util_pkg.Get_Table_Owner_for_View';
2650: BEGIN
2651:
2652: x_return_status := c_success;
2653:

Line 2715: 'fem.plsql.fem_admin_util_pkg.Get_Index_Owner_for_View';

2711: -- Returns the underlying table name and Index owner for a specified user defined view and the selected index.
2712: -- =========================================================================
2713:
2714: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2715: 'fem.plsql.fem_admin_util_pkg.Get_Index_Owner_for_View';
2716:
2717:
2718: BEGIN
2719:

Line 2775: 'fem.plsql.fem_admin_util_pkg.validate_view_class';

2771: x_passed_validation OUT NOCOPY VARCHAR2
2772: )
2773: IS
2774: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2775: 'fem.plsql.fem_admin_util_pkg.validate_view_class';
2776:
2777: CURSOR c_class_prop (p_class VARCHAR2) IS
2778: SELECT p.table_property_code, p.property_type, p.column_req_type
2779: FROM fem_table_class_prop c, fem_table_properties p

Line 2881: IF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PK_COLS_NOT_NULL') THEN

2877: -- Run other specified procedures for this table class
2878: FOR r IN c_procedure (p_tab_class_cd) LOOP
2879: v_procedure := r.stored_procedure_name;
2880:
2881: IF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PK_COLS_NOT_NULL') THEN
2882: Validate_PK_Cols_Not_Null (
2883: p_tab_name => p_view_name,
2884: p_tab_class_cd => p_tab_class_cd,
2885: p_tab_owner => l_apps,

Line 2889: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PROCESSING_KEY_IDX') THEN

2885: p_tab_owner => l_apps,
2886: p_db_tab_name => p_view_name,
2887: x_passed_validation => v_passed_valid_out);
2888:
2889: ELSIF (v_procedure = 'FEM_ADMIN_UTIL_PKG.VALIDATE_PROCESSING_KEY_IDX') THEN
2890: Validate_Processing_Key_Idx (
2891: p_tab_name => p_view_name,
2892: p_tab_class_cd => p_tab_class_cd,
2893: p_tab_owner => v_tab_owner,

Line 2938: END FEM_Admin_Util_Pkg;

2934:
2935: /**************************************************************************/
2936:
2937:
2938: END FEM_Admin_Util_Pkg;