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.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_USER_ATTRS_COMMON_PVT

Line 165: ERROR_HANDLER.Write_Debug('['||TO_CHAR(SYSDATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)||'] '||p_message);

161: IF (LENGTH(p_message) > 200) THEN
162: Debug_Msg(SUBSTR(p_message, 1, 200), p_level_of_debug);
163: Debug_Msg(SUBSTR(p_message, 201), p_level_of_debug);
164: ELSIF (LENGTH(p_message) > 0) THEN
165: ERROR_HANDLER.Write_Debug('['||TO_CHAR(SYSDATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)||'] '||p_message);
166: END IF;
167: END Debug_Msg;
168:
169: ----------------------------------------------------------------------

Line 330: l_dl_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(x_data_level_id);

326: l_name_value_pair_valid := FALSE;
327: IF x_data_level_id IS NOT NULL THEN
328: -- if the pk's passed satisfy this data_level, call Perform_DML_On_Template_Row
329: Debug_Msg(l_api_name || ' we have valid data_level_id as '|| x_data_level_id,1);
330: l_dl_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(x_data_level_id);
331: IF l_dl_metadata_obj IS NULL THEN
332: Debug_Msg(l_api_name || ' in invalid as we cannot have dl metadata object '|| x_data_level_id,1);
333: l_name_value_pair_valid := FALSE;
334: ELSE

Line 693: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

689: LOOP
690:
691: l_attr_name_value_rec := p_attr_name_value_pairs(l_attrs_index);
692:
693: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
694: p_attr_group_metadata_obj.attr_metadata_table
695: ,l_attr_name_value_rec.ATTR_NAME
696: );
697:

Line 746: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

742: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
743: LOOP
744:
745: l_attr_name_value_rec := p_attr_name_value_pairs(l_attrs_index);
746: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
747: p_attr_group_metadata_obj.attr_metadata_table
748: ,l_attr_name_value_rec.ATTR_NAME
749: );
750: l_curr_augmented_attr_rec.ATTR_GROUP_ID := p_attr_group_metadata_obj.ATTR_GROUP_ID;

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

811: l_db_column_tables_index := TO_NUMBER(SUBSTR(l_db_column_list, l_start_index, l_substring_length));
812:
813: END IF;
814:
815: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj);
816:
817: ----------------------------------------------------------------------
818: -- If this Attribute does not have a Value Set that distinguishes --
819: -- between Internal and Display Values, we just make sure that a --

Line 903: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

899: ----------------------------------------------------------------------
900: -- We know this call will succeed because we checked the PK columns --
901: -- against the metadata in Perform_Preliminary_Checks, above --
902: ----------------------------------------------------------------------
903: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
904: p_ext_table_metadata_obj.pk_column_metadata
905: ,p_pk_column_name_value_pairs
906: ,'EQUALS'
907: ,TRUE);

Line 925: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name

921: ----------------------------------------------------------------------------
922: IF(p_data_level IS NOT NULL
923: AND
924: FND_API.TO_BOOLEAN(
925: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name
926: ,p_column_name => 'DATA_LEVEL_ID'
927: )
928: )
929: ) THEN

Line 961: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,

957: -- we know this call will succeed because we built the array --
958: -- of data level name/value pairs ourselves using metadata. --
959: ---------------------------------------------------------------
960:
961: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
962: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
963:
964: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
965: l_dl_col_mdata_array

Line 964: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

960:
961: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
962: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
963:
964: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
965: l_dl_col_mdata_array
966: ,p_data_level_name_value_pairs
967: ,'EQUALS'
968: ,TRUE

Line 1066: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

1062: px_attr_diffs(j).OLD_ATTR_VALUE_NUM :=
1063: TO_NUMBER(l_retrieved_value);
1064: ELSIF (l_data_type_codes_table(j) = 'X') THEN
1065: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1066: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1067: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1068: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1069: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1070: ELSE

Line 1069: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

1065: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1066: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1067: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1068: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1069: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1070: ELSE
1071: px_attr_diffs(j).OLD_ATTR_VALUE_STR := l_retrieved_value;
1072: END IF;
1073:

Line 1100: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

1096: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_NUM :=
1097: TO_NUMBER(l_retrieved_value);
1098: ELSIF (l_data_type_codes_table(j) = 'X') THEN
1099: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1100: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1101: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1102: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1103: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1104: ELSE

Line 1103: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

1099: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1100: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1101: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1102: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1103: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1104: ELSE
1105: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_STR := l_retrieved_value;
1106: END IF;
1107:

Line 1132: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr

1128:
1129: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
1130: LOOP
1131: l_attr_name_value_rec := p_attr_name_value_pairs(l_attrs_index);
1132: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr
1133: (
1134: p_attr_group_metadata_obj.attr_metadata_table,
1135: l_attr_name_value_rec.ATTR_NAME
1136: );

Line 1574: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(p_data_level_id);

1570: -- to process it accordingly. --
1571: -----------------------------------------------------------------
1572: IF(p_data_level_id IS NOT NULL) THEN
1573:
1574: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(p_data_level_id);
1575: IF(l_data_level_metadata.PK_COLUMN_NAME1 IS NOT NULL) THEN
1576: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);
1577: END IF;
1578:

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

1630:
1631: END IF;
1632: -----------------------------------------------------------------------------R12C end
1633: l_object_id := Get_Object_Id_From_Name(p_object_name);
1634: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
1635: l_data_level_metadata_array := l_ext_table_metadata_obj.data_level_metadata;
1636:
1637: IF (l_data_level_metadata_array IS NOT NULL AND l_data_level_metadata_array(1) IS NOT NULL) THEN
1638: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 1713: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';

1709: -- turn it into a string version of that Date, formatted into --
1710: -- our standard format. --
1711: ----------------------------------------------------------------
1712: l_dynamic_sql := 'SELECT TO_CHAR('||l_formatted_string||', '''||
1713: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
1714: Debug_Msg('In Format_Sysdate_Expression, l_dynamic_sql is as follows:', 3);
1715: Debug_SQL(l_dynamic_sql);
1716: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formatted_string;
1717:

Line 1905: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

1901: ,l_attr_metadata_obj.ATTR_NAME
1902: );
1903: ELSE
1904: l_attr_data_obj := p_attr_name_value_pairs(l_for_loop_index);
1905: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
1906: p_attr_metadata_table => p_attr_metadata_table
1907: ,p_attr_name => l_attr_data_obj.ATTR_NAME
1908: );
1909: END IF;

Line 1982: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

1978:
1979: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
1980:
1981: l_candidate_value := TO_CHAR(TRUNC(l_attr_data_obj.ATTR_VALUE_DATE),
1982: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1983:
1984: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1985:
1986: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_DATE,

Line 1987: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

1983:
1984: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
1985:
1986: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_DATE,
1987: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1988:
1989: END IF;
1990:
1991: ----------------------------------------------------------

Line 2010: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT and that

2006: /***
2007: ASSUMPTIONS:
2008: 1). the UI validates that Number default values with UOM are in the UOM base
2009: 2). the UI validates that Date default values are in
2010: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT and that
2011: Standard Date default values are truncated appropriately
2012: ***/
2013:
2014: l_candidate_value := l_default_value;

Line 2073: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

2069: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2070: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2071:
2072: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2073: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2074:
2075: END IF;
2076:
2077: FND_DSQL.Add_Text(p_separator);

Line 2200: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name

2196: --------------------------------------------------------------
2197: IF(p_data_level IS NOT NULL
2198: AND
2199: FND_API.TO_BOOLEAN(
2200: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name
2201: ,p_column_name => 'DATA_LEVEL_ID'
2202: )
2203: )
2204: ) THEN

Line 2214: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');

2210: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
2211: Add_Bind(p_value => l_data_level_id);
2212: END IF;
2213:
2214: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');
2215: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2216: p_ext_table_metadata_obj.pk_column_metadata
2217: ,p_pk_column_name_value_pairs
2218: ,'EQUALS'

Line 2215: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

2211: Add_Bind(p_value => l_data_level_id);
2212: END IF;
2213:
2214: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');
2215: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2216: p_ext_table_metadata_obj.pk_column_metadata
2217: ,p_pk_column_name_value_pairs
2218: ,'EQUALS'
2219: ,TRUE

Line 2223: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');

2219: ,TRUE
2220: ,' AND '
2221: );
2222:
2223: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');
2224: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2225: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2226:
2227: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');

Line 2224: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,

2220: ,' AND '
2221: );
2222:
2223: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');
2224: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2225: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2226:
2227: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');
2228: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

Line 2227: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');

2223: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');
2224: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2225: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2226:
2227: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');
2228: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2229: l_dl_col_mdata_array
2230: ,p_data_level_name_value_pairs
2231: ,'EQUALS'

Line 2228: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

2224: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2225: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2226:
2227: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');
2228: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2229: l_dl_col_mdata_array
2230: ,p_data_level_name_value_pairs
2231: ,'EQUALS'
2232: ,TRUE

Line 2270: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

2266: l_attr_data_index := px_attr_name_value_pairs.FIRST;
2267: WHILE (l_attr_data_index <= px_attr_name_value_pairs.LAST)
2268: LOOP
2269:
2270: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
2271: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
2272: ,p_attr_name => px_attr_name_value_pairs(l_attr_data_index).ATTR_NAME
2273: );
2274:

Line 2482: l_replacement_attr_metadata := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

2478: -----------------------------------------
2479: -- Find the metadata for the Attribute --
2480: -- whose value will replace the token --
2481: -----------------------------------------
2482: l_replacement_attr_metadata := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
2483: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
2484: ,p_attr_name => l_source_of_replacement
2485: );
2486:

Line 2551: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

2547:
2548: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2549: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2550:
2551: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2552:
2553: END IF;
2554:
2555: -----------------------------------------------------------------------

Line 2844: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

2840:
2841: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2842: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2843:
2844: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2845:
2846: END IF;
2847:
2848: l_attr_int_value := TRIM(l_attr_int_value);

Line 2897: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(Get_Object_Id_From_Name(p_object_name));

2893: --------------------------------------------------------------------
2894: IF (p_ext_table_metadata_obj IS NOT NULL) THEN
2895: l_ext_table_metadata_obj := p_ext_table_metadata_obj;
2896: ELSE
2897: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(Get_Object_Id_From_Name(p_object_name));
2898: END IF;
2899:
2900: l_attr_disp_value := Tokenized_Val_Set_Query(
2901: p_attr_metadata_obj => p_attr_metadata_obj

Line 3182: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

3178: WHILE (l_table_index <= p_attr_name_value_pairs.LAST)
3179: LOOP
3180: EXIT WHEN (l_uk_attr_values_table.COUNT = l_uk_attrs_count);
3181:
3182: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
3183: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
3184: ,p_attr_name => p_attr_name_value_pairs(l_table_index).ATTR_NAME
3185: );
3186:

Line 3206: ,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

3202: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3203: l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3204:
3205: l_uk_attr_values_table(l_uk_attr_values_table_index) := TO_CHAR(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_DATE
3206: ,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3207:
3208: END IF;
3209:
3210: l_uk_attr_values_table_index := l_uk_attr_values_table_index + 1;

Line 3971: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

3967: l_attr_count := p_attr_name_value_pairs.FIRST;
3968: WHILE (l_attr_count <= p_attr_name_value_pairs.LAST)
3969: LOOP
3970:
3971: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
3972: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
3973: ,p_attr_name => p_attr_name_value_pairs(l_attr_count).ATTR_NAME
3974: );
3975: IF (l_attr_metadata_obj IS NULL OR

Line 4173: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata

4169: -----------------------------------------------------------------
4170: IF (p_data_level IS NOT NULL) THEN
4171:
4172: l_data_level_matched := FALSE;
4173: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata
4174: (p_attr_group_id => p_attr_group_id);
4175: l_enabled_data_level_table := l_attr_group_metadata_obj.ENABLED_DATA_LEVELS;
4176:
4177: FOR i IN l_enabled_data_level_table.FIRST .. l_enabled_data_level_table.LAST

Line 4180: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(

4176:
4177: FOR i IN l_enabled_data_level_table.FIRST .. l_enabled_data_level_table.LAST
4178: LOOP
4179: IF(l_enabled_data_level_table(i).DATA_LEVEL_NAME = p_data_level) THEN
4180: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(
4181: p_data_level_id => l_enabled_data_level_table(i).DATA_LEVEL_ID
4182: );
4183: l_data_level_matched := TRUE;
4184: l_column_matched := TRUE;

Line 4227: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4223: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4224: Add_Bind(p_value => p_attr_group_id);
4225: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4226: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4227: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4228: p_ext_table_metadata_obj.class_code_metadata
4229: ,p_class_code_name_value_pairs
4230: ,'VALUES_ALL_CC'
4231: ,TRUE

Line 4255: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4251: ELSE -- p_data_level IS NULL
4252: --
4253: -- R12 code
4254: --
4255: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4256: p_ext_table_metadata_obj.class_code_metadata
4257: ,p_class_code_name_value_pairs
4258: ,'VALUES_ALL_CC'
4259: ,FALSE

Line 4296: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4292: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4293:
4294: IF (LENGTH(l_cc_value_list) > 0) THEN
4295: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4296: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4297: p_ext_table_metadata_obj.class_code_metadata
4298: ,p_class_code_name_value_pairs
4299: ,'VALUES_ALL_CC'
4300: ,TRUE

Line 4525: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(px_attr_value_obj.ATTR_DISP_VALUE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

4521:
4522: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4523: px_attr_value_obj.ATTR_DISP_VALUE||
4524: ' into ATTR_VALUE_DATE column', 3);
4525: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(px_attr_value_obj.ATTR_DISP_VALUE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
4526:
4527: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
4528: px_attr_value_obj.ATTR_VALUE_DATE IS NULL) THEN
4529:

Line 4533: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(px_attr_value_obj.ATTR_DISP_VALUE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

4529:
4530: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
4531: px_attr_value_obj.ATTR_DISP_VALUE||
4532: ' into ATTR_VALUE_DATE column', 3);
4533: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(px_attr_value_obj.ATTR_DISP_VALUE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
4534:
4535: END IF;
4536: END IF;
4537: END IF;

Line 4664: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

4660: )
4661: ) THEN
4662:
4663: l_value := NVL(TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM),
4664: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
4665:
4666: ELSIF (
4667: (
4668: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE

Line 4680: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

4676: )
4677: ) THEN
4678:
4679: l_value := NVL(p_attr_value_obj.ATTR_VALUE_STR,
4680: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
4681:
4682: ELSIF (
4683: (
4684: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

Line 4781: -- EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT. --

4777: -- that part of the string in order to compare the value. --
4778: -- We also allow Min/Max Values to be expressions of the form --
4779: -- "$SYSDATE$ [+/- {integer}]"; if this value bound string is --
4780: -- in such a form, we turn it into a string in --
4781: -- EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT. --
4782: -----------------------------------------------------------------
4783: IF (INSTR(l_value_bound_string, '.', -1) > 0) THEN
4784: l_value_bound_string := SUBSTR(l_value_bound_string, 1, INSTR(l_value_bound_string, '.') - 1);
4785: ELSIF (INSTR(UPPER(l_value_bound_string), 'SYSDATE') > 0) THEN

Line 4797: p_attr_value_obj.ATTR_VALUE_DATE < TRUNC(TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT))

4793: (
4794: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND
4795: (
4796: p_min_or_max = 'MIN' AND
4797: p_attr_value_obj.ATTR_VALUE_DATE < TRUNC(TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT))
4798: )
4799: )
4800: OR
4801: (

Line 4803: TRUNC(p_attr_value_obj.ATTR_VALUE_DATE) > TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

4799: )
4800: OR
4801: (
4802: p_min_or_max = 'MAX' AND
4803: TRUNC(p_attr_value_obj.ATTR_VALUE_DATE) > TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
4804: )
4805: )
4806: OR
4807: (

Line 4812: p_attr_value_obj.ATTR_VALUE_DATE < TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

4808: (
4809: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
4810: (
4811: p_min_or_max = 'MIN' AND
4812: p_attr_value_obj.ATTR_VALUE_DATE < TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
4813: )
4814: )
4815: OR
4816: (

Line 4818: p_attr_value_obj.ATTR_VALUE_DATE > TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

4814: )
4815: OR
4816: (
4817: p_min_or_max = 'MAX' AND
4818: p_attr_value_obj.ATTR_VALUE_DATE > TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
4819: )
4820: )
4821: ) THEN
4822:

Line 5104: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

5100: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5101:
5102: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5103:
5104: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5105:
5106: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5107:
5108: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

Line 5108: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

5104: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5105:
5106: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5107:
5108: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5109:
5110: END IF;
5111: ELSE
5112:

Line 5388: l_candidate_attr := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5384: l_next_attr_name := TRIM(l_next_attr_name);
5385:
5386: Debug_Msg('In Get_Requested_Attr_Names, trying to add '||l_next_attr_name||' to table', 3);
5387:
5388: l_candidate_attr := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5389: p_attr_metadata_table => p_attr_metadata_table
5390: ,p_attr_name => l_next_attr_name
5391: );
5392:

Line 5476: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5472: l_attr_value_index := px_attr_name_value_pairs.FIRST;
5473: WHILE (l_attr_value_index <= px_attr_name_value_pairs.LAST)
5474: LOOP
5475:
5476: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5477: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
5478: ,p_attr_name => px_attr_name_value_pairs(l_attr_value_index).ATTR_NAME
5479: );
5480:

Line 5516: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

5512: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
5513: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5515: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5516: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5517: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5518: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5519: END IF;
5520: ELSE

Line 5518: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

5514: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5515: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5516: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5517: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5518: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5519: END IF;
5520: ELSE
5521:
5522: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';

Line 5576: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

5572: BEGIN
5573: l_formatted_expression := Format_Sysdate_Expression(px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR);
5574:
5575: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5576: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5577: ELSE
5578: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5579: END IF;
5580:

Line 5578: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

5574:
5575: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5576: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TRUNC(TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5577: ELSE
5578: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_DATE := TO_DATE(l_formatted_expression, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5579: END IF;
5580:
5581: EXCEPTION
5582: WHEN OTHERS THEN

Line 5852: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5848: IF(l_dml_type = 'UPDATE') THEN
5849: WHILE (l_attrs_index <= px_attr_diffs.LAST) LOOP
5850: l_attr_rec.attr_name := px_attr_diffs(l_attrs_index).attr_name;
5851: -- abedajna Bug 6134504 begin
5852: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5853: p_attr_group_metadata_obj.attr_metadata_table
5854: ,l_attr_rec.attr_name );
5855: -- abedajna Bug 6134504 end
5856: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>

Line 5872: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

5868: l_attr_name_val.EXTEND();
5869: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5870: -- abedajna Bug 6134504 begin
5871: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
5872: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5873: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5874: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5875: end if;
5876: -- abedajna Bug 6134504 end

Line 5887: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5883: ELSIF(l_dml_type = 'CREATE') then
5884: WHILE (l_attrs_index <= px_attr_diffs.LAST) LOOP
5885: l_attr_rec.attr_name := px_attr_diffs(l_attrs_index).attr_name;
5886: -- abedajna Bug 6134504 begin
5887: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5888: p_attr_group_metadata_obj.attr_metadata_table
5889: ,l_attr_rec.attr_name );
5890: -- abedajna Bug 6134504 end
5891: IF px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR IS NOT NULL THEN

Line 5899: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

5895: ELSIF px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE IS NOT NULL THEN
5896: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5897: -- abedajna Bug 6134504 begin
5898: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
5899: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5900: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5901: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
5902: end if;
5903: -- abedajna Bug 6134504 end

Line 5918: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5914: ELSIF(l_dml_type = 'DELETE') then
5915: WHILE (l_attrs_index <= px_attr_diffs.LAST) LOOP
5916: l_attr_rec.attr_name := px_attr_diffs(l_attrs_index).attr_name;
5917: -- abedajna Bug 6134504 begin
5918: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5919: p_attr_group_metadata_obj.attr_metadata_table
5920: ,l_attr_rec.attr_name );
5921: -- abedajna Bug 6134504 end
5922: IF px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR IS NOT NULL THEN

Line 5930: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

5926: ELSIF px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE IS NOT NULL THEN
5927: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
5928: -- abedajna Bug 6134504 begin
5929: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp
5930: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5931: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
5932: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
5933: end if;
5934: -- abedajna Bug 6134504 end

Line 6023: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

6019: END IF;--end if if flag enabled
6020: Debug_Msg( l_api_name ||' done ');
6021: EXCEPTION
6022: --- If subscription fails...don't add to the stack, already added in EGO_WF_WRAPPER_PVT
6023: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
6024: raise EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC;
6025:
6026: WHEN OTHERS THEN
6027: DECLARE

Line 6024: raise EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC;

6020: Debug_Msg( l_api_name ||' done ');
6021: EXCEPTION
6022: --- If subscription fails...don't add to the stack, already added in EGO_WF_WRAPPER_PVT
6023: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
6024: raise EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC;
6025:
6026: WHEN OTHERS THEN
6027: DECLARE
6028: l_token_table ERROR_HANDLER.Token_Tbl_Type;

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

6110: -- of the name/value pair arrays match up with the extension --
6111: -- table metadata (again, the Ext Table object we find will --
6112: -- be cached for later use, so asking for it now is OK). --
6113: ---------------------------------------------------------------
6114: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
6115:
6116: Debug_Msg('In Perform_Preliminary_Checks, getting ext table metadata for object ' || l_object_id, 2);
6117:
6118: IF (l_ext_table_metadata_obj IS NULL) THEN

Line 6450: EGO_USER_ATTRS_COMMON_PVT.Reset_Cache_And_Globals();

6446: -- (we only want to do this once per bulkload and once per UI call) --
6447: --------------------------------------------------------------------------
6448: IF (G_NEED_TO_RESET_AG_CACHE) THEN
6449:
6450: EGO_USER_ATTRS_COMMON_PVT.Reset_Cache_And_Globals();
6451: G_ASSOCIATION_DATA_LEVEL_CACHE.DELETE();
6452: G_HIERARCHY_CACHE.DELETE();
6453:
6454: IF (G_BULK_PROCESSING_FLAG) THEN

Line 6706: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') '||

6702: ---------------------------------------------------------------------
6703: IF (p_cast_date_cols_to_char) THEN
6704: IF (l_column_type = 'D') THEN
6705: l_table_column_names_list := l_table_column_names_list||','''||
6706: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') '||
6707: l_column_name;
6708: END IF;
6709: END IF;
6710:

Line 7061: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name

7057: -----------------------------------------------------
7058: IF(p_data_level IS NOT NULL
7059: AND
7060: FND_API.TO_BOOLEAN(
7061: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7062: ,p_column_name => 'DATA_LEVEL_ID'
7063: )
7064: )
7065: ) THEN

Line 7076: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK ');

7072: -- Validate_Row and went straight to Perform_DML_On_Row, then our --
7073: -- assumption that names and values will match up could cause an error. --
7074: --------------------------------------------------------------------------
7075:
7076: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK ');
7077: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7078: p_ext_table_metadata_obj.pk_column_metadata
7079: ,p_pk_column_name_value_pairs
7080: ,'NAMES'

Line 7077: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7073: -- assumption that names and values will match up could cause an error. --
7074: --------------------------------------------------------------------------
7075:
7076: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK ');
7077: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7078: p_ext_table_metadata_obj.pk_column_metadata
7079: ,p_pk_column_name_value_pairs
7080: ,'NAMES'
7081: ,TRUE

Line 7083: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC ');

7079: ,p_pk_column_name_value_pairs
7080: ,'NAMES'
7081: ,TRUE
7082: );
7083: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC ');
7084: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7085: p_ext_table_metadata_obj.class_code_metadata
7086: ,p_class_code_name_value_pairs
7087: ,'NAMES'

Line 7084: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7080: ,'NAMES'
7081: ,TRUE
7082: );
7083: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC ');
7084: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7085: p_ext_table_metadata_obj.class_code_metadata
7086: ,p_class_code_name_value_pairs
7087: ,'NAMES'
7088: ,TRUE

Line 7096: l_dl_col_mdata_array := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,

7092: -- NOTE: if inserting into the pending --
7093: -- table, we don't insert Data Level info --
7094: --------------------------------------------
7095:
7096: l_dl_col_mdata_array := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
7097: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
7098: /***
7099: FOR i IN l_dl_col_mdata_array.FIRST .. l_dl_col_mdata_array.LAST
7100: LOOP

Line 7107: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL ');

7103: ***/
7104: IF (p_data_level_name_value_pairs IS NOT NULL AND
7105: p_data_level_name_value_pairs.COUNT > 0 AND
7106: p_change_obj IS NULL) THEN
7107: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL ');
7108: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7109: l_dl_col_mdata_array
7110: ,p_data_level_name_value_pairs
7111: ,'NAMES'

Line 7108: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7104: IF (p_data_level_name_value_pairs IS NOT NULL AND
7105: p_data_level_name_value_pairs.COUNT > 0 AND
7106: p_change_obj IS NULL) THEN
7107: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL ');
7108: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7109: l_dl_col_mdata_array
7110: ,p_data_level_name_value_pairs
7111: ,'NAMES'
7112: ,TRUE

Line 7168: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name

7164: Debug_Msg(' in insert_row -- p_data_level-'||p_data_level);
7165: IF(p_data_level IS NOT NULL
7166: AND
7167: FND_API.TO_BOOLEAN(
7168: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7169: ,p_column_name => 'DATA_LEVEL_ID'
7170: )
7171: )
7172: ) THEN

Line 7184: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');

7180: END IF;
7181:
7182:
7183: FND_DSQL.Add_Text(', ');
7184: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');
7185: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7186: p_ext_table_metadata_obj.pk_column_metadata
7187: ,p_pk_column_name_value_pairs
7188: ,'VALUES'

Line 7185: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7181:
7182:
7183: FND_DSQL.Add_Text(', ');
7184: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');
7185: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7186: p_ext_table_metadata_obj.pk_column_metadata
7187: ,p_pk_column_name_value_pairs
7188: ,'VALUES'
7189: ,TRUE

Line 7191: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC 2 ');

7187: ,p_pk_column_name_value_pairs
7188: ,'VALUES'
7189: ,TRUE
7190: );
7191: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC 2 ');
7192: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7193: p_ext_table_metadata_obj.class_code_metadata
7194: ,p_class_code_name_value_pairs
7195: ,'VALUES'

Line 7192: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7188: ,'VALUES'
7189: ,TRUE
7190: );
7191: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC 2 ');
7192: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7193: p_ext_table_metadata_obj.class_code_metadata
7194: ,p_class_code_name_value_pairs
7195: ,'VALUES'
7196: ,TRUE

Line 7206: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL 2 ');

7202: --------------------------------------------
7203: IF (p_data_level_name_value_pairs IS NOT NULL AND
7204: p_data_level_name_value_pairs.COUNT > 0 AND
7205: p_change_obj IS NULL) THEN
7206: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL 2 ');
7207: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7208: l_dl_col_mdata_array
7209: ,p_data_level_name_value_pairs
7210: ,'VALUES'

Line 7207: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7203: IF (p_data_level_name_value_pairs IS NOT NULL AND
7204: p_data_level_name_value_pairs.COUNT > 0 AND
7205: p_change_obj IS NULL) THEN
7206: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL 2 ');
7207: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7208: l_dl_col_mdata_array
7209: ,p_data_level_name_value_pairs
7210: ,'VALUES'
7211: ,TRUE

Line 7318: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name

7314: -----------------------------------------------------
7315: IF(p_data_level IS NOT NULL
7316: AND
7317: FND_API.TO_BOOLEAN(
7318: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7319: ,p_column_name => 'DATA_LEVEL_ID'
7320: )
7321: )
7322: ) THEN

Line 7326: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7322: ) THEN
7323: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');
7324: END IF;
7325:
7326: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7327: p_ext_table_metadata_obj.pk_column_metadata
7328: ,p_pk_column_name_value_pairs
7329: ,'NAMES'
7330: ,TRUE

Line 7332: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7328: ,p_pk_column_name_value_pairs
7329: ,'NAMES'
7330: ,TRUE
7331: );
7332: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7333: p_ext_table_metadata_obj.class_code_metadata
7334: ,p_class_code_name_value_pairs
7335: ,'NAMES'
7336: ,TRUE

Line 7342: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7338: );
7339: IF (p_data_level_name_value_pairs IS NOT NULL AND
7340: p_data_level_name_value_pairs.COUNT > 0 AND
7341: p_change_obj IS NULL) THEN
7342: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7343: l_dl_col_mdata_array
7344: ,p_data_level_name_value_pairs
7345: ,'NAMES'
7346: ,TRUE

Line 7391: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name

7387: -----------------------------------------------------
7388: IF(p_data_level IS NOT NULL
7389: AND
7390: FND_API.TO_BOOLEAN(
7391: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7392: ,p_column_name => 'DATA_LEVEL_ID'
7393: )
7394: )
7395: ) THEN

Line 7405: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7401: ,p_value => l_data_level_id);
7402: END IF;
7403:
7404: FND_DSQL.Add_Text(', ');
7405: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7406: p_ext_table_metadata_obj.pk_column_metadata
7407: ,p_pk_column_name_value_pairs
7408: ,'VALUES'
7409: ,TRUE

Line 7411: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7407: ,p_pk_column_name_value_pairs
7408: ,'VALUES'
7409: ,TRUE
7410: );
7411: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7412: p_ext_table_metadata_obj.class_code_metadata
7413: ,p_class_code_name_value_pairs
7414: ,'VALUES'
7415: ,TRUE

Line 7421: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7417: );
7418: IF (p_data_level_name_value_pairs IS NOT NULL AND
7419: p_data_level_name_value_pairs.COUNT > 0 AND
7420: p_change_obj IS NULL) THEN
7421: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7422: l_dl_col_mdata_array
7423: ,p_data_level_name_value_pairs
7424: ,'VALUES'
7425: ,TRUE

Line 7582: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

7578: -----------------------------------------------------------
7579: --Start 4105841
7580: --Checking for Exception raised by preAttribute Change Event
7581: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
7582: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
7583: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
7584: IF FND_API.To_Boolean(p_commit) THEN
7585: ROLLBACK TO insert_row;
7586: END IF;

Line 7583: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');

7579: --Start 4105841
7580: --Checking for Exception raised by preAttribute Change Event
7581: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
7582: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
7583: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
7584: IF FND_API.To_Boolean(p_commit) THEN
7585: ROLLBACK TO insert_row;
7586: END IF;
7587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7893: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name

7889: ----------------------------------------------------------------------------
7890: IF(p_data_level IS NOT NULL
7891: AND
7892: FND_API.TO_BOOLEAN(
7893: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7894: ,p_column_name => 'DATA_LEVEL_ID'
7895: )
7896: )
7897: ) THEN

Line 8023: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name

8019: ----------------------------------------------------------------------------
8020: IF(p_data_level IS NOT NULL
8021: AND
8022: FND_API.TO_BOOLEAN(
8023: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
8024: ,p_column_name => 'DATA_LEVEL_ID'
8025: )
8026: )
8027: ) THEN

Line 8204: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

8200: -----------------------------------------------------------
8201: --Start 4105841
8202: --Checking for Exception raised by preAttribute Change Event
8203: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8204: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8205: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8206:
8207: IF FND_API.To_Boolean(p_commit) THEN
8208: ROLLBACK TO update_row;

Line 8205: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');

8201: --Start 4105841
8202: --Checking for Exception raised by preAttribute Change Event
8203: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8204: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8205: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8206:
8207: IF FND_API.To_Boolean(p_commit) THEN
8208: ROLLBACK TO update_row;
8209: END IF;

Line 8545: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

8541: -----------------------------------------------------------
8542: --Start 4105841
8543: --Checking for Exception raised by preAttribute Change Event
8544: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8545: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8546: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8547:
8548: IF FND_API.To_Boolean(p_commit) THEN
8549: ROLLBACK TO delete_row;

Line 8546: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');

8542: --Start 4105841
8543: --Checking for Exception raised by preAttribute Change Event
8544: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8545: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8546: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8547:
8548: IF FND_API.To_Boolean(p_commit) THEN
8549: ROLLBACK TO delete_row;
8550: END IF;

Line 8677: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

8673: l_attr_value_index := px_attr_name_value_pairs.FIRST;
8674: WHILE (l_attr_value_index <= px_attr_name_value_pairs.LAST)
8675: LOOP
8676:
8677: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
8678: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
8679: ,p_attr_name => px_attr_name_value_pairs(l_attr_value_index).ATTR_NAME
8680: );
8681:

Line 9456: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id

9452: px_object_id := Get_Object_Id_From_Name(p_object_name);
9453: END IF;
9454:
9455: x_attr_group_metadata_obj :=
9456: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id
9457: ,p_application_id
9458: ,p_attr_group_type
9459: ,p_attr_group_name);
9460: Debug_Msg(l_api_name || ' before validations: p_attr_group_id-'||p_attr_group_id||

Line 9521: x_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(px_object_id);

9517: RAISE FND_API.G_EXC_ERROR;
9518:
9519: END IF;
9520:
9521: x_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(px_object_id);
9522: IF (x_ext_table_metadata_obj IS NULL) THEN
9523:
9524: l_token_table.DELETE();
9525: l_token_table(1).TOKEN_NAME := 'OBJECT_NAME';

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

10320: -- (we know both of these calls will succeed because they --
10321: -- were tested in Perform_Preliminary_Checks, above) --
10322: -------------------------------------------------------------
10323: l_object_id := Get_Object_Id_From_Name(p_object_name);
10324: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
10325:
10326: --=======================================================================--
10327: -- Because there might be hundreds of Attribute Groups for which we need --
10328: -- to get data, we can't assume that we could store metadata for each of --

Line 10356: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(l_curr_ag_request_obj.ATTR_GROUP_ID

10352: Debug_Msg(l_api_name || ' ) ');
10353:
10354: -- Get the metadata for this attribute group
10355: l_curr_ag_metadata_obj :=
10356: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(l_curr_ag_request_obj.ATTR_GROUP_ID
10357: ,l_curr_ag_request_obj.APPLICATION_ID
10358: ,l_curr_ag_request_obj.ATTR_GROUP_TYPE
10359: ,l_curr_ag_request_obj.ATTR_GROUP_NAME);
10360:

Line 10362: l_has_data_level_col := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_curr_ag_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID'));

10358: ,l_curr_ag_request_obj.ATTR_GROUP_TYPE
10359: ,l_curr_ag_request_obj.ATTR_GROUP_NAME);
10360:
10361: -- Determine if the EXT table has a data level column
10362: l_has_data_level_col := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_curr_ag_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID'));
10363:
10364:
10365: ----------------------------------------------------------------------
10366: -- Scan the list of enabled data levels, and see if the data level --

Line 10395: l_curr_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(l_curr_data_level_row_obj.data_level_id);

10391: l_curr_data_level_row_obj := l_curr_ag_metadata_obj.ENABLED_DATA_LEVELS(dl_index);
10392:
10393: IF l_curr_data_level_row_obj IS NOT NULL THEN
10394: Debug_Msg(l_api_name || 'Data level metadata found');
10395: l_curr_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(l_curr_data_level_row_obj.data_level_id);
10396: EXIT; -- exit the loop as we found the DL metadata
10397: END IF;
10398: END IF;
10399: END LOOP;

Line 10594: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

10590: ---------------------------------------------------
10591: -- We know this call will succeed because it was --
10592: -- tested in Get_Requested_Attr_Names, above --
10593: ---------------------------------------------------
10594: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
10595: p_attr_metadata_table => l_curr_ag_metadata_obj.attr_metadata_table
10596: ,p_attr_name => l_requested_attr_names_table(l_attr_list_index)
10597: );
10598: Debug_Msg(l_api_name || ' processing attr '|| l_attr_list_index || ' - ' ||l_curr_augmented_attr_rec.ATTR_NAME);

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

10654: -- the exception to this is if an Attr has a Table Value Set --
10655: -- (in which case the Int -> Disp value query may assume the --
10656: -- data type of the database column to be a Date or Number) --
10657: ---------------------------------------------------------------
10658: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj);
10659:
10660: IF (l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY IS NULL) THEN
10661:
10662: ----------------------------------------------------------------------

Line 10816: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

10812: -- we know this call will succeed because we built the array --
10813: -- of data level name/value pairs ourselves using metadata. --
10814: ---------------------------------------------------------------
10815: IF l_has_data_level_col THEN
10816: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
10817: p_col_metadata_array => l_ext_table_metadata_obj.data_level_metadata
10818: ,p_col_name_value_pairs => l_data_level_name_value_pairs
10819: ,p_mode => 'EQUALS'
10820: );

Line 10822: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

10818: ,p_col_name_value_pairs => l_data_level_name_value_pairs
10819: ,p_mode => 'EQUALS'
10820: );
10821: ELSE
10822: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
10823: p_col_metadata_array => l_ext_table_metadata_obj.data_level_metadata
10824: ,p_col_name_value_pairs => l_data_level_name_value_pairs
10825: ,p_mode => 'EQUALS'
10826: );

Line 10893: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

10889: ----------------------------------------------------------------------
10890: -- We know this call will succeed because we checked the PK columns --
10891: -- against the metadata in Perform_Preliminary_Checks, above --
10892: ----------------------------------------------------------------------
10893: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
10894: l_ext_table_metadata_obj.pk_column_metadata
10895: ,p_pk_column_name_value_pairs
10896: ,'EQUALS');
10897: --bug 5494760.get the vl name or the table from the place where we have

Line 12203: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id

12199: l_object_id NUMBER;
12200:
12201: BEGIN
12202:
12203: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id
12204: ,p_application_id
12205: ,p_attr_group_type
12206: ,p_attr_group_name);
12207: BEGIN

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

12212: WHEN OTHERS THEN
12213: NULL;
12214: END;
12215:
12216: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
12217:
12218: l_ext_id := Get_Extension_Id_For_Row(
12219: p_attr_group_metadata_obj => l_attr_group_metadata_obj
12220: ,p_ext_table_metadata_obj => l_ext_table_metadata_obj

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

12675: -- Get the Object ID and Ext Table metadata --
12676: ----------------------------------------------
12677: l_object_id := Get_Object_Id_From_Name(p_object_name);
12678:
12679: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
12680:
12681: -----------------------------------------------------------------
12682: -- Build a DECODE string for the Classification Code Hierarchy --
12683: -----------------------------------------------------------------

Line 12763: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

12759: Add_Bind(p_value => p_template_id);
12760: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');
12761:
12762: -- we assume here that the calling procedure has passed in some class codes
12763: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
12764: l_ext_table_metadata_obj.class_code_metadata
12765: ,p_class_code_name_value_pairs
12766: ,'VALUES_ALL_CC'
12767: ,TRUE

Line 12866: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

12862: Add_Bind(p_value => p_template_id);
12863: FND_DSQL.Add_Text(
12864: ' AND ETA.CLASSIFICATION_CODE IN (');
12865:
12866: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
12867: l_ext_table_metadata_obj.class_code_metadata
12868: ,p_class_code_name_value_pairs
12869: ,'VALUES_ALL_CC'
12870: ,TRUE

Line 13009: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

13005: -- l_attr_group_metadata_obj for the new Attr Group --
13006: ----------------------------------------------------------
13007: IF (l_at_start_of_ag) THEN
13008:
13009: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
13010: p_attr_group_id => l_templ_attr_rec.ATTRIBUTE_GROUP_ID
13011: );
13012:
13013: IF (l_attr_group_metadata_obj IS NULL) THEN

Line 13032: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

13028: END IF;
13029: END IF;
13030: END IF;
13031:
13032: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
13033: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
13034: ,p_attr_id => l_templ_attr_rec.ATTRIBUTE_ID
13035: );
13036:

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

13370: --------------------------------------------------------------------
13371: -- The metadata for all extension tables (though not their names) --
13372: -- will be the same for all group types, so we only query it once --
13373: --------------------------------------------------------------------
13374: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
13375:
13376: ---------------------------------------------------------------------
13377: -- Now we build strings that will be necessary for the rest of the --
13378: -- processing and, like l_ext_table_metadata_obj, won't change --

Line 13572: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

13568: FROM EGO_ATTR_GROUP_TYPES_V
13569: WHERE APPLICATION_ID = p_application_id
13570: AND ATTR_GROUP_TYPE = group_rec.ATTR_GROUP_TYPE;
13571:
13572: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
13573: p_table_name => l_b_table_name
13574: ,p_column_name => 'DATA_LEVEL_ID')
13575: );
13576: IF l_has_data_level_id THEN

Line 13577: l_all_dl_cols := EGO_USER_ATTRS_COMMON_PVT.Get_All_Data_Level_PK_Names

13573: p_table_name => l_b_table_name
13574: ,p_column_name => 'DATA_LEVEL_ID')
13575: );
13576: IF l_has_data_level_id THEN
13577: l_all_dl_cols := EGO_USER_ATTRS_COMMON_PVT.Get_All_Data_Level_PK_Names
13578: (p_application_id => p_application_id
13579: ,p_attr_group_type => l_attr_group_type);
13580: -- l_all_dl_cols are in the format a,b,c
13581: -- this need to be changed as 'a','b','c'

Line 13971: EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);

13967: ---------------------------------------------------------
13968: -- Get the necessary metadata for our production table --
13969: ---------------------------------------------------------
13970: l_ext_table_metadata_obj :=
13971: EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
13972:
13973: ----------------------------------------------------------
13974: -- Build a PK name/value pair array and begin the lists --
13975: -- of column names to fetch explicitly instead of from --

Line 14327: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

14323: ---------------------------------------------------------
14324: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
14325: l_current_column_index := l_current_column_index + 1;
14326: l_attr_group_metadata_obj :=
14327: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
14328: p_attr_group_id => TO_NUMBER(l_retrieved_value)
14329: );
14330:
14331: ---------------------------------------------------------------

Line 14387: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

14383:
14384: ------------------------------------------------------------------------
14385: -- See whether the current column belongs to a User-Defined Attribute --
14386: ------------------------------------------------------------------------
14387: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
14388: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
14389: ,p_db_column_name => l_current_column_name
14390: );
14391:

Line 14425: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));

14421: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_NUM :=
14422: TO_NUMBER(l_retrieved_value);
14423: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'X') THEN
14424: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
14425: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
14426: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
14427: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
14428: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
14429: ELSE

Line 14428: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

14424: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
14425: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
14426: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
14427: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
14428: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
14429: ELSE
14430: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_STR :=
14431: l_retrieved_value;
14432: END IF;

Line 14489: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

14485: -------------------------------------------------------------
14486: IF (l_attr_name_value_pairs IS NOT NULL AND
14487: l_attr_name_value_pairs.COUNT > 0) THEN
14488:
14489: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
14490: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
14491: ,p_db_column_name => l_attr_col_name_for_uom_col
14492: );
14493:

Line 14936: l_db_column_alias := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(p_attr_metadata_obj);

14932: x_str_val := NULL;
14933: x_num_val := NULL;
14934: x_date_val := NULL;
14935:
14936: l_db_column_alias := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(p_attr_metadata_obj);
14937:
14938: l_cursor := DBMS_SQL.OPEN_CURSOR;
14939: l_bind_index := 0;
14940:

Line 15002: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.EXT_TABLE_B_NAME

14998: -- WHERE conditions: Data Level ID, Data Level Primary Keys --
14999: --------------------------------------------------------------
15000:
15001: l_has_data_level_id := FND_API.TO_BOOLEAN(
15002: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.EXT_TABLE_B_NAME
15003: ,p_column_name => 'DATA_LEVEL_ID')
15004: );
15005:
15006: IF p_data_level IS NOT NULL AND l_has_data_level_id THEN

Line 15015: l_dl_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(p_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_id);

15011: FOR dl_index IN p_attr_group_metadata_obj.ENABLED_DATA_LEVELS.FIRST .. p_attr_group_metadata_obj.ENABLED_DATA_LEVELS.LAST
15012: LOOP
15013:
15014: IF p_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_name = p_data_level THEN
15015: l_dl_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(p_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_id);
15016: Debug_Msg(l_api_name || ' Data level found, exiting loop.');
15017: -- exit the loop as we found the DL
15018: EXIT;
15019: END IF;

Line 15124: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

15120: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
15121: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);
15122: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15123: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
15124: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15125: ELSE
15126: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
15127: END IF;
15128: END IF;

Line 15217: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

15213: -----------------------------------------
15214: -- Get or build the necessary metadata --
15215: -----------------------------------------
15216: l_attr_group_metadata_obj :=
15217: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
15218: p_application_id => p_appl_id
15219: ,p_attr_group_type => p_attr_grp_type
15220: ,p_attr_group_name => p_attr_grp_name
15221: );

Line 15224: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

15220: ,p_attr_group_name => p_attr_grp_name
15221: );
15222:
15223: l_attr_metadata_table := l_attr_group_metadata_obj.attr_metadata_table;
15224: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
15225: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
15226: ,p_attr_name => p_attr_name
15227: );
15228:

Line 15261: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_attr_group_metadata_obj.EXT_TABLE_B_NAME

15257: IF p_data_level IS NOT NULL THEN
15258: -- check if the passed in data level is valid for this attribute group.
15259: Debug_Msg(l_api_name || ' Non-null data level');
15260: l_has_data_level_id := FND_API.TO_BOOLEAN(
15261: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_attr_group_metadata_obj.EXT_TABLE_B_NAME
15262: ,p_column_name => 'DATA_LEVEL_ID')
15263: );
15264: IF l_has_data_level_id THEN
15265: l_curr_data_level_row_obj := NULL;

Line 15283: l_curr_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_id);

15279: Debug_Msg(l_api_name || ' enabled data level: ' ||
15280: l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_name || '(' ||
15281: l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_id || ')');
15282: IF l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_name = p_data_level THEN
15283: l_curr_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_id);
15284: Debug_Msg(l_api_name || ' Found Data Level, finished searching.');
15285: EXIT;
15286: END IF;
15287: END LOOP;

Line 15407: l_attr_int_value := TO_CHAR(l_temp_date,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

15403: ELSIF (l_temp_num IS NOT NULL) THEN
15404: l_attr_int_value := TO_CHAR(l_temp_num);
15405: ELSIF (l_temp_date IS NOT NULL) THEN
15406: --bug 5094087
15407: l_attr_int_value := TO_CHAR(l_temp_date,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15408: END IF;
15409:
15410: ----------------------------------------------------------
15411: -- At this point I have the internal value; if the Attr --

Line 15494: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(

15490: IF ( l_attr_metadata_obj.DATA_TYPE_CODE IN
15491: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15492: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
15493: THEN
15494: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15495: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
15496: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
15497: ,x_return_status =>l_return_status
15498: ,x_msg_count =>l_msg_count

Line 15495: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

15491: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15492: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
15493: THEN
15494: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15495: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
15496: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
15497: ,x_return_status =>l_return_status
15498: ,x_msg_count =>l_msg_count
15499: ,x_msg_data =>l_msg_data

Line 15517: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(

15513: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
15514: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15515: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
15516: THEN
15517: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15518: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
15519: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
15520: ,x_return_status =>l_return_status
15521: ,x_msg_count =>l_msg_count

Line 15518: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)

15514: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
15515: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
15516: THEN
15517: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
15518: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
15519: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
15520: ,x_return_status =>l_return_status
15521: ,x_msg_count =>l_msg_count
15522: ,x_msg_data =>l_msg_data

Line 15631: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata

15627:
15628: Debug_Msg('In Update_Attributes, retrieved l_object_id as '||l_object_id, 2);
15629: Debug_Msg('In Update_Attributes, getting AG metadata for '||p_attr_group_id, 2);
15630:
15631: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata
15632: ( p_attr_group_id => p_attr_group_id );
15633:
15634: Debug_Msg('In Update_Attributes, got AG metadata: '||
15635: l_attr_group_metadata_obj.attr_group_id||','||

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

15638: l_attr_group_metadata_obj.attr_group_name||','||
15639: l_attr_group_metadata_obj.attr_group_disp_name
15640: , 2);
15641:
15642: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
15643: Convert_Attr_Diff_To_Data(p_attr_diffs, l_old_attr_name_value_pairs, FALSE, l_is_delete, x_error_message);
15644: Convert_Attr_Diff_To_Data(p_attr_diffs, l_new_attr_name_value_pairs, TRUE, l_is_delete, x_error_message);
15645:
15646: Debug_Msg('In Update_Attributes, got AG and ext table objs, getting ext id ');

Line 15782: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata

15778:
15779: Debug_Msg('In Get_Attr_Diffs, starting');
15780:
15781: -- get list of attributes in this group
15782: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata
15783: ( p_attr_group_id
15784: , p_application_id
15785: , p_attr_group_type
15786: , p_attr_group_name

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

15811: END LOOP;
15812:
15813: -- get other objects necessary for Get_Change_Attrs call
15814: l_object_id := Get_Object_Id_From_Name(p_object_name);
15815: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
15816:
15817: -- call Get_Changed_Attrs to get diffs as output
15818: Get_Changed_Attributes(
15819: p_dml_operation => 'UPDATE'

Line 15921: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

15917: ,null
15918: ,null
15919: );
15920:
15921: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
15922: p_attr_group_id => NULL
15923: ,p_application_id => p_application_id
15924: ,p_attr_group_type => p_attr_group_type
15925: ,p_attr_group_name => p_attr_group_int_name

Line 15929: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_attr_group_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID')) THEN

15925: ,p_attr_group_name => p_attr_group_int_name
15926: );
15927:
15928: --todo: why is this here?
15929: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_attr_group_metadata_obj.EXT_TABLE_B_NAME, 'DATA_LEVEL_ID')) THEN
15930: -- data level exists
15931: NULL;
15932: END IF;
15933:

Line 16037: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

16033: ,p_attr_disp_value
16034: ,null
16035: ,null
16036: );
16037: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
16038: p_attr_group_id => NULL
16039: ,p_application_id => p_application_id
16040: ,p_attr_group_type => p_attr_group_type
16041: ,p_attr_group_name => p_attr_group_int_name

Line 16072: RETURN TO_CHAR(TO_DATE(p_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

16068: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
16069: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16070: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16071: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16072: RETURN TO_CHAR(TO_DATE(p_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16073: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16074: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
16075: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
16076: RETURN p_attr_disp_value;

Line 16135: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(Get_Object_Id_From_Name(p_object_name));

16131:
16132: IF (p_ext_table_metadata_obj IS NOT NULL) THEN
16133: l_ext_table_metadata_obj := p_ext_table_metadata_obj;
16134: ELSE
16135: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(Get_Object_Id_From_Name(p_object_name));
16136: END IF;
16137:
16138:
16139: l_attr_internal_value := Get_Int_Val_For_Disp_Val(

Line 16161: l_attr_internal_value := TO_CHAR(TO_DATE(l_attr_internal_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

16157: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
16158: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
16159: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
16160: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
16161: l_attr_internal_value := TO_CHAR(TO_DATE(l_attr_internal_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT),EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16162: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
16163: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
16164: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
16165: l_attr_internal_value := l_attr_internal_value;

Line 17255: l_ag_id_col_exists := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

17251: -------------------------------------------------------------
17252: -- Find out weather the ATTR_GROUP_ID column exists in the --
17253: -- table where attribute data is to be uploaded or not --
17254: -------------------------------------------------------------
17255: l_ag_id_col_exists := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
17256: p_table_name => l_ext_b_table_name
17257: ,p_column_name => 'ATTR_GROUP_ID')
17258: );
17259:

Line 17260: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

17256: p_table_name => l_ext_b_table_name
17257: ,p_column_name => 'ATTR_GROUP_ID')
17258: );
17259:
17260: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
17261: p_table_name => l_ext_b_table_name
17262: ,p_column_name => 'DATA_LEVEL_ID')
17263: );
17264:

Line 17446: l_date_val := TO_DATE(l_attr_record.DEFAULT_VALUE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

17442: l_temp_date_str := REPLACE(UPPER(l_attr_record.DEFAULT_VALUE),'$'); --bugfix:5228308
17443: EXECUTE IMMEDIATE 'SELECT '||l_temp_date_str||' FROM DUAL '
17444: INTO l_date_val;
17445: ELSE
17446: l_date_val := TO_DATE(l_attr_record.DEFAULT_VALUE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
17447: END IF;
17448: END IF;
17449:
17450: IF (l_attr_record.REQUIRED_FLAG = 'Y' AND l_attr_record.DEFAULT_VALUE IS NULL) THEN