DBA Data[Home] [Help]

APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_OBJ_PACKAGES_V

Line 25: g_package_name cn_obj_packages_v.name%TYPE;

21:
22:
23: --
24: -- Global Variables
25: g_package_name cn_obj_packages_v.name%TYPE;
26: g_org_id cn_sca_credit_rules.org_id%TYPE;
27: --
28: PROCEDURE get_min ( p_min IN OUT NOCOPY number, p_max number) IS
29: BEGIN

Line 231: package_name IN cn_obj_packages_v.name%TYPE,

227: END check_create_object;
228: --
229: PROCEDURE pkg_init_boilerplate (
230: code IN OUT NOCOPY cn_utils.code_type,
231: package_name IN cn_obj_packages_v.name%TYPE,
232: description IN cn_obj_packages_v.description%TYPE,
233: object_type IN VARCHAR2)
234: IS
235: x_userid VARCHAR2(20);

Line 232: description IN cn_obj_packages_v.description%TYPE,

228: --
229: PROCEDURE pkg_init_boilerplate (
230: code IN OUT NOCOPY cn_utils.code_type,
231: package_name IN cn_obj_packages_v.name%TYPE,
232: description IN cn_obj_packages_v.description%TYPE,
233: object_type IN VARCHAR2)
234: IS
235: x_userid VARCHAR2(20);
236: BEGIN

Line 271: package_name cn_obj_packages_v.name%TYPE,

267: END pkg_init_boilerplate;
268: --
269: PROCEDURE pkg_init (
270: module_id cn_modules.module_id%TYPE,
271: package_name cn_obj_packages_v.name%TYPE,
272: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
273: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
274: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
275: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

Line 272: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

268: --
269: PROCEDURE pkg_init (
270: module_id cn_modules.module_id%TYPE,
271: package_name cn_obj_packages_v.name%TYPE,
272: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
273: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
274: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
275: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
276: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 273: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,

269: PROCEDURE pkg_init (
270: module_id cn_modules.module_id%TYPE,
271: package_name cn_obj_packages_v.name%TYPE,
272: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
273: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
274: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
275: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
276: spec_code IN OUT NOCOPY cn_utils.code_type,
277: body_code IN OUT NOCOPY cn_utils.code_type) IS

Line 274: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

270: module_id cn_modules.module_id%TYPE,
271: package_name cn_obj_packages_v.name%TYPE,
272: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
273: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
274: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
275: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
276: spec_code IN OUT NOCOPY cn_utils.code_type,
277: body_code IN OUT NOCOPY cn_utils.code_type) IS
278:

Line 275: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,

271: package_name cn_obj_packages_v.name%TYPE,
272: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
273: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
274: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
275: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
276: spec_code IN OUT NOCOPY cn_utils.code_type,
277: body_code IN OUT NOCOPY cn_utils.code_type) IS
278:
279: x_rowid ROWID;

Line 379: package_spec_id cn_obj_packages_v.package_id%TYPE;

375: --
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;

Line 690: package_name cn_obj_packages_v.name%TYPE;

686: FUNCTION create_sca_rules_batch_dyn (
687: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
688: RETURN BOOLEAN IS
689: -- Variables Section
690: package_name cn_obj_packages_v.name%TYPE;
691: package_spec_id cn_obj_packages_v.package_id%TYPE;
692: package_body_id cn_obj_packages_v.package_id%TYPE;
693: package_spec_desc cn_obj_packages_v.description%TYPE;
694: package_body_desc cn_obj_packages_v.description%TYPE;

Line 691: package_spec_id cn_obj_packages_v.package_id%TYPE;

687: x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
688: RETURN BOOLEAN IS
689: -- Variables Section
690: package_name cn_obj_packages_v.name%TYPE;
691: package_spec_id cn_obj_packages_v.package_id%TYPE;
692: package_body_id cn_obj_packages_v.package_id%TYPE;
693: package_spec_desc cn_obj_packages_v.description%TYPE;
694: package_body_desc cn_obj_packages_v.description%TYPE;
695: spec_code cn_utils.code_type;

Line 692: package_body_id cn_obj_packages_v.package_id%TYPE;

688: RETURN BOOLEAN IS
689: -- Variables Section
690: package_name cn_obj_packages_v.name%TYPE;
691: package_spec_id cn_obj_packages_v.package_id%TYPE;
692: package_body_id cn_obj_packages_v.package_id%TYPE;
693: package_spec_desc cn_obj_packages_v.description%TYPE;
694: package_body_desc cn_obj_packages_v.description%TYPE;
695: spec_code cn_utils.code_type;
696: body_code cn_utils.code_type;

Line 693: package_spec_desc cn_obj_packages_v.description%TYPE;

689: -- Variables Section
690: package_name cn_obj_packages_v.name%TYPE;
691: package_spec_id cn_obj_packages_v.package_id%TYPE;
692: package_body_id cn_obj_packages_v.package_id%TYPE;
693: package_spec_desc cn_obj_packages_v.description%TYPE;
694: package_body_desc cn_obj_packages_v.description%TYPE;
695: spec_code cn_utils.code_type;
696: body_code cn_utils.code_type;
697: dummy NUMBER(7);

Line 694: package_body_desc cn_obj_packages_v.description%TYPE;

690: package_name cn_obj_packages_v.name%TYPE;
691: package_spec_id cn_obj_packages_v.package_id%TYPE;
692: package_body_id cn_obj_packages_v.package_id%TYPE;
693: package_spec_desc cn_obj_packages_v.description%TYPE;
694: package_body_desc cn_obj_packages_v.description%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);