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