192: ) IS
193: BEGIN
194: SELECT fdc.category_id
195: INTO p_category_id
196: FROM fnd_document_categories fdc
197: WHERE upper(fdc.name) = decode(p_usage_id, 2, 'VENDOR' ,
198: 3, 'BUYER' ,
199: 4, 'RECEIVER' ,
200: 5, 'APPROVER' ,
235: 'INVOICE INTERNAL' ,12,
236: 'PAYABLES' ,13)
237:
238: INTO p_usage_id
239: FROM fnd_document_categories fdc
240: WHERE fdc.category_id = p_category_id;
241:
242: EXCEPTION
243: WHEN NO_DATA_FOUND THEN