[Home] [Help]
PACKAGE: APPS.OKL_SRV_PVT
Source
1 PACKAGE okl_srv_pvt AS
2 /* $Header: OKLSSRVS.pls 120.0 2005/07/07 10:45:49 viselvar noship $ */
3
4 --------------------------------------------------------------------------------
5 --GLOBAL DATASTRUCTURES
6 --------------------------------------------------------------------------------
7
8 TYPE okl_srv_rec IS RECORD (
9 std_rate_tmpl_ver_id NUMBER,
10 object_version_number NUMBER,
11 version_number okl_fe_std_rt_tmp_vers.version_number%TYPE,
12 std_rate_tmpl_id NUMBER,
13 effective_from_date okl_fe_std_rt_tmp_vers.effective_from_date%TYPE,
14 effective_to_date okl_fe_std_rt_tmp_vers.effective_to_date%TYPE,
15 sts_code okl_fe_std_rt_tmp_vers.sts_code%TYPE,
16 adj_mat_version_id NUMBER,
17 srt_rate NUMBER,
18 spread NUMBER,
19 day_convention_code okl_fe_std_rt_tmp_vers.day_convention_code%TYPE,
20 min_adj_rate NUMBER,
21 max_adj_rate NUMBER,
22 attribute_category okl_fe_std_rt_tmp_vers.attribute_category%TYPE,
23 attribute1 okl_fe_std_rt_tmp_vers.attribute1%TYPE,
24 attribute2 okl_fe_std_rt_tmp_vers.attribute2%TYPE,
25 attribute3 okl_fe_std_rt_tmp_vers.attribute3%TYPE,
26 attribute4 okl_fe_std_rt_tmp_vers.attribute4%TYPE,
27 attribute5 okl_fe_std_rt_tmp_vers.attribute5%TYPE,
28 attribute6 okl_fe_std_rt_tmp_vers.attribute6%TYPE,
29 attribute7 okl_fe_std_rt_tmp_vers.attribute7%TYPE,
30 attribute8 okl_fe_std_rt_tmp_vers.attribute8%TYPE,
31 attribute9 okl_fe_std_rt_tmp_vers.attribute9%TYPE,
32 attribute10 okl_fe_std_rt_tmp_vers.attribute10%TYPE,
33 attribute11 okl_fe_std_rt_tmp_vers.attribute11%TYPE,
34 attribute12 okl_fe_std_rt_tmp_vers.attribute12%TYPE,
35 attribute13 okl_fe_std_rt_tmp_vers.attribute13%TYPE,
36 attribute14 okl_fe_std_rt_tmp_vers.attribute14%TYPE,
37 attribute15 okl_fe_std_rt_tmp_vers.attribute15%TYPE,
38 created_by NUMBER,
39 creation_date okl_fe_std_rt_tmp_vers.creation_date%TYPE,
40 last_updated_by NUMBER,
41 last_update_date okl_fe_std_rt_tmp_vers.last_update_date%TYPE,
42 last_update_login NUMBER
43 );
44
45 TYPE okl_srv_tbl IS TABLE OF okl_srv_rec INDEX BY BINARY_INTEGER;
46
47 --------------------------------------------------------------------------------
48 -- GLOBAL MESSAGE CONSTANTS
49 --------------------------------------------------------------------------------
50
51 g_fnd_app CONSTANT VARCHAR2(200) := okl_api.g_fnd_app;
52 g_form_unable_to_reserve_rec CONSTANT VARCHAR2(200) := okl_api.g_form_unable_to_reserve_rec;
53 g_form_record_deleted CONSTANT VARCHAR2(200) := okl_api.g_form_record_deleted;
54 g_form_record_changed CONSTANT VARCHAR2(200) := okl_api.g_form_record_changed;
55 g_record_logically_deleted CONSTANT VARCHAR2(200) := okl_api.g_record_logically_deleted;
56 g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
57 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
58 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
59 g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
60 g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
61 g_ret_sts_success CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success;
62 g_ret_sts_unexp_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
63 g_ret_sts_error CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error;
64 g_db_error CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
65 g_prog_name_token CONSTANT VARCHAR2(9) := 'PROG_NAME';
66 g_api_version CONSTANT NUMBER := 1;
67 g_false CONSTANT VARCHAR2(1) := fnd_api.g_false;
68 g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;
69
70 --------------------------------------------------------------------------------
71 -- GLOBAL VARIABLES
72 --------------------------------------------------------------------------------
73
74 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_SRV_PVT';
75 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
76
77 --------------------------------------------------------------------------------
78 -- Procedures and Functions
79 --------------------------------------------------------------------------------
80
81 PROCEDURE change_version;
82
83 PROCEDURE api_copy;
84
85 PROCEDURE insert_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_srv_rec IN okl_srv_rec
91 ,x_srv_rec OUT NOCOPY okl_srv_rec);
92
93 PROCEDURE insert_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_srv_tbl IN okl_srv_tbl
99 ,x_srv_tbl OUT NOCOPY okl_srv_tbl);
100
101 PROCEDURE update_row(p_api_version IN NUMBER
102 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106 ,p_srv_rec IN okl_srv_rec
107 ,x_srv_rec OUT NOCOPY okl_srv_rec);
108
109 PROCEDURE update_row(p_api_version IN NUMBER
110 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
111 ,x_return_status OUT NOCOPY VARCHAR2
112 ,x_msg_count OUT NOCOPY NUMBER
113 ,x_msg_data OUT NOCOPY VARCHAR2
114 ,p_srv_tbl IN okl_srv_tbl
115 ,x_srv_tbl OUT NOCOPY okl_srv_tbl);
116
117 PROCEDURE delete_row(p_api_version IN NUMBER
118 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 ,p_srv_rec IN okl_srv_rec);
123
124 PROCEDURE delete_row(p_api_version IN NUMBER
125 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129 ,p_srv_tbl IN okl_srv_tbl);
130
131 END okl_srv_pvt;