[Home] [Help]
PACKAGE: APPS.OKL_RECEIPTS_PVT
Source
1 PACKAGE OKL_RECEIPTS_PVT AS
2 /* $Header: OKLRRCTS.pls 120.9 2008/05/14 11:51:24 sosharma noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 ---------------------------------------------------------------------------
7 -- GLOBAL VARIABLES
8 ---------------------------------------------------------------------------
9
10 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
11
12 g_unexpected_error CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
13
14 g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
15
16 g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
17
18 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_RECEIPTS_PVT';
19
20 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
21
22 g_parent_table_token CONSTANT VARCHAR2(200) := okl_api.g_parent_table_token;
23
24 g_child_table_token CONSTANT VARCHAR2(200) := okl_api.g_child_table_token;
25
26 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
27
28 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
29
30 g_required_value CONSTANT VARCHAR2(200) := okl_api.g_required_value;
31
32 g_exception_halt_validation EXCEPTION;
33 ---------------------------------------------------------------------------
34 -- Procedures and Functions
35 ---------------------------------------------------------------------------
36 ---------------------------------------------------------------------------
37 -- GLOBAL DATASTRUCTURES
38 ---------------------------------------------------------------------------
39
40 TYPE rcpt_rec_type IS RECORD(cash_receipt_id NUMBER := okl_api.g_miss_num,
41 amount NUMBER := okl_api.g_miss_num,
42 currency_code ar_cash_receipts.currency_code%TYPE := okl_api.g_miss_char,
43 customer_number hz_cust_accounts.account_number%TYPE := okl_api.g_miss_char,
44 customer_id NUMBER := okl_api.g_miss_num,
45 receipt_number ar_cash_receipts.receipt_number%TYPE := okl_api.g_miss_char,
46 receipt_date ar_cash_receipts.receipt_date%TYPE := okl_api.g_miss_date,
47 exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE := okl_api.g_miss_char,
48 exchange_rate NUMBER := okl_api.g_miss_num,
49 exchange_date ar_cash_receipts.exchange_date%TYPE := okl_api.g_miss_date,
50 remittance_bank_account_id NUMBER := okl_api.g_miss_num,
51 customer_bank_account_id NUMBER := okl_api.g_miss_num,
52 remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE := okl_api.g_miss_char,
53 remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE := okl_api.g_miss_char,
54 payment_trx_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE,
55 receipt_method_id NUMBER := okl_api.g_miss_num,
56 org_id NUMBER := okl_api.g_miss_num,
57 gl_date DATE := okl_api.g_miss_date,
58 dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
59 dff_attribute1 ar_cash_receipts.attribute1%TYPE,
60 dff_attribute2 ar_cash_receipts.attribute2%TYPE,
61 dff_attribute3 ar_cash_receipts.attribute3%TYPE,
62 dff_attribute4 ar_cash_receipts.attribute4%TYPE,
63 dff_attribute5 ar_cash_receipts.attribute5%TYPE,
64 dff_attribute6 ar_cash_receipts.attribute6%TYPE,
65 dff_attribute7 ar_cash_receipts.attribute7%TYPE,
66 dff_attribute8 ar_cash_receipts.attribute8%TYPE,
67 dff_attribute9 ar_cash_receipts.attribute9%TYPE,
68 dff_attribute10 ar_cash_receipts.attribute10%TYPE,
69 dff_attribute11 ar_cash_receipts.attribute11%TYPE,
70 dff_attribute12 ar_cash_receipts.attribute12%TYPE,
71 dff_attribute13 ar_cash_receipts.attribute13%TYPE,
72 dff_attribute14 ar_cash_receipts.attribute14%TYPE,
73 dff_attribute15 ar_cash_receipts.attribute15%TYPE,
74 create_mode VARCHAR2(30), -- can take values 'UNAPPLIED', 'UNIDENTIFIED', 'ONACCOUNT', 'APPLIED'
75 p_original_onacc_amount NUMBER := okl_api.g_miss_num, -- should be zero if this is new receipt or new application
76 p_apply_onacc_amount NUMBER := okl_api.g_miss_num
77 );
78
79 TYPE appl_rec_type IS RECORD(contract_id okc_k_headers_all_b.id%TYPE,
80 con_inv_id okl_cnsld_ar_hdrs_all_b.id%TYPE,
81 ar_inv_id NUMBER,
82 line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
83 original_applied_amount NUMBER, -- should be zero if this is new receipt or new application
84 line_type VARCHAR2(30) DEFAULT 'LINE',
85 amount_to_apply NUMBER DEFAULT NULL,
86 gl_date DATE,
87 line_applied NUMBER,
88 tax_applied NUMBER,
89 trans_to_receipt_rate NUMBER,
90 amount_applied_from NUMBER DEFAULT NULL);
91
92 TYPE appl_tbl_type IS TABLE OF APPL_REC_TYPE INDEX BY BINARY_INTEGER ;
93
94
95 PROCEDURE handle_receipt
96 (p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_rcpt_rec IN RCPT_REC_TYPE,
102 p_appl_tbl IN APPL_TBL_TYPE,
103 x_cash_receipt_id OUT NOCOPY NUMBER);
104
105 FUNCTION cross_currency_rate_type
106 (p_org_id IN NUMBER)
107 RETURN VARCHAR2;
108
109 END okl_receipts_pvt;