APPS.ARRX_TX dependencies on FA_RX_UTIL_PKG

Line 45: fa_rx_util_pkg.debug('arrx_tx.artx_rep()+');

41: l_profile_rsob_id NUMBER := NULL;
42: l_client_info_rsob_id NUMBER := NULL;
43: l_client_info_org_id NUMBER := NULL;
44: begin
45: fa_rx_util_pkg.debug('arrx_tx.artx_rep()+');
46:
47: --
48: -- Assign parameters to global variable
49: -- These values will be used within the before_report trigger

Line 116: fa_rx_util_pkg.debug('completed_flag = '|| var.completed_flag);

112: var.ca_sob_type := 'R';
113: END IF;
114:
115:
116: fa_rx_util_pkg.debug('completed_flag = '|| var.completed_flag);
117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);
118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);

Line 117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);

113: END IF;
114:
115:
116: fa_rx_util_pkg.debug('completed_flag = '|| var.completed_flag);
117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);
118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);

Line 118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);

114:
115:
116: fa_rx_util_pkg.debug('completed_flag = '|| var.completed_flag);
117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);
118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);

Line 119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);

115:
116: fa_rx_util_pkg.debug('completed_flag = '|| var.completed_flag);
117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);
118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);

Line 120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);

116: fa_rx_util_pkg.debug('completed_flag = '|| var.completed_flag);
117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);
118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);

Line 121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);

117: fa_rx_util_pkg.debug('posted_flag = '|| var.posted_flag);
118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);

Line 122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);

118: fa_rx_util_pkg.debug('start_gl_date = '|| var.start_gl_date);
119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);

Line 123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);

119: fa_rx_util_pkg.debug('end_gl_date = '|| var.end_gl_date);
120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);

Line 124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);

120: fa_rx_util_pkg.debug('start_transaction_date = '|| var.start_transaction_date);
121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);

Line 125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);

121: fa_rx_util_pkg.debug('end_transaction_date = '|| var.end_transaction_date);
122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);

Line 126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);

122: fa_rx_util_pkg.debug('start_transaction_type = '|| var.start_transaction_type);
123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);

Line 127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);

123: fa_rx_util_pkg.debug('end_transaction_type = '|| var.end_transaction_type);
124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);

Line 128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);

124: fa_rx_util_pkg.debug('start_transaction_class = '|| var.start_transaction_class);
125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);

Line 129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);

125: fa_rx_util_pkg.debug('end_transaction_class = '|| var.end_transaction_class);
126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);

Line 130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);

126: fa_rx_util_pkg.debug('start_balancing_segment = '|| var.start_balancing_segment);
127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);

Line 131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);

127: fa_rx_util_pkg.debug('end_balancing_segment = '|| var.end_balancing_segment);
128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);

Line 132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);

128: fa_rx_util_pkg.debug('start_bill_to_customer_name = '|| var.start_bill_to_customer_name);
129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);

Line 133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);

129: fa_rx_util_pkg.debug('end_bill_to_customer_name = '|| var.end_bill_to_customer_name);
130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);
137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);

Line 134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);

130: fa_rx_util_pkg.debug('start_currency = '|| var.start_currency);
131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);
137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);
138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);

Line 135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);

131: fa_rx_util_pkg.debug('end_currency = '|| var.end_currency);
132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);
137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);
138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);
139:

Line 136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);

132: fa_rx_util_pkg.debug('payment_method = '|| var.payment_method);
133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);
137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);
138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);
139:
140: -- bug3940958 added

Line 137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);

133: fa_rx_util_pkg.debug('doc_sequence_name = '|| var.doc_sequence_name);
134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);
137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);
138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);
139:
140: -- bug3940958 added
141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);

Line 138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);

134: fa_rx_util_pkg.debug('doc_sequence_number_from = '|| var.doc_sequence_number_from);
135: fa_rx_util_pkg.debug('doc_sequence_number_to = '|| var.doc_sequence_number_to);
136: fa_rx_util_pkg.debug('start_bill_to_customer_number = '|| var.start_bill_to_customer_number);
137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);
138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);
139:
140: -- bug3940958 added
141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);
142: fa_rx_util_pkg.debug('end_account = '|| var.end_account);

Line 141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);

137: fa_rx_util_pkg.debug('end_bill_to_customer_number = '|| var.end_bill_to_customer_number);
138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);
139:
140: -- bug3940958 added
141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);
142: fa_rx_util_pkg.debug('end_account = '|| var.end_account);
143: fa_rx_util_pkg.debug('batch_source_name = '|| var.batch_source_name);
144: fa_rx_util_pkg.debug('transaction_class = '|| var.start_transaction_class);
145:

Line 142: fa_rx_util_pkg.debug('end_account = '|| var.end_account);

138: fa_rx_util_pkg.debug('request_id = '|| var.request_id);
139:
140: -- bug3940958 added
141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);
142: fa_rx_util_pkg.debug('end_account = '|| var.end_account);
143: fa_rx_util_pkg.debug('batch_source_name = '|| var.batch_source_name);
144: fa_rx_util_pkg.debug('transaction_class = '|| var.start_transaction_class);
145:
146: -- Start Bug 5571594 - Added modification to code change of bug 5244313

Line 143: fa_rx_util_pkg.debug('batch_source_name = '|| var.batch_source_name);

139:
140: -- bug3940958 added
141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);
142: fa_rx_util_pkg.debug('end_account = '|| var.end_account);
143: fa_rx_util_pkg.debug('batch_source_name = '|| var.batch_source_name);
144: fa_rx_util_pkg.debug('transaction_class = '|| var.start_transaction_class);
145:
146: -- Start Bug 5571594 - Added modification to code change of bug 5244313
147: -- changing in-parameter variable with local variable

Line 144: fa_rx_util_pkg.debug('transaction_class = '|| var.start_transaction_class);

140: -- bug3940958 added
141: fa_rx_util_pkg.debug('start_account = '|| var.start_account);
142: fa_rx_util_pkg.debug('end_account = '|| var.end_account);
143: fa_rx_util_pkg.debug('batch_source_name = '|| var.batch_source_name);
144: fa_rx_util_pkg.debug('transaction_class = '|| var.start_transaction_class);
145:
146: -- Start Bug 5571594 - Added modification to code change of bug 5244313
147: -- changing in-parameter variable with local variable
148: -- Bug 5244313 Setting the Org context based on the Reporting context

Line 167: fa_rx_util_pkg.init_request('arrx_tx.artx_rep',request_id,'AR_TRANSACTIONS_REP_ITF');

163: mo_global.set_policy_context('S',var.reporting_entity_id);
164: END IF;
165: --End bug 5571594 SPDIXIT
166: -- Initialize request
167: fa_rx_util_pkg.init_request('arrx_tx.artx_rep',request_id,'AR_TRANSACTIONS_REP_ITF');
168:
169: --
170: -- Assign report triggers for this report.
171: -- This report has one section called AR TRANSACTION

Line 178: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',

174: -- bind is assigned 'arrx_tx.bind(:CURSOR_SELECT);'
175: -- Each trigger event is assigned with the full procedure name (including package name).
176: -- They end with a ';'.
177: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
178: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
179: true,
180: 'arrx_tx.before_report;',
181: 'arrx_tx.bind(:CURSOR_SELECT);',
182: 'arrx_tx.after_fetch;',

Line 188: fa_rx_util_pkg.run_report('arrx_tx.artx_rep', retcode, errbuf);

184:
185: --
186: -- Run the report. Make sure to pass as parameter the same
187: -- value passed to p_calling_proc in init_request().
188: fa_rx_util_pkg.run_report('arrx_tx.artx_rep', retcode, errbuf);
189:
190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');
191:
192: exception

Line 190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');

186: -- Run the report. Make sure to pass as parameter the same
187: -- value passed to p_calling_proc in init_request().
188: fa_rx_util_pkg.run_report('arrx_tx.artx_rep', retcode, errbuf);
189:
190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');
191:
192: exception
193: when others then
194: fa_rx_util_pkg.log(sqlcode);

Line 194: fa_rx_util_pkg.log(sqlcode);

190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');
191:
192: exception
193: when others then
194: fa_rx_util_pkg.log(sqlcode);
195: fa_rx_util_pkg.log(sqlerrm);
196: fa_rx_util_pkg.debug(sqlcode);
197: fa_rx_util_pkg.debug(sqlerrm);
198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');

Line 195: fa_rx_util_pkg.log(sqlerrm);

191:
192: exception
193: when others then
194: fa_rx_util_pkg.log(sqlcode);
195: fa_rx_util_pkg.log(sqlerrm);
196: fa_rx_util_pkg.debug(sqlcode);
197: fa_rx_util_pkg.debug(sqlerrm);
198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');
199: end artx_rep;

Line 196: fa_rx_util_pkg.debug(sqlcode);

192: exception
193: when others then
194: fa_rx_util_pkg.log(sqlcode);
195: fa_rx_util_pkg.log(sqlerrm);
196: fa_rx_util_pkg.debug(sqlcode);
197: fa_rx_util_pkg.debug(sqlerrm);
198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');
199: end artx_rep;
200:

Line 197: fa_rx_util_pkg.debug(sqlerrm);

193: when others then
194: fa_rx_util_pkg.log(sqlcode);
195: fa_rx_util_pkg.log(sqlerrm);
196: fa_rx_util_pkg.debug(sqlcode);
197: fa_rx_util_pkg.debug(sqlerrm);
198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');
199: end artx_rep;
200:
201:

Line 198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');

194: fa_rx_util_pkg.log(sqlcode);
195: fa_rx_util_pkg.log(sqlerrm);
196: fa_rx_util_pkg.debug(sqlcode);
197: fa_rx_util_pkg.debug(sqlerrm);
198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');
199: end artx_rep;
200:
201:
202: --

Line 236: fa_rx_util_pkg.debug('arrx_tx.before_report()+');

232: L_BS_ORG_WHERE varchar2(500);
233: BATCH_SOURCE_WHERE varchar2(500);
234: REC_ACCOUNT_WHERE varchar2(4500); /*4653230*/
235: begin
236: fa_rx_util_pkg.debug('arrx_tx.before_report()+');
237:
238: --
239: -- Get Profile GL_SET_OF_BKS_ID
240: --

Line 241: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');

237:
238: --
239: -- Get Profile GL_SET_OF_BKS_ID
240: --
241: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');
242: /* bug2018415 replace fnd_profile call with arp_global.sysparam
243: fnd_profile.get(
244: name => 'GL_SET_OF_BKS_ID',
245: val => var.books_id);

Line 277: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');

273:
274: --
275: -- Get CHART_OF_ACCOUNTS_ID
276: --
277: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');
278:
279: -- bug:3256137
280: select CHART_OF_ACCOUNTS_ID
281: ,NAME

Line 294: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');

290:
291: --
292: -- Figure out NOCOPY the where clause for the parameters
293: --
294: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');
295:
296: -- bug3940958 added for cross-org
297: if var.reporting_entity_id <> -99 then
298: XLA_MO_REPORTING_API.Initialize(var.reporting_level, var.reporting_entity_id, 'AUTO');

Line 525: fa_rx_util_pkg.debug('AR_GET_BILLING_NUMBER');

521:
522: --
523: -- Get BILLING NUMBER Function
524: --
525: fa_rx_util_pkg.debug('AR_GET_BILLING_NUMBER');
526: /* fnd_profile.get(
527: name => 'AR_SHOW_BILLING_NUMBER',
528: val => var.bill_flag);
529: */

Line 580: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');

576: var.tax_header_level_flag := NVL(var.tax_header_level_flag,'N');
577: --
578: -- Assign SELECT list
579: --
580: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
581:
582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');

Line 582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);

578: -- Assign SELECT list
579: --
580: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
581:
582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);

Line 584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');

580: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
581:
582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);

Line 585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);

581:
582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

Line 586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);

582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');

Line 587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');

583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);

Line 588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);

584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);

Line 589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);

Line 590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');

586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

Line 591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);

587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

Line 592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);

588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

Line 593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);

589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);

Line 594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');

Line 595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');

Line 596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');

Line 597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);

593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);

Line 598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');

594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');

Line 599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');

595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');

Line 600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');

596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

Line 601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);

597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');

Line 602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');

598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date

Line 603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');

599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');

Line 604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);

Line 605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');

601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

Line 607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');

603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

Line 608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);

604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);

Line 609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);

Line 610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');

606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);

Line 611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);

Line 612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);

608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);

Line 613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);

609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);

Line 614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);

610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);

Line 615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);

611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);

Line 616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);

612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);

Line 617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);

613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id

Line 618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);

614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);

Line 619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);

615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);

Line 620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);

616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
624: -->>SELECT_END<<--

Line 622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);

618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
624: -->>SELECT_END<<--
625:
626:

Line 623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);

619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
624: -->>SELECT_END<<--
625:
626:
627: --

Line 630: fa_rx_util_pkg.debug('AR_ASSIGN_FORM_CLAUSE');

626:
627: --
628: -- Assign From Clause
629: --
630: fa_rx_util_pkg.debug('AR_ASSIGN_FORM_CLAUSE');
631:
632: -- bug3940958 changed to _ALL for cross-org
633: IF var.ca_sob_type = 'P'
634: THEN

Line 635: fa_rx_util_pkg.From_Clause := 'RA_CUST_TRX_LINE_GL_DIST_ALL RECDIST,

631:
632: -- bug3940958 changed to _ALL for cross-org
633: IF var.ca_sob_type = 'P'
634: THEN
635: fa_rx_util_pkg.From_Clause := 'RA_CUST_TRX_LINE_GL_DIST_ALL RECDIST,
636: RA_CUSTOMER_TRX_ALL CT,
637: RA_CUST_TRX_TYPES_ALL TRX_TYPE,
638: HZ_CUST_ACCOUNTS_ALL BILL_TO,
639: HZ_PARTIES PARTY,

Line 645: fa_rx_util_pkg.From_Clause := 'RA_TRX_LINE_GL_DIST_ALL_MRC_V RECDIST,

641: AR_RECEIPT_METHODS METHODS,
642: FND_DOCUMENT_SEQUENCES DOC_SEQ,
643: AR_SYSTEM_PARAMETERS_ALL SYSPARAM';
644: ELSE
645: fa_rx_util_pkg.From_Clause := 'RA_TRX_LINE_GL_DIST_ALL_MRC_V RECDIST,
646: RA_CUSTOMER_TRX_ALL_MRC_V CT,
647: RA_CUST_TRX_TYPES_ALL TRX_TYPE,
648: HZ_CUST_ACCOUNTS_ALL BILL_TO,
649: HZ_PARTIES PARTY,

Line 658: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');

654:
655: --
656: -- Assign Where Clause (including the where clause from the parameters)
657: --
658: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');
659:
660:
661: -- bug:3256137
662:

Line 664: fa_rx_util_pkg.Where_Clause := 'CT.CUST_TRX_TYPE_ID = TRX_TYPE.CUST_TRX_TYPE_ID

660:
661: -- bug:3256137
662:
663: -- bug3940958 added where condition for cross-org and new paramereters
664: fa_rx_util_pkg.Where_Clause := 'CT.CUST_TRX_TYPE_ID = TRX_TYPE.CUST_TRX_TYPE_ID
665: AND CT.BILL_TO_CUSTOMER_ID = BILL_TO.CUST_ACCOUNT_ID
666: AND BILL_TO.PARTY_ID = PARTY.PARTY_ID
667: AND CT.receipt_method_id = METHODS.receipt_method_id(+)
668: AND CT.CUSTOMER_TRX_ID = RECDIST.CUSTOMER_TRX_ID

