1 package JL_AR_AUTOINV_PKG as
2 /* $Header: jlarrans.pls 120.2.12010000.1 2008/07/31 04:22:04 appldev ship $ */
3
4 PROCEDURE submit_request (
5 errbuf OUT NOCOPY varchar2,
6 retcode OUT NOCOPY number,
7 p_parallel_module_name IN varchar2 ,
8 p_running_mode IN varchar2 ,
9 p_batch_source_id IN ra_batch_sources.batch_source_id%TYPE,
10 p_batch_source_name IN varchar2 ,
11 p_default_date IN varchar2 ,
12 p_trans_flexfield IN varchar2 ,
13 p_trans_type IN ra_cust_trx_types.name%TYPE ,
14 p_low_bill_to_cust_num IN hz_cust_accounts.account_number%TYPE ,
15 p_high_bill_to_cust_num IN hz_cust_accounts.account_number%TYPE ,
16 p_low_bill_to_cust_name IN hz_parties.party_name%TYPE ,
17 p_high_bill_to_cust_name IN hz_parties.party_name%TYPE ,
18 p_low_gl_date IN VARCHAR2 ,
19 p_high_gl_date IN VARCHAR2 ,
20 p_low_ship_date IN VARCHAR2 ,
21 p_high_ship_date IN VARCHAR2,
22 p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
23 p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
24 p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
25 p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
26 p_low_invoice_date IN VARCHAR2 ,
27 p_high_invoice_date IN VARCHAR2 ,
28 p_low_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,
29 p_high_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,
30 p_low_ship_to_cust_name IN hz_parties.party_name%TYPE ,
31 p_high_ship_to_cust_name IN hz_parties.party_name%TYPE,
32 p_call_from_master_flag IN varchar2 ,
33 p_base_due_date_on_trx_date IN fnd_lookups.meaning%TYPE ,
34 p_due_date_adj_days IN number );
35
36 PROCEDURE UPDATE_BATCH_SOURCE(p_invoice_date_from IN DATE,
37 p_invoice_date_to IN DATE,
38 p_gl_date_from IN DATE,
39 p_gl_date_to IN DATE,
40 p_ship_date_from IN DATE,
41 p_ship_date_to IN DATE,
42 p_default_date IN DATE);
43
44 PROCEDURE JL_AR_AR_UPDATE_BATCH_SOURCE(
45 errbuf OUT NOCOPY varchar2,
46 retcode OUT NOCOPY number,
47 p_low_gl_date IN VARCHAR2 ,
48 p_high_gl_date IN VARCHAR2 ,
49 p_low_ship_date IN VARCHAR2 ,
50 p_high_ship_date IN VARCHAR2,
51 p_low_invoice_date IN VARCHAR2 ,
52 p_high_invoice_date IN VARCHAR2,
53 p_default_date IN VARCHAR2) ;
54 END JL_AR_AUTOINV_PKG;
[Home] [Help]