DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_USER_ATTRS_COMMON_PVT

Line 74: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT ||

70: THEN
71: -- Generally this is done later on so we don't do the conversion
72: -- unless forced by p_convert_date.
73: x_column_name := 'TO_DATE(' || x_column_name || ',''' ||
74: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT ||
75: ''')';
76:
77: ELSE
78: x_column_name := x_column_name ;

Line 1521: l_replacement_attr_metadata := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

1517: ------------------------------------------------------
1518: IF (l_token = p_attr_metadata_obj.ATTR_NAME) THEN
1519: l_replacement_attr_metadata := p_attr_metadata_obj;
1520: ELSE
1521: l_replacement_attr_metadata := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
1522: p_attr_group_metadata_obj.attr_metadata_table
1523: ,l_token
1524: );
1525: END IF;

Line 1545: EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_replacement_attr_metadata) ||

1541: -----------------------
1542: l_head_of_query := l_head_of_query ||
1543: SUBSTR(l_tail_of_query, 1, (l_token_start_index - 1)) ||
1544: '''||' ||
1545: EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_replacement_attr_metadata) ||
1546: '||''';
1547:
1548: l_tail_of_query := SUBSTR(l_tail_of_query, l_token_end_index + 1);
1549:

Line 3434: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

3430:
3431: ----------------------------------------------------------------
3432: -- Start by getting a metadata object for the Attribute Group --
3433: ----------------------------------------------------------------
3434: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
3435: p_attr_group_id => p_attr_group_id
3436: ,p_pick_from_cache => FALSE
3437: );
3438:

Line 3445: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(

3441:
3442: ---------------------------------------------------------
3443: -- Next, get a metadata object for the Extension Table --
3444: ---------------------------------------------------------
3445: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(
3446: EGO_EXT_FWK_PUB.Get_Object_Id_For_AG_Type(
3447: l_attr_group_metadata_obj.APPLICATION_ID
3448: ,l_attr_group_metadata_obj.ATTR_GROUP_TYPE
3449: )

Line 3457: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

3453:
3454: -----------------------------------------------------------------
3455: -- Build list strings for the Primary Key and Data Level names --
3456: -----------------------------------------------------------------
3457: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
3458: l_ext_table_metadata_obj.pk_column_metadata
3459: ,NULL
3460: ,'NAMES'
3461: );

Line 3463: -- l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

3459: ,NULL
3460: ,'NAMES'
3461: );
3462: -- bug 6345399 fetching all the dl column names
3463: -- l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
3464: -- l_ext_table_metadata_obj.data_level_metadata
3465: -- ,NULL
3466: -- ,'NAMES'
3467: -- );

Line 3468: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_All_Data_Level_PK_Names(

3464: -- l_ext_table_metadata_obj.data_level_metadata
3465: -- ,NULL
3466: -- ,'NAMES'
3467: -- );
3468: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_All_Data_Level_PK_Names(
3469: p_application_id => l_attr_group_metadata_obj.APPLICATION_ID
3470: ,p_attr_group_type => l_attr_group_metadata_obj.ATTR_GROUP_TYPE
3471: );
3472: SELECT application_table_name

Line 3478: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.HAS_COLUMN_IN_TABLE (p_table_name => l_ext_table_name

3474: FROM fnd_descriptive_flexs
3475: WHERE application_id = l_attr_group_metadata_obj.application_id
3476: AND descriptive_flexfield_name = l_attr_group_metadata_obj.attr_group_type;
3477:
3478: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.HAS_COLUMN_IN_TABLE (p_table_name => l_ext_table_name
3479: ,p_column_name => 'DATA_LEVEL_ID'
3480: )
3481: ) THEN
3482: IF (LENGTH(l_dl_col_names) > 0) THEN

Line 3546: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj);

3542: -- value in its native data type for the query to work) --
3543: ----------------------------------------------------------
3544: IF (l_curr_attr_metadata_obj.VALIDATION_CODE = G_INDEPENDENT_VALIDATION_CODE) THEN
3545:
3546: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj);
3547:
3548: END IF;
3549:
3550: l_aliased_attr_names := l_aliased_attr_names || '(' ||

Line 4165: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);

4161:
4162: -----------------------------------------------------
4163: -- Second, get the Extension Table metadata object --
4164: -----------------------------------------------------
4165: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
4166:
4167: --------------------------------------------------------------
4168: -- Next, start a list of columns on which to use 'Group By' --
4169: --------------------------------------------------------------

Line 4170: l_column_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4166:
4167: --------------------------------------------------------------
4168: -- Next, start a list of columns on which to use 'Group By' --
4169: --------------------------------------------------------------
4170: l_column_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4171: l_ext_table_metadata_obj.pk_column_metadata
4172: ,NULL
4173: ,'NAMES'
4174: ) || ',';

Line 4178: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4174: ) || ',';
4175: IF (l_tl_table_exists = 'Y') THEN
4176: l_column_list := l_column_list || 'LANGUAGE,';
4177: END IF;
4178: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4179: l_ext_table_metadata_obj.data_level_metadata
4180: ,NULL
4181: ,'NAMES'
4182: );

Line 5346: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

5342: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
5343: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
5344: BEGIN
5345: l_attr_group_metadata_obj :=
5346: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
5347: p_application_id => p_application_id
5348: ,p_attr_group_type => p_attr_group_type
5349: ,p_attr_group_name => p_attr_group_name
5350: );

Line 15366: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

15362:
15363: BEGIN
15364:
15365: l_attr_group_metadata_obj :=
15366: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
15367: p_application_id => p_source_appl_id
15368: ,p_attr_group_type => p_source_ag_type
15369: ,p_attr_group_name => p_source_ag_name
15370: ,p_pick_from_cache => FALSE