Line 695: fa_rx_util_pkg.debug('arrx_tx.before_report()-');

691: L_BILL_TO_ORG_WHERE || ' ' ||
692: BATCH_SOURCE_WHERE || ' ' ||
693: REC_ACCOUNT_WHERE ;
694:
695: fa_rx_util_pkg.debug('arrx_tx.before_report()-');
696:
697: end before_report;
698:
699:

Line 709: fa_rx_util_pkg.debug('AR_GET_BIND');

705: b_j_type_n varchar2(80);
706: YES_NO_Y varchar2(80);
707: YES_NO_N varchar2(80);
708: begin
709: fa_rx_util_pkg.debug('AR_GET_BIND');
710: --
711: -- These bind variables(Date Type) were included in the WHERE clause
712: --
713: IF var.start_gl_date IS NOT NULL THEN

Line 812: fa_rx_util_pkg.debug('GL_GET_FLEX_KEYWORD');

808: begin
809: --
810: -- Get FLEX FIELD VALUE and DESCRIPTION
811: --
812: fa_rx_util_pkg.debug('GL_GET_FLEX_KEYWORD');
813:
814: /* var.rec_account := fa_rx_flex_pkg.get_value(
815: p_application_id => 101,
816: p_id_flex_code => 'GL#',

Line 896: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()+');

892: -- Customer Number parameter declarations
893: start_bill_to_customer_number varchar2(30) := NULL;
894: end_bill_to_customer_number varchar2(30) := NULL;
895: begin
896: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()+');
897:
898: --
899: -- Assign parameters to global variable
900: -- These values will be used within the before_report trigger

Line 906: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);

902: var.start_update_date := Trunc(start_update_date);
903: var.end_update_date := Trunc(end_update_date)+1-1/24/60/60;
904: var.last_updated_by := last_updated_by;
905:
906: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);
907: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);
908: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
909:
910: --

Line 907: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);

903: var.end_update_date := Trunc(end_update_date)+1-1/24/60/60;
904: var.last_updated_by := last_updated_by;
905:
906: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);
907: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);
908: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
909:
910: --
911: -- Initialize request

Line 908: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);

904: var.last_updated_by := last_updated_by;
905:
906: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);
907: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);
908: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
909:
910: --
911: -- Initialize request
912: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');

Line 912: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');

908: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
909:
910: --
911: -- Initialize request
912: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');
913:
914: --
915: -- Call the main journal report
916:

Line 955: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',

951:
952: --
953: -- Assign triggers specific to this report
954: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
955: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
956: true,
957: 'arrx_tx.check_before_report;',
958: 'arrx_tx.check_bind(:CURSOR_SELECT);',
959: 'arrx_tx.check_after_fetch;',

Line 965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);

961:
962: --
963: -- Run the report.
964: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
966:
967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
968:
969: exception

Line 967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');

963: -- Run the report.
964: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
966:
967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
968:
969: exception
970: when others then
971: fa_rx_util_pkg.log(sqlcode);

Line 971: fa_rx_util_pkg.log(sqlcode);

967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
968:
969: exception
970: when others then
971: fa_rx_util_pkg.log(sqlcode);
972: fa_rx_util_pkg.log(sqlerrm);
973: fa_rx_util_pkg.debug(sqlcode);
974: fa_rx_util_pkg.debug(sqlerrm);
975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');

Line 972: fa_rx_util_pkg.log(sqlerrm);

968:
969: exception
970: when others then
971: fa_rx_util_pkg.log(sqlcode);
972: fa_rx_util_pkg.log(sqlerrm);
973: fa_rx_util_pkg.debug(sqlcode);
974: fa_rx_util_pkg.debug(sqlerrm);
975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
976: end artx_rep_check;

Line 973: fa_rx_util_pkg.debug(sqlcode);

969: exception
970: when others then
971: fa_rx_util_pkg.log(sqlcode);
972: fa_rx_util_pkg.log(sqlerrm);
973: fa_rx_util_pkg.debug(sqlcode);
974: fa_rx_util_pkg.debug(sqlerrm);
975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
976: end artx_rep_check;
977:

Line 974: fa_rx_util_pkg.debug(sqlerrm);

970: when others then
971: fa_rx_util_pkg.log(sqlcode);
972: fa_rx_util_pkg.log(sqlerrm);
973: fa_rx_util_pkg.debug(sqlcode);
974: fa_rx_util_pkg.debug(sqlerrm);
975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
976: end artx_rep_check;
977:
978:

Line 975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');

971: fa_rx_util_pkg.log(sqlcode);
972: fa_rx_util_pkg.log(sqlerrm);
973: fa_rx_util_pkg.debug(sqlcode);
974: fa_rx_util_pkg.debug(sqlerrm);
975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
976: end artx_rep_check;
977:
978:
979: --

Line 991: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');

987: decode_inv varchar2(500);
988: get_item varchar2(500);
989: LAST_UPDATE_WHERE varchar2(500);
990: begin
991: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');
992:
993: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
994:
995: oe_profile.get(

Line 993: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');

989: LAST_UPDATE_WHERE varchar2(500);
990: begin
991: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');
992:
993: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
994:
995: oe_profile.get(
996: name => 'SO_ID_FLEX_CODE',
997: val => var.so_id_flex_code);

Line 1000: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_ORG_ID');

996: name => 'SO_ID_FLEX_CODE',
997: val => var.so_id_flex_code);
998:
999:
1000: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_ORG_ID');
1001:
1002: oe_profile.get(
1003: name => 'SO_ORGANIZATION_ID',
1004: val => var.so_organization_id);

Line 1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

1043: p_qualifier => 'GL_ACCOUNT');
1044:
1045: --
1046: -- Assign another column specific to this report
1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');

Line 1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');

1045: --
1046: -- Assign another column specific to this report
1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

Line 1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1046: -- Assign another column specific to this report
1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

Line 1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');

1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

Line 1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);

1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

Line 1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

Line 1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

Line 1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

Line 1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:

Line 1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --

Line 1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --
1062: -- Add to the FROM clause specific to this report

Line 1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --
1062: -- Add to the FROM clause specific to this report
1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

Line 1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --
1062: -- Add to the FROM clause specific to this report
1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1064: fa_rx_util_pkg.From_Clause :=
1065: fa_rx_util_pkg.From_Clause || ',
1066: RA_CUSTOMER_TRX_LINES CTL,
1067: RA_CUST_TRX_LINE_GL_DIST DIST,

Line 1064: fa_rx_util_pkg.From_Clause :=

1060:
1061: --
1062: -- Add to the FROM clause specific to this report
1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1064: fa_rx_util_pkg.From_Clause :=
1065: fa_rx_util_pkg.From_Clause || ',
1066: RA_CUSTOMER_TRX_LINES CTL,
1067: RA_CUST_TRX_LINE_GL_DIST DIST,
1068: MTL_SYSTEM_ITEMS ITEM,

Line 1065: fa_rx_util_pkg.From_Clause || ',

1061: --
1062: -- Add to the FROM clause specific to this report
1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1064: fa_rx_util_pkg.From_Clause :=
1065: fa_rx_util_pkg.From_Clause || ',
1066: RA_CUSTOMER_TRX_LINES CTL,
1067: RA_CUST_TRX_LINE_GL_DIST DIST,
1068: MTL_SYSTEM_ITEMS ITEM,
1069: AR_MEMO_LINES MEMO,

Line 1074: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');

1070: GL_CODE_COMBINATIONS CCDIST';
1071:
1072: --
1073: -- Add to the WHERE clause specific to this report
1074: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1075:
1076: IF var.last_updated_by is null THEN
1077: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,
1078: :start_update_date,:end_update_date) = ''Y'' ';

Line 1084: fa_rx_util_pkg.Where_Clause :=

1080: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',
1081: :start_update_date,:end_update_date) = ''Y'' ';
1082: END IF;
1083:
1084: fa_rx_util_pkg.Where_Clause :=
1085: fa_rx_util_pkg.Where_Clause || '
1086: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID
1087: AND ITEM.ORGANIZATION_ID(+) = '|| var.so_organization_id ||'
1088: AND CTL.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID(+)

Line 1085: fa_rx_util_pkg.Where_Clause || '

1081: :start_update_date,:end_update_date) = ''Y'' ';
1082: END IF;
1083:
1084: fa_rx_util_pkg.Where_Clause :=
1085: fa_rx_util_pkg.Where_Clause || '
1086: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID
1087: AND ITEM.ORGANIZATION_ID(+) = '|| var.so_organization_id ||'
1088: AND CTL.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID(+)
1089: AND CTL.MEMO_LINE_ID = MEMO.MEMO_LINE_ID(+)

Line 1096: fa_rx_util_pkg.debug('arrx_tx.check_before_report()-');

1092: AND DIST.ACCOUNT_SET_FLAG = ''N''
1093: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID '||
1094: LAST_UPDATE_WHERE;
1095:
1096: fa_rx_util_pkg.debug('arrx_tx.check_before_report()-');
1097:
1098: end check_before_report;
1099:
1100:

Line 1106: fa_rx_util_pkg.debug('AR_GET_BIND');

1102: -- This is the bind trigger for the main artx_rep report
1103: procedure check_bind(c in integer)
1104: is
1105: begin
1106: fa_rx_util_pkg.debug('AR_GET_BIND');
1107: --
1108: -- These bind variables(Date Type) were included in the WHERE clause
1109: --
1110: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);

Line 1125: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');

1121:
1122: --
1123: -- Get FLEX FIELD VALUE and DESCRIPTION
1124: --
1125: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1126:
1127: /* var.account := fa_rx_flex_pkg.get_value(
1128: p_application_id => 101,
1129: p_id_flex_code => 'GL#',

Line 1209: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()+');

1205: start_bill_to_customer_number varchar2(30) := NULL;
1206: end_bill_to_customer_number varchar2(30) := NULL;
1207:
1208: begin
1209: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()+');
1210:
1211: --
1212: -- Assign parameters to global variable
1213: -- These values will be used within the before_report trigger

Line 1218: fa_rx_util_pkg.debug('start_due_date = '|| var.start_due_date);

1214:
1215: var.start_due_date := Trunc(start_due_date);
1216: var.end_due_date := Trunc(end_due_date)+1-1/24/60/60;
1217:
1218: fa_rx_util_pkg.debug('start_due_date = '|| var.start_due_date);
1219: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1220:
1221: --
1222: -- Initialize request

Line 1219: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);

1215: var.start_due_date := Trunc(start_due_date);
1216: var.end_due_date := Trunc(end_due_date)+1-1/24/60/60;
1217:
1218: fa_rx_util_pkg.debug('start_due_date = '|| var.start_due_date);
1219: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1220:
1221: --
1222: -- Initialize request
1223: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');

Line 1223: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');

1219: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1220:
1221: --
1222: -- Initialize request
1223: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');
1224:
1225: --
1226: -- Call the main journal report
1227:

Line 1265: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',

1261:
1262: --
1263: -- Assign triggers specific to this report
1264: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1265: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1266: true,
1267: 'arrx_tx.forecast_before_report;',
1268: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',
1269: null,

Line 1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);

1271:
1272: --
1273: -- Run the report.
1274: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1276:
1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1278:
1279: exception

Line 1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');

1273: -- Run the report.
1274: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1276:
1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1278:
1279: exception
1280: when others then
1281: fa_rx_util_pkg.log(sqlcode);

Line 1281: fa_rx_util_pkg.log(sqlcode);

1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1278:
1279: exception
1280: when others then
1281: fa_rx_util_pkg.log(sqlcode);
1282: fa_rx_util_pkg.log(sqlerrm);
1283: fa_rx_util_pkg.debug(sqlcode);
1284: fa_rx_util_pkg.debug(sqlerrm);
1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');

Line 1282: fa_rx_util_pkg.log(sqlerrm);

1278:
1279: exception
1280: when others then
1281: fa_rx_util_pkg.log(sqlcode);
1282: fa_rx_util_pkg.log(sqlerrm);
1283: fa_rx_util_pkg.debug(sqlcode);
1284: fa_rx_util_pkg.debug(sqlerrm);
1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1286: end artx_rep_forecast;

Line 1283: fa_rx_util_pkg.debug(sqlcode);

1279: exception
1280: when others then
1281: fa_rx_util_pkg.log(sqlcode);
1282: fa_rx_util_pkg.log(sqlerrm);
1283: fa_rx_util_pkg.debug(sqlcode);
1284: fa_rx_util_pkg.debug(sqlerrm);
1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1286: end artx_rep_forecast;
1287:

Line 1284: fa_rx_util_pkg.debug(sqlerrm);

1280: when others then
1281: fa_rx_util_pkg.log(sqlcode);
1282: fa_rx_util_pkg.log(sqlerrm);
1283: fa_rx_util_pkg.debug(sqlcode);
1284: fa_rx_util_pkg.debug(sqlerrm);
1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1286: end artx_rep_forecast;
1287:
1288: --

Line 1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');

1281: fa_rx_util_pkg.log(sqlcode);
1282: fa_rx_util_pkg.log(sqlerrm);
1283: fa_rx_util_pkg.debug(sqlcode);
1284: fa_rx_util_pkg.debug(sqlerrm);
1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1286: end artx_rep_forecast;
1287:
1288: --
1289: -- This is the before report trigger for the artx_rep_forecast report.

Line 1294: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');

1290: procedure forecast_before_report
1291: is
1292: SCHEDULE_DUE_DATE_WHERE varchar2(500);
1293: begin
1294: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');
1295:
1296: --
1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

Line 1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

1294: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');
1295:
1296: --
1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1299:
1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1302:

Line 1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');

1296: --
1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1299:
1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1302:
1303: --
1304: -- Add to the FROM clause specific to this report

Line 1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1299:
1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1302:
1303: --
1304: -- Add to the FROM clause specific to this report
1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

Line 1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1302:
1303: --
1304: -- Add to the FROM clause specific to this report
1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1306: fa_rx_util_pkg.From_Clause := '
1307: AR_PAYMENT_SCHEDULES PS,'||
1308: fa_rx_util_pkg.From_Clause || ',
1309: AR_CONS_INV CONS_INV';

Line 1306: fa_rx_util_pkg.From_Clause := '

1302:
1303: --
1304: -- Add to the FROM clause specific to this report
1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1306: fa_rx_util_pkg.From_Clause := '
1307: AR_PAYMENT_SCHEDULES PS,'||
1308: fa_rx_util_pkg.From_Clause || ',
1309: AR_CONS_INV CONS_INV';
1310:

Line 1308: fa_rx_util_pkg.From_Clause || ',

1304: -- Add to the FROM clause specific to this report
1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1306: fa_rx_util_pkg.From_Clause := '
1307: AR_PAYMENT_SCHEDULES PS,'||
1308: fa_rx_util_pkg.From_Clause || ',
1309: AR_CONS_INV CONS_INV';
1310:
1311: --
1312: -- Add to the WHERE clause specific to this report

Line 1313: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');

1309: AR_CONS_INV CONS_INV';
1310:
1311: --
1312: -- Add to the WHERE clause specific to this report
1313: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1314:
1315: IF var.start_due_date IS NULL AND var.end_due_date IS NULL THEN
1316: SCHEDULE_DUE_DATE_WHERE := NULL;
1317: ELSIF var.start_due_date IS NULL THEN

Line 1325: fa_rx_util_pkg.Where_Clause :=

1321: ELSE
1322: SCHEDULE_DUE_DATE_WHERE := ' AND PS.DUE_DATE BETWEEN :start_due_date AND :end_due_date';
1323: END IF;
1324:
1325: fa_rx_util_pkg.Where_Clause :=
1326: fa_rx_util_pkg.Where_Clause || '
1327: AND CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
1328: AND PS.STATUS = ''OP''
1329: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||

Line 1326: fa_rx_util_pkg.Where_Clause || '

1322: SCHEDULE_DUE_DATE_WHERE := ' AND PS.DUE_DATE BETWEEN :start_due_date AND :end_due_date';
1323: END IF;
1324:
1325: fa_rx_util_pkg.Where_Clause :=
1326: fa_rx_util_pkg.Where_Clause || '
1327: AND CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
1328: AND PS.STATUS = ''OP''
1329: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||
1330: SCHEDULE_DUE_DATE_WHERE;

Line 1332: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()-');

1328: AND PS.STATUS = ''OP''
1329: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||
1330: SCHEDULE_DUE_DATE_WHERE;
1331:
1332: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()-');
1333:
1334: end forecast_before_report;
1335:
1336:

Line 1342: fa_rx_util_pkg.debug('AR_GET_BIND');

1338: -- This is the bind trigger for the main artx_rep report
1339: procedure forecast_bind(c in integer)
1340: is
1341: begin
1342: fa_rx_util_pkg.debug('AR_GET_BIND');
1343: --
1344: -- These bind variables(Date Type) were included in the WHERE clause
1345: --
1346: IF var.start_due_date IS NOT NULL THEN

Line 1398: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()+');

1394: end_transaction_class varchar2(20) := NULL;
1395: payment_method varchar2(30) := NULL;
1396:
1397: begin
1398: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()+');
1399: --
1400: -- Set global variables (This variable will be used in before report trigger.)
1401: --
1402: var.line_invoice := line_invoice;

Line 1414: fa_rx_util_pkg.init_request('arrx_tx.artx_sales_rep',request_id,'AR_TRANSACTIONS_REP_ITF');

1410: var.end_amount := end_amount;
1411:
1412: --
1413: -- Initialize request
1414: fa_rx_util_pkg.init_request('arrx_tx.artx_sales_rep',request_id,'AR_TRANSACTIONS_REP_ITF');
1415:
1416: --
1417: -- Call the main journal report
1418:

Line 1456: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',

1452:
1453: --
1454: -- Assign triggers specific to this report
1455: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1456: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1457: true,
1458: 'arrx_tx.sales_before_report;',
1459: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1460: 'arrx_tx.sales_after_fetch;',

Line 1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);

1462:
1463: --
1464: -- Run the report.
1465: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1467:
1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1469:
1470: exception

Line 1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');

1464: -- Run the report.
1465: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1467:
1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1469:
1470: exception
1471: when others then
1472: fa_rx_util_pkg.log(sqlcode);

Line 1472: fa_rx_util_pkg.log(sqlcode);

1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1469:
1470: exception
1471: when others then
1472: fa_rx_util_pkg.log(sqlcode);
1473: fa_rx_util_pkg.log(sqlerrm);
1474: fa_rx_util_pkg.debug(sqlcode);
1475: fa_rx_util_pkg.debug(sqlerrm);
1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');

Line 1473: fa_rx_util_pkg.log(sqlerrm);

1469:
1470: exception
1471: when others then
1472: fa_rx_util_pkg.log(sqlcode);
1473: fa_rx_util_pkg.log(sqlerrm);
1474: fa_rx_util_pkg.debug(sqlcode);
1475: fa_rx_util_pkg.debug(sqlerrm);
1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1477: end artx_sales_rep;

Line 1474: fa_rx_util_pkg.debug(sqlcode);

1470: exception
1471: when others then
1472: fa_rx_util_pkg.log(sqlcode);
1473: fa_rx_util_pkg.log(sqlerrm);
1474: fa_rx_util_pkg.debug(sqlcode);
1475: fa_rx_util_pkg.debug(sqlerrm);
1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1477: end artx_sales_rep;
1478:

Line 1475: fa_rx_util_pkg.debug(sqlerrm);

1471: when others then
1472: fa_rx_util_pkg.log(sqlcode);
1473: fa_rx_util_pkg.log(sqlerrm);
1474: fa_rx_util_pkg.debug(sqlcode);
1475: fa_rx_util_pkg.debug(sqlerrm);
1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1477: end artx_sales_rep;
1478:
1479:

Line 1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');

1472: fa_rx_util_pkg.log(sqlcode);
1473: fa_rx_util_pkg.log(sqlerrm);
1474: fa_rx_util_pkg.debug(sqlcode);
1475: fa_rx_util_pkg.debug(sqlerrm);
1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1477: end artx_sales_rep;
1478:
1479:
1480: --

Line 1499: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');

1495: amount_where varchar2(1000); -- where-clause statement for line amounts
1496: line_select_statement varchar2(1000); -- where-clause statement for sub-query of line information
1497:
1498: begin
1499: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');
1500:
1501: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1502:
1503: oe_profile.get(

Line 1501: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');

1497:
1498: begin
1499: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');
1500:
1501: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1502:
1503: oe_profile.get(
1504: name => 'SO_ID_FLEX_CODE',
1505: val => var.so_id_flex_code);

Line 1508: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_ORG_ID');

1504: name => 'SO_ID_FLEX_CODE',
1505: val => var.so_id_flex_code);
1506:
1507:
1508: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_ORG_ID');
1509:
1510: oe_profile.get(
1511: name => 'SO_ORGANIZATION_ID',
1512: val => var.so_organization_id);

Line 1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

1703: end if;
1704:
1705: --
1706: -- Assign another column specific to this report
1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');

Line 1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');

1705: --
1706: -- Assign another column specific to this report
1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

Line 1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1706: -- Assign another column specific to this report
1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

Line 1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');

1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

Line 1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);

1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

Line 1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

Line 1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

Line 1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

Line 1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);

Line 1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:

Line 1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --

Line 1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --
1723: -- Add to the FROM clause specific to this report

Line 1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);

1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --
1723: -- Add to the FROM clause specific to this report
1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

Line 1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --
1723: -- Add to the FROM clause specific to this report
1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1725: fa_rx_util_pkg.From_Clause :=
1726: fa_rx_util_pkg.From_Clause || ',
1727: RA_CUSTOMER_TRX_LINES CTL,
1728: RA_CUST_TRX_LINE_GL_DIST DIST,

Line 1725: fa_rx_util_pkg.From_Clause :=

1721:
1722: --
1723: -- Add to the FROM clause specific to this report
1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1725: fa_rx_util_pkg.From_Clause :=
1726: fa_rx_util_pkg.From_Clause || ',
1727: RA_CUSTOMER_TRX_LINES CTL,
1728: RA_CUST_TRX_LINE_GL_DIST DIST,
1729: MTL_SYSTEM_ITEMS ITEM,

Line 1726: fa_rx_util_pkg.From_Clause || ',

1722: --
1723: -- Add to the FROM clause specific to this report
1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1725: fa_rx_util_pkg.From_Clause :=
1726: fa_rx_util_pkg.From_Clause || ',
1727: RA_CUSTOMER_TRX_LINES CTL,
1728: RA_CUST_TRX_LINE_GL_DIST DIST,
1729: MTL_SYSTEM_ITEMS ITEM,
1730: AR_MEMO_LINES MEMO,

Line 1735: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');

1731: GL_CODE_COMBINATIONS CCDIST';
1732:
1733: --
1734: -- Add to the WHERE clause specific to this report
1735: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1736:
1737: if var.line_invoice = 'LINE' then
1738: fa_rx_util_pkg.Where_Clause :=
1739: fa_rx_util_pkg.Where_Clause || '

Line 1738: fa_rx_util_pkg.Where_Clause :=

1734: -- Add to the WHERE clause specific to this report
1735: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1736:
1737: if var.line_invoice = 'LINE' then
1738: fa_rx_util_pkg.Where_Clause :=
1739: fa_rx_util_pkg.Where_Clause || '
1740: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID'||
1741: transaction_number_where ||
1742: natural_account_where ||

Line 1739: fa_rx_util_pkg.Where_Clause || '

1735: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1736:
1737: if var.line_invoice = 'LINE' then
1738: fa_rx_util_pkg.Where_Clause :=
1739: fa_rx_util_pkg.Where_Clause || '
1740: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID'||
1741: transaction_number_where ||
1742: natural_account_where ||
1743: account_where ||'

Line 1775: fa_rx_util_pkg.Where_Clause :=

1771: else
1772: line_select_statement := null;
1773: end if;
1774:
1775: fa_rx_util_pkg.Where_Clause :=
1776: fa_rx_util_pkg.Where_Clause ||
1777: line_select_statement ||
1778: transaction_number_where ||
1779: natural_account_where ||'

Line 1776: fa_rx_util_pkg.Where_Clause ||

1772: line_select_statement := null;
1773: end if;
1774:
1775: fa_rx_util_pkg.Where_Clause :=
1776: fa_rx_util_pkg.Where_Clause ||
1777: line_select_statement ||
1778: transaction_number_where ||
1779: natural_account_where ||'
1780: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID

Line 1790: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()-');

1786: AND DIST.ACCOUNT_SET_FLAG = ''N''
1787: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID ';
1788: end if;
1789:
1790: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()-');
1791:
1792: end sales_before_report;
1793:
1794: procedure sales_bind(c in integer)

Line 1797: fa_rx_util_pkg.debug('AR_GET_BIND');

1793:
1794: procedure sales_bind(c in integer)
1795: is
1796: begin
1797: fa_rx_util_pkg.debug('AR_GET_BIND');
1798: --
1799: -- These bind variables(Date Type) were included in the WHERE clause
1800: --
1801: IF var.start_invoice_num IS NOT NULL THEN

Line 1825: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');

1821:
1822: --
1823: -- Get FLEX FIELD VALUE and DESCRIPTION
1824: --
1825: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1826:
1827: var.account_desc := substrb(fa_rx_flex_pkg.get_description(
1828: p_application_id => 101,
1829: p_id_flex_code => 'GL#',