APPS.EGO_TEMPL_ATTRS_PUB dependencies on EGO_ATTRS_V

Line 73: p_attr_name IN ego_attrs_v.attr_name %TYPE,

69: -- R12C
70: --
71: ------------------------------------------------------------------------------
72: Procedure Get_Attr_Group_And_Attr_ID (
73: p_attr_name IN ego_attrs_v.attr_name %TYPE,
74: -- VARCHAR2(30)
75: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE
76: := 'EGO_MASTER_ITEMS', -- VARCHAR2
77: p_application_id IN ego_data_level_b.application_id %TYPE

Line 81: x_attr_id OUT NOCOPY ego_attrs_v.attr_id %TYPE);

77: p_application_id IN ego_data_level_b.application_id %TYPE
78: := 431, -- NUMBER
79: x_attr_group_id OUT NOCOPY ego_obj_ag_assocs_b.attr_group_id %TYPE,
80: -- NUMBER
81: x_attr_id OUT NOCOPY ego_attrs_v.attr_id %TYPE);
82: -- NUMBER(15)
83:
84: ---------------------------------
85: -- Private Debugging Procedure --

Line 250: l_attribute_id ego_attrs_v.attr_id%TYPE; -- NUMBER(15)

246: l_insert VARCHAR2(1);
247: l_attribute_group_id NUMBER;
248: l_data_level_name VARCHAR2(30);
249: l_data_level_id NUMBER;
250: l_attribute_id ego_attrs_v.attr_id%TYPE; -- NUMBER(15)
251: BEGIN
252:
253: Debug_Msg(l_api_name || 'BEGIN');
254: Debug_Msg(l_api_name || 'Syncing template ' || p_template_id ||

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 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 563: from ego_attrs_v eav

559: l_classification_code := '-1';
560:
561: -- get data type code
562: select eav.data_type_code into l_data_type_code
563: from ego_attrs_v eav
564: where attr_id = p_attribute_id;
565:
566: IF( l_data_type_code = G_CHAR_DATA_TYPE ) THEN
567: l_attr_string_value := p_attribute_value;

Line 666: from ego_attrs_v eav

662:
663: SetGlobals();
664: -- get data type code
665: select eav.data_type_code into l_data_type_code
666: from ego_attrs_v eav
667: where attr_id = p_attribute_id;
668:
669: IF( l_data_type_code = G_CHAR_DATA_TYPE ) THEN
670: l_attr_string_value := p_attribute_value;

Line 782: p_attr_name IN ego_attrs_v.attr_name %TYPE,

778: -- R12C
779: --
780: ------------------------------------------------------------------------------
781: Procedure Get_Attr_Group_And_Attr_ID (
782: p_attr_name IN ego_attrs_v.attr_name %TYPE,
783: -- VARCHAR2(30)
784: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,
785: -- VARCHAR2
786: p_application_id IN ego_data_level_b.application_id %TYPE,

Line 790: x_attr_id OUT NOCOPY ego_attrs_v.attr_id %TYPE)

786: p_application_id IN ego_data_level_b.application_id %TYPE,
787: -- NUMBER
788: x_attr_group_id OUT NOCOPY ego_obj_ag_assocs_b.attr_group_id %TYPE,
789: -- NUMBER
790: x_attr_id OUT NOCOPY ego_attrs_v.attr_id %TYPE)
791: -- NUMBER(15)
792: IS
793: l_api_name VARCHAR2(30) := 'Get_Attr_Group_And_Attr_ID: ';
794: BEGIN

Line 802: FROM ego_attrs_v eav, ego_attr_groups_v eagv

798: Debug_Msg(l_api_name || ' p_application_id => ' || p_application_id);
799:
800: SELECT eav.attr_id, eagv.attr_group_id
801: INTO x_attr_id, x_attr_group_id
802: FROM ego_attrs_v eav, ego_attr_groups_v eagv
803: WHERE 'MTL_SYSTEM_ITEMS.'||eav.database_column = p_attr_name
804: AND eav.attr_group_type = eagv.attr_group_type
805: AND eav.attr_group_name = eagv.attr_group_name
806: AND eav.application_id = p_application_id