4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: PROCEDURE add_language IS
7: BEGIN
8: okc_scs_pvt.add_language;
9: END;
10:
11: PROCEDURE create_subclass(
12: p_api_version IN NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,
17: p_scsv_rec IN scsv_rec_type,
18: x_scsv_rec OUT NOCOPY scsv_rec_type) IS
19: BEGIN
20: okc_scs_pvt.insert_row(
21: p_api_version,
22: p_init_msg_list,
23: x_return_status,
24: x_msg_count,
35: x_msg_data OUT NOCOPY VARCHAR2,
36: p_scsv_tbl IN scsv_tbl_type,
37: x_scsv_tbl OUT NOCOPY scsv_tbl_type) IS
38: BEGIN
39: okc_scs_pvt.insert_row(
40: p_api_version,
41: p_init_msg_list,
42: x_return_status,
43: x_msg_count,
55: x_msg_data OUT NOCOPY VARCHAR2,
56: p_scsv_rec IN scsv_rec_type,
57: x_scsv_rec OUT NOCOPY scsv_rec_type) IS
58: BEGIN
59: okc_scs_pvt.update_row(
60: p_api_version,
61: p_init_msg_list,
62: x_return_status,
63: x_msg_count,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_scsv_tbl IN scsv_tbl_type,
77: x_scsv_tbl OUT NOCOPY scsv_tbl_type) IS
78: BEGIN
79: okc_scs_pvt.update_row(
80: p_api_version,
81: p_init_msg_list,
82: x_return_status,
83: x_msg_count,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_scsv_rec IN scsv_rec_type) IS
96: BEGIN
97: okc_scs_pvt.delete_row(
98: p_api_version,
99: p_init_msg_list,
100: x_return_status,
101: x_msg_count,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_scsv_tbl IN scsv_tbl_type) IS
113: BEGIN
114: okc_scs_pvt.delete_row(
115: p_api_version,
116: p_init_msg_list,
117: x_return_status,
118: x_msg_count,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_scsv_rec IN scsv_rec_type) IS
130: BEGIN
131: okc_scs_pvt.lock_row(
132: p_api_version,
133: p_init_msg_list,
134: x_return_status,
135: x_msg_count,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_scsv_tbl IN scsv_tbl_type) IS
147: BEGIN
148: okc_scs_pvt.lock_row(
149: p_api_version,
150: p_init_msg_list,
151: x_return_status,
152: x_msg_count,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_scsv_rec IN scsv_rec_type) IS
164: BEGIN
165: okc_scs_pvt.validate_row(
166: p_api_version,
167: p_init_msg_list,
168: x_return_status,
169: x_msg_count,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_scsv_tbl IN scsv_tbl_type) IS
181: BEGIN
182: okc_scs_pvt.validate_row(
183: p_api_version,
184: p_init_msg_list,
185: x_return_status,
186: x_msg_count,