[Home] [Help]
PACKAGE: APPS.OKL_ETV_PVT
Source
1 PACKAGE okl_etv_pvt AS
2 /* $Header: OKLSETVS.pls 120.1 2005/08/25 10:34:04 viselvar noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_etv_rec IS RECORD (
9 end_of_term_value_id NUMBER,
10 object_version_number NUMBER,
11 eot_term NUMBER,
12 eot_value NUMBER,
13 end_of_term_ver_id NUMBER,
14 attribute_category okl_fe_eo_term_values.attribute_category%TYPE,
15 attribute1 okl_fe_eo_term_values.attribute1%TYPE,
16 attribute2 okl_fe_eo_term_values.attribute2%TYPE,
17 attribute3 okl_fe_eo_term_values.attribute3%TYPE,
18 attribute4 okl_fe_eo_term_values.attribute4%TYPE,
19 attribute5 okl_fe_eo_term_values.attribute5%TYPE,
20 attribute6 okl_fe_eo_term_values.attribute6%TYPE,
21 attribute7 okl_fe_eo_term_values.attribute7%TYPE,
22 attribute8 okl_fe_eo_term_values.attribute8%TYPE,
23 attribute9 okl_fe_eo_term_values.attribute9%TYPE,
24 attribute10 okl_fe_eo_term_values.attribute10%TYPE,
25 attribute11 okl_fe_eo_term_values.attribute11%TYPE,
26 attribute12 okl_fe_eo_term_values.attribute12%TYPE,
27 attribute13 okl_fe_eo_term_values.attribute13%TYPE,
28 attribute14 okl_fe_eo_term_values.attribute14%TYPE,
29 attribute15 okl_fe_eo_term_values.attribute15%TYPE,
30 created_by NUMBER,
31 creation_date okl_fe_eo_term_values.creation_date%TYPE,
32 last_updated_by NUMBER,
33 last_update_date okl_fe_eo_term_values.last_update_date%TYPE,
34 last_update_login NUMBER
35 );
36
37 TYPE okl_etv_tbl IS TABLE OF okl_etv_rec INDEX BY BINARY_INTEGER;
38
39 --------------------------------------------------------------------------------
40 -- GLOBAL MESSAGE CONSTANTS
41 --------------------------------------------------------------------------------
42
43 g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
44 g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
45 g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
46 g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
47 g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
48 g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
49 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
50 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
51 g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
52 g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
53 g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
54 g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
55 g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
56 g_db_error CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
57 g_prog_name_token CONSTANT VARCHAR2(9) := 'PROG_NAME';
58 g_api_version CONSTANT NUMBER := 1;
59 g_false CONSTANT VARCHAR2(1) := fnd_api.g_false;
60 g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;
61
62 --------------------------------------------------------------------------------
63 -- GLOBAL VARIABLES
64 --------------------------------------------------------------------------------
65
66 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_ETV_PVT';
67 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
68
69 --------------------------------------------------------------------------------
70 -- Procedures and Functions
71 --------------------------------------------------------------------------------
72
73 PROCEDURE change_version;
74
75 PROCEDURE api_copy;
76
77 PROCEDURE insert_row(p_api_version IN NUMBER
78 ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
79 ,x_return_status OUT NOCOPY VARCHAR2
80 ,x_msg_count OUT NOCOPY NUMBER
81 ,x_msg_data OUT NOCOPY VARCHAR2
82 ,p_etv_rec IN okl_etv_rec
83 ,x_etv_rec OUT NOCOPY okl_etv_rec);
84
85 PROCEDURE insert_row(p_api_version IN NUMBER
86 ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89 ,x_msg_data OUT NOCOPY VARCHAR2
90 ,p_etv_tbl IN okl_etv_tbl
91 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
92
93 PROCEDURE update_row(p_api_version IN NUMBER
94 ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
95 ,x_return_status OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2
98 ,p_etv_rec IN okl_etv_rec
99 ,x_etv_rec OUT NOCOPY okl_etv_rec);
100
101 PROCEDURE update_row(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_etv_tbl IN okl_etv_tbl
107 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
108
109 PROCEDURE delete_row(p_api_version IN NUMBER
110 ,p_init_msg_list IN VARCHAR2 DEFAULT okc_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_etv_rec IN okl_etv_rec);
115
116 PROCEDURE delete_row(p_api_version IN NUMBER
117 ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
118 ,x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 ,p_etv_tbl IN okl_etv_tbl);
122
123 END okl_etv_pvt;