DBA Data[Home] [Help]

APPS.PO_UDA_DATA_UTIL dependencies on EGO_ATTR_GROUPS_V

Line 1195: FROM EGO_ATTR_GROUPS_V

1191: FOR i IN 1..attribute_group_table.Count LOOP
1192: BEGIN
1193: SELECT attr_group_id
1194: INTO l_attr_group_id
1195: FROM EGO_ATTR_GROUPS_V
1196: WHERE ATTR_GROUP_TYPE = from_attr_group_Type
1197: AND ATTR_GROUP_NAME = attribute_group_table(i);
1198: EXCEPTION
1199: WHEN No_Data_Found THEN

Line 1974: FROM EGO_ATTR_GROUPS_V

1970:
1971: BEGIN
1972: SELECT attr_group_id
1973: INTO l_attr_group_id
1974: FROM EGO_ATTR_GROUPS_V
1975: WHERE ATTR_GROUP_TYPE = l_attr_group_Type
1976: AND ATTR_GROUP_NAME = x_attribute_group_table(i);
1977: EXCEPTION
1978: WHEN No_Data_Found THEN

Line 2151: FROM EGO_ATTR_GROUPS_V

2147: END IF;
2148:
2149: SELECT ATTR_GROUP_ID
2150: INTO l_attr_group_id
2151: FROM EGO_ATTR_GROUPS_V
2152: WHERE ATTR_GROUP_TYPE = 'PO_REQ_HEADER_EXT_ATTRS'
2153: AND ATTR_GROUP_NAME = 'addresses';
2154:
2155:

Line 2242: FROM EGO_ATTR_GROUPS_V

2238: END IF;
2239:
2240: SELECT ATTR_GROUP_ID
2241: INTO l_attr_group_id
2242: FROM EGO_ATTR_GROUPS_V
2243: WHERE ATTR_GROUP_TYPE = 'PO_HEADER_EXT_ATTRS'
2244: AND ATTR_GROUP_NAME = 'addresses';
2245:
2246: SELECT * BULK COLLECT INTO po_address_rows FROM po_headers_all_ext_b

Line 2602: from ego_attr_groups_v

2598: l_attr_grp_id := p_attr_grp_id;
2599:
2600: select attr_group_name
2601: into l_attr_grp_name
2602: from ego_attr_groups_v
2603: where ATTR_GROUP_TYPE = l_attr_group_Type
2604: and attr_group_id = l_attr_grp_id
2605: AND MULTI_ROW_CODE = 'N';
2606:

Line 2612: from ego_attr_groups_v

2608: l_attr_grp_name := p_attr_grp_int_name;
2609:
2610: select attr_group_id
2611: into l_attr_grp_id
2612: from ego_attr_groups_v
2613: where ATTR_GROUP_TYPE = l_attr_group_Type
2614: and attr_group_name = l_attr_grp_name
2615: AND MULTI_ROW_CODE = 'N';
2616: