1 PACKAGE ARP_PROCESS_BOE AS
2 /* $Header: ARREBOES.pls 120.2 2003/10/24 19:44:35 orashid ship $ */
3 ----------------------- Data types -----------------------------
4
5
6 ------------------ Public functions/procedures -------------------
7
8
9 PROCEDURE add_or_rm_remit_rec_to_batch (
10 p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
11 p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
12 p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE,
13 p_selected_remittance_batch_id IN
14 ar_cash_receipts.selected_remittance_batch_id%TYPE,
15 p_remittance_bank_account_id IN
16 ar_cash_receipts.remit_bank_acct_use_id%type,
17 p_override_remit_account_flag IN
18 ar_cash_receipts.override_remit_account_flag%TYPE,
19 p_customer_bank_account_id IN
20 ar_cash_receipts.customer_bank_account_id%TYPE,
21 p_bank_charges IN
22 ar_cash_receipt_history.factor_discount_amount%TYPE,
23 p_maturity_date IN
24 ar_payment_schedules.due_date%TYPE,
25 p_batch_id IN NUMBER,
26 p_control_count IN NUMBER,
27 p_control_amount IN NUMBER,
28 p_module_name IN VARCHAR2,
29 p_module_version IN VARCHAR2 );
30
31 PROCEDURE create_remit_batch_conc_req( p_create_flag IN VARCHAR2,
32 p_approve_flag IN VARCHAR2,
33 p_format_flag IN VARCHAR2,
34 p_batch_id IN ar_batches.batch_id%TYPE,
35 p_due_date_low IN ar_payment_schedules.due_date%TYPE,
36 p_due_date_high IN ar_payment_schedules.due_date%TYPE,
37 p_receipt_date_low IN ar_cash_receipts.receipt_date%TYPE,
38 p_receipt_date_high IN ar_cash_receipts.receipt_date%TYPE,
39 p_receipt_number_low IN ar_cash_receipts.receipt_number%TYPE,
40 p_receipt_number_high IN ar_cash_receipts.receipt_number%TYPE,
41 p_document_number_low IN NUMBER,
42 p_document_number_high IN NUMBER,
43 p_customer_number_low IN hz_cust_accounts.account_number%TYPE,
44 p_customer_number_high IN hz_cust_accounts.account_number%TYPE,
45 p_customer_name_low IN hz_parties.party_name%TYPE,
46 p_customer_name_high IN hz_parties.party_name%TYPE,
47 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
48 p_location_low IN hz_cust_site_uses.location%TYPE,
49 p_location_high IN hz_cust_site_uses.location%TYPE,
50 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
51 p_remit_total_low IN NUMBER,
52 p_remit_total_high IN NUMBER,
53 p_request_id OUT NOCOPY NUMBER,
54 p_batch_applied_status OUT NOCOPY VARCHAR2,
55 p_module_name IN VARCHAR2,
56 p_module_version IN VARCHAR2 );
57
58 PROCEDURE app_fmt_auto_batch_conc_req( p_approve_flag IN VARCHAR2,
59 p_format_flag IN VARCHAR2,
60 p_batch_id IN ar_batches.batch_id%TYPE,
61 p_request_id OUT NOCOPY NUMBER,
62 p_batch_applied_status OUT NOCOPY VARCHAR2,
63 p_module_name IN VARCHAR2,
64 p_module_version IN VARCHAR2 );
65 --
66 PROCEDURE app_fmt_remit_batch_conc_req( p_approve_flag IN VARCHAR2,
67 p_format_flag IN VARCHAR2,
68 p_batch_id IN ar_batches.batch_id%TYPE,
69 p_request_id OUT NOCOPY NUMBER,
70 p_batch_applied_status OUT NOCOPY VARCHAR2,
71 p_module_name IN VARCHAR2,
72 p_module_version IN VARCHAR2 );
73 --
74 PROCEDURE create_auto_batch_conc_req( p_create_flag IN VARCHAR2,
75 p_approve_flag IN VARCHAR2,
76 p_format_flag IN VARCHAR2,
77 p_batch_id IN ar_batches.batch_id%TYPE,
78 p_due_date_low IN ar_payment_schedules.due_date%TYPE,
79 p_due_date_high IN ar_payment_schedules.due_date%TYPE,
80 p_trx_date_low IN ra_customer_trx.trx_date%TYPE,
81 p_trx_date_high IN ra_customer_trx.trx_date%TYPE,
82 p_trx_number_low IN ra_customer_trx.trx_number%TYPE,
83 p_trx_number_high IN ra_customer_trx.trx_number%TYPE,
84 p_document_number_low IN NUMBER,
85 p_document_number_high IN NUMBER,
86 p_customer_number_low IN hz_cust_accounts.account_number%TYPE,
87 p_customer_number_high IN hz_cust_accounts.account_number%TYPE,
88 p_customer_name_low IN hz_parties.party_name%TYPE,
89 p_customer_name_high IN hz_parties.party_name%TYPE,
90 p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
91 p_location_low IN hz_cust_site_uses.location%TYPE,
92 p_location_high IN hz_cust_site_uses.location%TYPE,
93 p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
94 p_billing_number_low IN ar_cons_inv.cons_billing_number%TYPE,
95 p_billing_number_high IN ar_cons_inv.cons_billing_number%TYPE,
96 p_request_id OUT NOCOPY NUMBER,
97 p_batch_applied_status OUT NOCOPY VARCHAR2,
98 p_module_name IN VARCHAR2,
99 p_module_version IN VARCHAR2,
100 p_bank_account_low IN VARCHAR2,
101 p_bank_account_high IN VARCHAR2 );
102
103 PROCEDURE add_or_rm_txn_from_auto_batch(
104 p_ct_id IN ra_customer_trx.customer_trx_id%TYPE,
105 p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
106 p_selected_for_rec_batch_id IN
107 ar_payment_schedules.selected_for_receipt_batch_id%TYPE,
108 p_paying_customer_id IN ra_customer_trx.paying_customer_id%TYPE,
109 p_customer_bank_account_id IN
110 ra_customer_trx.customer_bank_account_id%TYPE,
111 p_module_name IN VARCHAR2,
112 p_module_version IN VARCHAR2 );
113
114 ----------------- Private functions/procedures ------------------
115
116
117 END ARP_PROCESS_BOE;