DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_TEMPL_ATTRIBUTES

Line 12630: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE

12626: l_data_level_id NUMBER;
12627: l_Perform_DML_On_Template_Row VARCHAR2(1);
12628:
12629: TYPE TEMPL_ATTR_REC IS RECORD (
12630: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE

Line 12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE

12627: l_Perform_DML_On_Template_Row VARCHAR2(1);
12628:
12629: TYPE TEMPL_ATTR_REC IS RECORD (
12630: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE

Line 12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE

12628:
12629: TYPE TEMPL_ATTR_REC IS RECORD (
12630: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE

Line 12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE

12629: TYPE TEMPL_ATTR_REC IS RECORD (
12630: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
12637: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE

Line 12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE

12630: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
12637: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
12638: );

Line 12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE

12631: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
12637: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
12638: );
12639: l_templ_attr_rec TEMPL_ATTR_REC;

Line 12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE

12632: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
12637: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
12638: );
12639: l_templ_attr_rec TEMPL_ATTR_REC;
12640:

Line 12637: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE

12633: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
12634: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
12635: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
12636: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
12637: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
12638: );
12639: l_templ_attr_rec TEMPL_ATTR_REC;
12640:
12641: BEGIN

Line 12744: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'

12740: ' ETA_OUTER.ATTRIBUTE_NUMBER_VALUE,' ||
12741: ' ETA_OUTER.ATTRIBUTE_UOM_CODE,' ||
12742: ' ETA_OUTER.ATTRIBUTE_DATE_VALUE,' ||
12743: ' ETA_OUTER.ATTRIBUTE_TRANSLATED_VALUE' ||
12744: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'
12745: );
12746: IF p_data_level IS NOT NULL THEN
12747: FND_DSQL.Add_Text(
12748: ' , EGO_DATA_LEVEL_B DL ' ||

Line 12860: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||

12856:
12857: END LOOP;
12858:
12859: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||
12860: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||
12861: ' WHERE ETA.TEMPLATE_ID = ');
12862: Add_Bind(p_value => p_template_id);
12863: FND_DSQL.Add_Text(
12864: ' AND ETA.CLASSIFICATION_CODE IN (');