63: INDEX BY BINARY_INTEGER;
64: ---------------------------------------------------------------------------
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64: ---------------------------------------------------------------------------
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65: -- GLOBAL MESSAGE CONSTANTS
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66: ---------------------------------------------------------------------------
67: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
69: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
77: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
77: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
78: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
77: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
78: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
79: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
72: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
76: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
77: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
78: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
79: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
80:
86: ---------------------------------------------------------------------------
87: -- GLOBAL VARIABLES
88: ---------------------------------------------------------------------------
89: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CIN_PVT';
90: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
91: ---------------------------------------------------------------------------
92: -- Procedures and Functions
93: ---------------------------------------------------------------------------
94:
96: PROCEDURE change_version;
97: PROCEDURE api_copy;
98: PROCEDURE insert_row(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_cin_rec IN cin_rec_type,
104: p_cin_rec IN cin_rec_type,
105: x_cin_rec OUT NOCOPY cin_rec_type);
106: PROCEDURE insert_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_cin_tbl IN cin_tbl_type,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_cin_tbl IN cin_tbl_type,
113: x_cin_tbl OUT NOCOPY cin_tbl_type,
114: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
115: PROCEDURE insert_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
113: x_cin_tbl OUT NOCOPY cin_tbl_type,
114: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
115: PROCEDURE insert_row(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_cin_tbl IN cin_tbl_type,
121: p_cin_tbl IN cin_tbl_type,
122: x_cin_tbl OUT NOCOPY cin_tbl_type);
123: PROCEDURE lock_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_cin_rec IN cin_rec_type);
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_cin_rec IN cin_rec_type);
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_cin_tbl IN cin_tbl_type,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_cin_tbl IN cin_tbl_type,
137: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
136: p_cin_tbl IN cin_tbl_type,
137: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_cin_tbl IN cin_tbl_type);
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_cin_tbl IN cin_tbl_type);
145: PROCEDURE update_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_cin_rec IN cin_rec_type,
151: p_cin_rec IN cin_rec_type,
152: x_cin_rec OUT NOCOPY cin_rec_type);
153: PROCEDURE update_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_cin_tbl IN cin_tbl_type,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_cin_tbl IN cin_tbl_type,
160: x_cin_tbl OUT NOCOPY cin_tbl_type,
161: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
162: PROCEDURE update_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
160: x_cin_tbl OUT NOCOPY cin_tbl_type,
161: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
162: PROCEDURE update_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_cin_tbl IN cin_tbl_type,
168: p_cin_tbl IN cin_tbl_type,
169: x_cin_tbl OUT NOCOPY cin_tbl_type);
170: PROCEDURE delete_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_cin_rec IN cin_rec_type);
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cin_rec IN cin_rec_type);
177: PROCEDURE delete_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_cin_tbl IN cin_tbl_type,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_cin_tbl IN cin_tbl_type,
184: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
185: PROCEDURE delete_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,
183: p_cin_tbl IN cin_tbl_type,
184: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
185: PROCEDURE delete_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_cin_tbl IN cin_tbl_type);
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_cin_tbl IN cin_tbl_type);
192: PROCEDURE validate_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_cin_rec IN cin_rec_type);
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_cin_rec IN cin_rec_type);
199: PROCEDURE validate_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_cin_tbl IN cin_tbl_type,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_cin_tbl IN cin_tbl_type,
206: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
207: PROCEDURE validate_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,
205: p_cin_tbl IN cin_tbl_type,
206: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
207: PROCEDURE validate_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_cin_tbl IN cin_tbl_type);