1 package AR_BR_REMIT_IMPORT_API_PUB AUTHID CURRENT_USER AS
5 * third party system into Receivables. This API validates the passed
2 /* $Header: ARBRIMRS.pls 120.4 2006/06/27 08:36:17 shveeram ship $ */
3 /*#
4 * Remittance Import API allows the user to import a remittance from a
6 * parameters and updates the remittance if it already exists or
7 * creates a new remittance. It also ensures that the bill receivable
8 * is assigned to the correct remittance.
9 * @rep:scope public
10 * @rep:metalink 236938.1 See OracleMetaLink note 236938.1
11 * @rep:product AR
12 * @rep:lifecycle active
13 * @rep:displayname Remittance Import
14 * @rep:category BUSINESS_ENTITY AR_REMITTANCE
15 */
16
17 PROCEDURE Dummy_Remittance (p_reserved_value ar_payment_schedules.reserved_value%TYPE,x_return_status IN OUT NOCOPY VARCHAR2);
18
19 PROCEDURE Check_BR_and_Batch_Status (p_internal_reference IN RA_CUSTOMER_TRX.Customer_trx_id%TYPE,
20 p_reserved_value OUT NOCOPY AR_PAYMENT_SCHEDULES.reserved_value%TYPE,
21 p_payment_schedule_id OUT NOCOPY AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE,
22 p_media_reference OUT NOCOPY AR_BATCHES.media_reference%TYPE);
23
24 PROCEDURE compare_old_versus_new_values (
25 p_media_reference IN ar_batches.media_reference%TYPE,
26 p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
27 p_remittance_method IN ar_batches.remit_method_code%TYPE,
28 p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
29 p_payment_method IN ar_receipt_methods.name%TYPE,
30 p_remittance_date IN ar_batches.batch_date%TYPE,
31 p_Currency_code IN ar_batches.currency_code%TYPE,
32 p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
33 l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
34 l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
35 );
36
37
38 PROCEDURE existing_remittance (
39 p_media_reference IN ar_batches.media_reference%TYPE,
40 p_remittance_accounting_Date IN ar_batches.gl_date%TYPE,
41 p_internal_reference IN ra_customer_trx.customer_trx_id%TYPE,
42 p_remittance_method IN ar_batches.remit_method_code%TYPE,
43 p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
44 p_payment_method IN ar_receipt_methods.name%TYPE,
45 p_remittance_date IN ar_batches.batch_date%TYPE,
46 p_currency_code IN ar_batches.currency_code%TYPE,
47 p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
48 x_return_status IN OUT NOCOPY VARCHAR2
49 );
50
51
52 PROCEDURE new_remittance(
53 p_media_reference IN ar_batches.media_reference%TYPE,
54 p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
55 p_remittance_Date IN ar_batches.batch_date%TYPE,
56 p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
57 p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
58 p_currency_code IN ar_batches.currency_code%TYPE,
59 p_remittance_method IN ar_batches.remit_method_code%TYPE,
60 p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
61 p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
62 p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
63 p_payment_method IN ar_receipt_methods.name%TYPE,
64 x_batch_name OUT NOCOPY ar_batches.name%TYPE,
65 x_return_status IN OUT NOCOPY VARCHAR2
66 );
67
68
69 FUNCTION Remittance_Exists (p_media_reference AR_BATCHES.media_reference%TYPE) return boolean;
70 /*#
71 * Use this procedure to import a remittance and call corresponding
72 * packages to create data. It is the main procedure for the Remittance Import API.
73 * @param p_api_version API version
74 * @param p_init_msg_list Initialization of the message list
75 * @param p_commit Commit
76 * @param p_validation_level Validation level
77 * @param p_remittance_bank_number Remittance bank number
78 * @param p_remittance_bnk_branch_number Remittance branch number
79 * @param p_remittance_bnk_acct_number Remmittance bank account number
80 * @param p_media_reference Media reference
81 * @param p_remittance_method Remittance method
82 * @param p_with_recourse_flag Remit with recourse flag
83 * @param p_payment_method Payment method
84 * @param p_remittance_date Remittance date
85 * @param p_remittance_accounting_date GL date
86 * @param p_Currency_code Currency code
87 * @param p_internal_reference Transaction ID
88 * @rep:scope public
89 * @rep:lifecycle active
90 * @rep:displayname Remittance Import
91 */
92
93 PROCEDURE import_remittance_main (
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2, -- := FND_API.G_FALSE,
97 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
102 p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
103 p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
104 p_media_reference IN ar_batches.media_reference%TYPE,
105 p_remittance_method IN ar_batches.remit_method_code%TYPE,
109 p_remittance_date IN ar_batches.batch_date%TYPE,
106 -- 'STANDARD' , 'FACTORING' etc.
107 p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
108 p_payment_method IN ar_receipt_methods.name%TYPE,
110 p_remittance_accounting_date IN ar_batches.gl_date%TYPE,
111 p_currency_code IN ar_batches.currency_code%TYPE,
112 p_internal_reference IN ra_customer_trx.Customer_trx_id%TYPE,
113 p_org_id IN Number default null,
114 p_remittance_name OUT NOCOPY ar_batches.name%TYPE
115 );
116
117 END AR_BR_REMIT_IMPORT_API_PUB;
118