DBA Data[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;