[Home] [Help]
157: -- Get the object_id in cn_objects for formula, if not exist, create it.
158: PROCEDURE check_create_object(x_name cn_objects.name%TYPE,
159: x_object_type cn_objects.object_type%TYPE,
160: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
161: x_repository_id cn_repositories.repository_id%TYPE)
162: IS
163: dummy NUMBER;
164: x_rowid ROWID;
165: BEGIN
276: procedure_name cn_obj_procedures_v.name%TYPE;
277: procedure_desc cn_obj_procedures_v.description%TYPE;
278: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
279: package_spec_id cn_obj_packages_v.package_id%TYPE;
280: x_repository_id cn_repositories.repository_id%TYPE;
281: l_attrib_counter NUMBER := 1;
282: l_rule_counter NUMBER := 1;
283:
284: -- ganesh uncomment out enabled flag .
513: spec_code cn_utils.code_type;
514: body_code cn_utils.code_type;
515: dummy NUMBER(7);
516: l_module_id number(15);
517: l_repository_id cn_repositories.repository_id%TYPE;
518: l_org_id NUMBER;
519: BEGIN
520:
521: --SELECT repository_id, org_id
518: l_org_id NUMBER;
519: BEGIN
520:
521: --SELECT repository_id, org_id
522: --INTO l_repository_id, l_org_id FROM cn_repositories;
523:
524: cn_utils.set_org_id(g_org_id);
525:
526: SELECT repository_id INTO l_repository_id FROM cn_repositories;
522: --INTO l_repository_id, l_org_id FROM cn_repositories;
523:
524: cn_utils.set_org_id(g_org_id);
525:
526: SELECT repository_id INTO l_repository_id FROM cn_repositories;
527:
528: package_name := 'cn_sca_rodyn_'|| substr(lower(x_transaction_source),1,8) || '_' || abs(g_org_id) || '_pkg';
529: g_package_name := package_name;
530:
599: -- Codes start here
600:
601: g_org_id := p_org_id;
602:
603: -- SELECT org_id INTO l_org_id FROM cn_repositories;
604:
605: l_pkg_name := 'cn_sca_rodyn_'|| substr(lower(x_transaction_source),1,8) || '_' || abs(g_org_id) || '_pkg';
606:
607: l_status := create_sca_rules_online_dyn(x_transaction_source);