APPS.OKC_TERMINATE_PVT dependencies on OKC_K_HEADERS_V

Line 341: l_k_num okc_k_headers_v.contract_number%type;

337: and a.object_chr_id=p_chr_id and
338: c.id=b.cop_id and c.opn_code='RENEWAL'
339: and b.id=a.oie_id and a.active_yn='Y' and
340: a.subject_cle_id is null and a.object_cle_id is null;
341: l_k_num okc_k_headers_v.contract_number%type;
342: l_k_mod okc_k_headers_v.contract_number_modifier%type;
343:
344: -- Find out which statuses are valid FOR termination to continue
345:

Line 342: l_k_mod okc_k_headers_v.contract_number_modifier%type;

338: c.id=b.cop_id and c.opn_code='RENEWAL'
339: and b.id=a.oie_id and a.active_yn='Y' and
340: a.subject_cle_id is null and a.object_cle_id is null;
341: l_k_num okc_k_headers_v.contract_number%type;
342: l_k_mod okc_k_headers_v.contract_number_modifier%type;
343:
344: -- Find out which statuses are valid FOR termination to continue
345:
346: l_chg_request_in_process varchar2(1);

Line 530: FROM okc_k_headers_v

526: CURSOR cur_k_header is
527: SELECT ID,
528: OBJECT_VERSION_NUMBER,
529: sts_code
530: FROM okc_k_headers_v
531: WHERE id = p_terminate_in_parameters_rec.p_contract_id
532: for update of object_version_number nowait;
533:
534: -- Will not need object_version_number this termination is an adverse step. Even if there

Line 640: l_k_status_code okc_k_headers_v.sts_code%type;

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:
644: l_api_name constant varchar2(30) := 'terminate_chr';

Line 1189: l_k_num okc_k_headers_v.contract_number%type;

1185: c.id=b.cop_id and c.opn_code='RENEWAL'
1186: and b.id=a.oie_id and a.active_yn='Y' and
1187: a.subject_cle_id is null and a.object_cle_id is null;
1188:
1189: l_k_num okc_k_headers_v.contract_number%type;
1190: l_k_mod okc_k_headers_v.contract_number_modifier%type;
1191: BEGIN
1192:
1193: x_return_status := okc_api.g_ret_sts_success;

Line 1190: l_k_mod okc_k_headers_v.contract_number_modifier%type;

1186: and b.id=a.oie_id and a.active_yn='Y' and
1187: a.subject_cle_id is null and a.object_cle_id is null;
1188:
1189: l_k_num okc_k_headers_v.contract_number%type;
1190: l_k_mod okc_k_headers_v.contract_number_modifier%type;
1191: BEGIN
1192:
1193: x_return_status := okc_api.g_ret_sts_success;
1194:

Line 1400: l_contract_modifier okc_k_headers_v.contract_number_modifier%type;

1396: AND cle.chr_id = k.id
1397: AND cle.id = p_terminate_in_parameters_rec.p_cle_id
1398: AND k.scs_code = scs.code;
1399:
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;

Line 1401: l_contract_number okc_k_headers_v.contract_number%type;

1397: AND cle.id = p_terminate_in_parameters_rec.p_cle_id
1398: AND k.scs_code = scs.code;
1399:
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;