DBA Data[Home] [Help]

APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on FND_API

Line 12: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;

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)

Line 13: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;

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;

Line 14: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;

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:

Line 15: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;

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 (

Line 17: := fnd_api.g_ret_sts_unexp_error;

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,

Line 572: p_commit IN VARCHAR2 := fnd_api.g_false

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,

Line 578: p_commit IN VARCHAR2 := fnd_api.g_false

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 ,

Line 584: p_commit IN VARCHAR2 := fnd_api.g_false

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 ,

Line 590: p_commit IN VARCHAR2 := fnd_api.g_false

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,

Line 595: 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,
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,

Line 600: p_commit IN VARCHAR2 := fnd_api.g_false

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,

Line 605: p_commit IN VARCHAR2 := fnd_api.g_false

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,

Line 611: p_commit IN VARCHAR2 := fnd_api.g_false,

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

Line 620: p_commit IN VARCHAR2 := fnd_api.g_false

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,

Line 626: p_commit IN VARCHAR2 := fnd_api.g_false,

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

Line 635: p_commit IN VARCHAR2 := fnd_api.g_false,

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

Line 644: p_commit IN VARCHAR2 := fnd_api.g_false,

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