eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_SELECTION_CRITERIA_PKG dependencies on AR_SELECTION_CRITERIA

Line 5: ( p_sel_rec IN AR_SELECTION_CRITERIA%rowtype ,

1: PACKAGE ARP_SELECTION_CRITERIA_PKG AUTHID CURRENT_USER 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

Line 6: p_sel_id OUT NOCOPY AR_SELECTION_CRITERIA.selection_criteria_id%type);

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 ,

Line 10: ( 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);

Line 11: p_sel_id IN 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:

Line 14: ( p_sel_id IN AR_SELECTION_CRITERIA.selection_criteria_id%type);

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 ,

Line 18: ( p_sel_rec OUT NOCOPY AR_SELECTION_CRITERIA%rowtype ,

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

Line 19: 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);

Line 23: ( p_sel_id IN AR_SELECTION_CRITERIA.selection_criteria_id%type);

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 ,

Line 27: ( p_sel_rec IN OUT NOCOPY AR_SELECTION_CRITERIA%rowtype ,

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

Line 28: 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 ,

Line 32: ( p_sel_rec IN 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 ,

Line 33: 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 ,

Line 38: p_selection_criteria_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 ,

Line 39: p_due_date_low IN AR_SELECTION_CRITERIA.due_date_low%type ,

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 ,

Line 40: p_due_date_high IN AR_SELECTION_CRITERIA.due_date_high%type ,

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 ,

Line 41: p_trx_date_low IN AR_SELECTION_CRITERIA.trx_date_low%type ,

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 ,

Line 42: p_trx_date_high IN AR_SELECTION_CRITERIA.trx_date_high%type ,

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 ,

Line 43: p_cust_trx_type_id IN AR_SELECTION_CRITERIA.cust_trx_type_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 ,

Line 44: p_receipt_method_id IN AR_SELECTION_CRITERIA.receipt_method_id%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 ,

Line 45: p_bank_branch_id IN AR_SELECTION_CRITERIA.bank_branch_id%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 ,

Line 46: p_trx_number_low IN AR_SELECTION_CRITERIA.trx_number_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 ,

Line 47: p_trx_number_high IN AR_SELECTION_CRITERIA.trx_number_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 );

Line 48: p_customer_class_code IN AR_SELECTION_CRITERIA.customer_class_code%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:

Line 49: p_customer_category_code IN AR_SELECTION_CRITERIA.customer_category_code%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:

Line 50: p_customer_id IN AR_SELECTION_CRITERIA.customer_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

Line 51: p_site_use_id IN AR_SELECTION_CRITERIA.site_use_id%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 );

Line 55: ( p_sel_rec OUT NOCOPY AR_SELECTION_CRITERIA%rowtype );

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 );

Line 59: ( p_sel_id IN AR_SELECTION_CRITERIA.selection_criteria_id%type );

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 );

Line 63: ( p_sel_rec IN AR_SELECTION_CRITERIA%rowtype );

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;