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_PROCESS_BR_BATCHES dependencies on AR_SELECTION_CRITERIA

Line 34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

30: p_issue_date IN ra_batches.issue_date%TYPE ,
31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

Line 35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,

31: p_maturity_date IN ra_batches.maturity_date%TYPE ,
32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

32: p_special_instructions IN ra_batches.special_instructions%TYPE ,
33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,

33: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

34: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

35: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

Line 40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

36: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

Line 41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

37: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

Line 42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

38: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

Line 43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

39: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,

Line 44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

40: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,

Line 45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

41: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
49: p_name IN OUT NOCOPY ra_batches.name%TYPE );

Line 46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

42: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
43: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
44: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
45: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
46: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
47: p_selection_criteria_id OUT NOCOPY ra_batches.selection_criteria_id%TYPE ,
48: p_batch_id OUT NOCOPY ra_batches.batch_id%TYPE ,
49: p_name IN OUT NOCOPY ra_batches.name%TYPE );
50:

Line 86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

82: p_maturity_date IN ra_batches.maturity_date%TYPE ,
83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

Line 87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,

83: p_special_instructions IN ra_batches.special_instructions%TYPE ,
84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

84: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,

85: p_request_id IN ra_batches.request_id%TYPE ,
86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

86: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

87: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE,
88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

Line 92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

88: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

Line 93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

89: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE,
90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

Line 94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

90: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

Line 95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

91: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
99: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);

Line 96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

92: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
99: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);
100:

Line 97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

93: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
99: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);
100:
101:

Line 98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,

94: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
99: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);
100:
101:
102:

Line 99: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);

95: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
96: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
97: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
98: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE ,
99: p_selection_criteria_id IN OUT NOCOPY ar_selection_criteria.selection_criteria_id%TYPE);
100:
101:
102:
103: PROCEDURE delete_batch (

Line 107: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE);

103: PROCEDURE delete_batch (
104: p_form_name IN varchar2 ,
105: p_form_version IN number ,
106: p_batch_id IN ra_batches.batch_id%TYPE ,
107: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE);
108:
109:
110:
111: PROCEDURE lock_compare_batch (

Line 142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,

138: p_issue_date IN ra_batches.issue_date%TYPE ,
139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,

Line 143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,

139: p_maturity_date IN ra_batches.maturity_date%TYPE ,
140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

Line 144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,

140: p_special_instructions IN ra_batches.special_instructions%TYPE ,
141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

Line 145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,

141: p_batch_process_status IN ra_batches.batch_process_status%TYPE ,
142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

Line 146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,

142: p_selection_criteria_id IN ar_selection_criteria.selection_criteria_id%TYPE,
143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

Line 147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,

143: p_due_date_low IN ar_selection_criteria.due_date_low%TYPE ,
144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

Line 148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,

144: p_due_date_high IN ar_selection_criteria.due_date_high%TYPE ,
145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

Line 149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,

145: p_trx_date_low IN ar_selection_criteria.trx_date_low%TYPE ,
146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

Line 150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,

146: p_trx_date_high IN ar_selection_criteria.trx_date_high%TYPE ,
147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

Line 151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,

147: p_cust_trx_TYPE_id IN ar_selection_criteria.cust_trx_TYPE_id%TYPE ,
148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
155: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );

Line 152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,

148: p_receipt_method_id IN ar_selection_criteria.receipt_method_id%TYPE ,
149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
155: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );
156:

Line 153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,

149: p_bank_branch_id IN ar_selection_criteria.bank_branch_id%TYPE ,
150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
155: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );
156:
157:

Line 154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,

150: p_trx_number_low IN ar_selection_criteria.trx_number_low%TYPE ,
151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
155: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );
156:
157:
158: PROCEDURE submit_print (

Line 155: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );

151: p_trx_number_high IN ar_selection_criteria.trx_number_high%TYPE ,
152: p_customer_class_code IN ar_selection_criteria.customer_class_code%TYPE ,
153: p_customer_category_code IN ar_selection_criteria.customer_category_code%TYPE,
154: p_customer_id IN ar_selection_criteria.customer_id%TYPE ,
155: p_site_use_id IN ar_selection_criteria.site_use_id%TYPE );
156:
157:
158: PROCEDURE submit_print (
159: p_format IN varchar2 ,