APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 341: FROM okc_k_headers_b chrb

337: AND TO_NUMBER(rle.object1_id1) = ban.party_id);
338:
339: Cursor contract_status_csr(p_contract_id NUMBER) IS
340: SELECT sts_code
341: FROM okc_k_headers_b chrb
342: WHERE chrb.id = p_contract_id
343: AND chrb.scs_code = 'LEASE'
344: AND chrb.sts_code in ('BOOKED', 'EVERGREEN', 'EXPIRED', 'TERMINATED', 'REVERSED', 'ABANDONED');
345:

Line 383: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;

379: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
380: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
381: l_txn_type FND_LOOKUPS.meaning%TYPE;
382: l_bankruptcy_status VARCHAR2(1);
383: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;
384: l_billing_invoice_status VARCHAR2(1) := '?';
385: l_advance_receipt_status VARCHAR2(1) := '?';
386:
387: begin

Line 774: UPDATE okc_k_headers_b

770: End loop;
771: -- Added for bug #5944260/5981076(Forward R12 cklee) -- End
772: -- Update the status of the header
773: -- Bug# 7631183: Set datetime_cancelled to SYSDATE
774: UPDATE okc_k_headers_b
775: SET sts_code = 'ABANDONED',
776: contract_number = l_new_contract_number,
777: datetime_cancelled = SYSDATE
778: WHERE id = p_contract_id;