APPS.OKC_RENEW_PVT dependencies on OKC_RULES_V

Line 813: okc_rules_v ru,okc_rule_groups_b rg

809:
810: CURSOR cur_rules(p_chr_id number) is
811: SELECT nvl(rg.cle_id,rg.chr_id) parent_ID,ru.id id,ru.object_version_number,
812: ru.comments,ru.rule_information_category from
813: okc_rules_v ru,okc_rule_groups_b rg
814: WHERE rgp_id=rg.id and rg.DNZ_CHR_ID = p_chr_id for update of ru.id nowait;
815:
816: CURSOR cur_ia(p_tve_id number) is
817: SELECT start_date ,end_date FROM okc_time_ia_startend_val_v

Line 1704: l_cle_renew_type OKC_RULES_V.rule_information1%type;

1700: l_parent_end_date date;
1701: l_parent_start_date date;
1702: l_parent_level number;
1703: l_DNR_LEVEL number:=0;
1704: l_cle_renew_type OKC_RULES_V.rule_information1%type;
1705: l_cle_tbl okc_contract_pub.clev_tbl_type;
1706: l_cle BINARY_INTEGER:=0;
1707: j BINARY_INTEGER;
1708:

Line 1715: lrt_type okc_rules_v.rule_information_category%TYPE:=OKC_API.G_MISS_CHAR

1711: ID NUMBER:=OKC_API.G_MISS_NUM,
1712: orig_start_date DATE:=OKC_API.G_MISS_DATE,
1713: start_date DATE:=OKC_API.G_MISS_DATE,
1714: end_date DATE:=OKC_API.G_MISS_DATE,
1715: lrt_type okc_rules_v.rule_information_category%TYPE:=OKC_API.G_MISS_CHAR
1716: );
1717:
1718: TYPE CLE_PARENT_TBL_TYPE IS TABLE OF CLE_PARENT_REC_TYPE
1719: INDEX BY BINARY_INTEGER;

Line 1760: l_return OKC_RULES_V.rule_information1%type:=g_def_cle_ren;

1756: return l_rec;
1757: END;
1758:
1759: Function get_cle_renew_type(p_comp_id number) Return varchar2 is
1760: l_return OKC_RULES_V.rule_information1%type:=g_def_cle_ren;
1761: i BINARY_INTEGER;
1762: l_rule okc_rules_v.rule_information1%type;
1763: l_api_name Varchar2(30) := 'get_cle_renew_type';
1764: Begin

Line 1762: l_rule okc_rules_v.rule_information1%type;

1758:
1759: Function get_cle_renew_type(p_comp_id number) Return varchar2 is
1760: l_return OKC_RULES_V.rule_information1%type:=g_def_cle_ren;
1761: i BINARY_INTEGER;
1762: l_rule okc_rules_v.rule_information1%type;
1763: l_api_name Varchar2(30) := 'get_cle_renew_type';
1764: Begin
1765:
1766: IF (l_debug = 'Y') THEN

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

2484: l_estimated_amount number;
2485: --l_wf_msg_tbl okc_async_pvt.par_tbl_typ;
2486: l_pdf_id number :=OKC_API.G_MISS_NUM;
2487: rule_rec cur_rules%rowtype;
2488: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;
2489: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;
2490: l_qcl_id number;
2491: l_msg_tbl OKC_QA_CHECK_PUB.MSG_TBL_TYPE;
2492: i BINARY_INTEGER;

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

2485: --l_wf_msg_tbl okc_async_pvt.par_tbl_typ;
2486: l_pdf_id number :=OKC_API.G_MISS_NUM;
2487: rule_rec cur_rules%rowtype;
2488: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;
2489: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;
2490: l_qcl_id number;
2491: l_msg_tbl OKC_QA_CHECK_PUB.MSG_TBL_TYPE;
2492: i BINARY_INTEGER;
2493: l_max_severity varchar2(1):='I';

Line 2998: l_ren_type okc_rules_v.rule_information1%type;

2994: ) is
2995:
2996: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
2997: l_renew_in_parameters_rec renew_in_parameters_rec := p_renew_in_parameters_rec;
2998: l_ren_type okc_rules_v.rule_information1%type;
2999: l_ultimate_end_date Date;
3000:
3001: l_api_name constant VARCHAR2(30) := 'CREATE_RENEWD_CONTRACT';
3002: