DBA Data[Home] [Help]

APPS.CN_SCA_INTERFACE_MAP_PVT dependencies on CN_OBJ_PACKAGES_V

Line 176: package_name IN cn_obj_packages_v.name%TYPE,

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

Line 177: description IN cn_obj_packages_v.description%TYPE,

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);

Line 328: package_name cn_obj_packages_v.name%TYPE,

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,

Line 329: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%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,

Line 330: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%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,

Line 331: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%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

Line 332: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%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
336:

Line 515: l_pkg_spec_id cn_obj_packages_v.package_id%TYPE;

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;

Line 516: l_pkg_body_id cn_obj_packages_v.package_id%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;

Line 519: l_pkg_spec_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);

Line 520: l_pkg_body_desc cn_obj_packages_v.description%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);
524: l_repository_id cn_repositories.repository_id%TYPE;

Line 521: l_pkg_name cn_obj_packages_v.NAME%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: