DBA Data[Home] [Help]

APPS.OKC_RENEW_PUB dependencies on OKC_RULES_V

Line 376: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;

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;

Line 377: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;

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 ;