[Home] [Help]
PACKAGE: APPS.OKL_AMH_PVT
Source
1 Package OKL_AMH_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSAMHS.pls 120.4 2006/08/11 07:55:14 pagarg noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE amhv_rec_type IS RECORD (
7 id NUMBER := OKL_API.G_MISS_NUM
8 ,object_version_number NUMBER := okl_api.G_MISS_NUM
9 ,hold_period_days NUMBER := okl_api.G_MISS_NUM
10 ,category_id NUMBER := okl_api.G_MISS_NUM
11 ,book_type_code OKL_AMORT_HLD_SETUPS_ALL.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
12 ,method_id NUMBER := okl_api.G_MISS_NUM
13 -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
14 ,DEPRN_RATE NUMBER := okl_api.G_MISS_NUM
15 ,org_id NUMBER := okl_api.G_MISS_NUM
16 ,created_by NUMBER := okl_api.G_MISS_NUM
17 ,creation_date OKL_AMORT_HLD_SETUPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
18 ,last_updated_by NUMBER := okl_api.G_MISS_NUM
19 ,last_update_date OKL_AMORT_HLD_SETUPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
20 ,last_update_login NUMBER := okl_api.G_MISS_NUM);
21 G_MISS_amhv_rec amhv_rec_type;
22 TYPE amhv_tbl_type IS TABLE OF amhv_rec_type
23 INDEX BY BINARY_INTEGER;
24 TYPE amh_rec_type IS RECORD (
25 id NUMBER := okl_api.G_MISS_NUM
26 ,object_version_number NUMBER := okl_api.G_MISS_NUM
27 ,hold_period_days NUMBER := okl_api.G_MISS_NUM
28 ,category_id NUMBER := okl_api.G_MISS_NUM
29 ,book_type_code OKL_AMORT_HOLD_SETUPS.BOOK_TYPE_CODE%TYPE := okl_api.G_MISS_CHAR
30 ,method_id NUMBER := okl_api.G_MISS_NUM
31 -- SECHAWLA 26-MAY-04 3645574 : addded deprn_rate
32 ,deprn_rate NUMBER := okl_api.G_MISS_NUM
33 ,org_id NUMBER := okl_api.G_MISS_NUM
34 ,created_by NUMBER := okl_api.G_MISS_NUM
35 ,creation_date OKL_AMORT_HOLD_SETUPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE
36 ,last_updated_by NUMBER := okl_api.G_MISS_NUM
37 ,last_update_date OKL_AMORT_HOLD_SETUPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE
38 ,last_update_login NUMBER := okl_api.G_MISS_NUM);
39 G_MISS_amh_rec amh_rec_type;
40 TYPE amh_tbl_type IS TABLE OF amh_rec_type
41 INDEX BY BINARY_INTEGER;
42 ---------------------------------------------------------------------------
43 -- GLOBAL MESSAGE CONSTANTS
44 ---------------------------------------------------------------------------
45 G_FND_APP CONSTANT VARCHAR2(200) := okc_api.G_FND_APP;
46 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okc_api.G_FORM_UNABLE_TO_RESERVE_REC;
47 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okc_api.G_FORM_RECORD_DELETED;
48 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okc_api.G_FORM_RECORD_CHANGED;
49 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okc_api.G_RECORD_LOGICALLY_DELETED;
50 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
51 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okc_api.G_INVALID_VALUE;
52 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_COL_NAME_TOKEN;
53 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_PARENT_TABLE_TOKEN;
54 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okc_api.G_CHILD_TABLE_TOKEN;
55 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
56 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
57 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
58
59 ---------------------------------------------------------------------------
60 -- GLOBAL EXCEPTIONS
61 ---------------------------------------------------------------------------
62 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
63
64 ---------------------------------------------------------------------------
65 -- GLOBAL VARIABLES
66 ---------------------------------------------------------------------------
67 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AMH_PVT';
68 G_APP_NAME CONSTANT VARCHAR2(3) := okc_api.G_APP_NAME;
69 ---------------------------------------------------------------------------
70 -- Procedures and Functions
71 ---------------------------------------------------------------------------
72
73 PROCEDURE qc;
74 PROCEDURE change_version;
75 PROCEDURE api_copy;
76 PROCEDURE insert_row(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_amhv_rec IN amhv_rec_type,
83 x_amhv_rec OUT NOCOPY amhv_rec_type);
84 PROCEDURE insert_row(
85 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_amhv_tbl IN amhv_tbl_type,
91 x_amhv_tbl OUT NOCOPY amhv_tbl_type,
92 px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
93 PROCEDURE insert_row(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_amhv_tbl IN amhv_tbl_type,
100 x_amhv_tbl OUT NOCOPY amhv_tbl_type);
101 PROCEDURE lock_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_amhv_rec IN amhv_rec_type);
108 PROCEDURE lock_row(
109 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_amhv_tbl IN amhv_tbl_type,
115 px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
116 PROCEDURE lock_row(
117 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_amhv_tbl IN amhv_tbl_type);
123 PROCEDURE update_row(
124 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_amhv_rec IN amhv_rec_type,
130 x_amhv_rec OUT NOCOPY amhv_rec_type);
131 PROCEDURE update_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_amhv_tbl IN amhv_tbl_type,
138 x_amhv_tbl OUT NOCOPY amhv_tbl_type,
139 px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
140 PROCEDURE update_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_amhv_tbl IN amhv_tbl_type,
147 x_amhv_tbl OUT NOCOPY amhv_tbl_type);
148 PROCEDURE delete_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_amhv_rec IN amhv_rec_type);
155 PROCEDURE delete_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_amhv_tbl IN amhv_tbl_type,
162 px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_amhv_tbl IN amhv_tbl_type);
170 PROCEDURE validate_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_amhv_rec IN amhv_rec_type);
177 PROCEDURE validate_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_amhv_tbl IN amhv_tbl_type,
184 px_error_tbl IN OUT NOCOPY okl_api.ERROR_TBL_TYPE);
185 PROCEDURE validate_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_amhv_tbl IN amhv_tbl_type);
192 END OKL_AMH_PVT;