204: BEGIN
205:
206: SELECT snu.category_id
207: INTO p_category_id
208: FROM so_note_usages snu
209: WHERE snu.usage_id = p_usage_id;
210:
211:
212: EXCEPTION
223:
224: SELECT snu.usage_id
225: INTO p_usage_id
226: FROM fnd_document_categories fdc,
227: so_note_usages snu
228: WHERE fdc.category_id = snu.category_id
229: AND fdc.category_id = p_category_id;
230:
231: END;
1092: RETURN;
1093: END IF;
1094:
1095: CLOSE C;
1096: SELECT so_note_usages_s.nextval
1097: INTO p_usage_id
1098: FROM dual;
1099:
1100: