eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_CAT_PVT

Source


1 PACKAGE Okl_Cat_Pvt AS
2 /* $Header: OKLSCATS.pls 120.4 2006/07/11 10:12:33 dkagrawa noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- GLOBAL DATASTRUCTURES
6   ---------------------------------------------------------------------------
7 /*  -- history tables not supported -- 04 APR 2002
8   TYPE okl_cash_allctn_rls_h_rec_type IS RECORD (
9     id                             NUMBER := Okl_Api.G_MISS_NUM,
10     major_version                  NUMBER := Okl_Api.G_MISS_NUM,
11     name                           OKL_CASH_ALLCTN_RLS_H.NAME%TYPE := Okl_Api.G_MISS_CHAR,
12     object_version_number          NUMBER := Okl_Api.G_MISS_NUM,
13     description                    OKL_CASH_ALLCTN_RLS_H.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
14     amount_tolerance_percent       NUMBER, -- := Okl_Api.G_MISS_NUM,
15     days_past_quote_valid_toleranc  NUMBER, -- := Okl_Api.G_MISS_NUM,
16     months_to_bill_ahead           NUMBER, -- := Okl_Api.G_MISS_NUM,
17    	under_payment_allocation_code  OKL_CASH_ALLCTN_RLS_H.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
18 	   over_payment_allocation_code   OKL_CASH_ALLCTN_RLS_H.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
19    	receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS_H.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
20     attribute_category             OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
21     attribute1                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
22     attribute2                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
23     attribute3                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
24     attribute4                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
25     attribute5                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
26     attribute6                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
27     attribute7                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
28     attribute8                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
29     attribute9                     OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
30     attribute10                    OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
31     attribute11                    OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
32     attribute12                    OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
33     attribute13                    OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
34     attribute14                    OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
35     attribute15                    OKL_CASH_ALLCTN_RLS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
36     created_by                     NUMBER := Okl_Api.G_MISS_NUM,
37     creation_date                  OKL_CASH_ALLCTN_RLS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
38     last_updated_by                NUMBER := Okl_Api.G_MISS_NUM,
39     last_update_date               OKL_CASH_ALLCTN_RLS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
40     last_update_login              NUMBER := Okl_Api.G_MISS_NUM);
41   GMissOklCashAllctnRlsHRec               okl_cash_allctn_rls_h_rec_type;
42   TYPE okl_cash_allctn_rls_h_tbl_type IS TABLE OF okl_cash_allctn_rls_h_rec_type
43         INDEX BY BINARY_INTEGER;
44 */
45   TYPE cat_rec_type IS RECORD (
46     id                              NUMBER := Okl_Api.G_MISS_NUM,
47     name                            OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
48     object_version_number           NUMBER := Okl_Api.G_MISS_NUM,
49     description                     OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
50     start_date                      OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
51     end_date                        OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
52     amount_tolerance_percent        NUMBER := Okl_Api.G_MISS_NUM,
53     days_past_quote_valid_toleranc  NUMBER := Okl_Api.G_MISS_NUM,
54     months_to_bill_ahead            NUMBER := Okl_Api.G_MISS_NUM,
55     under_payment_allocation_code   OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
56     over_payment_allocation_code    OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57     receipt_msmtch_allocation_code   OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
58     default_rule                    OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
59     attribute_category              OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
60     attribute1                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
61     attribute2                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
62     attribute3                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
63     attribute4                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
64     attribute5                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
65     attribute6                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
66     attribute7                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
67     attribute8                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
68     attribute9                      OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
69     attribute10                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
70     attribute11                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
71     attribute12                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
72     attribute13                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
73     attribute14                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
74     attribute15                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
75     org_id                          OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
76     created_by                      NUMBER := Okl_Api.G_MISS_NUM,
77     creation_date                   OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
78     last_updated_by                 NUMBER := Okl_Api.G_MISS_NUM,
79     last_update_date                OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
80     last_update_login               NUMBER := Okl_Api.G_MISS_NUM,
81     CAU_ID                          NUMBER := Okl_Api.G_MISS_NUM,
82 -- new column  to hold number of days to reserve advanced payment for contract.
83     num_days_hold_adv_pay     NUMBER := Okl_Api.G_MISS_NUM );
84   g_miss_cat_rec                          cat_rec_type;
85   TYPE cat_tbl_type IS TABLE OF cat_rec_type
86         INDEX BY BINARY_INTEGER;
87   TYPE catv_rec_type IS RECORD (
88     id                             NUMBER := Okl_Api.G_MISS_NUM,
89     object_version_number          NUMBER := Okl_Api.G_MISS_NUM,
90     name                           OKL_CASH_ALLCTN_RLS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
91     description                    OKL_CASH_ALLCTN_RLS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
92     start_date                     OKL_CASH_ALLCTN_RLS.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
93     end_date                       OKL_CASH_ALLCTN_RLS.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
94     amount_tolerance_percent       NUMBER := Okl_Api.G_MISS_NUM,
95     days_past_quote_valid_toleranc NUMBER := Okl_Api.G_MISS_NUM,
96     months_to_bill_ahead           NUMBER := Okl_Api.G_MISS_NUM,
97    	under_payment_allocation_code  OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
98    	over_payment_allocation_code   OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
99    	receipt_msmtch_allocation_code OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE := Okl_Api.G_MISS_CHAR,
100     default_rule                   OKL_CASH_ALLCTN_RLS.DEFAULT_RULE%TYPE := Okl_Api.G_MISS_CHAR,
101     attribute_category             OKL_CASH_ALLCTN_RLS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
102     attribute1                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
103     attribute2                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
104     attribute3                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
105     attribute4                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
106     attribute5                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
107     attribute6                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
108     attribute7                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
109     attribute8                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
110     attribute9                     OKL_CASH_ALLCTN_RLS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
111     attribute10                    OKL_CASH_ALLCTN_RLS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
112     attribute11                    OKL_CASH_ALLCTN_RLS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
113     attribute12                    OKL_CASH_ALLCTN_RLS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
114     attribute13                    OKL_CASH_ALLCTN_RLS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
115     attribute14                    OKL_CASH_ALLCTN_RLS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
116     attribute15                    OKL_CASH_ALLCTN_RLS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
117     org_id                         OKL_CASH_ALLCTN_RLS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
118     created_by                     NUMBER := Okl_Api.G_MISS_NUM,
119     creation_date                  OKL_CASH_ALLCTN_RLS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120     last_updated_by                NUMBER := Okl_Api.G_MISS_NUM,
121     last_update_date               OKL_CASH_ALLCTN_RLS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
122     last_update_login              NUMBER := Okl_Api.G_MISS_NUM,
123     CAU_ID                         NUMBER := Okl_Api.G_MISS_NUM,
124 -- new column  to hold number of days to reserve advanced payment for contract.
125     num_days_hold_adv_pay    NUMBER := Okl_Api.G_MISS_NUM );
126   g_miss_catv_rec                         catv_rec_type;
127   TYPE catv_tbl_type IS TABLE OF catv_rec_type
128         INDEX BY BINARY_INTEGER;
129   ---------------------------------------------------------------------------
130   -- GLOBAL MESSAGE CONSTANTS
131   ---------------------------------------------------------------------------
132   G_FND_APP			CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
133   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
134   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
135   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
136   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
137 
138   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
139 
140   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
141   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
142   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
143   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
144 
145   /****************** ADDED AFTER TAPI ************************************/
146 
147   G_UNEXPECTED_ERROR          CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
148    G_NO_PARENT_RECORD           CONSTANT   VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
149   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'OKC_SQLerrm';
150   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'OKC_SQLcode';
151   G_UPPERCASE_REQUIRED   CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
152   --G_UNQS     CONSTANT VARCHAR2(200) := 'OKC_VALUES_NOT_UNIQUE';
153   G_UNQS  CONSTANT VARCHAR2(200) := 'OKL_VALUES_NOT_UNIQUE';
154   G_ONE_DOI    CONSTANT VARCHAR2(200) := 'OKC_ONE_DOI';
155   ---------------------------------------------------------------------------
156   -- GLOBAL EXCEPTION
157   ---------------------------------------------------------------------------
158   G_EXCEPTION_HALT_VALIDATION  EXCEPTION;
159   ---------------------------------------------------------------------------
160   ---------------------------------------------------------------------------
161   -- GLOBAL VARIABLES
162   ---------------------------------------------------------------------------
163   G_VIEW                        CONSTANT   VARCHAR2(30) := 'OKL_CASH_ALLCTN_RLS';
164   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKL_CAT_PVT';
165   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  Okl_Api.G_APP_NAME;
166   ---------------------------------------------------------------------------
167   -- Procedures and Functions
168   ---------------------------------------------------------------------------
169 
170   PROCEDURE qc;
171   PROCEDURE change_version;
172   PROCEDURE api_copy;
173   PROCEDURE insert_row(
174     p_api_version                  IN NUMBER,
175     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
176     x_return_status                OUT NOCOPY VARCHAR2,
177     x_msg_count                    OUT NOCOPY NUMBER,
178     x_msg_data                     OUT NOCOPY VARCHAR2,
179     p_catv_rec                     IN catv_rec_type,
180     x_catv_rec                     OUT NOCOPY catv_rec_type);
181 
182   PROCEDURE insert_row(
183     p_api_version                  IN NUMBER,
184     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
185     x_return_status                OUT NOCOPY VARCHAR2,
186     x_msg_count                    OUT NOCOPY NUMBER,
187     x_msg_data                     OUT NOCOPY VARCHAR2,
188     p_catv_tbl                     IN catv_tbl_type,
189     x_catv_tbl                     OUT NOCOPY catv_tbl_type);
190 
191   PROCEDURE lock_row(
192     p_api_version                  IN NUMBER,
193     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
194     x_return_status                OUT NOCOPY VARCHAR2,
195     x_msg_count                    OUT NOCOPY NUMBER,
196     x_msg_data                     OUT NOCOPY VARCHAR2,
197     p_catv_rec                     IN catv_rec_type);
198 
199   PROCEDURE lock_row(
200     p_api_version                  IN NUMBER,
201     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
202     x_return_status                OUT NOCOPY VARCHAR2,
203     x_msg_count                    OUT NOCOPY NUMBER,
204     x_msg_data                     OUT NOCOPY VARCHAR2,
205     p_catv_tbl                     IN catv_tbl_type);
206 
207   PROCEDURE update_row(
208     p_api_version                  IN NUMBER,
209     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
210     x_return_status                OUT NOCOPY VARCHAR2,
211     x_msg_count                    OUT NOCOPY NUMBER,
212     x_msg_data                     OUT NOCOPY VARCHAR2,
213     p_catv_rec                     IN catv_rec_type,
214     x_catv_rec                     OUT NOCOPY catv_rec_type);
215 
216   PROCEDURE update_row(
217     p_api_version                  IN NUMBER,
218     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
219     x_return_status                OUT NOCOPY VARCHAR2,
220     x_msg_count                    OUT NOCOPY NUMBER,
221     x_msg_data                     OUT NOCOPY VARCHAR2,
222     p_catv_tbl                     IN catv_tbl_type,
223     x_catv_tbl                     OUT NOCOPY catv_tbl_type);
224 
225   PROCEDURE delete_row(
226     p_api_version                  IN NUMBER,
227     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
228     x_return_status                OUT NOCOPY VARCHAR2,
229     x_msg_count                    OUT NOCOPY NUMBER,
230     x_msg_data                     OUT NOCOPY VARCHAR2,
231     p_catv_rec                     IN catv_rec_type);
232 
233   PROCEDURE delete_row(
234     p_api_version                  IN NUMBER,
235     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
236     x_return_status                OUT NOCOPY VARCHAR2,
237     x_msg_count                    OUT NOCOPY NUMBER,
238     x_msg_data                     OUT NOCOPY VARCHAR2,
239     p_catv_tbl                     IN catv_tbl_type);
240 
241   PROCEDURE validate_row(
242     p_api_version                  IN NUMBER,
243     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
244     x_return_status                OUT NOCOPY VARCHAR2,
245     x_msg_count                    OUT NOCOPY NUMBER,
246     x_msg_data                     OUT NOCOPY VARCHAR2,
247     p_catv_rec                     IN catv_rec_type);
248 
249   PROCEDURE validate_row(
250     p_api_version                  IN NUMBER,
251     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
252     x_return_status                OUT NOCOPY VARCHAR2,
253     x_msg_count                    OUT NOCOPY NUMBER,
254     x_msg_data                     OUT NOCOPY VARCHAR2,
255     p_catv_tbl                     IN catv_tbl_type);
256 
257 END Okl_Cat_Pvt;