DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_TEMPL_ATTRIBUTES

Line 13656: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE

13652: l_data_level_id NUMBER;
13653: l_Perform_DML_On_Template_Row VARCHAR2(1);
13654:
13655: TYPE TEMPL_ATTR_REC IS RECORD (
13656: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE

Line 13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE

13653: l_Perform_DML_On_Template_Row VARCHAR2(1);
13654:
13655: TYPE TEMPL_ATTR_REC IS RECORD (
13656: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE

Line 13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE

13654:
13655: TYPE TEMPL_ATTR_REC IS RECORD (
13656: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE

Line 13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE

13655: TYPE TEMPL_ATTR_REC IS RECORD (
13656: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
13663: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE

Line 13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE

13656: ATTRIBUTE_GROUP_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_GROUP_ID%TYPE
13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
13663: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
13664: );

Line 13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE

13657: ,ATTRIBUTE_ID EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_ID%TYPE
13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
13663: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
13664: );
13665: l_templ_attr_rec TEMPL_ATTR_REC;

Line 13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE

13658: ,ROW_NUMBER EGO_TEMPL_ATTRIBUTES.ROW_NUMBER%TYPE
13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
13663: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
13664: );
13665: l_templ_attr_rec TEMPL_ATTR_REC;
13666:

Line 13663: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE

13659: ,ATTRIBUTE_STRING_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_STRING_VALUE%TYPE
13660: ,ATTRIBUTE_NUMBER_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_NUMBER_VALUE%TYPE
13661: ,ATTRIBUTE_UOM_CODE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_UOM_CODE%TYPE
13662: ,ATTRIBUTE_DATE_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_DATE_VALUE%TYPE
13663: ,ATTRIBUTE_TRANSLATED_VALUE EGO_TEMPL_ATTRIBUTES.ATTRIBUTE_TRANSLATED_VALUE%TYPE
13664: );
13665: l_templ_attr_rec TEMPL_ATTR_REC;
13666:
13667: BEGIN

Line 13770: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'

13766: ' ETA_OUTER.ATTRIBUTE_NUMBER_VALUE,' ||
13767: ' ETA_OUTER.ATTRIBUTE_UOM_CODE,' ||
13768: ' ETA_OUTER.ATTRIBUTE_DATE_VALUE,' ||
13769: ' ETA_OUTER.ATTRIBUTE_TRANSLATED_VALUE' ||
13770: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'
13771: );
13772: IF p_data_level IS NOT NULL THEN
13773: FND_DSQL.Add_Text(
13774: ' , EGO_DATA_LEVEL_B DL ' ||

Line 13886: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||

13882:
13883: END LOOP;
13884:
13885: FND_DSQL.Add_Text(')) STEPS_ABOVE_CURR' ||
13886: ' FROM EGO_TEMPL_ATTRIBUTES ETA' ||
13887: ' WHERE ETA.TEMPLATE_ID = ');
13888: Add_Bind(p_value => p_template_id);
13889: FND_DSQL.Add_Text(
13890: ' AND ETA.CLASSIFICATION_CODE IN (');