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_TEMPL_ATTRS_PUB dependencies on EGO_TEMPL_ATTRIBUTES

Line 118: --in mtl_item_templ_attributes with ego_templ_attributes

114:
115: ----------------------------------------------------------------
116: --Sync_Template is a procedure provided to sync up all operational attributes
117: --associated with the template
118: --in mtl_item_templ_attributes with ego_templ_attributes
119: --parameters:
120: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
121: ----------------------------------------------------------------
122:

Line 164: FROM ego_templ_attributes

160: Debug_Msg('Sync_Template: BEGIN');
161:
162: BEGIN
163: SELECT 'F' INTO l_always_insert
164: FROM ego_templ_attributes
165: WHERE template_id = p_template_id;
166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN
168: l_always_insert := 'T';

Line 208: --values in mtl_item_templ_attributes with ego_templ_attributes

204: END Sync_Template;
205:
206: ----------------------------------------------------------------
207: --Sync_Template_Attribute is a procedure provided to sync up operational attribute
208: --values in mtl_item_templ_attributes with ego_templ_attributes
209: --parameters:
210: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
211: ----------------------------------------------------------------
212:

Line 233: ego_templ_attributes eta

229: ,cp_attribute_name VARCHAR2) IS
230: SELECT 1
231: FROM fnd_descr_flex_column_usages fl_col ,
232: ego_fnd_df_col_usgs_ext ext,
233: ego_templ_attributes eta
234: WHERE ext.application_id = fl_col.application_id
235: AND ext.descriptive_flexfield_name = fl_col.descriptive_flexfield_name
236: AND ext.descriptive_flex_context_code = fl_col.descriptive_flex_context_code
237: AND ext.application_column_name = fl_col.application_column_name

Line 300: exists ( select attr_id from ego_templ_attributes eta, ego_attrs_v av

296: 1 into l_exists
297: FROM
298: dual
299: WHERE
300: exists ( select attr_id from ego_templ_attributes eta, ego_attrs_v av
301: where 'MTL_SYSTEM_ITEMS.'||av.database_column = p_attribute_name
302: and eta.attribute_id = av.attr_id
303: and av.attr_group_type = 'EGO_MASTER_ITEMS'
304: and template_id = p_template_id);

Line 338: -- update the row in ego_templ_attributes for this attribute

334: x_return_status,
335: x_message_text
336: );
337: ELSE
338: -- update the row in ego_templ_attributes for this attribute
339: Update_Template_Attribute( p_template_id,
340: p_ego_attr_group_id,
341: p_ego_attr_id,
342: l_data_level_id,

Line 361: --values in mtl_item_templ_attributes with ego_templ_attributes

357: END Sync_Template_Attribute;
358:
359: ----------------------------------------------------------------
360: --Sync_Template_Attribute is a procedure provided to sync up operational attribute
361: --values in mtl_item_templ_attributes with ego_templ_attributes
362: --parameters:
363: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
364: ----------------------------------------------------------------
365:

Line 382: ego_templ_attributes eta

378: ,cp_attribute_name VARCHAR2) IS
379: SELECT 1
380: FROM fnd_descr_flex_column_usages fl_col ,
381: ego_fnd_df_col_usgs_ext ext,
382: ego_templ_attributes eta
383: WHERE ext.application_id = fl_col.application_id
384: AND ext.descriptive_flexfield_name = fl_col.descriptive_flexfield_name
385: AND ext.descriptive_flex_context_code = fl_col.descriptive_flex_context_code
386: AND ext.application_column_name = fl_col.application_column_name

Line 463: exists ( select attr_id from ego_templ_attributes eta, ego_attrs_v av

459: 1 into l_exists
460: FROM
461: dual
462: WHERE
463: exists ( select attr_id from ego_templ_attributes eta, ego_attrs_v av
464: where 'MTL_SYSTEM_ITEMS.'||av.database_column = p_attribute_name
465: and eta.attribute_id = av.attr_id
466: and av.attr_group_type = 'EGO_MASTER_ITEMS'
467: and template_id = p_template_id);

Line 503: -- update the row in ego_templ_attributes for this attribute

499:
500: ELSE
501: Debug_Msg(l_api_name || 'Performing update.');
502:
503: -- update the row in ego_templ_attributes for this attribute
504: Update_Template_Attribute( r_inv_templ_attribute.template_id,
505: l_attribute_group_id,
506: l_attribute_id,
507: l_data_level_id,

Line 559: -- having classification_code = -1 will mark all operational attribute groups in EGO_TEMPL_ATTRIBUTES

555: SetGlobals();
556: -- all base attribute groups have single row attributes
557: l_row_num := 1;
558:
559: -- having classification_code = -1 will mark all operational attribute groups in EGO_TEMPL_ATTRIBUTES
560: l_classification_code := '-1';
561:
562: -- get data type code
563: select eav.data_type_code into l_data_type_code

Line 584: insert into ego_templ_attributes(template_id,

580: ELSE
581: RAISE e_data_type_missing;
582: END IF;
583:
584: insert into ego_templ_attributes(template_id,
585: attribute_group_id,
586: attribute_id,
587: enabled_flag,
588: last_update_date,

Line 691: update ego_templ_attributes

687: ELSE
688: RAISE e_data_type_missing;
689: END IF;
690:
691: update ego_templ_attributes
692: set attribute_string_value = l_attr_string_value,
693: attribute_number_value = l_attr_number_value,
694: attribute_date_value = l_attr_date_value,
695: attribute_translated_value = l_attr_translated_value,

Line 717: x_message_text := 'Failure to update EGO_TEMPL_ATTRIBUTES';

713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: x_return_status := 'U';
717: x_message_text := 'Failure to update EGO_TEMPL_ATTRIBUTES';
718: rollback;
719:
720: END Update_Template_Attribute;
721: