[Home] [Help]
PACKAGE: APPS.OKL_TAO_PVT
Source
1 PACKAGE Okl_Tao_Pvt AS
2 /* $Header: OKLSTAOS.pls 120.2 2006/07/11 10:29:39 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tao_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 try_id NUMBER := Okc_Api.G_MISS_NUM,
9 rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
10 freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
11 rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
12 clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
13 tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
14 unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
15 unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
16 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17 org_id NUMBER := Okc_Api.G_MISS_NUM,
18 attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19 attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20 attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21 attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22 attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23 attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24 attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25 attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26 attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33 attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34 created_by NUMBER := Okc_Api.G_MISS_NUM,
35 creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37 last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39 /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
40 post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
41 /* Changes Ends */
42
43 g_miss_tao_rec tao_rec_type;
44 TYPE tao_tbl_type IS TABLE OF tao_rec_type
45 INDEX BY BINARY_INTEGER;
46 TYPE taov_rec_type IS RECORD (
47 id NUMBER := Okc_Api.G_MISS_NUM,
48 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
49 try_id NUMBER := Okc_Api.G_MISS_NUM,
50 unearned_ccid NUMBER := Okc_Api.G_MISS_NUM,
51 rev_ccid NUMBER := Okc_Api.G_MISS_NUM,
52 freight_ccid NUMBER := Okc_Api.G_MISS_NUM,
53 rec_ccid NUMBER := Okc_Api.G_MISS_NUM,
54 clearing_ccid NUMBER := Okc_Api.G_MISS_NUM,
55 tax_ccid NUMBER := Okc_Api.G_MISS_NUM,
56 unbilled_ccid NUMBER := Okc_Api.G_MISS_NUM,
57 attribute_category OKL_TRX_ACCT_OPTS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
58 attribute1 OKL_TRX_ACCT_OPTS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
59 attribute2 OKL_TRX_ACCT_OPTS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
60 attribute3 OKL_TRX_ACCT_OPTS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
61 attribute4 OKL_TRX_ACCT_OPTS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
62 attribute5 OKL_TRX_ACCT_OPTS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
63 attribute6 OKL_TRX_ACCT_OPTS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
64 attribute7 OKL_TRX_ACCT_OPTS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
65 attribute8 OKL_TRX_ACCT_OPTS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
66 attribute9 OKL_TRX_ACCT_OPTS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
67 attribute10 OKL_TRX_ACCT_OPTS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
68 attribute11 OKL_TRX_ACCT_OPTS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
69 attribute12 OKL_TRX_ACCT_OPTS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
70 attribute13 OKL_TRX_ACCT_OPTS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
71 attribute14 OKL_TRX_ACCT_OPTS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
72 attribute15 OKL_TRX_ACCT_OPTS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
73 org_id NUMBER := Okc_Api.G_MISS_NUM,
74 created_by NUMBER := Okc_Api.G_MISS_NUM,
75 creation_date OKL_TRX_ACCT_OPTS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
76 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
77 last_update_date OKL_TRX_ACCT_OPTS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
78 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
79 /* Changes Made by Kanti on 06/27/2001. This field is present in Table but was missing from here */
80 post_to_gl_yn OKL_TRX_ACCT_OPTS.POST_TO_GL_YN%TYPE := Okc_Api.G_MISS_CHAR);
81 /* Changes Ends */
82
83
84 g_miss_taov_rec taov_rec_type;
85 TYPE taov_tbl_type IS TABLE OF taov_rec_type
86 INDEX BY BINARY_INTEGER;
87 ---------------------------------------------------------------------------
88 -- GLOBAL MESSAGE CONSTANTS
89 ---------------------------------------------------------------------------
90 -- Added 04/27/2001 Robin Edwin for validate attribute
91
92 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
93 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
94 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
95
96 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
97 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
98 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
99 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
100 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
101 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
102 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
103 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
104 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
105 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
106 ---------------------------------------------------------------------------
107 -- GLOBAL VARIABLES
108 ---------------------------------------------------------------------------
109 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAO_PVT';
110 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
111 ---------------------------------------------------------------------------
112 -- Procedures and Functions
113 ---------------------------------------------------------------------------
114
115 PROCEDURE qc;
116 PROCEDURE change_version;
117 PROCEDURE api_copy;
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_taov_rec IN taov_rec_type,
125 x_taov_rec OUT NOCOPY taov_rec_type);
126
127 PROCEDURE insert_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_taov_tbl IN taov_tbl_type,
134 x_taov_tbl OUT NOCOPY taov_tbl_type);
135
136 PROCEDURE lock_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_taov_rec IN taov_rec_type);
143
144 PROCEDURE lock_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_taov_tbl IN taov_tbl_type);
151
152 PROCEDURE update_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_taov_rec IN taov_rec_type,
159 x_taov_rec OUT NOCOPY taov_rec_type);
160
161 PROCEDURE update_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_taov_tbl IN taov_tbl_type,
168 x_taov_tbl OUT NOCOPY taov_tbl_type);
169
170 PROCEDURE delete_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_taov_rec IN taov_rec_type);
177
178 PROCEDURE delete_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_taov_tbl IN taov_tbl_type);
185
186 PROCEDURE validate_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_taov_rec IN taov_rec_type);
193
194 PROCEDURE validate_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_taov_tbl IN taov_tbl_type);
201
202 END Okl_Tao_Pvt;