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 163: FROM ego_templ_attributes

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

Line 207: --values in mtl_item_templ_attributes with ego_templ_attributes

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

Line 232: ego_templ_attributes eta

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

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

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

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

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

Line 360: --values in mtl_item_templ_attributes with ego_templ_attributes

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

Line 381: ego_templ_attributes eta

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

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

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

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

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

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

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

Line 583: insert into ego_templ_attributes(template_id,

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

Line 690: update ego_templ_attributes

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

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

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