372: -- 18-NOV-93 Devesh Khatu Created
373: --+
374: PROCEDURE pkg_init (
375: module_id cn_modules.module_id%TYPE,
376: package_name cn_obj_packages_v.name%TYPE,
377: package_org_append VARCHAR2,
378: package_type cn_obj_packages_v.package_type%TYPE,
379: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
380: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
374: PROCEDURE pkg_init (
375: module_id cn_modules.module_id%TYPE,
376: package_name cn_obj_packages_v.name%TYPE,
377: package_org_append VARCHAR2,
378: package_type cn_obj_packages_v.package_type%TYPE,
379: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
380: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
381: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
382: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
375: module_id cn_modules.module_id%TYPE,
376: package_name cn_obj_packages_v.name%TYPE,
377: package_org_append VARCHAR2,
378: package_type cn_obj_packages_v.package_type%TYPE,
379: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
380: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
381: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
382: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
383: spec_code IN OUT NOCOPY cn_utils.code_type,
376: package_name cn_obj_packages_v.name%TYPE,
377: package_org_append VARCHAR2,
378: package_type cn_obj_packages_v.package_type%TYPE,
379: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
380: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
381: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
382: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
383: spec_code IN OUT NOCOPY cn_utils.code_type,
384: body_code IN OUT NOCOPY cn_utils.code_type);
377: package_org_append VARCHAR2,
378: package_type cn_obj_packages_v.package_type%TYPE,
379: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
380: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
381: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
382: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
383: spec_code IN OUT NOCOPY cn_utils.code_type,
384: body_code IN OUT NOCOPY cn_utils.code_type);
385:
378: package_type cn_obj_packages_v.package_type%TYPE,
379: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
380: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
381: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
382: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
383: spec_code IN OUT NOCOPY cn_utils.code_type,
384: body_code IN OUT NOCOPY cn_utils.code_type);
385:
386: --+
391: -- History
392: -- 18-NOV-93 Devesh Khatu Created
393: --+
394: PROCEDURE pkg_end (
395: package_name cn_obj_packages_v.name%TYPE,
396: package_spec_id cn_obj_packages_v.package_id%TYPE,
397: package_body_id cn_obj_packages_v.package_id%TYPE,
398: spec_code IN OUT NOCOPY cn_utils.code_type,
399: body_code IN OUT NOCOPY cn_utils.code_type);
392: -- 18-NOV-93 Devesh Khatu Created
393: --+
394: PROCEDURE pkg_end (
395: package_name cn_obj_packages_v.name%TYPE,
396: package_spec_id cn_obj_packages_v.package_id%TYPE,
397: package_body_id cn_obj_packages_v.package_id%TYPE,
398: spec_code IN OUT NOCOPY cn_utils.code_type,
399: body_code IN OUT NOCOPY cn_utils.code_type);
400:
393: --+
394: PROCEDURE pkg_end (
395: package_name cn_obj_packages_v.name%TYPE,
396: package_spec_id cn_obj_packages_v.package_id%TYPE,
397: package_body_id cn_obj_packages_v.package_id%TYPE,
398: spec_code IN OUT NOCOPY cn_utils.code_type,
399: body_code IN OUT NOCOPY cn_utils.code_type);
400:
401:
408: -- 18-NOV-93 RK Created
409: --+
410: /*PROCEDURE pkg_init (
411: module_id cn_modules.module_id%TYPE,
412: package_name cn_obj_packages_v.name%TYPE,
413: package_org_append VARCHAR2,
414: package_type cn_obj_packages_v.package_type%TYPE,
415: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
416: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
410: /*PROCEDURE pkg_init (
411: module_id cn_modules.module_id%TYPE,
412: package_name cn_obj_packages_v.name%TYPE,
413: package_org_append VARCHAR2,
414: package_type cn_obj_packages_v.package_type%TYPE,
415: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
416: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
417: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
418: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
411: module_id cn_modules.module_id%TYPE,
412: package_name cn_obj_packages_v.name%TYPE,
413: package_org_append VARCHAR2,
414: package_type cn_obj_packages_v.package_type%TYPE,
415: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
416: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
417: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
418: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
419: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
412: package_name cn_obj_packages_v.name%TYPE,
413: package_org_append VARCHAR2,
414: package_type cn_obj_packages_v.package_type%TYPE,
415: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
416: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
417: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
418: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
419: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
420: body_code IN OUT NOCOPY cn_utils.clob_code_type);*/
413: package_org_append VARCHAR2,
414: package_type cn_obj_packages_v.package_type%TYPE,
415: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
416: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
417: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
418: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
419: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
420: body_code IN OUT NOCOPY cn_utils.clob_code_type);*/
421:
414: package_type cn_obj_packages_v.package_type%TYPE,
415: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
416: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
417: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
418: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
419: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
420: body_code IN OUT NOCOPY cn_utils.clob_code_type);*/
421:
422: --+
427: -- History
428: -- 18-NOV-93 RK Created
429: --+
430: PROCEDURE pkg_end (
431: package_name cn_obj_packages_v.name%TYPE,
432: package_spec_id cn_obj_packages_v.package_id%TYPE,
433: package_body_id cn_obj_packages_v.package_id%TYPE,
434: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
435: body_code IN OUT NOCOPY cn_utils.clob_code_type);
428: -- 18-NOV-93 RK Created
429: --+
430: PROCEDURE pkg_end (
431: package_name cn_obj_packages_v.name%TYPE,
432: package_spec_id cn_obj_packages_v.package_id%TYPE,
433: package_body_id cn_obj_packages_v.package_id%TYPE,
434: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
435: body_code IN OUT NOCOPY cn_utils.clob_code_type);
436:
429: --+
430: PROCEDURE pkg_end (
431: package_name cn_obj_packages_v.name%TYPE,
432: package_spec_id cn_obj_packages_v.package_id%TYPE,
433: package_body_id cn_obj_packages_v.package_id%TYPE,
434: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
435: body_code IN OUT NOCOPY cn_utils.clob_code_type);
436:
437: --+
443: -- 18-NOV-93 Devesh Khatu Created
444: --+
445: PROCEDURE pkg_init (
446: module_id cn_modules.module_id%TYPE,
447: package_name cn_obj_packages_v.name%TYPE,
448: package_org_append VARCHAR2,
449: package_type cn_obj_packages_v.package_type%TYPE,
450: package_flag VARCHAR2,
451: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
445: PROCEDURE pkg_init (
446: module_id cn_modules.module_id%TYPE,
447: package_name cn_obj_packages_v.name%TYPE,
448: package_org_append VARCHAR2,
449: package_type cn_obj_packages_v.package_type%TYPE,
450: package_flag VARCHAR2,
451: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
452: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
453: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
447: package_name cn_obj_packages_v.name%TYPE,
448: package_org_append VARCHAR2,
449: package_type cn_obj_packages_v.package_type%TYPE,
450: package_flag VARCHAR2,
451: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
452: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
453: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
454: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
455: spec_code IN OUT NOCOPY cn_utils.code_type,
448: package_org_append VARCHAR2,
449: package_type cn_obj_packages_v.package_type%TYPE,
450: package_flag VARCHAR2,
451: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
452: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
453: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
454: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
455: spec_code IN OUT NOCOPY cn_utils.code_type,
456: body_code IN OUT NOCOPY cn_utils.code_type);
449: package_type cn_obj_packages_v.package_type%TYPE,
450: package_flag VARCHAR2,
451: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
452: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
453: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
454: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
455: spec_code IN OUT NOCOPY cn_utils.code_type,
456: body_code IN OUT NOCOPY cn_utils.code_type);
457:
450: package_flag VARCHAR2,
451: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
452: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
453: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
454: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
455: spec_code IN OUT NOCOPY cn_utils.code_type,
456: body_code IN OUT NOCOPY cn_utils.code_type);
457:
458:
465: -- 18-NOV-93 RK Created
466: --+
467: PROCEDURE pkg_init (
468: module_id cn_modules.module_id%TYPE,
469: package_name cn_obj_packages_v.name%TYPE,
470: package_org_append VARCHAR2,
471: package_type cn_obj_packages_v.package_type%TYPE,
472: package_flag VARCHAR2,
473: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
467: PROCEDURE pkg_init (
468: module_id cn_modules.module_id%TYPE,
469: package_name cn_obj_packages_v.name%TYPE,
470: package_org_append VARCHAR2,
471: package_type cn_obj_packages_v.package_type%TYPE,
472: package_flag VARCHAR2,
473: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
474: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
475: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
469: package_name cn_obj_packages_v.name%TYPE,
470: package_org_append VARCHAR2,
471: package_type cn_obj_packages_v.package_type%TYPE,
472: package_flag VARCHAR2,
473: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
474: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
475: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
476: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
477: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
470: package_org_append VARCHAR2,
471: package_type cn_obj_packages_v.package_type%TYPE,
472: package_flag VARCHAR2,
473: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
474: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
475: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
476: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
477: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
478: body_code IN OUT NOCOPY cn_utils.clob_code_type);
471: package_type cn_obj_packages_v.package_type%TYPE,
472: package_flag VARCHAR2,
473: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
474: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
475: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
476: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
477: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
478: body_code IN OUT NOCOPY cn_utils.clob_code_type);
479:
472: package_flag VARCHAR2,
473: package_spec_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
474: package_body_id IN OUT NOCOPY cn_obj_packages_v.package_id%TYPE,
475: package_spec_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
476: package_body_desc IN OUT NOCOPY cn_obj_packages_v.description%TYPE,
477: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
478: body_code IN OUT NOCOPY cn_utils.clob_code_type);
479:
480:
486: -- History
487: -- 18-NOV-93 Devesh Khatu Created
488: --+
489: PROCEDURE pkg_end (
490: package_name cn_obj_packages_v.name%TYPE,
491: spec_code IN OUT NOCOPY cn_utils.code_type,
492: body_code IN OUT NOCOPY cn_utils.code_type);
493:
494:
500: -- History
501: -- 18-NOV-93 RK Created
502: --+
503: PROCEDURE pkg_end (
504: package_name cn_obj_packages_v.name%TYPE,
505: spec_code IN OUT NOCOPY cn_utils.clob_code_type,
506: body_code IN OUT NOCOPY cn_utils.clob_code_type);
507:
508:
516: --+
517: --+
518: PROCEDURE pkg_end_boilerplate (
519: code IN OUT NOCOPY cn_utils.code_type,
520: object_type cn_obj_packages_v.object_type%TYPE);
521:
522:
523:
524: --+
530: --+ CLOB
531: --+
532: PROCEDURE pkg_end_boilerplate (
533: code IN OUT NOCOPY cn_utils.clob_code_type,
534: object_type cn_obj_packages_v.object_type%TYPE);
535:
536:
537:
538: