1010:
1011: Begin
1012: select inventory_item_id
1013: into l_inventory_item_id
1014: from csd_sc_domains_v
1015: where sc_domain_id = p_sc_domain_rec.sc_domain_id
1016: and domain_type_code = p_sc_domain_rec.domain_type_code;
1017:
1018: Exception
1087:
1088: Begin
1089: select category_set_id
1090: into l_category_set_id
1091: from csd_sc_domains_v
1092: where sc_domain_id = p_sc_domain_rec.sc_domain_id
1093: and domain_type_code = p_sc_domain_rec.domain_type_code;
1094:
1095: Exception
1183:
1184: Begin
1185: select category_id
1186: into l_category_id
1187: from csd_sc_domains_v
1188: where sc_domain_id = p_sc_domain_rec.sc_domain_id
1189: and domain_type_code = p_sc_domain_rec.domain_type_code;
1190:
1191: Exception