APPS.OKL_RECEIPTS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 902: p_contract_id IN okc_k_headers_all_b.id%TYPE DEFAULT NULL,

898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_cons_bill_id IN okl_cnsld_ar_hdrs_v.id%TYPE DEFAULT NULL,
901: p_ar_inv_id IN NUMBER DEFAULT NULL,
902: p_contract_id IN okc_k_headers_all_b.id%TYPE DEFAULT NULL,
903: p_rcpt_rec IN RCPT_REC_TYPE,
904: x_cash_receipt_id OUT NOCOPY NUMBER)
905: IS
906: l_api_version NUMBER := 1.0;

Line 1622: l_contract_number okc_k_headers_all_b.contract_number%TYPE;

1618:
1619: l_currency_code ar_cash_receipts.currency_code%TYPE:= p_rcpt_rec.currency_code;
1620: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1621: l_org_id NUMBER:= p_rcpt_rec.org_id;
1622: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1623: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1624: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1625: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1626:

Line 1669: FROM OKC_K_HEADERS_ALL_B

1665: CURSOR c_cont_num( cp_contract_id IN NUMBER
1666: ,cp_org_id IN NUMBER
1667: ) IS
1668: SELECT contract_number
1669: FROM OKC_K_HEADERS_ALL_B
1670: WHERE id = cp_contract_id
1671: AND org_id = cp_org_id;
1672:
1673: CURSOR c_cons_inv_num( cp_con_inv_id IN NUMBER