DBA Data[Home] [Help]

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 1679: l_contract_number okc_k_headers_all_b.contract_number%TYPE;

1675:
1676: l_currency_code ar_cash_receipts.currency_code%TYPE:= p_rcpt_rec.currency_code;
1677: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1678: l_org_id NUMBER:= p_rcpt_rec.org_id;
1679: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1680: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1681: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1682: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1683:

Line 1726: FROM OKC_K_HEADERS_ALL_B

1722: CURSOR c_cont_num( cp_contract_id IN NUMBER
1723: ,cp_org_id IN NUMBER
1724: ) IS
1725: SELECT contract_number
1726: FROM OKC_K_HEADERS_ALL_B
1727: WHERE id = cp_contract_id
1728: AND org_id = cp_org_id;
1729:
1730: CURSOR c_cons_inv_num( cp_con_inv_id IN NUMBER