APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_SOURCE

Line 287: -- Delete module source code from cn_source

283: -- Find the package objects
284: cn_utils.find_object(package_name,'PKS',package_spec_id, package_spec_desc, g_org_id);
285: cn_utils.find_object(package_name,'PKB',package_body_id, package_body_desc, g_org_id);
286:
287: -- Delete module source code from cn_source
288: -- Delete module object dependencies for this module
289: cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);
290:
291: cn_utils.init_code (package_spec_id, spec_code);

Line 817: FROM cn_source cs

813: AND co.object_type = 'PKS'
814: AND co.org_id = g_org_id;
815:
816: SELECT cs.text bulk collect INTO sqlstring
817: FROM cn_source cs
818: WHERE cs.object_id = l_pkg_object_id
819: AND cs.org_id = g_org_id
820: ORDER BY cs.line_no ;
821:

Line 844: FROM cn_source cs

840:
841: --dbms_output.put_line('pkb id is '|| l_pkg_object_id );
842:
843: SELECT cs.text bulk collect INTO sqlstring
844: FROM cn_source cs
845: WHERE cs.object_id = l_pkg_object_id
846: AND cs.org_id = g_org_id
847: ORDER BY cs.line_no ;
848: