8:
9: ---------------------------------------------------------------------------
10: -- GLOBAL MESSAGE CONSTANTS
11: ---------------------------------------------------------------------------
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
9: ---------------------------------------------------------------------------
10: -- GLOBAL MESSAGE CONSTANTS
11: ---------------------------------------------------------------------------
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
10: -- GLOBAL MESSAGE CONSTANTS
11: ---------------------------------------------------------------------------
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
11: ---------------------------------------------------------------------------
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
15: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
25: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
31:
32: -- GLOBAL VARIABLES
33: ---------------------------------------------------------------------------
34: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASSENT_PVT';
35: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
36: ---------------------------------------------------------------------------
37: PROCEDURE add_language;
38:
39: PROCEDURE create_assent(
37: PROCEDURE add_language;
38:
39: PROCEDURE create_assent(
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: p_astv_rec IN astv_rec_type,
46: x_astv_rec OUT NOCOPY astv_rec_type);
47:
48: PROCEDURE create_assent(
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_astv_tbl IN astv_tbl_type,
55: x_astv_tbl OUT NOCOPY astv_tbl_type);
56:
57: PROCEDURE update_assent(
58: p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2,
63: p_astv_rec IN astv_rec_type,
64: x_astv_rec OUT NOCOPY astv_rec_type);
65:
66: PROCEDURE update_assent(
67: p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2,
72: p_astv_tbl IN astv_tbl_type,
74:
75:
76: PROCEDURE delete_assent(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_astv_rec IN astv_rec_type);
82: p_astv_rec IN astv_rec_type);
83:
84: PROCEDURE delete_assent(
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_astv_tbl IN astv_tbl_type);
90: p_astv_tbl IN astv_tbl_type);
91:
92: PROCEDURE lock_assent(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_astv_rec IN astv_rec_type);
98: p_astv_rec IN astv_rec_type);
99:
100: PROCEDURE lock_assent(
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_astv_tbl IN astv_tbl_type);
106: p_astv_tbl IN astv_tbl_type);
107:
108: PROCEDURE validate_assent(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_astv_rec IN astv_rec_type);
114: p_astv_rec IN astv_rec_type);
115:
116: PROCEDURE validate_assent(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_astv_tbl IN astv_tbl_type);
131: p_opn_code IN VARCHAR2) return varchar2;
132:
133: PROCEDURE create_status(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_stsv_rec IN stsv_rec_type,
140: x_stsv_rec OUT NOCOPY stsv_rec_type);
141:
142: PROCEDURE create_status(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_stsv_tbl IN stsv_tbl_type,
149: x_stsv_tbl OUT NOCOPY stsv_tbl_type);
150:
151: PROCEDURE update_status(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_stsv_rec IN stsv_rec_type,
158: x_stsv_rec OUT NOCOPY stsv_rec_type);
159:
160: PROCEDURE update_status(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_stsv_tbl IN stsv_tbl_type,
167: x_stsv_tbl OUT NOCOPY stsv_tbl_type);
168:
169: PROCEDURE delete_status(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_stsv_rec IN stsv_rec_type);
175: p_stsv_rec IN stsv_rec_type);
176:
177: PROCEDURE delete_status(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_stsv_tbl IN stsv_tbl_type);
183: p_stsv_tbl IN stsv_tbl_type);
184:
185: PROCEDURE lock_status(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_stsv_rec IN stsv_rec_type);
191: p_stsv_rec IN stsv_rec_type);
192:
193: PROCEDURE lock_status(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_stsv_tbl IN stsv_tbl_type);
199: p_stsv_tbl IN stsv_tbl_type);
200:
201: PROCEDURE validate_status(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_stsv_rec IN stsv_rec_type);
207: p_stsv_rec IN stsv_rec_type);
208:
209: PROCEDURE validate_status(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_stsv_tbl IN stsv_tbl_type);