PACKAGE: APPS.ARP_SELECTION_CRITERIA_PKG

Source

1 PACKAGE ARP_SELECTION_CRITERIA_PKG AS
2 /* $Header: ARBRSELS.pls 120.4 2005/10/30 03:49:02 appldev ship $ */
3 
4 procedure insert_p
5 	( 	p_sel_rec   	IN 	AR_SELECTION_CRITERIA%rowtype			,
6                 p_sel_id   	OUT NOCOPY 	AR_SELECTION_CRITERIA.selection_criteria_id%type);
7 
8 
9 PROCEDURE update_p
10 	( 	p_sel_rec 	IN 	AR_SELECTION_CRITERIA%rowtype			,
11                 p_sel_id  	IN 	AR_SELECTION_CRITERIA.selection_criteria_id%type);
12 
13 procedure delete_p
14 	( 	p_sel_id  	IN 	AR_SELECTION_CRITERIA.selection_criteria_id%type);
15 
16 
17 PROCEDURE fetch_p
18 	( 	p_sel_rec  	OUT NOCOPY 	AR_SELECTION_CRITERIA%rowtype			,
19                 p_sel_id    	IN 	AR_SELECTION_CRITERIA.selection_criteria_id%type);
20 
21 
22 PROCEDURE lock_p
23 	( 	p_sel_id 	IN 	AR_SELECTION_CRITERIA.selection_criteria_id%type);
24 
25 
26 PROCEDURE lock_fetch_p
27 	( 	p_sel_rec 	IN OUT NOCOPY 	AR_SELECTION_CRITERIA%rowtype			,
28                 p_sel_id  	IN 	AR_SELECTION_CRITERIA.selection_criteria_id%type);
29 
30 
31 PROCEDURE lock_compare_p
32 	( 	p_sel_rec 	IN   	AR_SELECTION_CRITERIA%rowtype			,
33                 p_sel_id  	IN   	AR_SELECTION_CRITERIA.selection_criteria_id%type);
34 
35 PROCEDURE lock_compare_cover
36 	(	p_form_name         		IN  varchar2						,
37 		p_form_version         		IN  number						,
38   		p_selection_criteria_id  	IN  AR_SELECTION_CRITERIA.selection_criteria_id%type	,
39   		p_due_date_low			IN  AR_SELECTION_CRITERIA.due_date_low%type		,
40 		p_due_date_high			IN  AR_SELECTION_CRITERIA.due_date_high%type		,
41 		p_trx_date_low			IN  AR_SELECTION_CRITERIA.trx_date_low%type		,
42 		p_trx_date_high			IN  AR_SELECTION_CRITERIA.trx_date_high%type		,
43 		p_cust_trx_type_id		IN  AR_SELECTION_CRITERIA.cust_trx_type_id%type		,
44 		p_receipt_method_id		IN  AR_SELECTION_CRITERIA.receipt_method_id%type	,
45 		p_bank_branch_id		IN  AR_SELECTION_CRITERIA.bank_branch_id%type		,
46 		p_trx_number_low		IN  AR_SELECTION_CRITERIA.trx_number_low%type		,
47 		p_trx_number_high		IN  AR_SELECTION_CRITERIA.trx_number_high%type		,
48 		p_customer_class_code		IN  AR_SELECTION_CRITERIA.customer_class_code%type	,
49 		p_customer_category_code	IN  AR_SELECTION_CRITERIA.customer_category_code%type	,
50 		p_customer_id			IN  AR_SELECTION_CRITERIA.customer_id%type		,
51 		p_site_use_id			IN  AR_SELECTION_CRITERIA.site_use_id%type		);
52 
53 
54 PROCEDURE set_to_dummy
55 	( 	p_sel_rec 			OUT NOCOPY AR_SELECTION_CRITERIA%rowtype			);
56 
57 
58 PROCEDURE display_selection
59 	(  	p_sel_id 			IN  AR_SELECTION_CRITERIA.selection_criteria_id%type	);
60 
61 
62 PROCEDURE display_selection_rec
63 	( 	p_sel_rec 			IN  AR_SELECTION_CRITERIA%rowtype 			);
64 
65 
66 END ARP_SELECTION_CRITERIA_PKG;