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