[Home] [Help]
PACKAGE: APPS.OKL_ECV_PVT
Source
1 PACKAGE okl_ecv_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSECVS.pls 120.1 2005/10/30 04:59:25 appldev noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_ecv_rec IS RECORD (
9 criterion_value_id number,
10 object_version_number number,
11 criteria_id number,
12 data_type_code varchar2(30),
13 source_yn varchar2(30),
14 value_type_code varchar2(30),
15 operator_code okl_fe_criterion_values.operator_code%TYPE,
16 crit_cat_value1 okl_fe_criterion_values.crit_cat_value1%TYPE,
17 crit_cat_value2 okl_fe_criterion_values.crit_cat_value2%TYPE,
18 crit_cat_numval1 number,
19 crit_cat_numval2 number,
20 crit_cat_dateval1 date,
21 crit_cat_dateval2 date,
22 validate_record varchar2(1),
23 adjustment_factor number,
24 created_by number,
25 creation_date okl_fe_criterion_values.creation_date%TYPE,
26 last_updated_by number,
27 last_update_date okl_fe_criterion_values.last_update_date%TYPE,
28 last_update_login number,
29 attribute_category okl_fe_criterion_values.attribute_category%TYPE,
30 attribute1 okl_fe_criterion_values.attribute1%TYPE,
31 attribute2 okl_fe_criterion_values.attribute2%TYPE,
32 attribute3 okl_fe_criterion_values.attribute3%TYPE,
33 attribute4 okl_fe_criterion_values.attribute4%TYPE,
34 attribute5 okl_fe_criterion_values.attribute5%TYPE,
35 attribute6 okl_fe_criterion_values.attribute6%TYPE,
36 attribute7 okl_fe_criterion_values.attribute7%TYPE,
37 attribute8 okl_fe_criterion_values.attribute8%TYPE,
38 attribute9 okl_fe_criterion_values.attribute9%TYPE,
39 attribute10 okl_fe_criterion_values.attribute10%TYPE,
40 attribute11 okl_fe_criterion_values.attribute11%TYPE,
41 attribute12 okl_fe_criterion_values.attribute12%TYPE,
42 attribute13 okl_fe_criterion_values.attribute13%TYPE,
43 attribute14 okl_fe_criterion_values.attribute14%TYPE,
44 attribute15 okl_fe_criterion_values.attribute15%TYPE
45 );
46
47 TYPE okl_ecv_tbl IS TABLE OF okl_ecv_rec INDEX BY BINARY_INTEGER;
48
49 --------------------------------------------------------------------------------
50 -- GLOBAL MESSAGE CONSTANTS
51 --------------------------------------------------------------------------------
52
53 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
54 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
55 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
56 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
57 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
58 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
59 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
60 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
61 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
62 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
63
64 --------------------------------------------------------------------------------
65 -- GLOBAL VARIABLES
66 --------------------------------------------------------------------------------
67
68 g_pkg_name CONSTANT varchar2(200) := 'OKL_ECV_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 okl_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_ecv_rec IN okl_ecv_rec
85 ,x_ecv_rec OUT NOCOPY okl_ecv_rec);
86
87 PROCEDURE insert_row(p_api_version IN number
88 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecv_tbl IN okl_ecv_tbl
93 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
94
95 PROCEDURE update_row(p_api_version IN number
96 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecv_rec IN okl_ecv_rec
101 ,x_ecv_rec OUT NOCOPY okl_ecv_rec);
102
103 PROCEDURE update_row(p_api_version IN number
104 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecv_tbl IN okl_ecv_tbl
109 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
110
111 PROCEDURE delete_row(p_api_version IN number
112 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecv_rec IN okl_ecv_rec);
117
118 PROCEDURE delete_row(p_api_version IN number
119 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecv_tbl IN okl_ecv_tbl);
124
125 FUNCTION validate_record(p_ecv_rec IN OUT NOCOPY okl_ecv_rec) RETURN varchar2;
126
127 END okl_ecv_pvt;