172:
173:
174: PROCEDURE pkg_init_boilerplate (
175: code IN OUT NOCOPY cn_utils.code_type,
176: package_name IN cn_obj_packages_v.name%TYPE,
177: description IN cn_obj_packages_v.description%TYPE,
178: object_type IN VARCHAR2) --,
179: -- p_org_id IN NUMBER) -- MOAC Change
180: IS
173:
174: PROCEDURE pkg_init_boilerplate (
175: code IN OUT NOCOPY cn_utils.code_type,
176: package_name IN cn_obj_packages_v.name%TYPE,
177: description IN cn_obj_packages_v.description%TYPE,
178: object_type IN VARCHAR2) --,
179: -- p_org_id IN NUMBER) -- MOAC Change
180: IS
181: x_userid VARCHAR2(20);
324: END check_create_object;
325:
326: PROCEDURE pkg_init (
327: module_id cn_modules.module_id%TYPE,
328: package_name cn_obj_packages_v.name%TYPE,
329: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
330: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
331: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
332: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
325:
326: PROCEDURE pkg_init (
327: module_id cn_modules.module_id%TYPE,
328: package_name cn_obj_packages_v.name%TYPE,
329: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
330: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
331: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
332: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
333: spec_code IN OUT NOCOPY cn_utils.code_type,
326: PROCEDURE pkg_init (
327: module_id cn_modules.module_id%TYPE,
328: package_name cn_obj_packages_v.name%TYPE,
329: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
330: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
331: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
332: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
333: spec_code IN OUT NOCOPY cn_utils.code_type,
334: body_code IN OUT NOCOPY cn_utils.code_type,
327: module_id cn_modules.module_id%TYPE,
328: package_name cn_obj_packages_v.name%TYPE,
329: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
330: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
331: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
332: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
333: spec_code IN OUT NOCOPY cn_utils.code_type,
334: body_code IN OUT NOCOPY cn_utils.code_type,
335: p_org_id IN NUMBER) IS -- MOAC Change
328: package_name cn_obj_packages_v.name%TYPE,
329: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
330: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
331: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
332: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
333: spec_code IN OUT NOCOPY cn_utils.code_type,
334: body_code IN OUT NOCOPY cn_utils.code_type,
335: p_org_id IN NUMBER) IS -- MOAC Change
336:
511: AS
512: l_module_id cn_modules.module_id%TYPE;
513: l_object_id cn_objects.object_id%TYPE;
514: l_org_id VARCHAR2(5);
515: l_pkg_spec_id cn_obj_packages_v.package_id%TYPE;
516: l_pkg_body_id cn_obj_packages_v.package_id%TYPE;
517: l_spec_code cn_utils.code_type;
518: l_body_code cn_utils.code_type;
519: l_pkg_spec_desc cn_obj_packages_v.description%TYPE;
512: l_module_id cn_modules.module_id%TYPE;
513: l_object_id cn_objects.object_id%TYPE;
514: l_org_id VARCHAR2(5);
515: l_pkg_spec_id cn_obj_packages_v.package_id%TYPE;
516: l_pkg_body_id cn_obj_packages_v.package_id%TYPE;
517: l_spec_code cn_utils.code_type;
518: l_body_code cn_utils.code_type;
519: l_pkg_spec_desc cn_obj_packages_v.description%TYPE;
520: l_pkg_body_desc cn_obj_packages_v.description%TYPE;
515: l_pkg_spec_id cn_obj_packages_v.package_id%TYPE;
516: l_pkg_body_id cn_obj_packages_v.package_id%TYPE;
517: l_spec_code cn_utils.code_type;
518: l_body_code cn_utils.code_type;
519: l_pkg_spec_desc cn_obj_packages_v.description%TYPE;
520: l_pkg_body_desc cn_obj_packages_v.description%TYPE;
521: l_pkg_name cn_obj_packages_v.NAME%TYPE;
522: l_creation_status BOOLEAN;
523: l_user VARCHAR2(15);
516: l_pkg_body_id cn_obj_packages_v.package_id%TYPE;
517: l_spec_code cn_utils.code_type;
518: l_body_code cn_utils.code_type;
519: l_pkg_spec_desc cn_obj_packages_v.description%TYPE;
520: l_pkg_body_desc cn_obj_packages_v.description%TYPE;
521: l_pkg_name cn_obj_packages_v.NAME%TYPE;
522: l_creation_status BOOLEAN;
523: l_user VARCHAR2(15);
524: l_repository_id cn_repositories.repository_id%TYPE;
517: l_spec_code cn_utils.code_type;
518: l_body_code cn_utils.code_type;
519: l_pkg_spec_desc cn_obj_packages_v.description%TYPE;
520: l_pkg_body_desc cn_obj_packages_v.description%TYPE;
521: l_pkg_name cn_obj_packages_v.NAME%TYPE;
522: l_creation_status BOOLEAN;
523: l_user VARCHAR2(15);
524: l_repository_id cn_repositories.repository_id%TYPE;
525: