372: CURSOR cur_user(p_user_id number)
373: is select fnd.user_name from okx_resources_v res, fnd_user fnd
374: where fnd.user_id=res.user_id and res.id1=p_user_id;
375:
376: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;
377: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;
378:
379: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
380: l_renew_in_parameters_rec renew_in_parameters_rec := p_renew_in_parameters_rec;
373: is select fnd.user_name from okx_resources_v res, fnd_user fnd
374: where fnd.user_id=res.user_id and res.id1=p_user_id;
375:
376: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;
377: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;
378:
379: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
380: l_renew_in_parameters_rec renew_in_parameters_rec := p_renew_in_parameters_rec;
381: lx_renew_in_parameters_rec renew_in_parameters_rec ;