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