300:
301:
302: If l_rgpv_tbl_in.count > 0 Then
303:
304: okc_rgp_pvt.Insert_Row(
305: p_api_version => l_api_version,
306: p_init_msg_list => l_init_msg_list,
307: x_return_status => l_return_status ,
308: x_msg_count => l_msg_count,
312:
313: dbms_output.put_line('Value of l_return_status='||l_return_status);
314: End If;
315: ELSE
316: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
317:
318: END IF;
319:
320:
3059:
3060:
3061: IF l_rgpv_tbl_in.COUNT>0
3062: THEN
3063: l_error_message := 'okc_rgp_pvt -';
3064: okc_rgp_pvt.Insert_Row(
3065: p_api_version => l_api_version,
3066: p_init_msg_list => l_init_msg_list,
3067: x_return_status => l_return_status ,
3060:
3061: IF l_rgpv_tbl_in.COUNT>0
3062: THEN
3063: l_error_message := 'okc_rgp_pvt -';
3064: okc_rgp_pvt.Insert_Row(
3065: p_api_version => l_api_version,
3066: p_init_msg_list => l_init_msg_list,
3067: x_return_status => l_return_status ,
3068: x_msg_count => l_msg_count,
3237:
3238:
3239: IF l_rgpv_tbl_in.COUNT>0
3240: THEN
3241: l_error_message := 'okc_rgp_pvt -';
3242: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
3243: END IF;
3244: l_rgpv_tbl_in.DELETE;
3245:
3238:
3239: IF l_rgpv_tbl_in.COUNT>0
3240: THEN
3241: l_error_message := 'okc_rgp_pvt -';
3242: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
3243: END IF;
3244: l_rgpv_tbl_in.DELETE;
3245:
3246:
3697: x_clev_tbl => x_clev_tbl_in);
3698: END IF;
3699:
3700: IF l_rgpv_tbl_in.COUNT>0 THEN
3701: l_Error_Message := 'okc_rgp_pvt';
3702: okc_rgp_pvt.Insert_Row(
3703: p_api_version => l_api_version,
3704: p_init_msg_list => l_init_msg_list,
3705: x_return_status => l_return_status ,
3698: END IF;
3699:
3700: IF l_rgpv_tbl_in.COUNT>0 THEN
3701: l_Error_Message := 'okc_rgp_pvt';
3702: okc_rgp_pvt.Insert_Row(
3703: p_api_version => l_api_version,
3704: p_init_msg_list => l_init_msg_list,
3705: x_return_status => l_return_status ,
3706: x_msg_count => l_msg_count,
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';
3750: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
3751: END IF;
3752:
3753: IF l_rulv_tbl_in.COUNT>0 THEN
3746: END IF;
3747:
3748: IF l_rgpv_tbl_in.COUNT>0 THEN
3749: l_Error_Message := 'okc_rgp_pvt';
3750: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
3751: END IF;
3752:
3753: IF l_rulv_tbl_in.COUNT>0 THEN
3754:
4125: x_clev_tbl => x_clev_tbl_in);
4126: END IF;
4127:
4128: IF l_rgpv_tbl_in.COUNT>0 THEN
4129: l_Error_Message := 'okc_rgp_pvt';
4130: okc_rgp_pvt.Insert_Row(
4131: p_api_version => l_api_version,
4132: p_init_msg_list => l_init_msg_list,
4133: x_return_status => l_return_status ,
4126: END IF;
4127:
4128: IF l_rgpv_tbl_in.COUNT>0 THEN
4129: l_Error_Message := 'okc_rgp_pvt';
4130: okc_rgp_pvt.Insert_Row(
4131: p_api_version => l_api_version,
4132: p_init_msg_list => l_init_msg_list,
4133: x_return_status => l_return_status ,
4134: x_msg_count => l_msg_count,
4162: l_Clev_tbl_in.DELETE;
4163:
4164:
4165: IF l_rgpv_tbl_in.COUNT>0 THEN
4166: l_error_message := 'okc_rgp_pvt -';
4167: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
4168: END IF;
4169: l_rgpv_tbl_in.DELETE;
4170:
4163:
4164:
4165: IF l_rgpv_tbl_in.COUNT>0 THEN
4166: l_error_message := 'okc_rgp_pvt -';
4167: okc_rgp_pvt.Insert_Row_Upg( l_return_status , l_rgpv_tbl_in);
4168: END IF;
4169: l_rgpv_tbl_in.DELETE;
4170:
4171: