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 189: ERROR_HANDLER.Write_Debug('['||TO_CHAR(SYSDATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)||'] '||p_message);

185: IF (LENGTH(p_message) > 200) THEN
186: Debug_Msg(SUBSTR(p_message, 1, 200), p_level_of_debug);
187: Debug_Msg(SUBSTR(p_message, 201), p_level_of_debug);
188: ELSIF (LENGTH(p_message) > 0) THEN
189: ERROR_HANDLER.Write_Debug('['||TO_CHAR(SYSDATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)||'] '||p_message);
190: -- dbms_output.put_line(p_message);
191: END IF;
192: END Debug_Msg;
193:

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

426: l_name_value_pair_valid := FALSE;
427: IF x_data_level_id IS NOT NULL THEN
428: -- if the pk's passed satisfy this data_level, call Perform_DML_On_Template_Row
429: Debug_Msg(l_api_name || ' we have valid data_level_id as '|| x_data_level_id,1);
430: l_dl_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(x_data_level_id);
431: IF l_dl_metadata_obj IS NULL THEN
432: Debug_Msg(l_api_name || ' in invalid as we cannot have dl metadata object '|| x_data_level_id,1);
433: l_name_value_pair_valid := FALSE;
434: ELSE

Line 793: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

789: LOOP
790:
791: l_attr_name_value_rec := p_attr_name_value_pairs(l_attrs_index);
792:
793: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
794: p_attr_group_metadata_obj.attr_metadata_table
795: ,l_attr_name_value_rec.ATTR_NAME
796: );
797:

Line 846: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

842: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
843: LOOP
844:
845: l_attr_name_value_rec := p_attr_name_value_pairs(l_attrs_index);
846: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
847: p_attr_group_metadata_obj.attr_metadata_table
848: ,l_attr_name_value_rec.ATTR_NAME
849: );
850: l_curr_augmented_attr_rec.ATTR_GROUP_ID := p_attr_group_metadata_obj.ATTR_GROUP_ID;

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

911: l_db_column_tables_index := TO_NUMBER(SUBSTR(l_db_column_list, l_start_index, l_substring_length));
912:
913: END IF;
914:
915: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj);
916:
917: ----------------------------------------------------------------------
918: -- If this Attribute does not have a Value Set that distinguishes --
919: -- between Internal and Display Values, we just make sure that a --

Line 1003: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

999: ----------------------------------------------------------------------
1000: -- We know this call will succeed because we checked the PK columns --
1001: -- against the metadata in Perform_Preliminary_Checks, above --
1002: ----------------------------------------------------------------------
1003: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
1004: p_ext_table_metadata_obj.pk_column_metadata
1005: ,p_pk_column_name_value_pairs
1006: ,'EQUALS'
1007: ,TRUE);

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

1021: ----------------------------------------------------------------------------
1022: IF(p_data_level IS NOT NULL
1023: AND
1024: FND_API.TO_BOOLEAN(
1025: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.ext_table_vl_name
1026: ,p_column_name => 'DATA_LEVEL_ID'
1027: )
1028: )
1029: ) THEN

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

1057: -- we know this call will succeed because we built the array --
1058: -- of data level name/value pairs ourselves using metadata. --
1059: ---------------------------------------------------------------
1060:
1061: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
1062: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
1063:
1064: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
1065: l_dl_col_mdata_array

Line 1064: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

1060:
1061: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
1062: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
1063:
1064: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
1065: l_dl_col_mdata_array
1066: ,p_data_level_name_value_pairs
1067: ,'EQUALS'
1068: ,TRUE

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

1162: px_attr_diffs(j).OLD_ATTR_VALUE_NUM :=
1163: TO_NUMBER(l_retrieved_value);
1164: ELSIF (l_data_type_codes_table(j) = 'X') THEN
1165: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1166: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1167: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1168: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1169: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1170: ELSE

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

1165: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1166: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1167: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1168: px_attr_diffs(j).OLD_ATTR_VALUE_DATE :=
1169: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1170: ELSE
1171: px_attr_diffs(j).OLD_ATTR_VALUE_STR := l_retrieved_value;
1172: END IF;
1173:

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

1196: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_NUM :=
1197: TO_NUMBER(l_retrieved_value);
1198: ELSIF (l_data_type_codes_table(j) = 'X') THEN
1199: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1200: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1201: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1202: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1203: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1204: ELSE

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

1199: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1200: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
1201: ELSIF (l_data_type_codes_table(j) = 'Y') THEN
1202: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_DATE :=
1203: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
1204: ELSE
1205: px_attr_diffs(px_attr_diffs.LAST).OLD_ATTR_VALUE_STR := l_retrieved_value;
1206: END IF;
1207:

Line 1232: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr

1228:
1229: WHILE (l_attrs_index <= p_attr_name_value_pairs.LAST)
1230: LOOP
1231: l_attr_name_value_rec := p_attr_name_value_pairs(l_attrs_index);
1232: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr
1233: (
1234: p_attr_group_metadata_obj.attr_metadata_table,
1235: l_attr_name_value_rec.ATTR_NAME
1236: );

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

1713: -- to process it accordingly. --
1714: -----------------------------------------------------------------
1715: IF(p_data_level_id IS NOT NULL) THEN
1716:
1717: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(p_data_level_id);
1718: IF(l_data_level_metadata.PK_COLUMN_NAME1 IS NOT NULL) THEN
1719: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(l_data_level_metadata.PK_COLUMN_NAME1,p_data_level_1);
1720: END IF;
1721:

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

1777:
1778: END IF;
1779: -----------------------------------------------------------------------------R12C end
1780: l_object_id := Get_Object_Id_From_Name(p_object_name);
1781: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
1782: l_data_level_metadata_array := l_ext_table_metadata_obj.data_level_metadata;
1783:
1784: IF (l_data_level_metadata_array IS NOT NULL AND l_data_level_metadata_array(1) IS NOT NULL) THEN
1785: l_data_level_1_name_value_pair := EGO_COL_NAME_VALUE_PAIR_OBJ(

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

1856: -- turn it into a string version of that Date, formatted into --
1857: -- our standard format. --
1858: ----------------------------------------------------------------
1859: l_dynamic_sql := 'SELECT TO_CHAR('||l_formatted_string||', '''||
1860: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') FROM DUAL';
1861: Debug_Msg('In Format_Sysdate_Expression, l_dynamic_sql is as follows:', 3);
1862: Debug_SQL(l_dynamic_sql);
1863: EXECUTE IMMEDIATE l_dynamic_sql INTO l_formatted_string;
1864:

Line 2052: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

2048: ,l_attr_metadata_obj.ATTR_NAME
2049: );
2050: ELSE
2051: l_attr_data_obj := p_attr_name_value_pairs(l_for_loop_index);
2052: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
2053: p_attr_metadata_table => p_attr_metadata_table
2054: ,p_attr_name => l_attr_data_obj.ATTR_NAME
2055: );
2056: END IF;

Line 2129: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

