DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES dependencies on AR_CASH_RECEIPTS_ALL

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;