DBA Data[Home] [Help]

APPS.POS_MERGE_SUPPLIER_PKG dependencies on EGO_ATTRS_V

Line 14: attr_name ego_attrs_v.attr_name%TYPE,

10:
11: TYPE uda_rec_tbl_type IS TABLE OF pos_supp_prof_ext_b%ROWTYPE INDEX BY BINARY_INTEGER;
12:
13: TYPE attributes_rec IS RECORD(
14: attr_name ego_attrs_v.attr_name%TYPE,
15: database_column ego_attrs_v.database_column%TYPE);
16:
17: TYPE attributes_coll_tab IS TABLE OF attributes_rec INDEX BY BINARY_INTEGER;
18: attributes_coll attributes_coll_tab;

Line 15: database_column ego_attrs_v.database_column%TYPE);

11: TYPE uda_rec_tbl_type IS TABLE OF pos_supp_prof_ext_b%ROWTYPE INDEX BY BINARY_INTEGER;
12:
13: TYPE attributes_rec IS RECORD(
14: attr_name ego_attrs_v.attr_name%TYPE,
15: database_column ego_attrs_v.database_column%TYPE);
16:
17: TYPE attributes_coll_tab IS TABLE OF attributes_rec INDEX BY BINARY_INTEGER;
18: attributes_coll attributes_coll_tab;
19:

Line 1128: FROM ego_attrs_v

1124:
1125: CURSOR get_attributes IS
1126: SELECT attr_name,
1127: database_column
1128: FROM ego_attrs_v
1129: WHERE application_id = 177
1130: AND attr_group_name = p_attribute_group_name
1131: AND attr_group_type = p_attribute_group_type;
1132:

Line 2821: FROM ego_attrs_v

2817: l_count NUMBER;
2818:
2819: CURSOR attr_unique_key IS
2820: SELECT database_column
2821: FROM ego_attrs_v
2822: WHERE application_id = 177
2823: AND attr_group_name = p_attribute_group_name
2824: AND attr_group_type = p_attribute_group_type
2825: AND unique_key_flag = 'Y';