119: --
120: -- Create a routing category and with default_flag 'Y'
121: -- File : pqrctapi.pkh/pkb
122: --
123: pqh_routing_categories_api.create_routing_category
124: (
125: p_validate => p_validate
126: ,p_routing_category_id => p_routing_category_id
127: ,p_transaction_category_id => p_transaction_category_id
265: Close csr_old_def_hierarchy;
266: --
267: -- Disable previously selected default hierarcy
268: --
269: pqh_routing_categories_api.update_routing_category
270: (
271: p_validate => p_validate
272: ,p_routing_category_id => p_old_routing_category_id
273: ,p_transaction_category_id => l_rct_record.transaction_category_id
324: --
325: --
326: -- Enable previously selected default hierarcy
327: --
328: pqh_routing_categories_api.update_routing_category
329: (
330: p_validate => p_validate
331: ,p_routing_category_id => p_routing_category_id
332: ,p_transaction_category_id => p_transaction_category_id
349:
350: --
351: -- Create a routing category and with default_flag 'Y'
352: --
353: pqh_routing_categories_api.create_routing_category
354: (
355: p_validate => p_validate
356: ,p_routing_category_id => p_routing_category_id
357: ,p_transaction_category_id => p_transaction_category_id
1354: If csr_attr%notfound then
1355: --
1356: For old_rec in csr_rout_hier loop
1357: --
1358: pqh_ROUTING_CATEGORIES_api.update_ROUTING_CATEGORY
1359: (
1360: p_validate => false
1361: ,p_routing_category_id => old_rec.routing_category_id
1362: ,p_enable_flag => 'N'