2125:
2126: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
2127:
2128: l_candidate_value := TO_CHAR(TRUNC(l_attr_data_obj.ATTR_VALUE_DATE),
2129: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2130:
2131: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2132:
2133: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_DATE,

Line 2134: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

2130:
2131: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2132:
2133: l_candidate_value := TO_CHAR(l_attr_data_obj.ATTR_VALUE_DATE,
2134: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2135:
2136: END IF;
2137:
2138: ----------------------------------------------------------

Line 2157: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT and that

2153: /***
2154: ASSUMPTIONS:
2155: 1). the UI validates that Number default values with UOM are in the UOM base
2156: 2). the UI validates that Date default values are in
2157: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT and that
2158: Standard Date default values are truncated appropriately
2159: ***/
2160:
2161: l_candidate_value := l_default_value;

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

2218: ELSIF (l_data_type = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2219: l_data_type = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2220:
2221: Add_Bind(p_bind_identifier => l_attr_metadata_obj.ATTR_GROUP_NAME||'$$'||l_attr_metadata_obj.ATTR_NAME
2222: ,p_value => TO_DATE(l_candidate_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2223:
2224: END IF;
2225:
2226: FND_DSQL.Add_Text(p_separator);

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

2431: FND_DSQL.Add_Text(' AND DATA_LEVEL_ID = ');
2432: Add_Bind(p_value => l_data_level_id);
2433: END IF;
2434:
2435: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');
2436: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2437: p_ext_table_metadata_obj.pk_column_metadata
2438: ,p_pk_column_name_value_pairs
2439: ,'EQUALS'

Line 2436: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

2432: Add_Bind(p_value => l_data_level_id);
2433: END IF;
2434:
2435: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for pk ');
2436: l_pk_col_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2437: p_ext_table_metadata_obj.pk_column_metadata
2438: ,p_pk_column_name_value_pairs
2439: ,'EQUALS'
2440: ,TRUE

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

2440: ,TRUE
2441: ,' AND '
2442: );
2443:
2444: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');
2445: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2446: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2447:
2448: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');

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

2441: ,' AND '
2442: );
2443:
2444: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');
2445: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2446: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2447:
2448: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');
2449: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

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

2444: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array ');
2445: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2446: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2447:
2448: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');
2449: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2450: l_dl_col_mdata_array
2451: ,p_data_level_name_value_pairs
2452: ,'EQUALS'

Line 2449: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

2445: l_dl_col_mdata_array:= EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
2446: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
2447:
2448: Debug_Msg(l_api_name ||' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for data level ');
2449: l_data_level_string := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
2450: l_dl_col_mdata_array
2451: ,p_data_level_name_value_pairs
2452: ,'EQUALS'
2453: ,TRUE

Line 2491: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

2487: l_attr_data_index := px_attr_name_value_pairs.FIRST;
2488: WHILE (l_attr_data_index <= px_attr_name_value_pairs.LAST)
2489: LOOP
2490:
2491: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
2492: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
2493: ,p_attr_name => px_attr_name_value_pairs(l_attr_data_index).ATTR_NAME
2494: );
2495:

Line 2703: l_replacement_attr_metadata := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

2699: -----------------------------------------
2700: -- Find the metadata for the Attribute --
2701: -- whose value will replace the token --
2702: -----------------------------------------
2703: l_replacement_attr_metadata := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
2704: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
2705: ,p_attr_name => l_source_of_replacement
2706: );
2707:

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

2769:
2770: ELSIF (l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
2771: l_replacement_attr_metadata.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
2772:
2773: l_token_replacement := TO_CHAR(l_replacement_attr_data.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2774:
2775: END IF;
2776:
2777: -----------------------------------------------------------------------

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

3068:
3069: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR
3070: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
3071:
3072: l_attr_int_value := TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3073:
3074: END IF;
3075:
3076: l_attr_int_value := TRIM(l_attr_int_value);

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

3135: --------------------------------------------------------------------
3136: IF (p_ext_table_metadata_obj IS NOT NULL) THEN
3137: l_ext_table_metadata_obj := p_ext_table_metadata_obj;
3138: ELSE
3139: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(Get_Object_Id_From_Name(p_object_name));
3140: END IF;
3141:
3142: l_attr_disp_value := Tokenized_Val_Set_Query(
3143: p_attr_metadata_obj => p_attr_metadata_obj

Line 3486: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table,

3482:
3483:
3484:
3485: IF (INSTR(UPPER(l_dynamic_query), ':$') > 0) THEN
3486: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table,
3487: p_attr_name => p_attr_name_value_pairs(l_table_index)
3488: .ATTR_NAME);
3489:
3490: l_display_value := Tokenized_Val_Set_Query(p_attr_metadata_obj => l_attr_metadata_obj,

Line 3512: l_attr_value_date :=To_char(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_DATE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

3508: END IF;
3509: ELSE -- Translatable Independent Validation Type
3510: IF p_attr_name_value_pairs(l_table_index).ATTR_VALUE_DATE IS NOT NULL THEN
3511:
3512: l_attr_value_date :=To_char(p_attr_name_value_pairs(l_table_index).ATTR_VALUE_DATE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3513:
3514: SELECT
3515: display_name INTO l_disp_value(l_table_index)
3516: FROM ego_value_set_values_v

Line 3584: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

3580: WHILE (l_table_index <= p_attr_name_value_pairs.LAST)
3581: LOOP
3582: EXIT WHEN (l_uk_attr_values_table.COUNT = l_uk_attrs_count);
3583:
3584: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
3585: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
3586: ,p_attr_name => p_attr_name_value_pairs(l_table_index).ATTR_NAME
3587: );
3588:

Line 4422: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

4418: l_attr_count := p_attr_name_value_pairs.FIRST;
4419: WHILE (l_attr_count <= p_attr_name_value_pairs.LAST)
4420: LOOP
4421:
4422: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
4423: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
4424: ,p_attr_name => p_attr_name_value_pairs(l_attr_count).ATTR_NAME
4425: );
4426: IF (l_attr_metadata_obj IS NULL OR

Line 4636: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata

4632: -----------------------------------------------------------------
4633: IF (p_data_level IS NOT NULL) THEN
4634:
4635: l_data_level_matched := FALSE;
4636: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata
4637: (p_attr_group_id => p_attr_group_id);
4638: l_enabled_data_level_table := l_attr_group_metadata_obj.ENABLED_DATA_LEVELS;
4639:
4640: FOR i IN l_enabled_data_level_table.FIRST .. l_enabled_data_level_table.LAST

Line 4643: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(

4639:
4640: FOR i IN l_enabled_data_level_table.FIRST .. l_enabled_data_level_table.LAST
4641: LOOP
4642: IF(l_enabled_data_level_table(i).DATA_LEVEL_NAME = p_data_level) THEN
4643: l_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.get_data_level_metadata(
4644: p_data_level_id => l_enabled_data_level_table(i).DATA_LEVEL_ID
4645: );
4646: l_data_level_matched := TRUE;
4647: l_column_matched := TRUE;

Line 4690: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4687: Add_Bind(p_value => p_attr_group_id);
4688: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4689: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4690: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4691: p_ext_table_metadata_obj.class_code_metadata
4692: ,p_class_code_name_value_pairs
4693: ,'VALUES_ALL_CC'
4694: ,TRUE

Line 4721: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4717: ELSE -- p_data_level IS NULL
4718: --
4719: -- R12 code
4720: --
4721: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4722: p_ext_table_metadata_obj.class_code_metadata
4723: ,p_class_code_name_value_pairs
4724: ,'VALUES_ALL_CC'
4725: ,FALSE

Line 4762: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

4758: FND_DSQL.Add_Text(' AND ROWNUM = 1');
4759:
4760: IF (LENGTH(l_cc_value_list) > 0) THEN
4761: FND_DSQL.Add_Text(' AND CLASSIFICATION_CODE IN (');
4762: l_cc_value_list := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
4763: p_ext_table_metadata_obj.class_code_metadata
4764: ,p_class_code_name_value_pairs
4765: ,'VALUES_ALL_CC'
4766: ,TRUE

Line 5011: 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));

5007:
5008: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
5009: px_attr_value_obj.ATTR_DISP_VALUE||
5010: ' into ATTR_VALUE_DATE column', 3);
5011: 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));
5012:
5013: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
5014: px_attr_value_obj.ATTR_VALUE_DATE IS NULL) THEN
5015:

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

5015:
5016: Debug_Msg('In Disp_Val_Replacement_Is_Bad, putting '||
5017: px_attr_value_obj.ATTR_DISP_VALUE||
5018: ' into ATTR_VALUE_DATE column', 3);
5019: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(px_attr_value_obj.ATTR_DISP_VALUE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5020:
5021: END IF;
5022: END IF;
5023: END IF;

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

5146: )
5147: ) THEN
5148:
5149: l_value := NVL(TO_CHAR(p_attr_value_obj.ATTR_VALUE_NUM),
5150: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5151:
5152: ELSIF (
5153: (
5154: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE

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

5162: )
5163: ) THEN
5164:
5165: l_value := NVL(p_attr_value_obj.ATTR_VALUE_STR,
5166: TO_CHAR(p_attr_value_obj.ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5167:
5168: ELSIF (
5169: (
5170: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE OR

Line 5267: -- EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT. --

5263: -- that part of the string in order to compare the value. --
5264: -- We also allow Min/Max Values to be expressions of the form --
5265: -- "$SYSDATE$ [+/- {integer}]"; if this value bound string is --
5266: -- in such a form, we turn it into a string in --
5267: -- EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT. --
5268: -----------------------------------------------------------------
5269: IF (INSTR(l_value_bound_string, '.', -1) > 0) THEN
5270: l_value_bound_string := SUBSTR(l_value_bound_string, 1, INSTR(l_value_bound_string, '.') - 1);
5271: ELSIF (INSTR(UPPER(l_value_bound_string), 'SYSDATE') > 0) THEN

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

5279: (
5280: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE AND
5281: (
5282: p_min_or_max = 'MIN' AND
5283: p_attr_value_obj.ATTR_VALUE_DATE < TRUNC(TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT))
5284: )
5285: )
5286: OR
5287: (

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

5285: )
5286: OR
5287: (
5288: p_min_or_max = 'MAX' AND
5289: TRUNC(p_attr_value_obj.ATTR_VALUE_DATE) > TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
5290: )
5291: )
5292: OR
5293: (

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

5294: (
5295: p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE AND
5296: (
5297: p_min_or_max = 'MIN' AND
5298: p_attr_value_obj.ATTR_VALUE_DATE < TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
5299: )
5300: )
5301: OR
5302: (

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

5300: )
5301: OR
5302: (
5303: p_min_or_max = 'MAX' AND
5304: p_attr_value_obj.ATTR_VALUE_DATE > TO_DATE(l_value_bound_string, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
5305: )
5306: )
5307: ) THEN
5308:

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

5595: px_attr_value_obj.ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
5596:
5597: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
5598:
5599: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5600:
5601: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5602:
5603: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

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

5599: px_attr_value_obj.ATTR_VALUE_DATE := TRUNC(TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5600:
5601: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
5602:
5603: px_attr_value_obj.ATTR_VALUE_DATE := TO_DATE(l_int_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5604:
5605: END IF;
5606: ELSE
5607:

Line 5883: l_candidate_attr := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5879: l_next_attr_name := TRIM(l_next_attr_name);
5880:
5881: Debug_Msg('In Get_Requested_Attr_Names, trying to add '||l_next_attr_name||' to table', 3);
5882:
5883: l_candidate_attr := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5884: p_attr_metadata_table => p_attr_metadata_table
5885: ,p_attr_name => l_next_attr_name
5886: );
5887:

Line 5971: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5967: l_attr_value_index := px_attr_name_value_pairs.FIRST;
5968: WHILE (l_attr_value_index <= px_attr_name_value_pairs.LAST)
5969: LOOP
5970:
5971: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5972: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
5973: ,p_attr_name => px_attr_name_value_pairs(l_attr_value_index).ATTR_NAME
5974: );
5975:

Line 6011: 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));

6007: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR := l_int_value;
6008: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_NUMBER_DATA_TYPE) THEN
6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6011: 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));
6012: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
6013: 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);
6014: END IF;
6015: ELSE

Line 6013: 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);

6009: px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_NUM := TO_NUMBER(l_int_value);
6010: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6011: 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));
6012: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) THEN
6013: 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);
6014: END IF;
6015: ELSE
6016:
6017: l_err_msg_name := 'EGO_EF_INDEPENDENT_VS_VIOLATED';

Line 6071: 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));

6067: BEGIN
6068: l_formatted_expression := Format_Sysdate_Expression(px_attr_name_value_pairs(l_attr_value_index).ATTR_VALUE_STR);
6069:
6070: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6071: 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));
6072: ELSE
6073: 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);
6074: END IF;
6075:

Line 6073: 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);

6069:
6070: IF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) THEN
6071: 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));
6072: ELSE
6073: 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);
6074: END IF;
6075:
6076: EXCEPTION
6077: WHEN OTHERS THEN

Line 6347: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

6343: IF(l_dml_type = 'UPDATE') THEN
6344: WHILE (l_attrs_index <= px_attr_diffs.LAST) LOOP
6345: l_attr_rec.attr_name := px_attr_diffs(l_attrs_index).attr_name;
6346: -- abedajna Bug 6134504 begin
6347: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
6348: p_attr_group_metadata_obj.attr_metadata_table
6349: ,l_attr_rec.attr_name );
6350: -- abedajna Bug 6134504 end
6351: IF(NVL(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR,FND_API.G_MISS_CHAR)<>

Line 6367: 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);

6363: l_attr_name_val.EXTEND();
6364: -- l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6365: -- abedajna Bug 6134504 begin
6366: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
6367: 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);
6368: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6369: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6370: end if;
6371: -- abedajna Bug 6134504 end

Line 6382: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

