[Home] [Help]
PACKAGE: APPS.ARP_TRX_SELECT_CONTROL
Source
1 PACKAGE ARP_TRX_SELECT_CONTROL AUTHID CURRENT_USER AS
2 /* $Header: ARPLTSCS.pls 115.4 2002/11/15 02:44:04 anukumar ship $ */
3
4
5 PROCEDURE build_where_clause (
6 P_choice IN varchar2,
7 P_open_invoice IN varchar2,
8 P_cust_trx_type_id IN number,
9 p_cust_trx_class IN varchar2,
10 P_installment_number IN number,
11 P_dates_low IN date,
12 P_dates_high IN date,
13 P_customer_id IN number,
14 P_customer_class_code IN varchar2,
15 P_trx_number_low IN varchar2,
16 P_trx_number_high IN varchar2,
17 P_batch_id IN number,
18 P_customer_trx_id IN number,
19 p_adj_number_low in varchar2,
20 p_adj_number_high in varchar2,
21 p_adj_dates_low in date,
22 p_adj_dates_high in date,
23 P_where1 OUT NOCOPY varchar2,
24 P_where2 OUT NOCOPY varchar2,
25 p_table1 out NOCOPY varchar2,
26 p_table2 out NOCOPY varchar2,
27 p_call_from IN varchar2 default 'INV'
28 );
29
30 END ARP_TRX_SELECT_CONTROL;