[Home] [Help]
PACKAGE: APPS.OKL_PAM_PVT
Source
1 PACKAGE okl_pam_pvt AS
2 /* $Header: OKLSPAMS.pls 120.2 2005/11/29 14:20:08 viselvar noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_pamv_rec IS RECORD (
9 adj_mat_id NUMBER,
10 object_version_number NUMBER,
11 org_id NUMBER,
12 currency_code okl_fe_adj_mat_v.currency_code%TYPE,
13 adj_mat_type_code okl_fe_adj_mat_v.adj_mat_type_code%TYPE,
14 orig_adj_mat_id NUMBER,
15 sts_code okl_fe_adj_mat_v.sts_code%TYPE,
16 effective_from_date okl_fe_adj_mat_v.effective_from_date%TYPE,
17 effective_to_date okl_fe_adj_mat_v.effective_to_date%TYPE,
18 attribute_category okl_fe_adj_mat_v.attribute_category%TYPE,
19 attribute1 okl_fe_adj_mat_v.attribute1%TYPE,
20 attribute2 okl_fe_adj_mat_v.attribute2%TYPE,
21 attribute3 okl_fe_adj_mat_v.attribute3%TYPE,
22 attribute4 okl_fe_adj_mat_v.attribute4%TYPE,
23 attribute5 okl_fe_adj_mat_v.attribute5%TYPE,
24 attribute6 okl_fe_adj_mat_v.attribute6%TYPE,
25 attribute7 okl_fe_adj_mat_v.attribute7%TYPE,
26 attribute8 okl_fe_adj_mat_v.attribute8%TYPE,
27 attribute9 okl_fe_adj_mat_v.attribute9%TYPE,
28 attribute10 okl_fe_adj_mat_v.attribute10%TYPE,
29 attribute11 okl_fe_adj_mat_v.attribute11%TYPE,
30 attribute12 okl_fe_adj_mat_v.attribute12%TYPE,
31 attribute13 okl_fe_adj_mat_v.attribute13%TYPE,
32 attribute14 okl_fe_adj_mat_v.attribute14%TYPE,
33 attribute15 okl_fe_adj_mat_v.attribute15%TYPE,
34 created_by NUMBER,
35 creation_date okl_fe_adj_mat_v.creation_date%TYPE,
36 last_updated_by NUMBER,
37 last_update_date okl_fe_adj_mat_v.last_update_date%TYPE,
38 last_update_login NUMBER,
39 adj_mat_name okl_fe_adj_mat_v.adj_mat_name%TYPE,
40 adj_mat_desc okl_fe_adj_mat_v.adj_mat_desc%TYPE
41 );
42
43 TYPE okl_pamv_tbl IS TABLE OF okl_pamv_rec INDEX BY BINARY_INTEGER;
44
45 TYPE okl_pamb_rec IS RECORD (
46 adj_mat_id NUMBER,
47 adj_mat_name okl_fe_adj_mat_all_b.adj_mat_name%TYPE,
48 object_version_number NUMBER,
49 org_id NUMBER,
50 currency_code okl_fe_adj_mat_all_b.currency_code%TYPE,
51 adj_mat_type_code okl_fe_adj_mat_all_b.adj_mat_type_code%TYPE,
52 orig_adj_mat_id NUMBER,
53 sts_code okl_fe_adj_mat_all_b.sts_code%TYPE,
54 effective_from_date okl_fe_adj_mat_all_b.effective_from_date%TYPE,
55 effective_to_date okl_fe_adj_mat_all_b.effective_to_date%TYPE,
56 attribute_category okl_fe_adj_mat_all_b.attribute_category%TYPE,
57 attribute1 okl_fe_adj_mat_all_b.attribute1%TYPE,
58 attribute2 okl_fe_adj_mat_all_b.attribute2%TYPE,
59 attribute3 okl_fe_adj_mat_all_b.attribute3%TYPE,
60 attribute4 okl_fe_adj_mat_all_b.attribute4%TYPE,
61 attribute5 okl_fe_adj_mat_all_b.attribute5%TYPE,
62 attribute6 okl_fe_adj_mat_all_b.attribute6%TYPE,
63 attribute7 okl_fe_adj_mat_all_b.attribute7%TYPE,
64 attribute8 okl_fe_adj_mat_all_b.attribute8%TYPE,
65 attribute9 okl_fe_adj_mat_all_b.attribute9%TYPE,
66 attribute10 okl_fe_adj_mat_all_b.attribute10%TYPE,
67 attribute11 okl_fe_adj_mat_all_b.attribute11%TYPE,
68 attribute12 okl_fe_adj_mat_all_b.attribute12%TYPE,
69 attribute13 okl_fe_adj_mat_all_b.attribute13%TYPE,
70 attribute14 okl_fe_adj_mat_all_b.attribute14%TYPE,
71 attribute15 okl_fe_adj_mat_all_b.attribute15%TYPE,
72 created_by NUMBER,
73 creation_date okl_fe_adj_mat_all_b.creation_date%TYPE,
74 last_updated_by NUMBER,
75 last_update_date okl_fe_adj_mat_all_b.last_update_date%TYPE,
76 last_update_login NUMBER
77 );
78
79 TYPE okl_pamb_tbl IS TABLE OF okl_pamb_rec INDEX BY BINARY_INTEGER;
80
81 TYPE okl_pamtl_rec IS RECORD (
82 adj_mat_id NUMBER,
83 adj_mat_desc okl_fe_adj_mat_all_tl.adj_mat_desc%TYPE,
84 language okl_fe_adj_mat_all_tl.language%TYPE,
85 source_lang okl_fe_adj_mat_all_tl.source_lang%TYPE,
86 sfwt_flag okl_fe_adj_mat_all_tl.sfwt_flag%TYPE,
87 created_by NUMBER,
88 creation_date okl_fe_adj_mat_all_tl.creation_date%TYPE,
89 last_updated_by NUMBER,
90 last_update_date okl_fe_adj_mat_all_tl.last_update_date%TYPE,
91 last_update_login NUMBER
92 );
93
94 TYPE okl_pamtl_tbl IS TABLE OF okl_pamtl_rec INDEX BY BINARY_INTEGER;
95
96 --------------------------------------------------------------------------------
97 -- GLOBAL MESSAGE CONSTANTS
98 --------------------------------------------------------------------------------
99
100 g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
101 g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
102 g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
103 g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
104 g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
105 g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
106 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
107 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
108 g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
109 g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
110 g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
111 g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
112 g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
113 g_db_error CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
114 g_prog_name_token CONSTANT VARCHAR2(9) := 'PROG_NAME';
115 g_api_version CONSTANT NUMBER := 1;
116 g_false CONSTANT VARCHAR2(1) := fnd_api.g_false;
117 g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;
118
119 --------------------------------------------------------------------------------
120 -- GLOBAL VARIABLES
121 --------------------------------------------------------------------------------
122
123 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_PAM_PVT';
124 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
125
126 --------------------------------------------------------------------------------
127 -- Procedures and Functions
128 --------------------------------------------------------------------------------
129
130 PROCEDURE change_version;
131
132 PROCEDURE api_copy;
133
134 PROCEDURE add_language;
135
136 PROCEDURE insert_row(p_api_version IN NUMBER
137 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
138 ,x_return_status OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140 ,x_msg_data OUT NOCOPY VARCHAR2
141 ,p_pamv_rec IN okl_pamv_rec
142 ,x_pamv_rec OUT NOCOPY okl_pamv_rec);
143
144 PROCEDURE insert_row(p_api_version IN NUMBER
145 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
146 ,x_return_status OUT NOCOPY VARCHAR2
147 ,x_msg_count OUT NOCOPY NUMBER
148 ,x_msg_data OUT NOCOPY VARCHAR2
149 ,p_pamv_tbl IN okl_pamv_tbl
150 ,x_pamv_tbl OUT NOCOPY okl_pamv_tbl);
151
152 PROCEDURE update_row(p_api_version IN NUMBER
153 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
154 ,x_return_status OUT NOCOPY VARCHAR2
155 ,x_msg_count OUT NOCOPY NUMBER
156 ,x_msg_data OUT NOCOPY VARCHAR2
157 ,p_pamv_rec IN okl_pamv_rec
158 ,x_pamv_rec OUT NOCOPY okl_pamv_rec);
159
160 PROCEDURE update_row(p_api_version IN NUMBER
161 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
162 ,x_return_status OUT NOCOPY VARCHAR2
163 ,x_msg_count OUT NOCOPY NUMBER
164 ,x_msg_data OUT NOCOPY VARCHAR2
165 ,p_pamv_tbl IN okl_pamv_tbl
166 ,x_pamv_tbl OUT NOCOPY okl_pamv_tbl);
167
168 PROCEDURE delete_row(p_api_version IN NUMBER
169 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
170 ,x_return_status OUT NOCOPY VARCHAR2
171 ,x_msg_count OUT NOCOPY NUMBER
172 ,x_msg_data OUT NOCOPY VARCHAR2
173 ,p_pamv_rec IN okl_pamv_rec);
174
175 PROCEDURE delete_row(p_api_version IN NUMBER
176 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
177 ,x_return_status OUT NOCOPY VARCHAR2
178 ,x_msg_count OUT NOCOPY NUMBER
179 ,x_msg_data OUT NOCOPY VARCHAR2
180 ,p_pamv_tbl IN okl_pamv_tbl);
181
182 END okl_pam_pvt;