DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES dependencies on OKL_CNSLD_AR_HDRS_V

Line 53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL

49: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
50: ,x_return_status OUT NOCOPY VARCHAR2
51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL

Line 54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL

50: ,x_return_status OUT NOCOPY VARCHAR2
51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
54: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
55: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
56: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
57: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
58: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL

Line 80: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT p_cons_bill_id;

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;
83: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
84: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;

Line 81: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT p_cons_bill_num;

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;
83: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
84: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT p_contract_num;
85: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;

Line 2199: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL

2195: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2196: ,x_return_status OUT NOCOPY VARCHAR2
2197: ,x_msg_count OUT NOCOPY NUMBER
2198: ,x_msg_data OUT NOCOPY VARCHAR2
2199: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
2200: ,p_ar_inv_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL
2201: ,p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE DEFAULT NULL
2202: ,p_rcpt_rec IN rcpt_rec_type
2203: ,x_cash_receipt_id OUT NOCOPY NUMBER