[Home] [Help]
PACKAGE: APPS.OKL_ECH_PVT
Source
1 PACKAGE okl_ech_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSECHS.pls 120.1 2005/10/30 04:59:15 appldev noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_ech_rec IS RECORD (
9 criteria_set_id number,
10 object_version_number number,
11 source_id number,
12 source_object_code okl_fe_criteria_set.source_object_code%TYPE,
13 match_criteria_code okl_fe_criteria_set.match_criteria_code%TYPE,
14 validation_code okl_fe_criteria_set.validation_code%TYPE,
15 created_by number,
16 creation_date okl_fe_criteria_set.creation_date%TYPE,
17 last_updated_by number,
18 last_update_date okl_fe_criteria_set.last_update_date%TYPE,
19 last_update_login number
20 );
21
22 TYPE okl_ech_tbl IS TABLE OF okl_ech_rec INDEX BY BINARY_INTEGER;
23
24 --------------------------------------------------------------------------------
25 -- GLOBAL MESSAGE CONSTANTS
26 --------------------------------------------------------------------------------
27
28 g_fnd_app CONSTANT varchar2(200) := okl_api.g_fnd_app;
29 g_form_unable_to_reserve_rec CONSTANT varchar2(200) := okl_api.g_form_unable_to_reserve_rec;
30 g_form_record_deleted CONSTANT varchar2(200) := okl_api.g_form_record_deleted;
31 g_form_record_changed CONSTANT varchar2(200) := okl_api.g_form_record_changed;
32 g_record_logically_deleted CONSTANT varchar2(200) := okl_api.g_record_logically_deleted;
33 g_required_value CONSTANT varchar2(200) := okl_api.g_required_value;
34 g_invalid_value CONSTANT varchar2(200) := okl_api.g_invalid_value;
35 g_col_name_token CONSTANT varchar2(200) := okl_api.g_col_name_token;
36 g_parent_table_token CONSTANT varchar2(200) := okl_api.g_parent_table_token;
37 g_child_table_token CONSTANT varchar2(200) := okl_api.g_child_table_token;
38
39 --------------------------------------------------------------------------------
40 -- GLOBAL VARIABLES
41 --------------------------------------------------------------------------------
42
43 g_pkg_name CONSTANT varchar2(200) := 'OKL_ECH_PVT';
44 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
45
46 --------------------------------------------------------------------------------
47 -- Procedures and Functions
48 --------------------------------------------------------------------------------
49
50 PROCEDURE change_version;
51
52 PROCEDURE api_copy;
53
54 PROCEDURE insert_row(p_api_version IN number
55 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
56 ,x_return_status OUT NOCOPY varchar2
57 ,x_msg_count OUT NOCOPY number
58 ,x_msg_data OUT NOCOPY varchar2
59 ,p_ech_rec IN okl_ech_rec
60 ,x_ech_rec OUT NOCOPY okl_ech_rec);
61
62 PROCEDURE insert_row(p_api_version IN number
63 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
64 ,x_return_status OUT NOCOPY varchar2
65 ,x_msg_count OUT NOCOPY number
66 ,x_msg_data OUT NOCOPY varchar2
67 ,p_ech_tbl IN okl_ech_tbl
68 ,x_ech_tbl OUT NOCOPY okl_ech_tbl);
69
70 PROCEDURE update_row(p_api_version IN number
71 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
72 ,x_return_status OUT NOCOPY varchar2
73 ,x_msg_count OUT NOCOPY number
74 ,x_msg_data OUT NOCOPY varchar2
75 ,p_ech_rec IN okl_ech_rec
76 ,x_ech_rec OUT NOCOPY okl_ech_rec);
77
78 PROCEDURE update_row(p_api_version IN number
79 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
80 ,x_return_status OUT NOCOPY varchar2
81 ,x_msg_count OUT NOCOPY number
82 ,x_msg_data OUT NOCOPY varchar2
83 ,p_ech_tbl IN okl_ech_tbl
84 ,x_ech_tbl OUT NOCOPY okl_ech_tbl);
85
86 PROCEDURE delete_row(p_api_version IN number
87 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
88 ,x_return_status OUT NOCOPY varchar2
89 ,x_msg_count OUT NOCOPY number
90 ,x_msg_data OUT NOCOPY varchar2
91 ,p_ech_rec IN okl_ech_rec);
92
93 PROCEDURE delete_row(p_api_version IN number
94 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
95 ,x_return_status OUT NOCOPY varchar2
96 ,x_msg_count OUT NOCOPY number
97 ,x_msg_data OUT NOCOPY varchar2
98 ,p_ech_tbl IN okl_ech_tbl);
99
100 END okl_ech_pvt;