[Home] [Help]
25: G_OKL_DAY_CONVEN_VAL_EXT CONSTANT VARCHAR2(30) := 'OKL_DAY_CONVEN_VAL_EXT';
26: G_OKL_DAY_CONVEN_VAL_INT CONSTANT VARCHAR2(30) := 'OKL_DAY_CONVEN_VAL_INT';
27:
28:
29: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
30:
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PVT';
33:
104: INDEX BY BINARY_INTEGER;
105:
106: Procedure create_strm_gen_template(
107: p_api_version IN NUMBER
108: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
109: ,x_return_status OUT NOCOPY VARCHAR2
110: ,x_msg_count OUT NOCOPY NUMBER
111: ,x_msg_data OUT NOCOPY VARCHAR2
112: ,p_gtsv_rec IN gtsv_rec_type
117: );
118:
119: Procedure update_strm_gen_template(
120: p_api_version IN NUMBER
121: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
122: ,x_return_status OUT NOCOPY VARCHAR2
123: ,x_msg_count OUT NOCOPY NUMBER
124: ,x_msg_data OUT NOCOPY VARCHAR2
125: ,p_gtsv_rec IN gtsv_rec_type
130: );
131:
132: Procedure update_dep_strms(
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_gtt_id IN OKL_ST_GEN_TEMPLATES.ID%type
143: );
144:
145: Procedure create_version_duplicate(
146: p_api_version IN NUMBER
147: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
148: ,x_return_status OUT NOCOPY VARCHAR2
149: ,x_msg_count OUT NOCOPY NUMBER
150: ,x_msg_data OUT NOCOPY VARCHAR2
151: ,p_gtt_id IN okl_st_gen_templates.id%type
154: );
155:
156: Procedure delete_tmpt_prc_params(
157: p_api_version IN NUMBER
158: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,x_msg_count OUT NOCOPY NUMBER
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: ,p_gtpv_tbl IN gtpv_tbl_type
163: );
164:
165: Procedure delete_pri_tmpt_lns(
166: p_api_version IN NUMBER
167: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
168: ,x_return_status OUT NOCOPY VARCHAR2
169: ,x_msg_count OUT NOCOPY NUMBER
170: ,x_msg_data OUT NOCOPY VARCHAR2
171: ,p_gtlv_tbl IN gtlv_tbl_type
171: ,p_gtlv_tbl IN gtlv_tbl_type
172: );
173: Procedure delete_dep_tmpt_lns(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
176: ,x_return_status OUT NOCOPY VARCHAR2
177: ,x_msg_count OUT NOCOPY NUMBER
178: ,x_msg_data OUT NOCOPY VARCHAR2
179: ,p_gtlv_tbl IN gtlv_tbl_type
180: );
181:
182: Procedure validate_template(
183: p_api_version IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
185: ,x_return_status OUT NOCOPY VARCHAR2
186: ,x_msg_count OUT NOCOPY NUMBER
187: ,x_msg_data OUT NOCOPY VARCHAR2
188: ,p_gtt_id IN okl_st_gen_templates.id%type
192: );
193:
194: Procedure activate_template(
195: p_api_version IN NUMBER
196: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
197: ,x_return_status OUT NOCOPY VARCHAR2
198: ,x_msg_count OUT NOCOPY NUMBER
199: ,x_msg_data OUT NOCOPY VARCHAR2
200: ,p_gtt_id IN okl_st_gen_templates.id%type
201: );
202:
203: Procedure validate_for_warnings(
204: p_api_version IN NUMBER
205: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
206: ,x_return_status OUT NOCOPY VARCHAR2
207: ,x_msg_count OUT NOCOPY NUMBER
208: ,x_msg_data OUT NOCOPY VARCHAR2
209: ,p_gtt_id IN okl_st_gen_templates.id%type
213: );
214:
215: PROCEDURE update_pri_dep_of_sgt(
216: p_api_version IN NUMBER
217: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2
221: ,p_gtsv_rec IN gtsv_rec_type