9: SUBTYPE aaev_tbl_type IS okc_aae_pvt.aaev_tbl_type;
10:
11: -- GLOBAL_MESSAGE_CONSTANTS
12: ---------------------------------------------------------------------------
13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
10:
11: -- GLOBAL_MESSAGE_CONSTANTS
12: ---------------------------------------------------------------------------
13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
11: -- GLOBAL_MESSAGE_CONSTANTS
12: ---------------------------------------------------------------------------
13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
12: ---------------------------------------------------------------------------
13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
13: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
14: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
15: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
16: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
33:
34: -- GLOBAL VARIABLES
35: ---------------------------------------------------------------------------
36: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ACTIONS_PUB';
37: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
38:
39: g_acnv_rec acnv_rec_type;
40: g_aaev_rec aaev_rec_type;
41: ---------------------------------------------------------------------------
43: PROCEDURE add_language;
44:
45: PROCEDURE create_actions(
46: p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: p_acnv_rec IN acnv_rec_type,
54: x_aaev_tbl OUT NOCOPY aaev_tbl_type);
55:
56: PROCEDURE create_actions(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_acnv_tbl IN acnv_tbl_type,
65: x_aaev_tbl OUT NOCOPY aaev_tbl_type);
66:
67: PROCEDURE update_actions(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_acnv_rec IN acnv_rec_type,
76: x_aaev_tbl OUT NOCOPY aaev_tbl_type);
77:
78: PROCEDURE validate_actions(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_acnv_rec IN acnv_rec_type,
85: p_aaev_tbl IN aaev_tbl_type);
86:
87: PROCEDURE create_actions(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_acnv_tbl IN acnv_tbl_type,
94: x_acnv_tbl OUT NOCOPY acnv_tbl_type);
95:
96: PROCEDURE create_actions(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_acnv_rec IN acnv_rec_type,
103: x_acnv_rec OUT NOCOPY acnv_rec_type);
104:
105: PROCEDURE lock_actions(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_acnv_tbl IN acnv_tbl_type);
111: p_acnv_tbl IN acnv_tbl_type);
112:
113: PROCEDURE lock_actions(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_acnv_rec IN acnv_rec_type);
119: p_acnv_rec IN acnv_rec_type);
120:
121: PROCEDURE update_actions(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_acnv_tbl IN acnv_tbl_type,
128: x_acnv_tbl OUT NOCOPY acnv_tbl_type);
129:
130: PROCEDURE update_actions(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_acnv_rec IN acnv_rec_type,
137: x_acnv_rec OUT NOCOPY acnv_rec_type);
138:
139: PROCEDURE delete_actions(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_acnv_tbl IN acnv_tbl_type);
145: p_acnv_tbl IN acnv_tbl_type);
146:
147: PROCEDURE delete_actions(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_acnv_rec IN acnv_rec_type);
153: p_acnv_rec IN acnv_rec_type);
154:
155: PROCEDURE validate_actions(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_acnv_tbl IN acnv_tbl_type);
161: p_acnv_tbl IN acnv_tbl_type);
162:
163: PROCEDURE validate_actions(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_acnv_rec IN acnv_rec_type);
169: p_acnv_rec IN acnv_rec_type);
170:
171: PROCEDURE create_act_atts(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_aaev_tbl IN aaev_tbl_type,
178: x_aaev_tbl OUT NOCOPY aaev_tbl_type);
179:
180: PROCEDURE create_act_atts(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_aaev_rec IN aaev_rec_type,
187: x_aaev_rec OUT NOCOPY aaev_rec_type);
188:
189: PROCEDURE lock_act_atts(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_aaev_tbl IN aaev_tbl_type);
195: p_aaev_tbl IN aaev_tbl_type);
196:
197: PROCEDURE lock_act_atts(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_aaev_rec IN aaev_rec_type);
203: p_aaev_rec IN aaev_rec_type);
204:
205: PROCEDURE update_act_atts(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_aaev_tbl IN aaev_tbl_type,
212: x_aaev_tbl OUT NOCOPY aaev_tbl_type);
213:
214: PROCEDURE update_act_atts(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_aaev_rec IN aaev_rec_type,
221: x_aaev_rec OUT NOCOPY aaev_rec_type);
222:
223: PROCEDURE delete_act_atts(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_aaev_tbl IN aaev_tbl_type);
229: p_aaev_tbl IN aaev_tbl_type);
230:
231: PROCEDURE delete_act_atts(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_aaev_rec IN aaev_rec_type);
237: p_aaev_rec IN aaev_rec_type);
238:
239: PROCEDURE validate_act_atts(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_aaev_tbl IN aaev_tbl_type);
245: p_aaev_tbl IN aaev_tbl_type);
246:
247: PROCEDURE validate_act_atts(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_aaev_rec IN aaev_rec_type);