DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_BULK_PVT dependencies on FND_FORM_FUNCTIONS

Line 1165: l_view_priv_to_check FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308

1161: --if we change required parameters, version goes FROM n.x to (n+1).x
1162: --if we change optional parameters, version goes FROM x.n to x.(n+1)
1163: l_api_version CONSTANT NUMBER := 1.0;
1164:
1165: l_view_priv_to_check FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308
1166: l_edit_priv_to_check FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308
1167:
1168: l_class_blk_tbl_declare VARCHAR2(1000);
1169: l_class_blk_tbl_list VARCHAR2(100);

Line 1166: l_edit_priv_to_check FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308

1162: --if we change optional parameters, version goes FROM x.n to x.(n+1)
1163: l_api_version CONSTANT NUMBER := 1.0;
1164:
1165: l_view_priv_to_check FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308
1166: l_edit_priv_to_check FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308
1167:
1168: l_class_blk_tbl_declare VARCHAR2(1000);
1169: l_class_blk_tbl_list VARCHAR2(100);
1170: l_class_blk_tbl_list_2 VARCHAR2(100);

Line 1191: -- 6070367 this must be more than double fnd_form_functions.function_name

1187: l_dynamic_sql_1 VARCHAR2(32767);
1188: l_ext_table_select VARCHAR2(32767);
1189: l_dummy NUMBER;
1190: l_priv_predicate VARCHAR2(32767);
1191: -- 6070367 this must be more than double fnd_form_functions.function_name
1192: l_prev_ag_id_priv VARCHAR2(1000);
1193: l_do_dml_for_this_ag BOOLEAN;
1194:
1195: l_no_of_err_recs NUMBER;

Line 1368: VIEW_PRIVILEGE FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE, --4105308

1364: MAXIMUM_VALUE VARCHAR2(150),
1365: UOM_CODE VARCHAR2(3),
1366: UOM_CLASS VARCHAR2(10),
1367: DATA_LEVEL_ID NUMBER,
1368: VIEW_PRIVILEGE FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE, --4105308
1369: EDIT_PRIVILEGE FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE --4105308
1370: );
1371:
1372: l_attr_metadata_rec ATTR_METADATA_RECORD;

Line 1369: EDIT_PRIVILEGE FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE --4105308

1365: UOM_CODE VARCHAR2(3),
1366: UOM_CLASS VARCHAR2(10),
1367: DATA_LEVEL_ID NUMBER,
1368: VIEW_PRIVILEGE FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE, --4105308
1369: EDIT_PRIVILEGE FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE --4105308
1370: );
1371:
1372: l_attr_metadata_rec ATTR_METADATA_RECORD;
1373:

Line 2637: FND_FORM_FUNCTIONS FNV,

2633: EGO_FND_DF_COL_USGS_EXT EXT,
2634: EGO_ATTR_GROUP_DL AG_DL,
2635: FND_FLEX_VALUE_SETS VS,
2636: MTL_UNITS_OF_MEASURE UOM,
2637: FND_FORM_FUNCTIONS FNV,
2638: FND_FORM_FUNCTIONS FNE
2639: WHERE DISTINCT_ATTRS.ATTR_GROUP_ID = FLX_EXT.ATTR_GROUP_ID
2640: and FLX_EXT.APPLICATION_ID = a.APPLICATION_ID
2641: and FLX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = a.DESCRIPTIVE_FLEXFIELD_NAME

Line 2638: FND_FORM_FUNCTIONS FNE

2634: EGO_ATTR_GROUP_DL AG_DL,
2635: FND_FLEX_VALUE_SETS VS,
2636: MTL_UNITS_OF_MEASURE UOM,
2637: FND_FORM_FUNCTIONS FNV,
2638: FND_FORM_FUNCTIONS FNE
2639: WHERE DISTINCT_ATTRS.ATTR_GROUP_ID = FLX_EXT.ATTR_GROUP_ID
2640: and FLX_EXT.APPLICATION_ID = a.APPLICATION_ID
2641: and FLX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = a.DESCRIPTIVE_FLEXFIELD_NAME
2642: and FLX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = a.DESCRIPTIVE_FLEX_CONTEXT_CODE