3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: PROCEDURE add_language IS
6: BEGIN
7: okc_operation_pvt.add_language;
8: END;
9:
10: PROCEDURE insert_operation(
11: p_api_version IN NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,
16: p_opnv_rec IN opnv_rec_type,
17: x_opnv_rec OUT NOCOPY opnv_rec_type) IS
18: BEGIN
19: okc_operation_pvt.insert_operation(
20: p_api_version,
21: p_init_msg_list,
22: x_return_status,
23: x_msg_count,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_opnv_tbl IN opnv_tbl_type,
36: x_opnv_tbl OUT NOCOPY opnv_tbl_type) IS
37: BEGIN
38: okc_operation_pvt.insert_operation(
39: p_api_version,
40: p_init_msg_list,
41: x_return_status,
42: x_msg_count,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_opnv_rec IN opnv_rec_type) IS
55: BEGIN
56: okc_operation_pvt.lock_operation(
57: p_api_version,
58: p_init_msg_list,
59: x_return_status,
60: x_msg_count,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
71: p_opnv_tbl IN opnv_tbl_type) IS
72: BEGIN
73: okc_operation_pvt.lock_operation(
74: p_api_version,
75: p_init_msg_list,
76: x_return_status,
77: x_msg_count,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_opnv_rec IN opnv_rec_type,
89: x_opnv_rec OUT NOCOPY opnv_rec_type) IS
90: BEGIN
91: okc_operation_pvt.update_operation(
92: p_api_version,
93: p_init_msg_list,
94: x_return_status,
95: x_msg_count,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_opnv_tbl IN opnv_tbl_type,
108: x_opnv_tbl OUT NOCOPY opnv_tbl_type) IS
109: BEGIN
110: okc_operation_pvt.update_operation(
111: p_api_version,
112: p_init_msg_list,
113: x_return_status,
114: x_msg_count,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_opnv_rec IN opnv_rec_type) IS
127: BEGIN
128: okc_operation_pvt.delete_operation(
129: p_api_version,
130: p_init_msg_list,
131: x_return_status,
132: x_msg_count,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_opnv_tbl IN opnv_tbl_type) IS
144: BEGIN
145: okc_operation_pvt.delete_operation(
146: p_api_version,
147: p_init_msg_list,
148: x_return_status,
149: x_msg_count,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_opnv_rec IN opnv_rec_type) IS
161: BEGIN
162: okc_operation_pvt.validate_operation(
163: p_api_version,
164: p_init_msg_list,
165: x_return_status,
166: x_msg_count,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_opnv_tbl IN opnv_tbl_type) IS
178: BEGIN
179: okc_operation_pvt.validate_operation(
180: p_api_version,
181: p_init_msg_list,
182: x_return_status,
183: x_msg_count,