238:
239:
240: If l_clev_tbl_in.count > 0 Then
241:
242: okc_cle_pvt.Insert_Row(
243: p_api_version => l_api_version,
244: p_init_msg_list => l_init_msg_list,
245: x_return_status => l_return_status ,
246: x_msg_count => l_msg_count,
250:
251: dbms_output.put_line('Value of l_return_status='||l_return_status);
252: End If;
253: ELSE
254: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
255:
256: END IF;
257:
258: -- l_clev_tbl_in.delete;
3026:
3027:
3028:
3029: If l_clev_tbl_in.count > 0 Then
3030: l_error_message := 'okc_cle_pvt -';
3031: okc_cle_pvt.Insert_Row(
3032: p_api_version => l_api_version,
3033: p_init_msg_list => l_init_msg_list,
3034: x_return_status => l_return_status ,
3027:
3028:
3029: If l_clev_tbl_in.count > 0 Then
3030: l_error_message := 'okc_cle_pvt -';
3031: okc_cle_pvt.Insert_Row(
3032: p_api_version => l_api_version,
3033: p_init_msg_list => l_init_msg_list,
3034: x_return_status => l_return_status ,
3035: x_msg_count => l_msg_count,
3221: IF L_validate_flag = 'N' THEN
3222:
3223: IF l_Clev_tbl_in.COUNT>0
3224: THEN
3225: l_error_message := 'okc_cle_pvt -';
3226: -- dbms_output.put_line('In Sert');
3227: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
3228: END IF;
3229: l_Clev_tbl_in.DELETE;
3223: IF l_Clev_tbl_in.COUNT>0
3224: THEN
3225: l_error_message := 'okc_cle_pvt -';
3226: -- dbms_output.put_line('In Sert');
3227: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
3228: END IF;
3229: l_Clev_tbl_in.DELETE;
3230:
3231: IF l_Cimv_tbl_in.COUNT>0
3685: end if;
3686:
3687: If l_validate_flag = 'Y' THEN
3688: IF l_Clev_tbl_in.COUNT>0 THEN
3689: l_Error_Message := 'okc_cle_pvt';
3690: okc_cle_pvt.Insert_Row(
3691: p_api_version => l_api_version,
3692: p_init_msg_list => l_init_msg_list,
3693: x_return_status => l_return_status ,
3686:
3687: If l_validate_flag = 'Y' THEN
3688: IF l_Clev_tbl_in.COUNT>0 THEN
3689: l_Error_Message := 'okc_cle_pvt';
3690: okc_cle_pvt.Insert_Row(
3691: p_api_version => l_api_version,
3692: p_init_msg_list => l_init_msg_list,
3693: x_return_status => l_return_status ,
3694: x_msg_count => l_msg_count,
3740:
3741: if l_validate_flag = 'N' THEN
3742:
3743: IF l_Clev_tbl_in.COUNT>0 THEN
3744: l_Error_Message := 'okc_cle_pvt';
3745: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
3746: END IF;
3747:
3748: IF l_rgpv_tbl_in.COUNT>0 THEN
3741: if l_validate_flag = 'N' THEN
3742:
3743: IF l_Clev_tbl_in.COUNT>0 THEN
3744: l_Error_Message := 'okc_cle_pvt';
3745: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
3746: END IF;
3747:
3748: IF l_rgpv_tbl_in.COUNT>0 THEN
3749: l_Error_Message := 'okc_rgp_pvt';
4113: end loop;
4114: end if;
4115: IF l_validate_flag = 'Y' THEN
4116: IF l_Clev_tbl_in.COUNT>0 THEN
4117: l_Error_Message := 'okc_cle_pvt';
4118: okc_cle_pvt.Insert_Row(
4119: p_api_version => l_api_version,
4120: p_init_msg_list => l_init_msg_list,
4121: x_return_status => l_return_status ,
4114: end if;
4115: IF l_validate_flag = 'Y' THEN
4116: IF l_Clev_tbl_in.COUNT>0 THEN
4117: l_Error_Message := 'okc_cle_pvt';
4118: okc_cle_pvt.Insert_Row(
4119: p_api_version => l_api_version,
4120: p_init_msg_list => l_init_msg_list,
4121: x_return_status => l_return_status ,
4122: x_msg_count => l_msg_count,
4155:
4156: IF l_validate_flag = 'N' THEN
4157:
4158: IF l_Clev_tbl_in.COUNT>0 THEN
4159: l_error_message := 'okc_cle_pvt -';
4160: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
4161: END IF;
4162: l_Clev_tbl_in.DELETE;
4163:
4156: IF l_validate_flag = 'N' THEN
4157:
4158: IF l_Clev_tbl_in.COUNT>0 THEN
4159: l_error_message := 'okc_cle_pvt -';
4160: okc_cle_pvt.Insert_Row_Upg( l_return_status , l_clev_tbl_in);
4161: END IF;
4162: l_Clev_tbl_in.DELETE;
4163:
4164: