[Home] [Help]
PACKAGE: APPS.AR_ADD_FETCH_SELECT
Source
1 package AR_ADD_FETCH_SELECT AUTHID CURRENT_USER as
2 /* $Header: ARXRWAFS.pls 120.4 2005/10/30 03:59:51 appldev ship $ */
3
4 PROCEDURE on_select (
5 p_select_type VARCHAR2
6 ,p_apply_date DATE
7 ,p_receipt_gl_date DATE
8 ,p_customer_id NUMBER
9 ,p_bill_to_site_use_id NUMBER
10 ,p_receipt_currency VARCHAR2
11 ,p_cm_customer_trx_id NUMBER
12 ,p_trx_type_name_find VARCHAR2
13 ,p_due_date_find VARCHAR2
14 ,p_trx_date_find VARCHAR2
15 ,p_amt_due_rem_find VARCHAR2
16 ,p_trx_number_find VARCHAR2
17 ,p_include_disputed VARCHAR2
18 ,p_include_cross_curr VARCHAR2
19 ,p_inv_class VARCHAR2
20 ,p_chb_class VARCHAR2
21 ,p_cm_class VARCHAR2
22 ,p_dm_class VARCHAR2
23 ,p_dep_class VARCHAR2
24 ,p_status VARCHAR2
25 ,p_order_by VARCHAR2
26 ,p_trx_bill_number_find VARCHAR2
27 ,p_purchase_order_find VARCHAR2 default NULL
28 ,p_transaction_category_find VARCHAR2 default NULL
29 ,p_br_class VARCHAR2 DEFAULT NULL/* 01-JUN-2000 J Rautiainen BR Implementation */
30 ,p_related_cust_flag VARCHAR2
31 );
32
33 function on_fetch (
34 p_select_type IN VARCHAR2,
35 row_id OUT NOCOPY VARCHAR2,
36 cash_receipt_id OUT NOCOPY NUMBER,
37 customer_trx_id OUT NOCOPY NUMBER,
38 cm_customer_trx_id OUT NOCOPY NUMBER,
39 last_update_date OUT NOCOPY DATE,
40 last_updated_by OUT NOCOPY NUMBER,
41 creation_date OUT NOCOPY DATE,
42 created_by OUT NOCOPY NUMBER,
43 last_update_login OUT NOCOPY NUMBER,
44 program_application_id OUT NOCOPY NUMBER,
45 program_id OUT NOCOPY NUMBER,
46 program_update_date OUT NOCOPY DATE,
47 request_id OUT NOCOPY NUMBER,
48 receipt_number OUT NOCOPY VARCHAR2,
49 applied_flag OUT NOCOPY VARCHAR2,
50 customer_id OUT NOCOPY NUMBER,
51 customer_name OUT NOCOPY VARCHAR2,
52 customer_number OUT NOCOPY VARCHAR2,
53 trx_number OUT NOCOPY VARCHAR2,
54 installment OUT NOCOPY NUMBER,
55 amount_applied OUT NOCOPY NUMBER,
56 amount_applied_from OUT NOCOPY NUMBER,
57 trans_to_receipt_rate OUT NOCOPY NUMBER,
58 discount OUT NOCOPY NUMBER,
59 discounts_earned OUT NOCOPY NUMBER,
60 discounts_unearned OUT NOCOPY NUMBER,
61 discount_taken_earned OUT NOCOPY NUMBER,
62 discount_taken_unearned OUT NOCOPY NUMBER,
63 amount_due_remaining OUT NOCOPY NUMBER,
64 due_date OUT NOCOPY DATE,
65 status OUT NOCOPY VARCHAR2,
66 term_id OUT NOCOPY NUMBER,
67 trx_class_name OUT NOCOPY VARCHAR2,
68 trx_class_code OUT NOCOPY VARCHAR2,
69 trx_type_name OUT NOCOPY VARCHAR2,
70 cust_trx_type_id OUT NOCOPY NUMBER,
71 trx_date OUT NOCOPY DATE,
72 location_name OUT NOCOPY VARCHAR2,
73 bill_to_site_use_id OUT NOCOPY NUMBER,
74 days_late OUT NOCOPY NUMBER,
75 line_number OUT NOCOPY NUMBER,
76 customer_trx_line_id OUT NOCOPY NUMBER,
77 apply_date OUT NOCOPY DATE,
78 gl_date OUT NOCOPY DATE,
79 gl_posted_date OUT NOCOPY DATE,
80 reversal_gl_date OUT NOCOPY DATE,
81 exchange_rate OUT NOCOPY NUMBER,
82 invoice_currency_code OUT NOCOPY VARCHAR2,
83 amount_due_original OUT NOCOPY NUMBER,
84 amount_in_dispute OUT NOCOPY NUMBER,
85 amount_line_items_original OUT NOCOPY NUMBER,
86 acctd_amount_due_remaining OUT NOCOPY NUMBER,
87 acctd_amount_applied_to OUT NOCOPY NUMBER,
88 acctd_amount_applied_from OUT NOCOPY NUMBER,
89 exchange_gain_loss OUT NOCOPY NUMBER,
90 discount_remaining OUT NOCOPY NUMBER,
91 calc_discount_on_lines_flag OUT NOCOPY VARCHAR2,
92 partial_discount_flag OUT NOCOPY VARCHAR2,
93 allow_overapplication_flag OUT NOCOPY VARCHAR2,
94 natural_application_only_flag OUT NOCOPY VARCHAR2,
95 creation_sign OUT NOCOPY VARCHAR2,
96 applied_payment_schedule_id OUT NOCOPY NUMBER,
97 ussgl_transaction_code OUT NOCOPY VARCHAR2,
98 ussgl_transaction_code_context OUT NOCOPY VARCHAR2,
99 purchase_order OUT NOCOPY VARCHAR2,
100 trx_doc_sequence_id OUT NOCOPY NUMBER,
101 trx_doc_sequence_value OUT NOCOPY VARCHAR2,
102 trx_batch_source_name OUT NOCOPY VARCHAR2,
103 amount_adjusted OUT NOCOPY NUMBER,
104 amount_adjusted_pending OUT NOCOPY NUMBER,
105 amount_line_items_remaining OUT NOCOPY NUMBER,
106 freight_original OUT NOCOPY NUMBER,
107 freight_remaining OUT NOCOPY NUMBER,
108 receivables_charges_remaining OUT NOCOPY NUMBER,
109 tax_original OUT NOCOPY NUMBER,
110 tax_remaining OUT NOCOPY NUMBER,
111 selected_for_receipt_batch_id OUT NOCOPY NUMBER,
112 receivable_application_id OUT NOCOPY NUMBER,
113 attribute_category OUT NOCOPY VARCHAR2,
114 attribute1 OUT NOCOPY VARCHAR2,
115 attribute2 OUT NOCOPY VARCHAR2,
116 attribute3 OUT NOCOPY VARCHAR2,
117 attribute4 OUT NOCOPY VARCHAR2,
118 attribute5 OUT NOCOPY VARCHAR2,
119 attribute6 OUT NOCOPY VARCHAR2,
120 attribute7 OUT NOCOPY VARCHAR2,
121 attribute8 OUT NOCOPY VARCHAR2,
122 attribute9 OUT NOCOPY VARCHAR2,
123 attribute10 OUT NOCOPY VARCHAR2,
124 attribute11 OUT NOCOPY VARCHAR2,
125 attribute12 OUT NOCOPY VARCHAR2,
126 attribute13 OUT NOCOPY VARCHAR2,
127 attribute14 OUT NOCOPY VARCHAR2,
128 attribute15 OUT NOCOPY VARCHAR2,
129 trx_billing_number OUT NOCOPY VARCHAR2,
130 global_attribute_category OUT NOCOPY VARCHAR2,
131 global_attribute1 OUT NOCOPY VARCHAR2,
132 global_attribute2 OUT NOCOPY VARCHAR2,
133 global_attribute3 OUT NOCOPY VARCHAR2,
134 global_attribute4 OUT NOCOPY VARCHAR2,
135 global_attribute5 OUT NOCOPY VARCHAR2,
136 global_attribute6 OUT NOCOPY VARCHAR2,
137 global_attribute7 OUT NOCOPY VARCHAR2,
138 global_attribute8 OUT NOCOPY VARCHAR2,
139 global_attribute9 OUT NOCOPY VARCHAR2,
140 global_attribute10 OUT NOCOPY VARCHAR2,
141 global_attribute11 OUT NOCOPY VARCHAR2,
142 global_attribute12 OUT NOCOPY VARCHAR2,
143 global_attribute13 OUT NOCOPY VARCHAR2,
144 global_attribute14 OUT NOCOPY VARCHAR2,
145 global_attribute15 OUT NOCOPY VARCHAR2,
146 global_attribute16 OUT NOCOPY VARCHAR2,
147 global_attribute17 OUT NOCOPY VARCHAR2,
148 global_attribute18 OUT NOCOPY VARCHAR2,
149 global_attribute19 OUT NOCOPY VARCHAR2,
150 global_attribute20 OUT NOCOPY VARCHAR2,
151 -- purchase_order OUT NOCOPY VARCHAR2,
152 transaction_category OUT NOCOPY VARCHAR2,
153 trx_gl_date OUT NOCOPY DATE,
154 comments OUT NOCOPY VARCHAR2, --- bug 2662270
155 receivables_trx_id OUT NOCOPY NUMBER,
156 rec_activity_name OUT NOCOPY VARCHAR,
157 application_ref_id OUT NOCOPY NUMBER,
158 application_ref_num OUT NOCOPY VARCHAR2,
159 application_ref_type OUT NOCOPY VARCHAR2,
160 application_ref_type_meaning OUT NOCOPY VARCHAR2
161 ) return BOOLEAN;
162 end ar_add_fetch_select;