[Home] [Help]
PACKAGE BODY: APPS.OKC_IMP_TERMS_TEMPLATES_PUB
Source
1 PACKAGE BODY okc_imp_terms_templates_pub
2 /*$Header: OKCPITTB.pls 120.1.12020000.2 2012/07/16 16:13:21 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 IS
9 BEGIN
10 okc_imp_terms_templates_pvt.create_template
11 (p_template_tbl => p_template_tbl,
12 p_commit => p_commit
13 );
14 END create_template;
15
16 PROCEDURE create_article (
17 p_article_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.k_article_tbl_type,
18 p_commit IN VARCHAR2 := fnd_api.g_false
19 )
20 IS
21 BEGIN
22 okc_imp_terms_templates_pvt.create_article
23 (p_article_tbl => p_article_tbl,
24 p_commit => p_commit
25 );
26 END create_article;
27
28 PROCEDURE create_section (
29 p_section_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.section_tbl_type,
30 p_commit IN VARCHAR2 := fnd_api.g_false
31 )
32 IS
33 BEGIN
34 okc_imp_terms_templates_pvt.create_section
35 (p_section_tbl => p_section_tbl,
36 p_commit => p_commit
37 );
38 END create_section;
39
40 PROCEDURE create_deliverable (
41 p_deliverable_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_tbl_type,
42 p_commit IN VARCHAR2 := fnd_api.g_false
43 )
44 IS
45 BEGIN
46 okc_imp_terms_templates_pvt.create_deliverable
47 (p_deliverable_tbl => p_deliverable_tbl,
48 p_commit => p_commit
49 );
50 END create_deliverable;
51
52 PROCEDURE update_template( p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
53 p_commit IN VARCHAR2 := fnd_api.g_false
54 )
55 IS
56 BEGIN
57 okc_imp_terms_templates_pvt.update_template(p_template_tbl => p_template_tbl,
58 p_commit => p_commit
59 );
60 END update_template;
61
62
63 PROCEDURE create_template_revision (
64 p_template_id IN NUMBER,
65 p_copy_deliverables IN VARCHAR2 DEFAULT 'Y',
66 p_commit IN VARCHAR2 := fnd_api.g_false,
67 x_new_template_id OUT NOCOPY NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_data OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER
71 )
72 IS
73 BEGIN
74 okc_imp_terms_templates_pvt.create_template_revision
75 (p_template_id => p_template_id,
76 p_copy_deliverables => p_copy_deliverables,
77 p_commit => p_commit,
78 x_new_template_id => x_new_template_id,
79 x_return_status => x_return_status,
80 x_msg_data => x_msg_data,
81 x_msg_count => x_msg_count
82 );
83 END create_template_revision;
84
85 PROCEDURE delete_articles (
86 p_template_id IN NUMBER,
87 p_k_article_id_tbl IN okc_imp_terms_templates_pvt.k_article_id_tbl_type,
88 p_commit IN VARCHAR2 := fnd_api.g_false,
89 x_k_article_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.k_article_id_tbl_type,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_data OUT NOCOPY VARCHAR2
92 )
93 IS
94 BEGIN
95 okc_imp_terms_templates_pvt.delete_articles
96 (p_template_id => p_template_id,
97 p_k_article_id_tbl => p_k_article_id_tbl,
98 p_commit => p_commit,
99 x_k_article_id_tbl => x_k_article_id_tbl,
100 x_return_status => x_return_status,
101 x_msg_data => x_msg_data
102 );
103 END delete_articles;
104
105 PROCEDURE delete_sections (
106 p_template_id IN NUMBER,
107 p_section_id_tbl IN okc_imp_terms_templates_pvt.section_id_tbl_type,
108 p_commit IN VARCHAR2 := fnd_api.g_false,
109 x_section_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.section_id_tbl_type,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_data OUT NOCOPY VARCHAR2
112 )
113 IS
114 BEGIN
115 okc_imp_terms_templates_pvt.delete_sections
116 (p_template_id => p_template_id,
117 p_section_id_tbl => p_section_id_tbl,
118 p_commit => p_commit,
119 x_section_id_tbl => x_section_id_tbl,
120 x_return_status => x_return_status,
121 x_msg_data => x_msg_data
122 );
123 END delete_sections;
124
125 PROCEDURE delete_deliverables (
126 p_template_id IN NUMBER,
127 p_deliverable_id_tbl IN okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
128 p_commit IN VARCHAR2 := fnd_api.g_false,
129 x_deliverable_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_data OUT NOCOPY VARCHAR2
132 )
133 IS
134 BEGIN
135 okc_imp_terms_templates_pvt.delete_deliverables
136 (p_template_id => p_template_id,
137 p_deliverable_id_tbl => p_deliverable_id_tbl,
138 p_commit => p_commit,
139 x_deliverable_id_tbl => x_deliverable_id_tbl,
140 x_return_status => x_return_status,
141 x_msg_data => x_msg_data
142 );
143 END delete_deliverables;
144 -- Template Usages --
145 PROCEDURE create_tmpl_usage (
146 p_template_id IN NUMBER,
147 p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
148 p_commit IN VARCHAR2 := fnd_api.g_false
149 )
150 IS
151 BEGIN
152 okc_imp_terms_templates_pvt.create_tmpl_usage( p_template_id => p_template_id,
153 p_tmpl_usage_tbl => p_tmpl_usage_tbl,
154 p_commit => p_commit
155 );
156 END create_tmpl_usage;
157
158 PROCEDURE update_tmpl_usage(
159 p_template_id IN NUMBER ,
160 p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
161 p_commit IN VARCHAR2 := fnd_api.g_false
162 )
163 IS
164 BEGIN
165 okc_imp_terms_templates_pvt.update_tmpl_usage( p_template_id => p_template_id,
166 p_tmpl_usage_tbl => p_tmpl_usage_tbl,
167 p_commit => p_commit
168 );
169 END update_tmpl_usage;
170
171 PROCEDURE delete_tmpl_usage (
172 p_template_id IN NUMBER ,
173 p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
174 p_commit IN VARCHAR2 := fnd_api.g_false
175 )
176 IS
177 BEGIN
178 okc_imp_terms_templates_pvt.delete_tmpl_usage( p_template_id => p_template_id,
179 p_tmpl_usage_tbl => p_tmpl_usage_tbl,
180 p_commit => p_commit
181 );
182
183 END delete_tmpl_usage;
184
185
186 END okc_imp_terms_templates_pub;