6378: ELSIF(l_dml_type = 'CREATE') then
6379: WHILE (l_attrs_index <= px_attr_diffs.LAST) LOOP
6380: l_attr_rec.attr_name := px_attr_diffs(l_attrs_index).attr_name;
6381: -- abedajna Bug 6134504 begin
6382: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
6383: p_attr_group_metadata_obj.attr_metadata_table
6384: ,l_attr_rec.attr_name );
6385: -- abedajna Bug 6134504 end
6386: IF px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_STR IS NOT NULL THEN

Line 6394: 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);

6390: ELSIF px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE IS NOT NULL THEN
6391: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6392: -- abedajna Bug 6134504 begin
6393: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE ) then -- timestamp
6394: 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);
6395: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6396: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).NEW_ATTR_VALUE_DATE);
6397: end if;
6398: -- abedajna Bug 6134504 end

Line 6413: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

6409: ELSIF(l_dml_type = 'DELETE') then
6410: WHILE (l_attrs_index <= px_attr_diffs.LAST) LOOP
6411: l_attr_rec.attr_name := px_attr_diffs(l_attrs_index).attr_name;
6412: -- abedajna Bug 6134504 begin
6413: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
6414: p_attr_group_metadata_obj.attr_metadata_table
6415: ,l_attr_rec.attr_name );
6416: -- abedajna Bug 6134504 end
6417: IF px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_STR IS NOT NULL THEN

Line 6425: 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);

6421: ELSIF px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE IS NOT NULL THEN
6422: -- l_attr_rec.attr_value := TO_CHAR(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
6423: -- abedajna Bug 6134504 begin
6424: if ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) then -- timestamp
6425: 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);
6426: elsif ( l_curr_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE) then -- date
6427: l_attr_rec.attr_value := to_char(px_attr_diffs(L_ATTRS_INDEX).OLD_ATTR_VALUE_DATE);
6428: end if;
6429: -- abedajna Bug 6134504 end

Line 6518: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

6514: END IF;--end if if flag enabled
6515: Debug_Msg( l_api_name ||' done ');
6516: EXCEPTION
6517: --- If subscription fails...don't add to the stack, already added in EGO_WF_WRAPPER_PVT
6518: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
6519: raise EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC;
6520:
6521: WHEN OTHERS THEN
6522: DECLARE

Line 6519: raise EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC;

6515: Debug_Msg( l_api_name ||' done ');
6516: EXCEPTION
6517: --- If subscription fails...don't add to the stack, already added in EGO_WF_WRAPPER_PVT
6518: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
6519: raise EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC;
6520:
6521: WHEN OTHERS THEN
6522: DECLARE
6523: l_token_table ERROR_HANDLER.Token_Tbl_Type;

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

6605: -- of the name/value pair arrays match up with the extension --
6606: -- table metadata (again, the Ext Table object we find will --
6607: -- be cached for later use, so asking for it now is OK). --
6608: ---------------------------------------------------------------
6609: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
6610:
6611: Debug_Msg('In Perform_Preliminary_Checks, getting ext table metadata for object ' || l_object_id, 2);
6612:
6613: IF (l_ext_table_metadata_obj IS NULL) THEN

Line 6945: EGO_USER_ATTRS_COMMON_PVT.Reset_Cache_And_Globals();

6941: -- (we only want to do this once per bulkload and once per UI call) --
6942: --------------------------------------------------------------------------
6943: IF (G_NEED_TO_RESET_AG_CACHE) THEN
6944:
6945: EGO_USER_ATTRS_COMMON_PVT.Reset_Cache_And_Globals();
6946: G_ASSOCIATION_DATA_LEVEL_CACHE.DELETE();
6947: G_HIERARCHY_CACHE.DELETE();
6948:
6949: IF (G_BULK_PROCESSING_FLAG) THEN

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

7213: ---------------------------------------------------------------------
7214: IF (p_cast_date_cols_to_char) THEN
7215: IF (l_column_type = 'D') THEN
7216: l_table_column_names_list := l_table_column_names_list||','''||
7217: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') '||
7218: l_column_name;
7219: END IF;
7220: END IF;
7221:

Line 7577: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name

7573: -----------------------------------------------------
7574: IF(p_data_level IS NOT NULL
7575: AND
7576: FND_API.TO_BOOLEAN(
7577: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7578: ,p_column_name => 'DATA_LEVEL_ID'
7579: )
7580: )
7581: ) THEN

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

7588: -- Validate_Row and went straight to Perform_DML_On_Row, then our --
7589: -- assumption that names and values will match up could cause an error. --
7590: --------------------------------------------------------------------------
7591:
7592: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK ');
7593: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7594: p_ext_table_metadata_obj.pk_column_metadata
7595: ,p_pk_column_name_value_pairs
7596: ,'NAMES'

Line 7593: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7589: -- assumption that names and values will match up could cause an error. --
7590: --------------------------------------------------------------------------
7591:
7592: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK ');
7593: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7594: p_ext_table_metadata_obj.pk_column_metadata
7595: ,p_pk_column_name_value_pairs
7596: ,'NAMES'
7597: ,TRUE

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

7595: ,p_pk_column_name_value_pairs
7596: ,'NAMES'
7597: ,TRUE
7598: );
7599: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC ');
7600: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7601: p_ext_table_metadata_obj.class_code_metadata
7602: ,p_class_code_name_value_pairs
7603: ,'NAMES'

Line 7600: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7596: ,'NAMES'
7597: ,TRUE
7598: );
7599: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC ');
7600: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7601: p_ext_table_metadata_obj.class_code_metadata
7602: ,p_class_code_name_value_pairs
7603: ,'NAMES'
7604: ,TRUE

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

7608: -- NOTE: if inserting into the pending --
7609: -- table, we don't insert Data Level info --
7610: --------------------------------------------
7611:
7612: l_dl_col_mdata_array := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Col_Array(p_attr_group_metadata_obj.APPLICATION_ID,
7613: p_attr_group_metadata_obj.ATTR_GROUP_TYPE);
7614: /***
7615: FOR i IN l_dl_col_mdata_array.FIRST .. l_dl_col_mdata_array.LAST
7616: LOOP

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

7619: ***/
7620: IF (p_data_level_name_value_pairs IS NOT NULL AND
7621: p_data_level_name_value_pairs.COUNT > 0 AND
7622: p_change_obj IS NULL) THEN
7623: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL ');
7624: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7625: l_dl_col_mdata_array
7626: ,p_data_level_name_value_pairs
7627: ,'NAMES'

Line 7624: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7620: IF (p_data_level_name_value_pairs IS NOT NULL AND
7621: p_data_level_name_value_pairs.COUNT > 0 AND
7622: p_change_obj IS NULL) THEN
7623: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL ');
7624: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7625: l_dl_col_mdata_array
7626: ,p_data_level_name_value_pairs
7627: ,'NAMES'
7628: ,TRUE

Line 7697: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name

7693: Debug_Msg(' in insert_row -- p_data_level-'||p_data_level);
7694: IF(p_data_level IS NOT NULL
7695: AND
7696: FND_API.TO_BOOLEAN(
7697: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
7698: ,p_column_name => 'DATA_LEVEL_ID'
7699: )
7700: )
7701: ) THEN

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

