APPS.OKL_CASH_APPL_RULES dependencies on AR_CASH_RECEIPTS

Line 65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL

61: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
62: ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
63: ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
64: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL
69: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL

Line 69: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL

65: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
66: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
67: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
68: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL
69: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
70: ,p_create_receipt_flag IN VARCHAR2
71: ) IS
72:
73: ---------------------------

Line 78: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;

74: -- DECLARE Local Variables
75: ---------------------------
76:
77: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_customer_id;
78: l_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT p_customer_num;
79:
80: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT p_cons_bill_id;
81: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT p_cons_bill_num;
82: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT p_contract_id;

Line 108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;

104: l_rcpt_amount_orig OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_rcpt_amount;
105: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;
109:
110: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
111: l_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT p_bank_account_id;
112: l_receivables_invoice_num NUMBER DEFAULT NULL;

Line 110: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

106: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_date);
107: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
108: l_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT p_comments;
109:
110: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
111: l_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT p_bank_account_id;
112: l_receivables_invoice_num NUMBER DEFAULT NULL;
113:
114: l_over_pay VARCHAR(1) DEFAULT NULL;

Line 2232: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE;

2228: l_return_status VARCHAR2(1);
2229: l_msg_count NUMBER;
2230: l_msg_data VARCHAR2(2000);
2231: l_api_name CONSTANT VARCHAR2(30) := 'create_manual_receipt';
2232: l_cash_receipt_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE;
2233:
2234:
2235: l_rcpt_rec rcpt_rec_type := p_rcpt_rec;
2236:

Line 2244: FROM AR_CASH_RECEIPTS

2240: ,cp_check_num IN VARCHAR2
2241: ,cp_receipt_date IN DATE
2242: ) IS
2243: SELECT '1'
2244: FROM AR_CASH_RECEIPTS
2245: WHERE PAY_FROM_CUSTOMER = cp_customer_id
2246: AND receipt_number = cp_check_num
2247: AND TRUNC(RECEIPT_DATE) = TRUNC(cp_receipt_date);
2248: