[Home] [Help]
PACKAGE: APPS.OKL_ECL_PVT
Source
1 PACKAGE okl_ecl_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSECLS.pls 120.1 2005/10/30 04:59:18 appldev noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_ecl_rec IS RECORD (
9 criteria_id number,
10 object_version_number number,
11 criteria_set_id number,
12 crit_cat_def_id number,
13 effective_from_date okl_fe_criteria.effective_from_date%TYPE,
14 effective_to_date okl_fe_criteria.effective_to_date%TYPE,
15 match_criteria_code okl_fe_criteria.match_criteria_code%TYPE,
16 is_new_flag varchar2(1),
17 created_by number,
18 creation_date okl_fe_criteria.creation_date%TYPE,
19 last_updated_by number,
20 last_update_date okl_fe_criteria.last_update_date%TYPE,
21 last_update_login number
22 );
23
24 TYPE okl_ecl_tbl IS TABLE OF okl_ecl_rec INDEX BY BINARY_INTEGER;
25
26 --------------------------------------------------------------------------------
27 -- GLOBAL MESSAGE CONSTANTS
28 --------------------------------------------------------------------------------
29
30 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
31 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
32 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
33 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
34 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
35 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
36 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
37 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
38 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
39 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
40
41 --------------------------------------------------------------------------------
42 -- GLOBAL VARIABLES
43 --------------------------------------------------------------------------------
44
45 g_pkg_name CONSTANT varchar2(200) := 'OKL_ECL_PVT';
46 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
47
48 --------------------------------------------------------------------------------
49 -- Procedures and Functions
50 --------------------------------------------------------------------------------
51
52 PROCEDURE change_version;
53
54 PROCEDURE api_copy;
55
56 PROCEDURE insert_row(p_api_version IN number
57 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
58 ,x_return_status OUT NOCOPY varchar2
59 ,x_msg_count OUT NOCOPY number
60 ,x_msg_data OUT NOCOPY varchar2
61 ,p_ecl_rec IN okl_ecl_rec
62 ,x_ecl_rec OUT NOCOPY okl_ecl_rec);
63
64 PROCEDURE insert_row(p_api_version IN number
65 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
66 ,x_return_status OUT NOCOPY varchar2
67 ,x_msg_count OUT NOCOPY number
68 ,x_msg_data OUT NOCOPY varchar2
69 ,p_ecl_tbl IN okl_ecl_tbl
70 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl);
71
72 PROCEDURE update_row(p_api_version IN number
73 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
74 ,x_return_status OUT NOCOPY varchar2
75 ,x_msg_count OUT NOCOPY number
76 ,x_msg_data OUT NOCOPY varchar2
77 ,p_ecl_rec IN okl_ecl_rec
78 ,x_ecl_rec OUT NOCOPY okl_ecl_rec);
79
80 PROCEDURE update_row(p_api_version IN number
81 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecl_tbl IN okl_ecl_tbl
86 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl);
87
88 PROCEDURE delete_row(p_api_version IN number
89 ,p_init_msg_list IN varchar2 DEFAULT okl_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_ecl_rec IN okl_ecl_rec);
94
95 PROCEDURE delete_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_ecl_tbl IN okl_ecl_tbl);
101
102 END okl_ecl_pvt;