DBA Data[Home] [Help]

APPS.OKC_TERMINATE_PVT dependencies on OKC_SUBCLASSES_V

Line 638: l_scs_code okc_subclasses_v.code%type;

634: AND cnh.id = co.cnh_id (+);
635:
636: l_lse_id number;
637: l_cnh_terminate_date DATE;
638: l_scs_code okc_subclasses_v.code%type;
639: l_cls_code okc_subclasses_v.cls_code%type;
640: l_k_status_code okc_k_headers_v.sts_code%type;
641: l_estimated_amount number;
642: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 639: l_cls_code okc_subclasses_v.cls_code%type;

635:
636: l_lse_id number;
637: l_cnh_terminate_date DATE;
638: l_scs_code okc_subclasses_v.code%type;
639: l_cls_code okc_subclasses_v.cls_code%type;
640: l_k_status_code okc_k_headers_v.sts_code%type;
641: l_estimated_amount number;
642: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
643:

Line 1404: l_scs_code okc_subclasses_v.code%type;

1400: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;
1401: l_contract_number okc_k_headers_v.contract_number%type;
1402: l_kl_sts_code okc_k_lines_v.sts_code%type;
1403:
1404: l_scs_code okc_subclasses_v.code%type;
1405: l_cls_code okc_subclasses_v.cls_code%type;
1406: l_price_negotiated number;
1407:
1408: CURSOR cur_lines is

Line 1405: l_cls_code okc_subclasses_v.cls_code%type;

1401: l_contract_number okc_k_headers_v.contract_number%type;
1402: l_kl_sts_code okc_k_lines_v.sts_code%type;
1403:
1404: l_scs_code okc_subclasses_v.code%type;
1405: l_cls_code okc_subclasses_v.cls_code%type;
1406: l_price_negotiated number;
1407:
1408: CURSOR cur_lines is
1409: SELECT id,object_version_number,sts_code,lse_id,start_date,end_date