7709: END IF;
7710:
7711:
7712: FND_DSQL.Add_Text(', ');
7713: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');
7714: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7715: p_ext_table_metadata_obj.pk_column_metadata
7716: ,p_pk_column_name_value_pairs
7717: ,'VALUES'

Line 7714: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7710:
7711:
7712: FND_DSQL.Add_Text(', ');
7713: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for PK 2 ');
7714: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7715: p_ext_table_metadata_obj.pk_column_metadata
7716: ,p_pk_column_name_value_pairs
7717: ,'VALUES'
7718: ,TRUE

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

7716: ,p_pk_column_name_value_pairs
7717: ,'VALUES'
7718: ,TRUE
7719: );
7720: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC 2 ');
7721: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7722: p_ext_table_metadata_obj.class_code_metadata
7723: ,p_class_code_name_value_pairs
7724: ,'VALUES'

Line 7721: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7717: ,'VALUES'
7718: ,TRUE
7719: );
7720: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for CC 2 ');
7721: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7722: p_ext_table_metadata_obj.class_code_metadata
7723: ,p_class_code_name_value_pairs
7724: ,'VALUES'
7725: ,TRUE

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

7731: --------------------------------------------
7732: IF (p_data_level_name_value_pairs IS NOT NULL AND
7733: p_data_level_name_value_pairs.COUNT > 0 AND
7734: p_change_obj IS NULL) THEN
7735: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL 2 ');
7736: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7737: l_dl_col_mdata_array
7738: ,p_data_level_name_value_pairs
7739: ,'VALUES'

Line 7736: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7732: IF (p_data_level_name_value_pairs IS NOT NULL AND
7733: p_data_level_name_value_pairs.COUNT > 0 AND
7734: p_change_obj IS NULL) THEN
7735: Debug_Msg(l_api_name || ' calling EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols for DL 2 ');
7736: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7737: l_dl_col_mdata_array
7738: ,p_data_level_name_value_pairs
7739: ,'VALUES'
7740: ,TRUE

Line 7871: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name

7867: -----------------------------------------------------
7868: IF(p_data_level IS NOT NULL
7869: AND
7870: FND_API.TO_BOOLEAN(
7871: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7872: ,p_column_name => 'DATA_LEVEL_ID'
7873: )
7874: )
7875: ) THEN

Line 7879: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7875: ) THEN
7876: FND_DSQL.Add_Text('DATA_LEVEL_ID, ');
7877: END IF;
7878:
7879: l_pk_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7880: p_ext_table_metadata_obj.pk_column_metadata
7881: ,p_pk_column_name_value_pairs
7882: ,'NAMES'
7883: ,TRUE

Line 7885: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7881: ,p_pk_column_name_value_pairs
7882: ,'NAMES'
7883: ,TRUE
7884: );
7885: l_cc_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7886: p_ext_table_metadata_obj.class_code_metadata
7887: ,p_class_code_name_value_pairs
7888: ,'NAMES'
7889: ,TRUE

Line 7895: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7891: );
7892: IF (p_data_level_name_value_pairs IS NOT NULL AND
7893: p_data_level_name_value_pairs.COUNT > 0 AND
7894: p_change_obj IS NULL) THEN
7895: l_dl_col_names := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7896: l_dl_col_mdata_array
7897: ,p_data_level_name_value_pairs
7898: ,'NAMES'
7899: ,TRUE

Line 7944: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name

7940: -----------------------------------------------------
7941: IF(p_data_level IS NOT NULL
7942: AND
7943: FND_API.TO_BOOLEAN(
7944: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
7945: ,p_column_name => 'DATA_LEVEL_ID'
7946: )
7947: )
7948: ) THEN

Line 7958: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7954: ,p_value => l_data_level_id);
7955: END IF;
7956:
7957: FND_DSQL.Add_Text(', ');
7958: l_pk_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7959: p_ext_table_metadata_obj.pk_column_metadata
7960: ,p_pk_column_name_value_pairs
7961: ,'VALUES'
7962: ,TRUE

Line 7964: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7960: ,p_pk_column_name_value_pairs
7961: ,'VALUES'
7962: ,TRUE
7963: );
7964: l_cc_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7965: p_ext_table_metadata_obj.class_code_metadata
7966: ,p_class_code_name_value_pairs
7967: ,'VALUES'
7968: ,TRUE

Line 7974: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

7970: );
7971: IF (p_data_level_name_value_pairs IS NOT NULL AND
7972: p_data_level_name_value_pairs.COUNT > 0 AND
7973: p_change_obj IS NULL) THEN
7974: l_dl_col_values := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
7975: l_dl_col_mdata_array
7976: ,p_data_level_name_value_pairs
7977: ,'VALUES'
7978: ,TRUE

Line 8135: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

8131: -----------------------------------------------------------
8132: --Start 4105841
8133: --Checking for Exception raised by preAttribute Change Event
8134: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8135: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8136: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8137: IF FND_API.To_Boolean(p_commit) THEN
8138: ROLLBACK TO insert_row;
8139: END IF;

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

8132: --Start 4105841
8133: --Checking for Exception raised by preAttribute Change Event
8134: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8135: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8136: Debug_Msg('Insert_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8137: IF FND_API.To_Boolean(p_commit) THEN
8138: ROLLBACK TO insert_row;
8139: END IF;
8140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8448: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name

8444: ----------------------------------------------------------------------------
8445: IF(p_data_level IS NOT NULL
8446: AND
8447: FND_API.TO_BOOLEAN(
8448: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_b_table_name
8449: ,p_column_name => 'DATA_LEVEL_ID'
8450: )
8451: )
8452: ) THEN

Line 8593: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name

8589: ----------------------------------------------------------------------------
8590: IF(p_data_level IS NOT NULL
8591: AND
8592: FND_API.TO_BOOLEAN(
8593: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_tl_table_name
8594: ,p_column_name => 'DATA_LEVEL_ID'
8595: )
8596: )
8597: ) THEN

Line 8783: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

8779: -----------------------------------------------------------
8780: --Start 4105841
8781: --Checking for Exception raised by preAttribute Change Event
8782: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8783: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8784: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8785:
8786: IF FND_API.To_Boolean(p_commit) THEN
8787: ROLLBACK TO update_row;

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

8780: --Start 4105841
8781: --Checking for Exception raised by preAttribute Change Event
8782: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
8783: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
8784: Debug_Msg('Update_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
8785:
8786: IF FND_API.To_Boolean(p_commit) THEN
8787: ROLLBACK TO update_row;
8788: END IF;

Line 9124: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN

9120: -----------------------------------------------------------
9121: --Start 4105841
9122: --Checking for Exception raised by preAttribute Change Event
9123: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
9124: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
9125: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
9126:
9127: IF FND_API.To_Boolean(p_commit) THEN
9128: ROLLBACK TO delete_row;

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

9121: --Start 4105841
9122: --Checking for Exception raised by preAttribute Change Event
9123: --don't put to the stack already added in EGO_WF_WRAPPER_PVT
9124: WHEN EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC THEN
9125: Debug_Msg('Delete_Row EXCEPTION EGO_USER_ATTRS_COMMON_PVT.G_SUBSCRIPTION_EXC ');
9126:
9127: IF FND_API.To_Boolean(p_commit) THEN
9128: ROLLBACK TO delete_row;
9129: END IF;

Line 9256: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

9252: l_attr_value_index := px_attr_name_value_pairs.FIRST;
9253: WHILE (l_attr_value_index <= px_attr_name_value_pairs.LAST)
9254: LOOP
9255:
9256: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
9257: p_attr_metadata_table => p_attr_group_metadata_obj.attr_metadata_table
9258: ,p_attr_name => px_attr_name_value_pairs(l_attr_value_index).ATTR_NAME
9259: );
9260:

Line 10036: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id

10032: px_object_id := Get_Object_Id_From_Name(p_object_name);
10033: END IF;
10034:
10035: x_attr_group_metadata_obj :=
10036: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id
10037: ,p_application_id
10038: ,p_attr_group_type
10039: ,p_attr_group_name);
10040: Debug_Msg(l_api_name || ' before validations: p_attr_group_id-'||p_attr_group_id||

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

10097: RAISE FND_API.G_EXC_ERROR;
10098:
10099: END IF;
10100:
10101: x_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(px_object_id);
10102: IF (x_ext_table_metadata_obj IS NULL) THEN
10103:
10104: l_token_table.DELETE();
10105: l_token_table(1).TOKEN_NAME := 'OBJECT_NAME';

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

11371: -- (we know both of these calls will succeed because they --
11372: -- were tested in Perform_Preliminary_Checks, above) --
11373: -------------------------------------------------------------
11374: l_object_id := Get_Object_Id_From_Name(p_object_name);
11375: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
11376:
11377: --=======================================================================--
11378: -- Because there might be hundreds of Attribute Groups for which we need --
11379: -- to get data, we can't assume that we could store metadata for each of --

Line 11407: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(l_curr_ag_request_obj.ATTR_GROUP_ID

11403: Debug_Msg(l_api_name || ' ) ');
11404:
11405: -- Get the metadata for this attribute group
11406: l_curr_ag_metadata_obj :=
11407: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(l_curr_ag_request_obj.ATTR_GROUP_ID
11408: ,l_curr_ag_request_obj.APPLICATION_ID
11409: ,l_curr_ag_request_obj.ATTR_GROUP_TYPE
11410: ,l_curr_ag_request_obj.ATTR_GROUP_NAME);
11411:

Line 11413: 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'));

11409: ,l_curr_ag_request_obj.ATTR_GROUP_TYPE
11410: ,l_curr_ag_request_obj.ATTR_GROUP_NAME);
11411:
11412: -- Determine if the EXT table has a data level column
11413: 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'));
11414:
11415:
11416: ----------------------------------------------------------------------
11417: -- Scan the list of enabled data levels, and see if the data level --

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

11442: l_curr_data_level_row_obj := l_curr_ag_metadata_obj.ENABLED_DATA_LEVELS(dl_index);
11443:
11444: IF l_curr_data_level_row_obj IS NOT NULL THEN
11445: Debug_Msg(l_api_name || 'Data level metadata found');
11446: l_curr_data_level_metadata := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(l_curr_data_level_row_obj.data_level_id);
11447: EXIT; -- exit the loop as we found the DL metadata
11448: END IF;
11449: END IF;
11450: END LOOP;

Line 11646: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

11642: ---------------------------------------------------
11643: -- We know this call will succeed because it was --
11644: -- tested in Get_Requested_Attr_Names, above --
11645: ---------------------------------------------------
11646: l_curr_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
11647: p_attr_metadata_table => l_curr_ag_metadata_obj.attr_metadata_table
11648: ,p_attr_name => l_requested_attr_names_table(l_attr_list_index)
11649: );
11650: Debug_Msg(l_api_name || ' processing attr '|| l_attr_list_index || ' - ' ||l_curr_augmented_attr_rec.ATTR_NAME);

Line 11711: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj,'EMSI');

11707: -- the exception to this is if an Attr has a Table Value Set --
11708: -- (in which case the Int -> Disp value query may assume the --
11709: -- data type of the database column to be a Date or Number) --
11710: ---------------------------------------------------------------
11711: l_to_char_db_col_expression := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(l_curr_attr_metadata_obj,'EMSI');
11712:
11713: IF (l_curr_attr_metadata_obj.INT_TO_DISP_VAL_QUERY IS NULL) THEN
11714:
11715: ----------------------------------------------------------------------

Line 12071: l_new_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

12067: WHILE (l_attr_list_index <= l_requested_attr_names_table.LAST)
12068: LOOP
12069:
12070: IF (l_curr_augmented_attr_rec.ATTR_NAME = l_requested_attr_names_table(l_attr_list_index)) THEN
12071: l_new_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
12072: p_attr_metadata_table => l_curr_ag_metadata_obj.attr_metadata_table
12073: ,p_attr_name => l_requested_attr_names_table(l_attr_list_index)
12074: );
12075: exit;

Line 13223: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id

13219: l_object_id NUMBER;
13220:
13221: BEGIN
13222:
13223: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(p_attr_group_id
13224: ,p_application_id
13225: ,p_attr_group_type
13226: ,p_attr_group_name);
13227: BEGIN

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

13232: WHEN OTHERS THEN
13233: NULL;
13234: END;
13235:
13236: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
13237:
13238: l_ext_id := Get_Extension_Id_For_Row(
13239: p_attr_group_metadata_obj => l_attr_group_metadata_obj
13240: ,p_ext_table_metadata_obj => l_ext_table_metadata_obj

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

13701: -- Get the Object ID and Ext Table metadata --
13702: ----------------------------------------------
13703: l_object_id := Get_Object_Id_From_Name(p_object_name);
13704:
13705: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
13706:
13707: -----------------------------------------------------------------
13708: -- Build a DECODE string for the Classification Code Hierarchy --
13709: -----------------------------------------------------------------

Line 13789: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

13785: Add_Bind(p_value => p_template_id);
13786: FND_DSQL.Add_Text(' AND ETA_OUTER.CLASSIFICATION_CODE IN (');
13787:
13788: -- we assume here that the calling procedure has passed in some class codes
13789: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
13790: l_ext_table_metadata_obj.class_code_metadata
13791: ,p_class_code_name_value_pairs
13792: ,'VALUES_ALL_CC'
13793: ,TRUE

Line 13892: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(

13888: Add_Bind(p_value => p_template_id);
13889: FND_DSQL.Add_Text(
13890: ' AND ETA.CLASSIFICATION_CODE IN (');
13891:
13892: l_class_code_hierarchy := EGO_USER_ATTRS_COMMON_PVT.Get_List_For_Table_Cols(
13893: l_ext_table_metadata_obj.class_code_metadata
13894: ,p_class_code_name_value_pairs
13895: ,'VALUES_ALL_CC'
13896: ,TRUE

Line 14035: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

14031: -- l_attr_group_metadata_obj for the new Attr Group --
14032: ----------------------------------------------------------
14033: IF (l_at_start_of_ag) THEN
14034:
14035: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
14036: p_attr_group_id => l_templ_attr_rec.ATTRIBUTE_GROUP_ID
14037: );
14038:
14039: IF (l_attr_group_metadata_obj IS NULL) THEN

Line 14058: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

14054: END IF;
14055: END IF;
14056: END IF;
14057:
14058: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
14059: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
14060: ,p_attr_id => l_templ_attr_rec.ATTRIBUTE_ID
14061: );
14062:

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

14411: --------------------------------------------------------------------
14412: -- The metadata for all extension tables (though not their names) --
14413: -- will be the same for all group types, so we only query it once --
14414: --------------------------------------------------------------------
14415: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
14416:
14417: ---------------------------------------------------------------------
14418: -- Now we build strings that will be necessary for the rest of the --
14419: -- processing and, like l_ext_table_metadata_obj, won't change --

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

14635: FROM EGO_ATTR_GROUP_TYPES_V
14636: WHERE APPLICATION_ID = p_application_id
14637: AND ATTR_GROUP_TYPE = l_attr_group_types(agt_itr);
14638:
14639: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
14640: p_table_name => l_b_table_name
14641: ,p_column_name => 'DATA_LEVEL_ID')
14642: );
14643: IF l_has_data_level_id THEN

Line 14644: l_all_dl_cols := EGO_USER_ATTRS_COMMON_PVT.Get_All_Data_Level_PK_Names

14640: p_table_name => l_b_table_name
14641: ,p_column_name => 'DATA_LEVEL_ID')
14642: );
14643: IF l_has_data_level_id THEN
14644: l_all_dl_cols := EGO_USER_ATTRS_COMMON_PVT.Get_All_Data_Level_PK_Names
14645: (p_application_id => p_application_id
14646: ,p_attr_group_type => l_attr_group_type);
14647: -- l_all_dl_cols are in the format a,b,c
14648: -- this need to be changed as 'a','b','c'

Line 15121: EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);

15117: ---------------------------------------------------------
15118: -- Get the necessary metadata for our production table --
15119: ---------------------------------------------------------
15120: l_ext_table_metadata_obj :=
15121: EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
15122:
15123: ----------------------------------------------------------
15124: -- Build a PK name/value pair array and begin the lists --
15125: -- of column names to fetch explicitly instead of from --

Line 15477: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

15473: ---------------------------------------------------------
15474: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
15475: l_current_column_index := l_current_column_index + 1;
15476: l_attr_group_metadata_obj :=
15477: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
15478: p_attr_group_id => TO_NUMBER(l_retrieved_value)
15479: );
15480:
15481: ---------------------------------------------------------------

Line 15537: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

15533:
15534: ------------------------------------------------------------------------
15535: -- See whether the current column belongs to a User-Defined Attribute --
15536: ------------------------------------------------------------------------
15537: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
15538: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
15539: ,p_db_column_name => l_current_column_name
15540: );
15541:

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

15571: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_NUM :=
15572: TO_NUMBER(l_retrieved_value);
15573: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'X') THEN
15574: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
15575: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
15576: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15577: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
15578: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15579: ELSE

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

15574: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
15575: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
15576: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
15577: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
15578: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
15579: ELSE
15580: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_STR :=
15581: l_retrieved_value;
15582: END IF;

Line 15639: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

15635: -------------------------------------------------------------
15636: IF (l_attr_name_value_pairs IS NOT NULL AND
15637: l_attr_name_value_pairs.COUNT > 0) THEN
15638:
15639: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
15640: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
15641: ,p_db_column_name => l_attr_col_name_for_uom_col
15642: );
15643:

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

16082: x_str_val := NULL;
16083: x_num_val := NULL;
16084: x_date_val := NULL;
16085:
16086: l_db_column_alias := EGO_USER_ATTRS_COMMON_PVT.Create_DB_Col_Alias_If_Needed(p_attr_metadata_obj);
16087:
16088: l_cursor := DBMS_SQL.OPEN_CURSOR;
16089: l_bind_index := 0;
16090:

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

16148: -- WHERE conditions: Data Level ID, Data Level Primary Keys --
16149: --------------------------------------------------------------
16150:
16151: l_has_data_level_id := FND_API.TO_BOOLEAN(
16152: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => p_attr_group_metadata_obj.EXT_TABLE_B_NAME
16153: ,p_column_name => 'DATA_LEVEL_ID')
16154: );
16155:
16156: IF p_data_level IS NOT NULL AND l_has_data_level_id THEN

Line 16165: 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);

16161: FOR dl_index IN p_attr_group_metadata_obj.ENABLED_DATA_LEVELS.FIRST .. p_attr_group_metadata_obj.ENABLED_DATA_LEVELS.LAST
16162: LOOP
16163:
16164: IF p_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_name = p_data_level THEN
16165: 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);
16166: Debug_Msg(l_api_name || ' Data level found, exiting loop.');
16167: -- exit the loop as we found the DL
16168: EXIT;
16169: END IF;

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

16270: IF (p_attr_metadata_obj.DATA_TYPE_CODE = 'N') THEN
16271: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_num_val);
16272: ELSIF (p_attr_metadata_obj.DATA_TYPE_CODE = 'X' OR p_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
16273: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_str);
16274: x_date_val := TO_DATE(l_str,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16275: ELSE
16276: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, x_str_val);
16277: END IF;
16278: END IF;

Line 16367: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

16363: -----------------------------------------
16364: -- Get or build the necessary metadata --
16365: -----------------------------------------
16366: l_attr_group_metadata_obj :=
16367: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
16368: p_application_id => p_appl_id
16369: ,p_attr_group_type => p_attr_grp_type
16370: ,p_attr_group_name => p_attr_grp_name
16371: );

Line 16374: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

16370: ,p_attr_group_name => p_attr_grp_name
16371: );
16372:
16373: l_attr_metadata_table := l_attr_group_metadata_obj.attr_metadata_table;
16374: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
16375: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
16376: ,p_attr_name => p_attr_name
16377: );
16378:

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

16407: IF p_data_level IS NOT NULL THEN
16408: -- check if the passed in data level is valid for this attribute group.
16409: Debug_Msg(l_api_name || ' Non-null data level');
16410: l_has_data_level_id := FND_API.TO_BOOLEAN(
16411: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_table_name => l_attr_group_metadata_obj.EXT_TABLE_B_NAME
16412: ,p_column_name => 'DATA_LEVEL_ID')
16413: );
16414: IF l_has_data_level_id THEN
16415: l_curr_data_level_row_obj := NULL;

Line 16433: 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);

16429: Debug_Msg(l_api_name || ' enabled data level: ' ||
16430: l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_name || '(' ||
16431: l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_id || ')');
16432: IF l_attr_group_metadata_obj.ENABLED_DATA_LEVELS(dl_index).data_level_name = p_data_level THEN
16433: 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);
16434: Debug_Msg(l_api_name || ' Found Data Level, finished searching.');
16435: EXIT;
16436: END IF;
16437: END LOOP;

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

16559: ELSIF (l_temp_num IS NOT NULL) THEN
16560: l_attr_int_value := TO_CHAR(l_temp_num);
16561: ELSIF (l_temp_date IS NOT NULL) THEN
16562: --bug 5094087
16563: l_attr_int_value := TO_CHAR(l_temp_date,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
16564: END IF;
16565:
16566: ----------------------------------------------------------
16567: -- At this point I have the internal value; if the Attr --

Line 16650: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(

16646: IF ( l_attr_metadata_obj.DATA_TYPE_CODE IN
16647: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16648: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
16649: THEN
16650: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16651: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
16652: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
16653: ,x_return_status =>l_return_status
16654: ,x_msg_count =>l_msg_count

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

16647: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16648: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE) )
16649: THEN
16650: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16651: p_date => TO_DATE(l_attr_int_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
16652: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
16653: ,x_return_status =>l_return_status
16654: ,x_msg_count =>l_msg_count
16655: ,x_msg_data =>l_msg_data

Line 16673: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(

16669: AND (l_attr_metadata_obj.DATA_TYPE_CODE IN
16670: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16671: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
16672: THEN
16673: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16674: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
16675: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
16676: ,x_return_status =>l_return_status
16677: ,x_msg_count =>l_msg_count

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

16670: (EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE,
16671: EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)))
16672: THEN
16673: l_attr_disp_value := EGO_USER_ATTRS_COMMON_PVT.Get_User_Pref_Date_Time_Val(
16674: p_date => TO_DATE(l_attr_disp_value,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT)
16675: ,p_attr_type => l_attr_metadata_obj.DATA_TYPE_CODE
16676: ,x_return_status =>l_return_status
16677: ,x_msg_count =>l_msg_count
16678: ,x_msg_data =>l_msg_data

Line 16792: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata

16788:
16789: Debug_Msg('In Update_Attributes, retrieved l_object_id as '||l_object_id, 2);
16790: Debug_Msg('In Update_Attributes, getting AG metadata for '||p_attr_group_id, 2);
16791:
16792: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata
16793: ( p_attr_group_id => p_attr_group_id );
16794:
16795: Debug_Msg('In Update_Attributes, got AG metadata: '||
16796: l_attr_group_metadata_obj.attr_group_id||','||

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

16799: l_attr_group_metadata_obj.attr_group_name||','||
16800: l_attr_group_metadata_obj.attr_group_disp_name
16801: , 2);
16802:
16803: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
16804: Convert_Attr_Diff_To_Data(p_attr_diffs, l_old_attr_name_value_pairs, FALSE, l_is_delete, x_error_message);
16805: Convert_Attr_Diff_To_Data(p_attr_diffs, l_new_attr_name_value_pairs, TRUE, l_is_delete, x_error_message);
16806:
16807: Debug_Msg('In Update_Attributes, got AG and ext table objs, getting ext id ');

Line 16943: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata

16939:
16940: Debug_Msg('In Get_Attr_Diffs, starting');
16941:
16942: -- get list of attributes in this group
16943: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata
16944: ( p_attr_group_id
16945: , p_application_id
16946: , p_attr_group_type
16947: , p_attr_group_name

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

16972: END LOOP;
16973:
16974: -- get other objects necessary for Get_Change_Attrs call
16975: l_object_id := Get_Object_Id_From_Name(p_object_name);
16976: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
16977:
16978: -- call Get_Changed_Attrs to get diffs as output
16979: Get_Changed_Attributes(
16980: p_dml_operation => 'UPDATE'

Line 17082: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

17078: ,null
17079: ,null
17080: );
17081:
17082: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
17083: p_attr_group_id => NULL
17084: ,p_application_id => p_application_id
17085: ,p_attr_group_type => p_attr_group_type
17086: ,p_attr_group_name => p_attr_group_int_name

Line 17090: 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

17086: ,p_attr_group_name => p_attr_group_int_name
17087: );
17088:
17089: --todo: why is this here?
17090: 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
17091: -- data level exists
17092: NULL;
17093: END IF;
17094:

Line 17198: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

17194: ,p_attr_disp_value
17195: ,null
17196: ,null
17197: );
17198: l_attr_group_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
17199: p_attr_group_id => NULL
17200: ,p_application_id => p_application_id
17201: ,p_attr_group_type => p_attr_group_type
17202: ,p_attr_group_name => p_attr_group_int_name

Line 17233: 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);

17229: RETURN TO_CHAR(TO_NUMBER(p_attr_disp_value));
17230: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17231: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17232: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17233: 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);
17234: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17235: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
17236: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
17237: RETURN p_attr_disp_value;

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

17292:
17293: IF (p_ext_table_metadata_obj IS NOT NULL) THEN
17294: l_ext_table_metadata_obj := p_ext_table_metadata_obj;
17295: ELSE
17296: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(Get_Object_Id_From_Name(p_object_name));
17297: END IF;
17298:
17299:
17300: l_attr_internal_value := Get_Int_Val_For_Disp_Val(

Line 17322: 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);

17318: l_attr_internal_value := TO_CHAR(TO_NUMBER(l_attr_internal_value));
17319: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_DATA_TYPE
17320: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_DATE_TIME_DATA_TYPE)
17321: AND (p_return_intf_col = 'ATTR_VALUE_DATE') THEN
17322: 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);
17323: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_TRANS_TEXT_DATA_TYPE
17324: OR l_attr_metadata_obj.DATA_TYPE_CODE = EGO_EXT_FWK_PUB.G_CHAR_DATA_TYPE)
17325: AND (p_return_intf_col = 'ATTR_VALUE_STR') THEN
17326: l_attr_internal_value := l_attr_internal_value;

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

18412: -------------------------------------------------------------
18413: -- Find out weather the ATTR_GROUP_ID column exists in the --
18414: -- table where attribute data is to be uploaded or not --
18415: -------------------------------------------------------------
18416: l_ag_id_col_exists := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
18417: p_table_name => l_ext_b_table_name
18418: ,p_column_name => 'ATTR_GROUP_ID')
18419: );
18420:

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

18417: p_table_name => l_ext_b_table_name
18418: ,p_column_name => 'ATTR_GROUP_ID')
18419: );
18420:
18421: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
18422: p_table_name => l_ext_b_table_name
18423: ,p_column_name => 'DATA_LEVEL_ID')
18424: );
18425:

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

18605: l_temp_date_str := REPLACE(UPPER(l_attr_record.DEFAULT_VALUE),'$'); --bugfix:5228308
18606: EXECUTE IMMEDIATE 'SELECT '||l_temp_date_str||' FROM DUAL '
18607: INTO l_date_val;
18608: ELSE
18609: l_date_val := TO_DATE(l_attr_record.DEFAULT_VALUE,EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
18610: END IF;
18611: END IF;
18612:
18613: IF (l_attr_record.REQUIRED_FLAG = 'Y' AND l_attr_record.DEFAULT_VALUE IS NULL) THEN