[Home] [Help]
PACKAGE: APPS.OKL_SRT_PVT
Source
1 PACKAGE okl_srt_pvt AS
2 /* $Header: OKLSSRTS.pls 120.1 2005/11/29 14:29:26 viselvar noship $ */
3 --------------------------------------------------------------------------------
4 --GLOBAL DATASTRUCTURES
5 --------------------------------------------------------------------------------
6 TYPE okl_srtv_rec IS RECORD (
7 std_rate_tmpl_id NUMBER,
8 template_name okl_fe_std_rt_tmp_v.template_name%TYPE,
9 template_desc okl_fe_std_rt_tmp_v.template_desc%TYPE,
10 object_version_number NUMBER,
11 org_id NUMBER,
12 currency_code okl_fe_std_rt_tmp_v.currency_code%TYPE,
13 rate_card_yn okl_fe_std_rt_tmp_v.rate_card_yn%TYPE,
14 pricing_engine_code okl_fe_std_rt_tmp_v.pricing_engine_code%TYPE,
15 orig_std_rate_tmpl_id NUMBER,
16 rate_type_code okl_fe_std_rt_tmp_v.rate_type_code%TYPE,
17 frequency_code okl_fe_std_rt_tmp_v.frequency_code%TYPE,
18 index_id NUMBER,
19 default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
20 sts_code okl_fe_std_rt_tmp_v.sts_code%TYPE,
21 effective_from_date okl_fe_std_rt_tmp_v.effective_from_date%TYPE,
22 effective_to_date okl_fe_std_rt_tmp_v.effective_to_date%TYPE,
23 srt_rate NUMBER,
24 attribute_category okl_fe_std_rt_tmp_v.attribute_category%TYPE,
25 attribute1 okl_fe_std_rt_tmp_v.attribute1%TYPE,
26 attribute2 okl_fe_std_rt_tmp_v.attribute2%TYPE,
27 attribute3 okl_fe_std_rt_tmp_v.attribute3%TYPE,
28 attribute4 okl_fe_std_rt_tmp_v.attribute4%TYPE,
29 attribute5 okl_fe_std_rt_tmp_v.attribute5%TYPE,
30 attribute6 okl_fe_std_rt_tmp_v.attribute6%TYPE,
31 attribute7 okl_fe_std_rt_tmp_v.attribute7%TYPE,
32 attribute8 okl_fe_std_rt_tmp_v.attribute8%TYPE,
33 attribute9 okl_fe_std_rt_tmp_v.attribute9%TYPE,
34 attribute10 okl_fe_std_rt_tmp_v.attribute10%TYPE,
35 attribute11 okl_fe_std_rt_tmp_v.attribute11%TYPE,
36 attribute12 okl_fe_std_rt_tmp_v.attribute12%TYPE,
37 attribute13 okl_fe_std_rt_tmp_v.attribute13%TYPE,
38 attribute14 okl_fe_std_rt_tmp_v.attribute14%TYPE,
39 attribute15 okl_fe_std_rt_tmp_v.attribute15%TYPE,
40 created_by NUMBER,
41 creation_date okl_fe_std_rt_tmp_v.creation_date%TYPE,
42 last_updated_by NUMBER,
43 last_update_date okl_fe_std_rt_tmp_v.last_update_date%TYPE,
44 last_update_login NUMBER
45 );
46
47 TYPE okl_srtv_tbl IS TABLE OF okl_srtv_rec INDEX BY BINARY_INTEGER;
48 TYPE okl_srtb_rec IS RECORD (
49 std_rate_tmpl_id NUMBER,
50 template_name okl_fe_std_rt_tmp_all_b.template_name%TYPE,
51 object_version_number NUMBER,
52 org_id NUMBER,
53 currency_code okl_fe_std_rt_tmp_all_b.currency_code%TYPE,
54 rate_card_yn okl_fe_std_rt_tmp_all_b.rate_card_yn%TYPE,
55 pricing_engine_code okl_fe_std_rt_tmp_all_b.pricing_engine_code%TYPE,
56 orig_std_rate_tmpl_id NUMBER,
57 rate_type_code okl_fe_std_rt_tmp_all_b.rate_type_code%TYPE,
58 frequency_code okl_fe_std_rt_tmp_all_b.frequency_code%TYPE,
59 index_id NUMBER,
60 default_yn okl_fe_std_rt_tmp_v.default_yn%TYPE,
61 sts_code okl_fe_std_rt_tmp_all_b.sts_code%TYPE,
62 effective_from_date okl_fe_std_rt_tmp_all_b.effective_from_date%TYPE,
63 effective_to_date okl_fe_std_rt_tmp_all_b.effective_to_date%TYPE,
64 srt_rate NUMBER,
65 attribute_category okl_fe_std_rt_tmp_all_b.attribute_category%TYPE,
66 attribute1 okl_fe_std_rt_tmp_all_b.attribute1%TYPE,
67 attribute2 okl_fe_std_rt_tmp_all_b.attribute2%TYPE,
68 attribute3 okl_fe_std_rt_tmp_all_b.attribute3%TYPE,
69 attribute4 okl_fe_std_rt_tmp_all_b.attribute4%TYPE,
70 attribute5 okl_fe_std_rt_tmp_all_b.attribute5%TYPE,
71 attribute6 okl_fe_std_rt_tmp_all_b.attribute6%TYPE,
72 attribute7 okl_fe_std_rt_tmp_all_b.attribute7%TYPE,
73 attribute8 okl_fe_std_rt_tmp_all_b.attribute8%TYPE,
74 attribute9 okl_fe_std_rt_tmp_all_b.attribute9%TYPE,
75 attribute10 okl_fe_std_rt_tmp_all_b.attribute10%TYPE,
76 attribute11 okl_fe_std_rt_tmp_all_b.attribute11%TYPE,
77 attribute12 okl_fe_std_rt_tmp_all_b.attribute12%TYPE,
78 attribute13 okl_fe_std_rt_tmp_all_b.attribute13%TYPE,
79 attribute14 okl_fe_std_rt_tmp_all_b.attribute14%TYPE,
80 attribute15 okl_fe_std_rt_tmp_all_b.attribute15%TYPE,
81 created_by NUMBER,
82 creation_date okl_fe_std_rt_tmp_all_b.creation_date%TYPE,
83 last_updated_by NUMBER,
84 last_update_date okl_fe_std_rt_tmp_all_b.last_update_date%TYPE,
85 last_update_login NUMBER
86 );
87
88 TYPE okl_srtb_tbl IS TABLE OF okl_srtb_rec INDEX BY BINARY_INTEGER;
89 TYPE okl_srttl_rec IS RECORD (
90 std_rate_tmpl_id NUMBER,
91 template_desc okl_fe_std_rt_tmp_all_tl.template_desc%TYPE,
92 language okl_fe_std_rt_tmp_all_tl.language%TYPE,
93 source_lang okl_fe_std_rt_tmp_all_tl.source_lang%TYPE,
94 sfwt_flag okl_fe_std_rt_tmp_all_tl.sfwt_flag%TYPE,
95 created_by NUMBER,
96 creation_date okl_fe_std_rt_tmp_all_tl.creation_date%TYPE,
97 last_updated_by NUMBER,
98 last_update_date okl_fe_std_rt_tmp_all_tl.last_update_date%TYPE,
99 last_update_login NUMBER
100 );
101
102 TYPE okl_srttl_tbl IS TABLE OF okl_srttl_rec INDEX BY BINARY_INTEGER;
103
104 --------------------------------------------------------------------------------
105 -- GLOBAL MESSAGE CONSTANTS
106 --------------------------------------------------------------------------------
107 g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
108 g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
109 g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
110 g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
111 g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
112 g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
113 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
114 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
115 g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
116 g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
117
118 --------------------------------------------------------------------------------
119 -- GLOBAL VARIABLES
120 --------------------------------------------------------------------------------
121 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_SRT_PVT';
122 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
123
124 --------------------------------------------------------------------------------
125 -- Procedures and Functions
126 --------------------------------------------------------------------------------
127
128 PROCEDURE change_version;
129
130 PROCEDURE api_copy;
131
132 PROCEDURE add_language;
133
134 PROCEDURE insert_row(p_api_version IN NUMBER
135 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 ,p_srtv_rec IN okl_srtv_rec
140 ,x_srtv_rec OUT NOCOPY okl_srtv_rec);
141
142 PROCEDURE insert_row(p_api_version IN NUMBER
143 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
144 ,x_return_status OUT NOCOPY VARCHAR2
145 ,x_msg_count OUT NOCOPY NUMBER
146 ,x_msg_data OUT NOCOPY VARCHAR2
147 ,p_srtv_tbl IN okl_srtv_tbl
148 ,x_srtv_tbl OUT NOCOPY okl_srtv_tbl);
149
150 PROCEDURE update_row(p_api_version IN NUMBER
151 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155 ,p_srtv_rec IN okl_srtv_rec
156 ,x_srtv_rec OUT NOCOPY okl_srtv_rec);
157
158 PROCEDURE update_row(p_api_version IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 ,p_srtv_tbl IN okl_srtv_tbl
164 ,x_srtv_tbl OUT NOCOPY okl_srtv_tbl);
165
166 PROCEDURE delete_row(p_api_version IN NUMBER
167 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_srtv_rec IN okl_srtv_rec);
172
173 PROCEDURE delete_row(p_api_version IN NUMBER
174 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
175 ,x_return_status OUT NOCOPY VARCHAR2
176 ,x_msg_count OUT NOCOPY NUMBER
177 ,x_msg_data OUT NOCOPY VARCHAR2
178 ,p_srtv_tbl IN okl_srtv_tbl);
179
180 END okl_srt_pvt;