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 251: l_attribute_id ego_attrs_v.attr_id%TYPE; -- NUMBER(15)

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

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

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

Line 667: from ego_attrs_v eav

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

Line 783: p_attr_name IN ego_attrs_v.attr_name %TYPE,

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

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

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

Line 803: FROM ego_attrs_v eav, ego_attr_groups_v eagv

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