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

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

659: ---------------------------------------------------------------------
660: IF (p_cast_date_cols_to_char) THEN
661: IF (l_column_type = 'D') THEN
662: l_table_column_names_list := l_table_column_names_list||','''||
663: EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT||''') '||
664: l_column_name;
665: END IF;
666: END IF;
667:

Line 1964: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

1960:
1961: ------------------------------------------------------------------------
1962: -- See whether the current column belongs to a User-Defined Attribute --
1963: ------------------------------------------------------------------------
1964: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
1965: p_attr_metadata_table => l_attr_metadata_table
1966: ,p_db_column_name => l_current_column_name
1967: );
1968:

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

2002: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_NUM :=
2003: TO_NUMBER(l_retrieved_value);
2004: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'X') THEN
2005: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
2006: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2007: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
2008: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
2009: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2010: ELSE

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

2005: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
2006: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
2007: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
2008: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
2009: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
2010: ELSE
2011: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_STR :=
2012: l_retrieved_value;
2013: END IF;

Line 2079: -- l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

2075: -------------------------------------------------------------
2076: -- IF (l_attr_name_value_pairs IS NOT NULL AND
2077: -- l_attr_name_value_pairs.COUNT > 0) THEN
2078: --
2079: -- l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
2080: -- p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
2081: -- ,p_db_column_name => l_attr_col_name_for_uom_col
2082: -- );
2083: --

Line 2191: l_date_value_char := TO_CHAR(l_attr_name_value_pairs(j).ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT) ;

2187: -----------------------------
2188: l_num_value := l_attr_name_value_pairs(j).ATTR_VALUE_NUM ;
2189: l_char_value := l_attr_name_value_pairs(j).ATTR_VALUE_STR ;
2190: l_date_value := l_attr_name_value_pairs(j).ATTR_VALUE_DATE ;
2191: l_date_value_char := TO_CHAR(l_attr_name_value_pairs(j).ATTR_VALUE_DATE, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT) ;
2192:
2193:
2194: -- ATTR_NAME is set as DB Column Name
2195: IF l_num_value IS NOT NULL

Line 2223: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || ' TO_DATE( ''' || l_date_value_char || ''', ''' || EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT || ''') ';

2219: l_date_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;
2220: END IF;
2221:
2222: l_dynamic_sql := l_dynamic_sql ||
2223: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || ' TO_DATE( ''' || l_date_value_char || ''', ''' || EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT || ''') ';
2224:
2225: -- l_dynamic_sql := l_dynamic_sql || ''' || l_date_value || '''' ;
2226:
2227: END IF ;

Line 3409: -- l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

3405:
3406: ------------------------------------------------------------------------
3407: -- See whether the current column belongs to a User-Defined Attribute --
3408: ------------------------------------------------------------------------
3409: -- l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
3410: -- p_attr_metadata_table => l_attr_metadata_table
3411: -- ,p_db_column_name => l_current_column_name
3412: -- );
3413: --

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

3471: -- l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_NUM :=
3472: -- TO_NUMBER(l_retrieved_value);
3473: -- ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'X') THEN
3474: -- l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3475: -- TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
3476: -- ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
3477: -- l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3478: -- TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3479: -- ELSE

Line 3478: -- TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);

3474: -- l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3475: -- TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
3476: -- ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
3477: -- l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3478: -- TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3479: -- ELSE
3480: -- l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_STR :=
3481: -- l_retrieved_value;
3482: -- END IF;

Line 3802: -- := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);

3798:
3799:
3800: -- l_object_id := Get_Object_Id_From_Name(G_EGO_ITEM);
3801: -- l_ext_table_metadata_obj
3802: -- := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
3803:
3804:
3805: WHILE (DBMS_SQL.Fetch_Rows(l_cursor_id) > 0)
3806: LOOP

Line 3861: Write_Debug('EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata for ' || to_char(l_attr_group_id));

3857: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
3858: l_current_column_index := l_current_column_index + 1;
3859: l_attr_group_id := TO_NUMBER(l_retrieved_value) ;
3860:
3861: Write_Debug('EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata for ' || to_char(l_attr_group_id));
3862:
3863: l_attr_group_metadata_obj :=
3864: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
3865: p_attr_group_id => l_attr_group_id

Line 3864: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

3860:
3861: Write_Debug('EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata for ' || to_char(l_attr_group_id));
3862:
3863: l_attr_group_metadata_obj :=
3864: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
3865: p_attr_group_id => l_attr_group_id
3866: );
3867:
3868: Write_Debug('After EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata ') ;

Line 3868: Write_Debug('After EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata ') ;

3864: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
3865: p_attr_group_id => l_attr_group_id
3866: );
3867:
3868: Write_Debug('After EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata ') ;
3869:
3870: -------------------------------------------------------------------
3871: -- Now we loop through the rest of the columns assigning values --
3872: -- to Attr data objects, which we add to a table of such objects --

Line 3887: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

3883: ------------------------------------------------------------------------
3884: -- See whether the current column belongs to a User-Defined Attribute --
3885: ------------------------------------------------------------------------
3886: l_attr_metadata_table := l_attr_group_metadata_obj.ATTR_METADATA_TABLE;
3887: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
3888: p_attr_metadata_table => l_attr_metadata_table
3889: ,p_db_column_name => l_current_column_name
3890: );
3891:

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

3952: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_NUM :=
3953: TO_NUMBER(l_retrieved_value);
3954: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'X') THEN
3955: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3956: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
3957: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
3958: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3959: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3960: ELSE

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

3955: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3956: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
3957: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
3958: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
3959: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
3960: ELSE
3961: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_STR :=
3962: l_retrieved_value;
3963: END IF;

Line 4616: EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);

4612: ---------------------------------------------------------
4613: -- Get the necessary metadata for our production table --
4614: ---------------------------------------------------------
4615: l_ext_table_metadata_obj :=
4616: EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(l_object_id);
4617:
4618: ----------------------------------------------------------
4619: -- Build a PK name/value pair array and begin the lists --
4620: -- of column names to fetch explicitly instead of from --

Line 4975: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(

4971: DBMS_SQL.Column_Value(l_cursor_id, l_current_column_index, l_retrieved_value);
4972: l_current_column_index := l_current_column_index + 1;
4973: L_ATTR_GROUP_ID := TO_NUMBER(l_retrieved_value);
4974: l_attr_group_metadata_obj :=
4975: EGO_USER_ATTRS_COMMON_PVT.Get_Attr_Group_Metadata(
4976: p_attr_group_id => L_ATTR_GROUP_ID
4977: );
4978:
4979: --------------------------

Line 4998: L_DATA_LEVEL_META_DATA := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(L_DATA_LEVEL_ID);

4994: L_DATA_LEVEL_ID := TO_NUMBER(l_retrieved_value);
4995: Write_Debug('Current data level Id : ' || TO_CHAR(L_DATA_LEVEL_ID));
4996: if L_DATA_LEVEL_ID is not NULL
4997: then
4998: L_DATA_LEVEL_META_DATA := EGO_USER_ATTRS_COMMON_PVT.Get_Data_Level_Metadata(L_DATA_LEVEL_ID);
4999: L_DATA_LEVEL_NAME := L_DATA_LEVEL_META_DATA.DATA_LEVEL_NAME;
5000: Write_Debug('Current data level name : ' || TO_CHAR(L_DATA_LEVEL_NAME));
5001:
5002: IF L_DATA_LEVEL_NAME='ITEM_REVISION_LEVEL'

Line 5140: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5136: ------------------------------------------------------------------------
5137: -- See whether the current column belongs to a User-Defined Attribute --
5138: ------------------------------------------------------------------------
5139:
5140: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5141: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
5142: ,p_db_column_name => l_current_column_name
5143: );
5144:

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

5174: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_NUM :=
5175: TO_NUMBER(l_retrieved_value);
5176: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'X') THEN
5177: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
5178: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5179: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
5180: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
5181: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5182: ELSE

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

5177: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
5178: TRUNC(TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT));
5179: ELSIF (l_attr_metadata_obj.DATA_TYPE_CODE = 'Y') THEN
5180: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_DATE :=
5181: TO_DATE(l_retrieved_value, EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT);
5182: ELSE
5183: l_attr_name_value_pairs(l_attr_name_value_pairs.LAST).ATTR_VALUE_STR :=
5184: l_retrieved_value;
5185: END IF;

Line 5242: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(

5238: -------------------------------------------------------------
5239: IF (l_attr_name_value_pairs IS NOT NULL AND
5240: l_attr_name_value_pairs.COUNT > 0) THEN
5241:
5242: l_attr_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Find_Metadata_For_Attr(
5243: p_attr_metadata_table => l_attr_group_metadata_obj.attr_metadata_table
5244: ,p_db_column_name => l_attr_col_name_for_uom_col
5245: );
5246: