[Home] [Help]
PACKAGE: APPS.OKL_STRM_GEN_TEMPLATE_PUB
Source
1 Package okl_strm_gen_template_pub AUTHID CURRENT_USER as
2 /* $Header: OKLPTSGS.pls 120.4 2005/11/15 11:52:47 rgooty noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PUB';
8
9 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
10 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
11 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
12 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
13 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
14
15 G_DEFAULT_MODE CONSTANT VARCHAR2(10) := 'DUPLICATE';
16
17 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
18 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
19 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
21 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
22 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
23
24 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
25 G_EXCEPTION_ERROR EXCEPTION;
26 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
27
28 -- Stream Generation Template Set
29 SUBTYPE gttv_rec_type IS okl_gtt_pvt.gttv_rec_type;
30 SUBTYPE gttv_tbl_type IS okl_gtt_pvt.gttv_tbl_type;
31
32 -- Stream Generation Template
33 SUBTYPE gtsv_rec_type IS okl_gts_pvt.gtsv_rec_type;
34 SUBTYPE gtsv_tbl_type IS okl_gts_pvt.gtsv_tbl_type;
35
36 -- Stream Generation Template Pricing Parameters
37 SUBTYPE gtpv_rec_type IS okl_gtp_pvt.gtpv_rec_type;
38 SUBTYPE gtpv_tbl_type IS okl_gtp_pvt.gtpv_tbl_type;
39
40 -- Stream Generation Template Stream Types
41 SUBTYPE gtlv_rec_type IS okl_gtl_pvt.gtlv_rec_type;
42 SUBTYPE gtlv_tbl_type IS okl_gtl_pvt.gtlv_tbl_type;
43
44 SUBTYPE error_msgs_tbl_type IS okl_strm_gen_template_pvt.error_msgs_tbl_type;
45
46 Procedure create_strm_gen_template(
47 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_gtsv_rec IN gtsv_rec_type
53 ,p_gttv_rec IN gttv_rec_type
54 ,p_gtpv_tbl IN gtpv_tbl_type
55 ,p_gtlv_tbl IN gtlv_tbl_type
56 ,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
57 );
58
59 Procedure update_strm_gen_template(
60 p_api_version IN NUMBER
61 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2
65 ,p_gtsv_rec IN gtsv_rec_type
66 ,p_gttv_rec IN gttv_rec_type
67 ,p_gtpv_tbl IN gtpv_tbl_type
68 ,p_gtlv_tbl IN gtlv_tbl_type
69 ,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
70 );
71
72 Procedure delete_tmpt_prc_params(
73 p_api_version IN NUMBER
74 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78 ,p_gtpv_tbl IN gtpv_tbl_type
79 );
80
81 Procedure delete_pri_tmpt_lns(
82 p_api_version IN NUMBER
83 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2
87 ,p_gtlv_tbl IN gtlv_tbl_type
88 );
89
90 Procedure delete_dep_tmpt_lns(
91 p_api_version IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 ,p_gtlv_tbl IN gtlv_tbl_type
97 );
98
99
100 Procedure update_dep_strms(
101 p_api_version IN NUMBER
102 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106 ,p_gtt_id IN OKL_ST_GEN_TEMPLATES.ID%type
107 ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
108 ,p_gtlv_tbl IN gtlv_tbl_type
109 ,x_missing_deps OUT NOCOPY VARCHAR2
110 ,x_show_warn_flag OUT NOCOPY VARCHAR2
111 );
112
113 Procedure create_version_duplicate(
114 p_api_version IN NUMBER
115 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2
119 ,p_gtt_id IN okl_st_gen_templates.id%type
120 ,p_mode IN VARCHAR2 DEFAULT G_DEFAULT_MODE
121 ,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
122 );
123 Procedure validate_template(
124 p_api_version IN NUMBER
125 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129 ,p_gtt_id IN okl_st_gen_templates.id%type
130 ,x_error_msgs_tbl OUT NOCOPY error_msgs_tbl_type
131 ,x_return_tmpt_status OUT NOCOPY VARCHAR2
132 ,p_during_upd_flag IN VARCHAR2
133 );
134 Procedure activate_template(
135 p_api_version IN NUMBER
136 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 ,p_gtt_id IN okl_st_gen_templates.id%type
141 );
142 Procedure validate_for_warnings(
143 p_api_version IN NUMBER
144 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ,p_gtt_id IN okl_st_gen_templates.id%type
149 ,x_wrn_msgs_tbl OUT NOCOPY error_msgs_tbl_type
150 ,p_during_upd_flag IN VARCHAR
151 ,x_pri_purpose_list OUT NOCOPY VARCHAR
152 );
153
154 PROCEDURE update_pri_dep_of_sgt(
155 p_api_version IN NUMBER
156 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
157 ,x_return_status OUT NOCOPY VARCHAR2
158 ,x_msg_count OUT NOCOPY NUMBER
159 ,x_msg_data OUT NOCOPY VARCHAR2
160 ,p_gtsv_rec IN gtsv_rec_type
161 ,p_gttv_rec IN gttv_rec_type
162 ,p_gtpv_tbl IN gtpv_tbl_type
163 ,p_pri_gtlv_tbl IN gtlv_tbl_type
164 ,p_del_dep_gtlv_tbl IN gtlv_tbl_type
165 ,p_ins_dep_gtlv_tbl IN gtlv_tbl_type
166 ,x_gttv_rec OUT NOCOPY gttv_rec_type
167 ,x_pri_purpose_list OUT NOCOPY VARCHAR2);
168
169 End okl_strm_gen_template_pub;