8: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
9: ------------------------------------------------------------------------------
10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
13: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
14: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
16: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
9: ------------------------------------------------------------------------------
10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
13: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
14: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
16: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
17: := fnd_api.g_ret_sts_unexp_error;
10: -- GLOBAL CONSTANTS
11: ------------------------------------------------------------------------------
12: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
13: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
14: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
16: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
17: := fnd_api.g_ret_sts_unexp_error;
18:
11: ------------------------------------------------------------------------------
12: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
13: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
14: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
16: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
17: := fnd_api.g_ret_sts_unexp_error;
18:
19: TYPE terms_template_rec_type IS RECORD (
13: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
14: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
15: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
16: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
17: := fnd_api.g_ret_sts_unexp_error;
18:
19: TYPE terms_template_rec_type IS RECORD (
20: template_id okc_terms_templates_all.template_id%TYPE
21: := okc_api.g_miss_num,
568: INDEX BY PLS_INTEGER;
569:
570: PROCEDURE create_template (
571: p_template_tbl IN OUT NOCOPY terms_template_tbl_type,
572: p_commit IN VARCHAR2 := fnd_api.g_false
573: );
574:
575: PROCEDURE create_tmpl_usage (
576: p_template_id IN NUMBER,
574:
575: PROCEDURE create_tmpl_usage (
576: p_template_id IN NUMBER,
577: p_tmpl_usage_tbl IN OUT NOCOPY tmpl_usage_tbl_type,
578: p_commit IN VARCHAR2 := fnd_api.g_false
579: );
580:
581: PROCEDURE update_tmpl_usage(
582: p_template_id IN NUMBER ,
580:
581: PROCEDURE update_tmpl_usage(
582: p_template_id IN NUMBER ,
583: p_tmpl_usage_tbl IN OUT NOCOPY tmpl_usage_tbl_type,
584: p_commit IN VARCHAR2 := fnd_api.g_false
585: );
586:
587: PROCEDURE delete_tmpl_usage (
588: p_template_id IN NUMBER ,
586:
587: PROCEDURE delete_tmpl_usage (
588: p_template_id IN NUMBER ,
589: p_tmpl_usage_tbl IN OUT NOCOPY tmpl_usage_tbl_type,
590: p_commit IN VARCHAR2 := fnd_api.g_false
591: );
592:
593: PROCEDURE create_article (
594: p_article_tbl IN OUT NOCOPY k_article_tbl_type,
591: );
592:
593: PROCEDURE create_article (
594: p_article_tbl IN OUT NOCOPY k_article_tbl_type,
595: p_commit IN VARCHAR2 := fnd_api.g_false
596: );
597:
598: PROCEDURE create_section (
599: p_section_tbl IN OUT NOCOPY section_tbl_type,
596: );
597:
598: PROCEDURE create_section (
599: p_section_tbl IN OUT NOCOPY section_tbl_type,
600: p_commit IN VARCHAR2 := fnd_api.g_false
601: );
602:
603: PROCEDURE create_deliverable (
604: p_deliverable_tbl IN OUT NOCOPY deliverable_tbl_type,
601: );
602:
603: PROCEDURE create_deliverable (
604: p_deliverable_tbl IN OUT NOCOPY deliverable_tbl_type,
605: p_commit IN VARCHAR2 := fnd_api.g_false
606: );
607:
608: PROCEDURE create_template_revision (
609: p_template_id IN NUMBER,
607:
608: PROCEDURE create_template_revision (
609: p_template_id IN NUMBER,
610: p_copy_deliverables IN VARCHAR2 DEFAULT 'Y',
611: p_commit IN VARCHAR2 := fnd_api.g_false,
612: x_new_template_id OUT NOCOPY NUMBER,
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_data OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER
616: );
617:
618: PROCEDURE update_template (
619: p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
620: p_commit IN VARCHAR2 := fnd_api.g_false
621: );
622:
623: PROCEDURE delete_articles (
624: p_template_id IN NUMBER,
622:
623: PROCEDURE delete_articles (
624: p_template_id IN NUMBER,
625: p_k_article_id_tbl IN k_article_id_tbl_type,
626: p_commit IN VARCHAR2 := fnd_api.g_false,
627: x_k_article_id_tbl OUT NOCOPY k_article_id_tbl_type,
628: x_return_status OUT NOCOPY VARCHAR2,
629: x_msg_data OUT NOCOPY VARCHAR2
630: );
631:
632: PROCEDURE delete_sections (
633: p_template_id IN NUMBER,
634: p_section_id_tbl IN section_id_tbl_type,
635: p_commit IN VARCHAR2 := fnd_api.g_false,
636: x_section_id_tbl OUT NOCOPY section_id_tbl_type,
637: x_return_status OUT NOCOPY VARCHAR2,
638: x_msg_data OUT NOCOPY VARCHAR2
639: );
640:
641: PROCEDURE delete_deliverables (
642: p_template_id IN NUMBER,
643: p_deliverable_id_tbl IN deliverable_id_tbl_type,
644: p_commit IN VARCHAR2 := fnd_api.g_false,
645: x_deliverable_id_tbl OUT NOCOPY deliverable_id_tbl_type,
646: x_return_status OUT NOCOPY VARCHAR2,
647: x_msg_data OUT NOCOPY VARCHAR2
648: );