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 741: p_data_level_name IN ego_data_level_b.data_level_name %TYPE,

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

Line 743: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,

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

Line 745: p_application_id IN ego_data_level_b.application_id %TYPE,

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

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

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

Line 761: FROM ego_data_level_b

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

Line 784: p_attr_group_type IN ego_data_level_b.attr_group_type %TYPE,

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

Line 786: p_application_id IN ego_data_level_b.application_id %TYPE,

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