APPS.EGO_TEMPL_ATTRS_PUB dependencies on EGO_DATA_LEVEL_B

Line 51: p_data_level_name IN ego_data_level_b.data_level_name %TYPE

47: -------------------------------------------------------------------------------
48: Procedure Get_Data_Level_ID (
49: p_attribute_group_id IN ego_obj_ag_assocs_b.attr_group_id %TYPE,
50: -- NUMBER
51: p_data_level_name IN ego_data_level_b.data_level_name %TYPE
52: := 'ITEM_ORG', -- VARCHAR2
53: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE
54: := 'EGO_MASTER_ITEMS', -- VARCHAR2
55: p_application_id IN ego_data_level_b.application_id %TYPE

Line 53: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE

49: p_attribute_group_id IN ego_obj_ag_assocs_b.attr_group_id %TYPE,
50: -- NUMBER
51: p_data_level_name IN ego_data_level_b.data_level_name %TYPE
52: := 'ITEM_ORG', -- VARCHAR2
53: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE
54: := 'EGO_MASTER_ITEMS', -- VARCHAR2
55: p_application_id IN ego_data_level_b.application_id %TYPE
56: := 431, -- NUMBER
57: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE);

Line 55: p_application_id IN ego_data_level_b.application_id %TYPE

51: p_data_level_name IN ego_data_level_b.data_level_name %TYPE
52: := 'ITEM_ORG', -- VARCHAR2
53: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE
54: := 'EGO_MASTER_ITEMS', -- VARCHAR2
55: p_application_id IN ego_data_level_b.application_id %TYPE
56: := 431, -- NUMBER
57: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE);
58: -- NUMBER
59:

Line 57: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE);

53: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE
54: := 'EGO_MASTER_ITEMS', -- VARCHAR2
55: p_application_id IN ego_data_level_b.application_id %TYPE
56: := 431, -- NUMBER
57: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE);
58: -- NUMBER
59:
60: ------------------------------------------------------------------------------
61: --

Line 75: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE

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
78: := 431, -- NUMBER
79: x_attr_group_id OUT NOCOPY ego_obj_ag_assocs_b.attr_group_id %TYPE,

Line 77: p_application_id IN ego_data_level_b.application_id %TYPE

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
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);

Line 742: p_data_level_name IN ego_data_level_b.data_level_name %TYPE,

738: -------------------------------------------------------------------------------
739: Procedure Get_Data_Level_ID (
740: p_attribute_group_id IN ego_obj_ag_assocs_b.attr_group_id %TYPE,
741: -- NUMBER
742: p_data_level_name IN ego_data_level_b.data_level_name %TYPE,
743: -- VARCHAR2
744: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,
745: -- VARCHAR2
746: p_application_id IN ego_data_level_b.application_id %TYPE,

Line 744: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,

740: p_attribute_group_id IN ego_obj_ag_assocs_b.attr_group_id %TYPE,
741: -- NUMBER
742: p_data_level_name IN ego_data_level_b.data_level_name %TYPE,
743: -- VARCHAR2
744: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,
745: -- VARCHAR2
746: p_application_id IN ego_data_level_b.application_id %TYPE,
747: -- NUMBER
748: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE)

Line 746: p_application_id IN ego_data_level_b.application_id %TYPE,

742: p_data_level_name IN ego_data_level_b.data_level_name %TYPE,
743: -- VARCHAR2
744: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,
745: -- VARCHAR2
746: p_application_id IN ego_data_level_b.application_id %TYPE,
747: -- NUMBER
748: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE)
749: -- NUMBER
750: IS

Line 748: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE)

744: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,
745: -- VARCHAR2
746: p_application_id IN ego_data_level_b.application_id %TYPE,
747: -- NUMBER
748: x_data_level_id OUT NOCOPY ego_data_level_b.data_level_id %TYPE)
749: -- NUMBER
750: IS
751: l_api_name VARCHAR2(30) := 'Get_Data_Level_ID: ';
752:

Line 762: FROM ego_data_level_b

758: Debug_Msg(l_api_name || ' p_application_id => ' || p_application_id);
759:
760: SELECT data_level_id
761: INTO x_data_level_id
762: FROM ego_data_level_b
763: WHERE application_id = p_application_id AND
764: attr_group_type = p_attr_group_type AND
765: data_level_name = p_data_level_name;
766:

Line 785: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,

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,
788: -- NUMBER
789: x_attr_group_id OUT NOCOPY ego_obj_ag_assocs_b.attr_group_id %TYPE,

Line 787: p_application_id IN ego_data_level_b.application_id %TYPE,

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,
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)