APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_REPOSITORIES

Line 185: x_repository_id cn_repositories.repository_id%TYPE) IS

181: PROCEDURE check_create_object(
182: x_name cn_objects.name%TYPE,
183: x_object_type cn_objects.object_type%TYPE,
184: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
185: x_repository_id cn_repositories.repository_id%TYPE) IS
186: --
187: dummy NUMBER;
188: x_rowid ROWID;
189: --

Line 380: x_repository_id cn_repositories.repository_id%TYPE;

376: procedure_name cn_obj_procedures_v.name%TYPE;
377: procedure_desc cn_obj_procedures_v.description%TYPE;
378: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
379: package_spec_id cn_obj_packages_v.package_id%TYPE;
380: x_repository_id cn_repositories.repository_id%TYPE;
381: l_attr_counter NUMBER := 1;
382: l_rule_counter NUMBER := 1;
383: l_operator_counter NUMBER := 1;
384: l_comb_counter NUMBER := 1;

Line 699: l_repository_id cn_repositories.repository_id%TYPE;

695: spec_code cn_utils.code_type;
696: body_code cn_utils.code_type;
697: dummy NUMBER(7);
698: l_module_id number(15);
699: l_repository_id cn_repositories.repository_id%TYPE;
700: l_org_id NUMBER;
701: --
702: BEGIN
703:

Line 707: from cn_repositories where org_id = g_org_id;

703:
704: cn_utils.set_org_id(g_org_id);
705:
706: select repository_id into l_repository_id
707: from cn_repositories where org_id = g_org_id;
708:
709:
710: package_name := 'cn_sca_batch_'||lower(x_transaction_source)||'_'||
711: abs(g_org_id)||'_pkg';

Line 798: -- SELECT org_id INTO l_org_id FROM cn_repositories;

794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795:
796:
797: -- Codes start here
798: -- SELECT org_id INTO l_org_id FROM cn_repositories;
799: g_org_id := p_org_id;
800:
801: l_pkg_name := 'cn_sca_batch_'||lower(x_transaction_source)||'_'||
802: abs(g_org_id)||'_pkg';