[Home] [Help]
72:
73: cursor get_key_cols (p_attr_group_type varchar2,
74: p_attr_group_name varchar2 ) is
75: select database_column
76: from ego_attrs_v
77: where ATTR_GROUP_TYPE = p_attr_group_type
78: and ATTR_GROUP_NAME = p_attr_group_name
79: and UNIQUE_KEY_FLAG = 'Y'
80: order by sequence;
153: PO_LOG.stmt(d_module,d_progress,'l_attr_grp_id',l_attr_grp_id);
154: PO_LOG.stmt(d_module,d_progress,'l_attr_grp_name',l_attr_grp_name);
155: END IF;
156:
157: -- next hit ego_attrs_v to get the db column name
158: d_progress := 040;
159: begin
160: if p_attr_id is not null then
161:
160: if p_attr_id is not null then
161:
162: select database_column, application_id, attr_name, attr_id, DATA_TYPE_CODE
163: into l_db_col_name, l_application_id, l_attr_int_name, l_attr_id, l_data_type_code
164: from ego_attrs_v
165: where attr_id = p_attr_id
166: and ATTR_GROUP_NAME = l_attr_grp_name
167: and ATTR_GROUP_TYPE = l_attr_group_Type;
168:
168:
169: elsif p_attr_int_name is not null then
170: select database_column, application_id, attr_name, attr_id, DATA_TYPE_CODE
171: into l_db_col_name, l_application_id, l_attr_int_name, l_attr_id, l_data_type_code
172: from ego_attrs_v
173: where ATTR_NAME = p_attr_int_name
174: and ATTR_GROUP_NAME = l_attr_grp_name
175: and ATTR_GROUP_TYPE = l_attr_group_Type;
176:
581: begin
582: if p_attr_int_name is not null and p_attr_id is null then
583: select attr_id , attr_name
584: into l_attr_id , l_attr_name
585: from ego_attrs_v
586: where attr_name = p_attr_int_name
587: and attr_group_name = l_ag_name
588: and attr_group_type = l_attr_group_type;
589: else
588: and attr_group_type = l_attr_group_type;
589: else
590: select attr_id , attr_name
591: into l_attr_id, l_attr_name
592: from ego_attrs_v
593: where attr_id = p_attr_id
594: and attr_group_name = l_ag_name
595: and attr_group_type = l_attr_group_type;
596: end if;