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