[Home] [Help]
PACKAGE: APPS.OKL_ECO_PVT
Source
1 PACKAGE okl_eco_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSECOS.pls 120.2 2006/12/07 06:10:35 ssdeshpa noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_eco_rec IS RECORD (
9 object_class_id number,
10 object_version_number number,
11 crit_cat_def_id number,
12 object_class_code okl_fe_crit_cat_objects.object_class_code%TYPE,
13 is_applicable varchar2(3),
14 created_by number,
15 creation_date okl_fe_crit_cat_objects.creation_date%TYPE,
16 last_updated_by number,
17 last_update_date okl_fe_crit_cat_objects.last_update_date%TYPE,
18 last_update_login number
19 );
20
21 TYPE okl_eco_tbl IS TABLE OF okl_eco_rec INDEX BY BINARY_INTEGER;
22
23 --------------------------------------------------------------------------------
24 -- GLOBAL MESSAGE CONSTANTS
25 --------------------------------------------------------------------------------
26
27 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
28 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
29 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
30 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
31 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
32 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
33 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
34 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
35 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
36 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
37
38 --------------------------------------------------------------------------------
39 -- GLOBAL VARIABLES
40 --------------------------------------------------------------------------------
41
42 g_pkg_name CONSTANT varchar2(200) := 'OKL_ECO_PVT';
43 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
44
45 --------------------------------------------------------------------------------
46 -- Procedures and Functions
47 --------------------------------------------------------------------------------
48
49 PROCEDURE change_version;
50
51 PROCEDURE api_copy;
52
53 PROCEDURE insert_row(p_api_version IN number
54 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
55 ,x_return_status OUT NOCOPY varchar2
56 ,x_msg_count OUT NOCOPY number
57 ,x_msg_data OUT NOCOPY varchar2
58 ,p_eco_rec IN okl_eco_rec
59 ,x_eco_rec OUT NOCOPY okl_eco_rec);
60
61 PROCEDURE insert_row(p_api_version IN number
62 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
63 ,x_return_status OUT NOCOPY varchar2
64 ,x_msg_count OUT NOCOPY number
65 ,x_msg_data OUT NOCOPY varchar2
66 ,p_eco_tbl IN okl_eco_tbl
67 ,x_eco_tbl OUT NOCOPY okl_eco_tbl);
68
69 PROCEDURE update_row(p_api_version IN number
70 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
71 ,x_return_status OUT NOCOPY varchar2
72 ,x_msg_count OUT NOCOPY number
73 ,x_msg_data OUT NOCOPY varchar2
74 ,p_eco_rec IN okl_eco_rec
75 ,x_eco_rec OUT NOCOPY okl_eco_rec);
76
77 PROCEDURE update_row(p_api_version IN number
78 ,p_init_msg_list IN varchar2 DEFAULT okl_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_eco_tbl IN okl_eco_tbl
83 ,x_eco_tbl OUT NOCOPY okl_eco_tbl);
84
85 PROCEDURE delete_row(p_api_version IN number
86 ,p_init_msg_list IN varchar2 DEFAULT okl_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_eco_rec IN okl_eco_rec);
91
92 PROCEDURE delete_row(p_api_version IN number
93 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
94 ,x_return_status OUT NOCOPY varchar2
95 ,x_msg_count OUT NOCOPY number
96 ,x_msg_data OUT NOCOPY varchar2
97 ,p_eco_tbl IN okl_eco_tbl);
98
99 PROCEDURE LOAD_SEED_ROW(p_object_class_id IN VARCHAR2,
100 p_object_version_number IN VARCHAR2,
101 p_crit_cat_def_id IN VARCHAR2,
102 p_object_class_code IN VARCHAR2,
103 p_owner IN VARCHAR2,
104 p_last_update_date IN VARCHAR2);
105
106 END okl_eco_pvt;