[Home] [Help]
PACKAGE: APPS.OKL_ECC_PVT
Source
1 PACKAGE okl_ecc_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSECCS.pls 120.3 2006/12/07 06:10:03 ssdeshpa noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_eccv_rec IS RECORD (
9 crit_cat_def_id number,
10 object_version_number number,
11 ecc_ac_flag okl_fe_crit_cat_def_v.ecc_ac_flag%TYPE,
12 orig_crit_cat_def_id number,
13 crit_cat_name okl_fe_crit_cat_def_v.crit_cat_name%TYPE,
14 crit_cat_desc okl_fe_crit_cat_def_v.crit_cat_desc%TYPE,
15 sfwt_flag okl_fe_crit_cat_def_v.sfwt_flag%TYPE,
16 value_type_code okl_fe_crit_cat_def_v.value_type_code%TYPE,
17 data_type_code okl_fe_crit_cat_def_v.data_type_code%TYPE,
18 enabled_yn okl_fe_crit_cat_def_v.enabled_yn%TYPE,
19 seeded_yn okl_fe_crit_cat_def_v.seeded_yn%TYPE,
20 function_id okl_fe_crit_cat_def_v.function_id%TYPE,
21 source_yn okl_fe_crit_cat_def_v.source_yn%TYPE,
22 sql_statement okl_fe_crit_cat_def_v.sql_statement%TYPE,
23 created_by number,
24 creation_date okl_fe_crit_cat_def_v.creation_date%TYPE,
25 last_updated_by number,
26 last_update_date okl_fe_crit_cat_def_v.last_update_date%TYPE,
27 last_update_login number
28 );
29
30 TYPE okl_eccv_tbl IS TABLE OF okl_eccv_rec INDEX BY BINARY_INTEGER;
31
32 TYPE okl_eccb_rec IS RECORD (
33 crit_cat_def_id number,
34 object_version_number number,
35 crit_cat_name okl_fe_crit_cat_def_b.crit_cat_name%TYPE,
36 ecc_ac_flag okl_fe_crit_cat_def_b.ecc_ac_flag%TYPE,
37 orig_crit_cat_def_id number,
38 value_type_code okl_fe_crit_cat_def_b.value_type_code%TYPE,
39 data_type_code okl_fe_crit_cat_def_b.data_type_code%TYPE,
40 enabled_yn okl_fe_crit_cat_def_b.enabled_yn%TYPE,
41 seeded_yn okl_fe_crit_cat_def_b.seeded_yn%TYPE,
42 function_id okl_fe_crit_cat_def_b.function_id%TYPE,
43 source_yn okl_fe_crit_cat_def_b.source_yn%TYPE,
47 last_updated_by number,
44 sql_statement okl_fe_crit_cat_def_b.sql_statement%TYPE,
45 created_by number,
46 creation_date okl_fe_crit_cat_def_b.creation_date%TYPE,
48 last_update_date okl_fe_crit_cat_def_b.last_update_date%TYPE,
49 last_update_login number
50 );
51
52 TYPE okl_eccb_tbl IS TABLE OF okl_eccb_rec INDEX BY BINARY_INTEGER;
53
54 TYPE okl_ecctl_rec IS RECORD (
55 crit_cat_def_id number,
56 language okl_fe_crit_cat_def_tl.language%TYPE,
57 source_lang okl_fe_crit_cat_def_tl.source_lang%TYPE,
58 sfwt_flag okl_fe_crit_cat_def_tl.sfwt_flag%TYPE,
59 crit_cat_desc okl_fe_crit_cat_def_tl.crit_cat_desc%TYPE,
60 created_by number,
61 creation_date okl_fe_crit_cat_def_tl.creation_date%TYPE,
62 last_updated_by number,
63 last_update_date okl_fe_crit_cat_def_tl.last_update_date%TYPE,
64 last_update_login number
65 );
66
67 TYPE okl_ecctl_tbl IS TABLE OF okl_ecctl_rec INDEX BY BINARY_INTEGER;
68
69 --------------------------------------------------------------------------------
70 -- GLOBAL MESSAGE CONSTANTS
71 --------------------------------------------------------------------------------
72
73 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
74 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
75 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
76 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
77 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
78 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
79 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
80 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
81 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
82 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
83
84 --------------------------------------------------------------------------------
85 -- GLOBAL VARIABLES
86 --------------------------------------------------------------------------------
87
88 g_pkg_name CONSTANT varchar2(200) := 'OKL_ECC_PVT';
89 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
90
91 --------------------------------------------------------------------------------
92 -- Procedures and Functions
93 --------------------------------------------------------------------------------
94
95 PROCEDURE change_version;
96
97 PROCEDURE api_copy;
98
99 PROCEDURE add_language;
100
101 PROCEDURE insert_row(p_api_version IN number
102 ,p_init_msg_list IN varchar2 DEFAULT okl_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_eccv_rec IN okl_eccv_rec
107 ,x_eccv_rec OUT NOCOPY okl_eccv_rec);
108
109 PROCEDURE insert_row(p_api_version IN number
110 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
111 ,x_return_status OUT NOCOPY varchar2
112 ,x_msg_count OUT NOCOPY number
113 ,x_msg_data OUT NOCOPY varchar2
114 ,p_eccv_tbl IN okl_eccv_tbl
115 ,x_eccv_tbl OUT NOCOPY okl_eccv_tbl);
116
117 PROCEDURE update_row(p_api_version IN number
118 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
119 ,x_return_status OUT NOCOPY varchar2
120 ,x_msg_count OUT NOCOPY number
121 ,x_msg_data OUT NOCOPY varchar2
122 ,p_eccv_rec IN okl_eccv_rec
123 ,x_eccv_rec OUT NOCOPY okl_eccv_rec);
124
125 PROCEDURE update_row(p_api_version IN number
126 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
127 ,x_return_status OUT NOCOPY varchar2
128 ,x_msg_count OUT NOCOPY number
129 ,x_msg_data OUT NOCOPY varchar2
130 ,p_eccv_tbl IN okl_eccv_tbl
131 ,x_eccv_tbl OUT NOCOPY okl_eccv_tbl);
132
133 PROCEDURE delete_row(p_api_version IN number
134 ,p_init_msg_list IN varchar2 DEFAULT okl_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_eccv_rec IN okl_eccv_rec);
139
140 PROCEDURE delete_row(p_api_version IN number
141 ,p_init_msg_list IN varchar2 DEFAULT okl_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_eccv_tbl IN okl_eccv_tbl);
146
147 PROCEDURE LOAD_SEED_ROW(p_upload_mode IN VARCHAR2,
148 p_crit_cat_def_id IN VARCHAR2,
149 p_object_version_number IN VARCHAR2,
150 p_ecc_ac_flag IN VARCHAR2,
151 p_crit_cat_name IN VARCHAR2,
152 p_orig_crit_cat_def_id IN VARCHAR2,
153 p_value_type_code IN VARCHAR2,
154 p_data_type_code IN VARCHAR2,
155 p_enabled_yn IN VARCHAR2,
156 p_seeded_yn IN VARCHAR2,
157 p_function_id IN VARCHAR2,
158 p_source_yn IN VARCHAR2,
159 p_sql_statement IN VARCHAR2,
160 p_trans_crit_cat_desc IN VARCHAR2,
161 p_owner IN VARCHAR2,
162 p_last_update_date IN VARCHAR2);
163
164 END okl_ecc_pvt;