1 PACKAGE OKL_PROCESS_TMPT_SET_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTMSS.pls 115.6 2002/05/03 14:13:55 pkm ship $ */
3 SUBTYPE aesv_rec_type IS OKL_PROCESS_TMPT_SET_PVT.aesv_rec_type;
4 SUBTYPE aesv_tbl_type IS OKL_PROCESS_TMPT_SET_PVT.aesv_tbl_type;
5 SUBTYPE avlv_rec_type IS OKL_PROCESS_TMPT_SET_PVT.avlv_rec_type;
6 SUBTYPE avlv_tbl_type IS OKL_PROCESS_TMPT_SET_PVT.avlv_tbl_type;
7 SUBTYPE atlv_rec_type IS OKL_PROCESS_TMPT_SET_PVT.atlv_rec_type;
8 SUBTYPE atlv_tbl_type IS OKL_PROCESS_TMPT_SET_PVT.atlv_tbl_type;
9 PROCEDURE create_tmpt_set(p_api_version IN NUMBER
10 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
11 ,x_return_status OUT NOCOPY VARCHAR2
12 ,x_msg_count OUT NOCOPY NUMBER
13 ,x_msg_data OUT NOCOPY VARCHAR2
14 ,p_aesv_rec IN aesv_rec_type
15 ,p_avlv_tbl IN avlv_tbl_type
16 ,p_atlv_tbl IN atlv_tbl_type
17 ,x_aesv_rec OUT NOCOPY aesv_rec_type
18 ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
19 ,x_atlv_tbl OUT NOCOPY atlv_tbl_type);
20 --Object type procedure for update
21 PROCEDURE update_tmpt_set(p_api_version IN NUMBER
22 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25 ,x_msg_data OUT NOCOPY VARCHAR2
26 ,p_aesv_rec IN aesv_rec_type
27 ,p_avlv_tbl IN avlv_tbl_type
28 ,p_atlv_tbl IN atlv_tbl_type
29 ,x_aesv_rec OUT NOCOPY aesv_rec_type
30 ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
31 ,x_atlv_tbl OUT NOCOPY atlv_tbl_type );
32 PROCEDURE create_tmpt_set(p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 p_aesv_tbl IN aesv_tbl_type,
38 x_aesv_tbl OUT NOCOPY aesv_tbl_type);
39 PROCEDURE create_tmpt_set(p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_aesv_rec IN aesv_rec_type,
45 x_aesv_rec OUT NOCOPY aesv_rec_type,
46 p_aes_source_id IN OKL_AE_TMPT_SETS.id%TYPE DEFAULT NULL);
47 PROCEDURE update_tmpt_set(p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_aesv_tbl IN aesv_tbl_type,
53 x_aesv_tbl OUT NOCOPY aesv_tbl_type);
54 PROCEDURE update_tmpt_set(p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2,
59 p_aesv_rec IN aesv_rec_type,
60 x_aesv_rec OUT NOCOPY aesv_rec_type);
61 PROCEDURE delete_tmpt_set(p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_aesv_tbl IN aesv_tbl_type);
67 PROCEDURE delete_tmpt_set(p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_aesv_rec IN aesv_rec_type);
73 PROCEDURE create_template(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_avlv_tbl IN avlv_tbl_type,
80 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
81 PROCEDURE create_template(p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_avlv_rec IN avlv_rec_type,
87 x_avlv_rec OUT NOCOPY avlv_rec_type);
88 PROCEDURE update_template(p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_avlv_tbl IN avlv_tbl_type,
94 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
95 PROCEDURE update_template(p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_avlv_rec IN avlv_rec_type,
101 x_avlv_rec OUT NOCOPY avlv_rec_type);
102 PROCEDURE delete_template(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_avlv_tbl IN avlv_tbl_type);
109 PROCEDURE delete_template(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_avlv_rec IN avlv_rec_type);
116 PROCEDURE create_tmpt_lines(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_atlv_tbl IN atlv_tbl_type,
123 x_atlv_tbl OUT NOCOPY atlv_tbl_type);
124 PROCEDURE create_tmpt_lines(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_atlv_rec IN atlv_rec_type,
131 x_atlv_rec OUT NOCOPY atlv_rec_type);
132 PROCEDURE update_tmpt_lines(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_atlv_tbl IN atlv_tbl_type,
139 x_atlv_tbl OUT NOCOPY atlv_tbl_type);
140 PROCEDURE update_tmpt_lines(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_atlv_rec IN atlv_rec_type,
147 x_atlv_rec OUT NOCOPY atlv_rec_type);
148 PROCEDURE delete_tmpt_lines(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_atlv_tbl IN atlv_tbl_type);
155 PROCEDURE delete_tmpt_lines(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_atlv_rec IN atlv_rec_type);
162 -- mvasudev -- 02/13/2002
163 /* This API Takes 'From Template Set ID' and 'To Template Set ID'
164 as parameters and copies all the templates and Template Line
165 from 'From Template Set ID' to 'To Template Set ID'. The Template
166 names in the copied templates is suffixed with '-COPY' so as not
167 to violate the unique constraint. */
168 PROCEDURE COPY_TMPL_SET(p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_aes_id_from IN NUMBER,
174 p_aes_id_to IN NUMBER);
175 /* This API is used for Copying a Single Template Lines from one template
176 to another. It first creates the template record for the given p_avlv_rec
177 and then copies the template line records from source template lines to
178 the target template lines. */
179 PROCEDURE COPY_TEMPLATE(p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_avlv_rec IN avlv_rec_type,
185 p_source_tmpl_id IN NUMBER,
186 x_avlv_rec OUT NOCOPY avlv_rec_type);
187 -- end,mvasudev -- 02/13/2002
188 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PROCESS_TMPT_SET_PUB';
189 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
190 END OKL_PROCESS_TMPT_SET_PUB;