[Home] [Help]
PACKAGE: APPS.OKC_IMP_TERMS_TEMPLATES_PUB
Source
1 PACKAGE okc_imp_terms_templates_pub
2 /*$Header: OKCPITTS.pls 120.1.12020000.2 2012/07/16 16:13:45 harchand ship $*/
3 AS
4 PROCEDURE create_template (
5 p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
6 p_commit IN VARCHAR2 := fnd_api.g_false
7 );
8
9 PROCEDURE create_article (
10 p_article_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.k_article_tbl_type,
11 p_commit IN VARCHAR2 := fnd_api.g_false
12 );
13
14 PROCEDURE create_section (
15 p_section_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.section_tbl_type,
16 p_commit IN VARCHAR2 := fnd_api.g_false
17 );
18
19 PROCEDURE create_deliverable (
20 p_deliverable_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_tbl_type,
21 p_commit IN VARCHAR2 := fnd_api.g_false
22 );
23
24 PROCEDURE update_template( p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
25 p_commit IN VARCHAR2 := fnd_api.g_false
26 );
27
28 PROCEDURE create_template_revision (
29 p_template_id IN NUMBER,
30 p_copy_deliverables IN VARCHAR2 DEFAULT 'Y',
31 p_commit IN VARCHAR2 := fnd_api.g_false,
32 x_new_template_id OUT NOCOPY NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER
36 );
37
38 PROCEDURE delete_articles (
39 p_template_id IN NUMBER,
40 p_k_article_id_tbl IN okc_imp_terms_templates_pvt.k_article_id_tbl_type,
41 p_commit IN VARCHAR2 := fnd_api.g_false,
42 x_k_article_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.k_article_id_tbl_type,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE delete_sections (
48 p_template_id IN NUMBER,
49 p_section_id_tbl IN okc_imp_terms_templates_pvt.section_id_tbl_type,
50 p_commit IN VARCHAR2 := fnd_api.g_false,
51 x_section_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.section_id_tbl_type,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE delete_deliverables (
57 p_template_id IN NUMBER,
58 p_deliverable_id_tbl IN okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
59 p_commit IN VARCHAR2 := fnd_api.g_false,
60 x_deliverable_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 -- Template Usages --
66 PROCEDURE create_tmpl_usage (
67 p_template_id IN NUMBER,
68 p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
69 p_commit IN VARCHAR2 := fnd_api.g_false
70 );
71
72 PROCEDURE update_tmpl_usage(
73 p_template_id IN NUMBER ,
74 p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
75 p_commit IN VARCHAR2 := fnd_api.g_false
76 );
77
78 PROCEDURE delete_tmpl_usage (
79 p_template_id IN NUMBER ,
80 p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
81 p_commit IN VARCHAR2 := fnd_api.g_false
82 );
83 END okc_imp_terms_templates_pub;