[Home] [Help]
PACKAGE: APPS.OKL_CASH_APPL_RULES
Source
1 PACKAGE OKL_CASH_APPL_RULES AUTHID CURRENT_USER AS
2 /* $Header: OKLRCAPS.pls 120.5 2007/08/02 15:50:10 nikshah ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10
11 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
12 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15
16 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CASH_APPL_RULES';
17 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
19 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
20 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
21 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
23 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24
25 ---------------------------------------------------------------------------
26 -- Procedures and Functions
27 ---------------------------------------------------------------------------
28
29 ---------------------------------------------------------------------------
30 -- GLOBAL DATASTRUCTURES
31 ---------------------------------------------------------------------------
32
33 l_xcav_tbl Okl_Xca_Pvt.xcav_tbl_type;
34 l_initialize Okl_Xca_Pvt.xcav_tbl_type;
35
36 TYPE rcpt_rec_type IS RECORD (
37 CASH_RECEIPT_ID NUMBER := OKL_API.G_MISS_NUM,
38 AMOUNT NUMBER := OKL_API.G_MISS_NUM,
39 CURRENCY_CODE AR_CASH_RECEIPTS.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40 CUSTOMER_NUMBER HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
41 CUSTOMER_ID NUMBER := OKL_API.G_MISS_NUM,
42 RECEIPT_NUMBER AR_CASH_RECEIPTS.RECEIPT_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
43 RECEIPT_DATE AR_CASH_RECEIPTS.RECEIPT_DATE%TYPE := OKL_API.G_MISS_DATE,
44 EXCHANGE_RATE_TYPE AR_CASH_RECEIPTS.EXCHANGE_RATE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
45 EXCHANGE_RATE NUMBER := OKL_API.G_MISS_NUM,
46 EXCHANGE_DATE AR_CASH_RECEIPTS.EXCHANGE_DATE%TYPE := OKL_API.G_MISS_DATE,
47 REMITTANCE_BANK_ACCOUNT_ID NUMBER := OKL_API.G_MISS_NUM,
48 REMITTANCE_BANK_ACCOUNT_NUM CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := OKL_API.G_MISS_CHAR,
49 REMITTANCE_BANK_ACCOUNT_NAME CE_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE := OKL_API.G_MISS_CHAR,
50 PAYMENT_TRX_EXTENSION_ID ar_cash_receipts.payment_trxn_extension_id%TYPE,
51 RECEIPT_METHOD_ID NUMBER := OKL_API.G_MISS_NUM,
52 ORG_ID NUMBER := OKL_API.G_MISS_NUM,
53 GL_DATE DATE := OKL_API.G_MISS_DATE,
54 DFF_ATTRIBUTE_CATEGORY AR_CASH_RECEIPTS.ATTRIBUTE_CATEGORY%TYPE,
55 DFF_ATTRIBUTE1 AR_CASH_RECEIPTS.ATTRIBUTE1%TYPE,
56 DFF_ATTRIBUTE2 AR_CASH_RECEIPTS.ATTRIBUTE2%TYPE,
57 DFF_ATTRIBUTE3 AR_CASH_RECEIPTS.ATTRIBUTE3%TYPE,
58 DFF_ATTRIBUTE4 AR_CASH_RECEIPTS.ATTRIBUTE4%TYPE,
59 DFF_ATTRIBUTE5 AR_CASH_RECEIPTS.ATTRIBUTE5%TYPE,
60 DFF_ATTRIBUTE6 AR_CASH_RECEIPTS.ATTRIBUTE6%TYPE,
61 DFF_ATTRIBUTE7 AR_CASH_RECEIPTS.ATTRIBUTE7%TYPE,
62 DFF_ATTRIBUTE8 AR_CASH_RECEIPTS.ATTRIBUTE8%TYPE,
63 DFF_ATTRIBUTE9 AR_CASH_RECEIPTS.ATTRIBUTE9%TYPE,
64 DFF_ATTRIBUTE10 AR_CASH_RECEIPTS.ATTRIBUTE10%TYPE,
65 DFF_ATTRIBUTE11 AR_CASH_RECEIPTS.ATTRIBUTE11%TYPE,
66 DFF_ATTRIBUTE12 AR_CASH_RECEIPTS.ATTRIBUTE12%TYPE,
67 DFF_ATTRIBUTE13 AR_CASH_RECEIPTS.ATTRIBUTE13%TYPE,
68 DFF_ATTRIBUTE14 AR_CASH_RECEIPTS.ATTRIBUTE14%TYPE,
69 DFF_ATTRIBUTE15 AR_CASH_RECEIPTS.ATTRIBUTE15%TYPE
70 );
71
72 FUNCTION okl_installed (p_org_id IN NUMBER) RETURN BOOLEAN; -- used by lockbox processing.
73
74 PROCEDURE handle_manual_pay ( p_api_version IN NUMBER
75 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
76 ,x_return_status OUT NOCOPY VARCHAR2
77 ,x_msg_count OUT NOCOPY NUMBER
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
80 ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
81 ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
82 ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
83 ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
84 ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
85 ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
86 ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
87 ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
88 ,p_contract_id IN OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL
89 ,p_contract_num IN OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL
90 ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
91 ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
92 ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
93 ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
94 ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL
95 ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
96 ,p_create_receipt_flag IN VARCHAR2
97 );
98
99 PROCEDURE create_manual_receipt ( p_api_version IN NUMBER
100 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2
104 ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
105 ,p_ar_inv_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL
106 ,p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE DEFAULT NULL
107 ,p_rcpt_rec IN rcpt_rec_type
108 ,x_cash_receipt_id OUT NOCOPY NUMBER
109 );
110
111
112 END Okl_Cash_Appl_Rules;