86: END IF;
87:
88: --------------------Start of API Body-----------------------------------
89: IF p_x_space_rec.operation_flag = 'C' THEN
90: AHL_APPR_SPACE_CAPB_PVT.CREATE_SPACE
91: (
92: p_api_version => l_api_version,
93: p_init_msg_list => p_init_msg_list,
94: p_commit => p_commit,
103: ELSIF p_x_space_capbl_tbl.COUNT > 0 THEN
104: FOR i IN p_x_space_capbl_tbl.first..p_x_space_capbl_tbl.LAST
105: LOOP
106: IF p_x_space_capbl_tbl(i).operation_flag = 'C' THEN
107: AHL_APPR_SPACE_CAPB_PVT.CREATE_SPACE_CAPBLTS
108: (
109: p_api_version => l_api_version,
110: p_init_msg_list => p_init_msg_list,
111: p_commit => p_commit,
136: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_code);
137: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_mean);
138: END IF;
139:
140: AHL_APPR_SPACE_CAPB_PVT.UPDATE_SPACE
141: (
142: p_api_version => l_api_version,
143: p_init_msg_list => p_init_msg_list,
144: p_commit => p_commit,
153: ELSIF p_x_space_capbl_tbl.COUNT > 0 THEN
154: FOR i IN p_x_space_capbl_tbl.first..p_x_space_capbl_tbl.LAST
155: LOOP
156: IF p_x_space_capbl_tbl(i).operation_flag = 'U' THEN
157: AHL_APPR_SPACE_CAPB_PVT.UPDATE_SPACE_CAPBLTS
158: (
159: p_api_version => l_api_version,
160: p_init_msg_list => p_init_msg_list,
161: p_commit => p_commit,
182: END IF;
183:
184: --For Delet
185: ELSIF p_x_space_rec.operation_flag = 'D' THEN
186: AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE
187: (
188: p_api_version => l_api_version,
189: p_init_msg_list => p_init_msg_list,
190: p_commit => p_commit,
202: ELSIF p_x_space_capbl_tbl.COUNT > 0 THEN
203: FOR i IN p_x_space_capbl_tbl.first..p_x_space_capbl_tbl.LAST
204: LOOP
205: IF p_x_space_capbl_tbl(i).operation_flag = 'D' THEN
206: AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE_CAPBLTS
207: (
208: p_api_version => l_api_version,
209: p_init_msg_list => p_init_msg_list,
210: p_commit => p_commit,
239: AHL_DEBUG_PUB.debug( 'inside pub delete capb'||p_x_space_capbl_tbl(i).operation_flag);
240: END IF;
241:
242: IF p_x_space_capbl_tbl(i).operation_flag = 'D' THEN
243: AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE_CAPBLTS
244: (
245: p_api_version => l_api_version,
246: p_init_msg_list => p_init_msg_list,
247: p_commit => p_commit,