[Home] [Help]
PACKAGE: APPS.OKL_CASH_APPL_RULES_PUB
Source
1 PACKAGE OKL_CASH_APPL_RULES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPCAPS.pls 120.10 2008/02/29 10:48:47 asawanka ship $ */
3
4
5
6 ------------------------------------------------------------------------------
7 -- Global Variables
8 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_ALLCTN_RLS_PUB';
9 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13 ------------------------------------------------------------------------------
14 --Global Exception
15 ------------------------------------------------------------------------------
16 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
17
18 ------------------------------------------------------------------------------
19
20
21
22 PROCEDURE okl_cash_applic ( p_api_version IN NUMBER
23 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
28 ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
29 ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
30 ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
31 ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
32 ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
33 ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
34 ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
35 ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
36 ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
37 ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
38 ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
39 ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
40 ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
41 ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
42 ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE
43 ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
44 ,p_create_receipt_flag IN VARCHAR2
45 );
46
47 PROCEDURE create_manual_receipt ( p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
53 ,p_ar_inv_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL
54 ,p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE DEFAULT NULL
55 ,p_rcpt_rec IN OKL_CASH_APPL_RULES.rcpt_rec_type
56 ,x_cash_receipt_id OUT NOCOPY NUMBER
57 );
58
59
60 END Okl_Cash_Appl_Rules_Pub;