DBA Data[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;