APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 45: FROM okc_k_headers_b chrb

41: AND TO_NUMBER(rle.object1_id1) = ban.party_id);
42:
43: Cursor contract_status_csr(p_contract_id NUMBER) IS
44: SELECT sts_code
45: FROM okc_k_headers_b chrb
46: WHERE chrb.id = p_contract_id
47: AND chrb.scs_code = 'LEASE'
48: AND chrb.sts_code in ('BOOKED', 'EVERGREEN', 'EXPIRED', 'TERMINATED', 'REVERSED', 'ABANDONED');
49:

Line 87: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;

83: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;
84: l_funding_type_code OKL_TRX_AP_INVOICES_B.funding_type_code%TYPE := NULL;
85: l_txn_type FND_LOOKUPS.meaning%TYPE;
86: l_bankruptcy_status VARCHAR2(1);
87: l_status_code OKC_K_HEADERS_B.sts_code%TYPE;
88: l_billing_invoice_status VARCHAR2(1) := '?';
89: l_advance_receipt_status VARCHAR2(1) := '?';
90:
91: begin

Line 478: UPDATE okc_k_headers_b

474: End loop;
475: -- Added for bug #5944260/5981076(Forward R12 cklee) -- End
476: -- Update the status of the header
477: -- Bug# 7631183: Set datetime_cancelled to SYSDATE
478: UPDATE okc_k_headers_b
479: SET sts_code = 'ABANDONED',
480: contract_number = l_new_contract_number,
481: datetime_cancelled = SYSDATE
482: WHERE id = p_contract_id;