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 547: fa_rx_util_pkg.debug('AR_GET_BILLING_NUMBER');

543:
544: --
545: -- Get BILLING NUMBER Function
546: --
547: fa_rx_util_pkg.debug('AR_GET_BILLING_NUMBER');
548: /* fnd_profile.get(
549: name => 'AR_SHOW_BILLING_NUMBER',
550: val => var.bill_flag);
551: */

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

598: var.tax_header_level_flag := NVL(var.tax_header_level_flag,'N');
599: --
600: -- Assign SELECT list
601: --
602: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
603:
604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');

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

600: -- Assign SELECT list
601: --
602: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
603:
604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);

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

602: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
603:
604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);

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

603:
604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

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

604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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 609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');

605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);

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

606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);

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

607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);

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

608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

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

609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

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

610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

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

611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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 616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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 617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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 618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');

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

615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);

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

616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');

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

617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');

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

618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

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

619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');

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

620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date

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

621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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 626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);

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

623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

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

625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

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

626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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 631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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 632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');

628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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 633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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 634: 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);

630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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 635: 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);

631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);

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

632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);

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

633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);

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

634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);

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

635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id

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

636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);

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

637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);

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

638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
646: -->>SELECT_END<<--

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

640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
646: -->>SELECT_END<<--
647:
648:

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

641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
646: -->>SELECT_END<<--
647:
648:
649: --

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

648:
649: --
650: -- Assign From Clause
651: --
652: fa_rx_util_pkg.debug('AR_ASSIGN_FORM_CLAUSE');
653:
654: -- bug3940958 changed to _ALL for cross-org
655: IF var.ca_sob_type = 'P'
656: THEN

Line 657: fa_rx_util_pkg.From_Clause := 'RA_CUST_TRX_LINE_GL_DIST RECDIST,

653:
654: -- bug3940958 changed to _ALL for cross-org
655: IF var.ca_sob_type = 'P'
656: THEN
657: fa_rx_util_pkg.From_Clause := 'RA_CUST_TRX_LINE_GL_DIST RECDIST,
658: RA_CUSTOMER_TRX CT,
659: RA_CUST_TRX_TYPES TRX_TYPE,
660: HZ_CUST_ACCOUNTS BILL_TO,
661: HZ_PARTIES PARTY,

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

663: AR_RECEIPT_METHODS METHODS,
664: FND_DOCUMENT_SEQUENCES DOC_SEQ,
665: AR_SYSTEM_PARAMETERS SYSPARAM';
666: ELSE
667: fa_rx_util_pkg.From_Clause := 'RA_TRX_LINE_GL_DIST_ALL_MRC_V RECDIST,
668: RA_CUSTOMER_TRX_ALL_MRC_V CT,
669: RA_CUST_TRX_TYPES_ALL TRX_TYPE,
670: HZ_CUST_ACCOUNTS_ALL BILL_TO,
671: HZ_PARTIES PARTY,

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

676:
677: --
678: -- Assign Where Clause (including the where clause from the parameters)
679: --
680: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');
681:
682:
683: -- bug:3256137
684:

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

682:
683: -- bug:3256137
684:
685: -- bug3940958 added where condition for cross-org and new paramereters
686: fa_rx_util_pkg.Where_Clause := 'CT.CUST_TRX_TYPE_ID = TRX_TYPE.CUST_TRX_TYPE_ID
687: AND CT.BILL_TO_CUSTOMER_ID = BILL_TO.CUST_ACCOUNT_ID
688: AND BILL_TO.PARTY_ID = PARTY.PARTY_ID
689: AND CT.receipt_method_id = METHODS.receipt_method_id(+)
690: AND CT.CUSTOMER_TRX_ID = RECDIST.CUSTOMER_TRX_ID

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

709: DOC_SEQUENCE_NUMBER_WHERE || ' ' ||
710: BATCH_SOURCE_WHERE || ' ' ||
711: REC_ACCOUNT_WHERE ;
712:
713: fa_rx_util_pkg.debug('arrx_tx.before_report()-');
714:
715: end before_report;
716:
717:

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

723: b_j_type_n varchar2(80);
724: YES_NO_Y varchar2(80);
725: YES_NO_N varchar2(80);
726: begin
727: fa_rx_util_pkg.debug('AR_GET_BIND');
728: --
729: -- These bind variables(Date Type) were included in the WHERE clause
730: --
731: IF var.start_gl_date IS NOT NULL THEN

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

826: begin
827: --
828: -- Get FLEX FIELD VALUE and DESCRIPTION
829: --
830: fa_rx_util_pkg.debug('GL_GET_FLEX_KEYWORD');
831:
832: /* var.rec_account := fa_rx_flex_pkg.get_value(
833: p_application_id => 101,
834: p_id_flex_code => 'GL#',

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

910: -- Customer Number parameter declarations
911: start_bill_to_customer_number varchar2(30) := NULL;
912: end_bill_to_customer_number varchar2(30) := NULL;
913: begin
914: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()+');
915:
916: --
917: -- Assign parameters to global variable
918: -- These values will be used within the before_report trigger

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

920: var.start_update_date := Trunc(start_update_date);
921: var.end_update_date := Trunc(end_update_date)+1-1/24/60/60;
922: var.last_updated_by := last_updated_by;
923:
924: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);
925: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);
926: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
927:
928: --

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

921: var.end_update_date := Trunc(end_update_date)+1-1/24/60/60;
922: var.last_updated_by := last_updated_by;
923:
924: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);
925: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);
926: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
927:
928: --
929: -- Initialize request

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

922: var.last_updated_by := last_updated_by;
923:
924: fa_rx_util_pkg.debug('start_update_date = '|| var.start_update_date);
925: fa_rx_util_pkg.debug('end_update_date = '|| var.end_update_date);
926: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
927:
928: --
929: -- Initialize request
930: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');

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

926: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
927:
928: --
929: -- Initialize request
930: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');
931:
932: --
933: -- Call the main journal report
934:

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

969:
970: --
971: -- Assign triggers specific to this report
972: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
973: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
974: true,
975: 'arrx_tx.check_before_report;',
976: 'arrx_tx.check_bind(:CURSOR_SELECT);',
977: 'arrx_tx.check_after_fetch;',

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

979:
980: --
981: -- Run the report.
982: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
983: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
984:
985: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
986:
987: exception

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

981: -- Run the report.
982: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
983: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
984:
985: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
986:
987: exception
988: when others then
989: fa_rx_util_pkg.log(sqlcode);

Line 989: fa_rx_util_pkg.log(sqlcode);

985: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
986:
987: exception
988: when others then
989: fa_rx_util_pkg.log(sqlcode);
990: fa_rx_util_pkg.log(sqlerrm);
991: fa_rx_util_pkg.debug(sqlcode);
992: fa_rx_util_pkg.debug(sqlerrm);
993: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');

Line 990: fa_rx_util_pkg.log(sqlerrm);

986:
987: exception
988: when others then
989: fa_rx_util_pkg.log(sqlcode);
990: fa_rx_util_pkg.log(sqlerrm);
991: fa_rx_util_pkg.debug(sqlcode);
992: fa_rx_util_pkg.debug(sqlerrm);
993: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
994: end artx_rep_check;

Line 991: fa_rx_util_pkg.debug(sqlcode);

987: exception
988: when others then
989: fa_rx_util_pkg.log(sqlcode);
990: fa_rx_util_pkg.log(sqlerrm);
991: fa_rx_util_pkg.debug(sqlcode);
992: fa_rx_util_pkg.debug(sqlerrm);
993: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
994: end artx_rep_check;
995:

Line 992: fa_rx_util_pkg.debug(sqlerrm);

988: when others then
989: fa_rx_util_pkg.log(sqlcode);
990: fa_rx_util_pkg.log(sqlerrm);
991: fa_rx_util_pkg.debug(sqlcode);
992: fa_rx_util_pkg.debug(sqlerrm);
993: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
994: end artx_rep_check;
995:
996:

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

989: fa_rx_util_pkg.log(sqlcode);
990: fa_rx_util_pkg.log(sqlerrm);
991: fa_rx_util_pkg.debug(sqlcode);
992: fa_rx_util_pkg.debug(sqlerrm);
993: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
994: end artx_rep_check;
995:
996:
997: --

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

1005: decode_inv varchar2(500);
1006: get_item varchar2(500);
1007: LAST_UPDATE_WHERE varchar2(500);
1008: begin
1009: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');
1010:
1011: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1012:
1013: oe_profile.get(

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

1007: LAST_UPDATE_WHERE varchar2(500);
1008: begin
1009: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');
1010:
1011: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1012:
1013: oe_profile.get(
1014: name => 'SO_ID_FLEX_CODE',
1015: val => var.so_id_flex_code);

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

1014: name => 'SO_ID_FLEX_CODE',
1015: val => var.so_id_flex_code);
1016:
1017:
1018: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_ORG_ID');
1019:
1020: oe_profile.get(
1021: name => 'SO_ORGANIZATION_ID',
1022: val => var.so_organization_id);

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

1061: p_qualifier => 'GL_ACCOUNT');
1062:
1063: --
1064: -- Assign another column specific to this report
1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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 1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');

1063: --
1064: -- Assign another column specific to this report
1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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 1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1064: -- Assign another column specific to this report
1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

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

1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

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

1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

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

1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

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

1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

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

1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

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

1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:

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

1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --

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

1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --
1080: -- Add to the FROM clause specific to this report

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

1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --
1080: -- Add to the FROM clause specific to this report
1081: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

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

1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --
1080: -- Add to the FROM clause specific to this report
1081: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1082: fa_rx_util_pkg.From_Clause :=
1083: fa_rx_util_pkg.From_Clause || ',
1084: RA_CUSTOMER_TRX_LINES CTL,
1085: RA_CUST_TRX_LINE_GL_DIST DIST,

Line 1082: fa_rx_util_pkg.From_Clause :=

1078:
1079: --
1080: -- Add to the FROM clause specific to this report
1081: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1082: fa_rx_util_pkg.From_Clause :=
1083: fa_rx_util_pkg.From_Clause || ',
1084: RA_CUSTOMER_TRX_LINES CTL,
1085: RA_CUST_TRX_LINE_GL_DIST DIST,
1086: MTL_SYSTEM_ITEMS ITEM,

Line 1083: fa_rx_util_pkg.From_Clause || ',

1079: --
1080: -- Add to the FROM clause specific to this report
1081: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1082: fa_rx_util_pkg.From_Clause :=
1083: fa_rx_util_pkg.From_Clause || ',
1084: RA_CUSTOMER_TRX_LINES CTL,
1085: RA_CUST_TRX_LINE_GL_DIST DIST,
1086: MTL_SYSTEM_ITEMS ITEM,
1087: AR_MEMO_LINES MEMO,

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

1088: GL_CODE_COMBINATIONS CCDIST';
1089:
1090: --
1091: -- Add to the WHERE clause specific to this report
1092: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1093:
1094: IF var.last_updated_by is null THEN
1095: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,
1096: :start_update_date,:end_update_date) = ''Y'' ';

Line 1102: fa_rx_util_pkg.Where_Clause :=

1098: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',
1099: :start_update_date,:end_update_date) = ''Y'' ';
1100: END IF;
1101:
1102: fa_rx_util_pkg.Where_Clause :=
1103: fa_rx_util_pkg.Where_Clause || '
1104: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID
1105: AND ITEM.ORGANIZATION_ID(+) = '|| var.so_organization_id ||'
1106: AND CTL.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID(+)

Line 1103: fa_rx_util_pkg.Where_Clause || '

1099: :start_update_date,:end_update_date) = ''Y'' ';
1100: END IF;
1101:
1102: fa_rx_util_pkg.Where_Clause :=
1103: fa_rx_util_pkg.Where_Clause || '
1104: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID
1105: AND ITEM.ORGANIZATION_ID(+) = '|| var.so_organization_id ||'
1106: AND CTL.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID(+)
1107: AND CTL.MEMO_LINE_ID = MEMO.MEMO_LINE_ID(+)

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

1110: AND DIST.ACCOUNT_SET_FLAG = ''N''
1111: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID '||
1112: LAST_UPDATE_WHERE;
1113:
1114: fa_rx_util_pkg.debug('arrx_tx.check_before_report()-');
1115:
1116: end check_before_report;
1117:
1118:

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

1120: -- This is the bind trigger for the main artx_rep report
1121: procedure check_bind(c in integer)
1122: is
1123: begin
1124: fa_rx_util_pkg.debug('AR_GET_BIND');
1125: --
1126: -- These bind variables(Date Type) were included in the WHERE clause
1127: --
1128: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);

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

1139:
1140: --
1141: -- Get FLEX FIELD VALUE and DESCRIPTION
1142: --
1143: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1144:
1145: /* var.account := fa_rx_flex_pkg.get_value(
1146: p_application_id => 101,
1147: p_id_flex_code => 'GL#',

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

1223: start_bill_to_customer_number varchar2(30) := NULL;
1224: end_bill_to_customer_number varchar2(30) := NULL;
1225:
1226: begin
1227: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()+');
1228:
1229: --
1230: -- Assign parameters to global variable
1231: -- These values will be used within the before_report trigger

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

1232:
1233: var.start_due_date := Trunc(start_due_date);
1234: var.end_due_date := Trunc(end_due_date)+1-1/24/60/60;
1235:
1236: fa_rx_util_pkg.debug('start_due_date = '|| var.start_due_date);
1237: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1238:
1239: --
1240: -- Initialize request

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

1233: var.start_due_date := Trunc(start_due_date);
1234: var.end_due_date := Trunc(end_due_date)+1-1/24/60/60;
1235:
1236: fa_rx_util_pkg.debug('start_due_date = '|| var.start_due_date);
1237: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1238:
1239: --
1240: -- Initialize request
1241: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');

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

1237: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1238:
1239: --
1240: -- Initialize request
1241: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');
1242:
1243: --
1244: -- Call the main journal report
1245:

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

1279:
1280: --
1281: -- Assign triggers specific to this report
1282: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1283: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1284: true,
1285: 'arrx_tx.forecast_before_report;',
1286: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',
1287: null,

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

1289:
1290: --
1291: -- Run the report.
1292: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1293: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1294:
1295: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1296:
1297: exception

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

1291: -- Run the report.
1292: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1293: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1294:
1295: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1296:
1297: exception
1298: when others then
1299: fa_rx_util_pkg.log(sqlcode);

Line 1299: fa_rx_util_pkg.log(sqlcode);

1295: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1296:
1297: exception
1298: when others then
1299: fa_rx_util_pkg.log(sqlcode);
1300: fa_rx_util_pkg.log(sqlerrm);
1301: fa_rx_util_pkg.debug(sqlcode);
1302: fa_rx_util_pkg.debug(sqlerrm);
1303: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');

Line 1300: fa_rx_util_pkg.log(sqlerrm);

1296:
1297: exception
1298: when others then
1299: fa_rx_util_pkg.log(sqlcode);
1300: fa_rx_util_pkg.log(sqlerrm);
1301: fa_rx_util_pkg.debug(sqlcode);
1302: fa_rx_util_pkg.debug(sqlerrm);
1303: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1304: end artx_rep_forecast;

Line 1301: fa_rx_util_pkg.debug(sqlcode);

1297: exception
1298: when others then
1299: fa_rx_util_pkg.log(sqlcode);
1300: fa_rx_util_pkg.log(sqlerrm);
1301: fa_rx_util_pkg.debug(sqlcode);
1302: fa_rx_util_pkg.debug(sqlerrm);
1303: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1304: end artx_rep_forecast;
1305:

Line 1302: fa_rx_util_pkg.debug(sqlerrm);

1298: when others then
1299: fa_rx_util_pkg.log(sqlcode);
1300: fa_rx_util_pkg.log(sqlerrm);
1301: fa_rx_util_pkg.debug(sqlcode);
1302: fa_rx_util_pkg.debug(sqlerrm);
1303: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1304: end artx_rep_forecast;
1305:
1306: --

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

1299: fa_rx_util_pkg.log(sqlcode);
1300: fa_rx_util_pkg.log(sqlerrm);
1301: fa_rx_util_pkg.debug(sqlcode);
1302: fa_rx_util_pkg.debug(sqlerrm);
1303: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1304: end artx_rep_forecast;
1305:
1306: --
1307: -- This is the before report trigger for the artx_rep_forecast report.

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

1308: procedure forecast_before_report
1309: is
1310: SCHEDULE_DUE_DATE_WHERE varchar2(500);
1311: begin
1312: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');
1313:
1314: --
1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

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

1312: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');
1313:
1314: --
1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1317:
1318: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1319: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1320:

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

1314: --
1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1317:
1318: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1319: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1320:
1321: --
1322: -- Add to the FROM clause specific to this report

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

1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1317:
1318: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1319: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1320:
1321: --
1322: -- Add to the FROM clause specific to this report
1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

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

1319: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1320:
1321: --
1322: -- Add to the FROM clause specific to this report
1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1324: fa_rx_util_pkg.From_Clause := '
1325: AR_PAYMENT_SCHEDULES PS,'||
1326: fa_rx_util_pkg.From_Clause || ',
1327: AR_CONS_INV CONS_INV';

Line 1324: fa_rx_util_pkg.From_Clause := '

1320:
1321: --
1322: -- Add to the FROM clause specific to this report
1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1324: fa_rx_util_pkg.From_Clause := '
1325: AR_PAYMENT_SCHEDULES PS,'||
1326: fa_rx_util_pkg.From_Clause || ',
1327: AR_CONS_INV CONS_INV';
1328:

Line 1326: fa_rx_util_pkg.From_Clause || ',

1322: -- Add to the FROM clause specific to this report
1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1324: fa_rx_util_pkg.From_Clause := '
1325: AR_PAYMENT_SCHEDULES PS,'||
1326: fa_rx_util_pkg.From_Clause || ',
1327: AR_CONS_INV CONS_INV';
1328:
1329: --
1330: -- Add to the WHERE clause specific to this report

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

1327: AR_CONS_INV CONS_INV';
1328:
1329: --
1330: -- Add to the WHERE clause specific to this report
1331: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1332:
1333: IF var.start_due_date IS NULL AND var.end_due_date IS NULL THEN
1334: SCHEDULE_DUE_DATE_WHERE := NULL;
1335: ELSIF var.start_due_date IS NULL THEN

Line 1343: fa_rx_util_pkg.Where_Clause :=

1339: ELSE
1340: SCHEDULE_DUE_DATE_WHERE := ' AND PS.DUE_DATE BETWEEN :start_due_date AND :end_due_date';
1341: END IF;
1342:
1343: fa_rx_util_pkg.Where_Clause :=
1344: fa_rx_util_pkg.Where_Clause || '
1345: AND CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
1346: AND PS.STATUS = ''OP''
1347: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||

Line 1344: fa_rx_util_pkg.Where_Clause || '

1340: SCHEDULE_DUE_DATE_WHERE := ' AND PS.DUE_DATE BETWEEN :start_due_date AND :end_due_date';
1341: END IF;
1342:
1343: fa_rx_util_pkg.Where_Clause :=
1344: fa_rx_util_pkg.Where_Clause || '
1345: AND CT.CUSTOMER_TRX_ID = PS.CUSTOMER_TRX_ID
1346: AND PS.STATUS = ''OP''
1347: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||
1348: SCHEDULE_DUE_DATE_WHERE;

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

1346: AND PS.STATUS = ''OP''
1347: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||
1348: SCHEDULE_DUE_DATE_WHERE;
1349:
1350: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()-');
1351:
1352: end forecast_before_report;
1353:
1354:

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

1356: -- This is the bind trigger for the main artx_rep report
1357: procedure forecast_bind(c in integer)
1358: is
1359: begin
1360: fa_rx_util_pkg.debug('AR_GET_BIND');
1361: --
1362: -- These bind variables(Date Type) were included in the WHERE clause
1363: --
1364: IF var.start_due_date IS NOT NULL THEN

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

1412: end_transaction_class varchar2(20) := NULL;
1413: payment_method varchar2(30) := NULL;
1414:
1415: begin
1416: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()+');
1417: --
1418: -- Set global variables (This variable will be used in before report trigger.)
1419: --
1420: var.line_invoice := line_invoice;

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

1428: var.end_amount := end_amount;
1429:
1430: --
1431: -- Initialize request
1432: fa_rx_util_pkg.init_request('arrx_tx.artx_sales_rep',request_id,'AR_TRANSACTIONS_REP_ITF');
1433:
1434: --
1435: -- Call the main journal report
1436:

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

1470:
1471: --
1472: -- Assign triggers specific to this report
1473: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1474: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1475: true,
1476: 'arrx_tx.sales_before_report;',
1477: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1478: 'arrx_tx.sales_after_fetch;',

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

1480:
1481: --
1482: -- Run the report.
1483: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1484: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1485:
1486: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1487:
1488: exception

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

1482: -- Run the report.
1483: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1484: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1485:
1486: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1487:
1488: exception
1489: when others then
1490: fa_rx_util_pkg.log(sqlcode);

Line 1490: fa_rx_util_pkg.log(sqlcode);

1486: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1487:
1488: exception
1489: when others then
1490: fa_rx_util_pkg.log(sqlcode);
1491: fa_rx_util_pkg.log(sqlerrm);
1492: fa_rx_util_pkg.debug(sqlcode);
1493: fa_rx_util_pkg.debug(sqlerrm);
1494: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');

Line 1491: fa_rx_util_pkg.log(sqlerrm);

1487:
1488: exception
1489: when others then
1490: fa_rx_util_pkg.log(sqlcode);
1491: fa_rx_util_pkg.log(sqlerrm);
1492: fa_rx_util_pkg.debug(sqlcode);
1493: fa_rx_util_pkg.debug(sqlerrm);
1494: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1495: end artx_sales_rep;

Line 1492: fa_rx_util_pkg.debug(sqlcode);

1488: exception
1489: when others then
1490: fa_rx_util_pkg.log(sqlcode);
1491: fa_rx_util_pkg.log(sqlerrm);
1492: fa_rx_util_pkg.debug(sqlcode);
1493: fa_rx_util_pkg.debug(sqlerrm);
1494: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1495: end artx_sales_rep;
1496:

Line 1493: fa_rx_util_pkg.debug(sqlerrm);

1489: when others then
1490: fa_rx_util_pkg.log(sqlcode);
1491: fa_rx_util_pkg.log(sqlerrm);
1492: fa_rx_util_pkg.debug(sqlcode);
1493: fa_rx_util_pkg.debug(sqlerrm);
1494: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1495: end artx_sales_rep;
1496:
1497:

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

1490: fa_rx_util_pkg.log(sqlcode);
1491: fa_rx_util_pkg.log(sqlerrm);
1492: fa_rx_util_pkg.debug(sqlcode);
1493: fa_rx_util_pkg.debug(sqlerrm);
1494: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1495: end artx_sales_rep;
1496:
1497:
1498: --

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

1513: amount_where varchar2(1000); -- where-clause statement for line amounts
1514: line_select_statement varchar2(1000); -- where-clause statement for sub-query of line information
1515:
1516: begin
1517: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');
1518:
1519: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1520:
1521: oe_profile.get(

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

1515:
1516: begin
1517: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');
1518:
1519: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1520:
1521: oe_profile.get(
1522: name => 'SO_ID_FLEX_CODE',
1523: val => var.so_id_flex_code);

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

1522: name => 'SO_ID_FLEX_CODE',
1523: val => var.so_id_flex_code);
1524:
1525:
1526: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_ORG_ID');
1527:
1528: oe_profile.get(
1529: name => 'SO_ORGANIZATION_ID',
1530: val => var.so_organization_id);

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

1721: end if;
1722:
1723: --
1724: -- Assign another column specific to this report
1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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 1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');

1723: --
1724: -- Assign another column specific to this report
1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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 1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1724: -- Assign another column specific to this report
1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

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

1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

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

1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

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

1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

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

1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

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

1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

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

1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);

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

1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:

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

1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --

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

1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --
1741: -- Add to the FROM clause specific to this report

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

1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --
1741: -- Add to the FROM clause specific to this report
1742: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

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

1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --
1741: -- Add to the FROM clause specific to this report
1742: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1743: fa_rx_util_pkg.From_Clause :=
1744: fa_rx_util_pkg.From_Clause || ',
1745: RA_CUSTOMER_TRX_LINES CTL,
1746: RA_CUST_TRX_LINE_GL_DIST DIST,

Line 1743: fa_rx_util_pkg.From_Clause :=

1739:
1740: --
1741: -- Add to the FROM clause specific to this report
1742: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1743: fa_rx_util_pkg.From_Clause :=
1744: fa_rx_util_pkg.From_Clause || ',
1745: RA_CUSTOMER_TRX_LINES CTL,
1746: RA_CUST_TRX_LINE_GL_DIST DIST,
1747: MTL_SYSTEM_ITEMS ITEM,

Line 1744: fa_rx_util_pkg.From_Clause || ',

1740: --
1741: -- Add to the FROM clause specific to this report
1742: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');
1743: fa_rx_util_pkg.From_Clause :=
1744: fa_rx_util_pkg.From_Clause || ',
1745: RA_CUSTOMER_TRX_LINES CTL,
1746: RA_CUST_TRX_LINE_GL_DIST DIST,
1747: MTL_SYSTEM_ITEMS ITEM,
1748: AR_MEMO_LINES MEMO,

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

1749: GL_CODE_COMBINATIONS CCDIST';
1750:
1751: --
1752: -- Add to the WHERE clause specific to this report
1753: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1754:
1755: if var.line_invoice = 'LINE' then
1756: fa_rx_util_pkg.Where_Clause :=
1757: fa_rx_util_pkg.Where_Clause || '

Line 1756: fa_rx_util_pkg.Where_Clause :=

1752: -- Add to the WHERE clause specific to this report
1753: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1754:
1755: if var.line_invoice = 'LINE' then
1756: fa_rx_util_pkg.Where_Clause :=
1757: fa_rx_util_pkg.Where_Clause || '
1758: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID'||
1759: transaction_number_where ||
1760: natural_account_where ||

Line 1757: fa_rx_util_pkg.Where_Clause || '

1753: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1754:
1755: if var.line_invoice = 'LINE' then
1756: fa_rx_util_pkg.Where_Clause :=
1757: fa_rx_util_pkg.Where_Clause || '
1758: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID'||
1759: transaction_number_where ||
1760: natural_account_where ||
1761: account_where ||'

Line 1793: fa_rx_util_pkg.Where_Clause :=

1789: else
1790: line_select_statement := null;
1791: end if;
1792:
1793: fa_rx_util_pkg.Where_Clause :=
1794: fa_rx_util_pkg.Where_Clause ||
1795: line_select_statement ||
1796: transaction_number_where ||
1797: natural_account_where ||'

Line 1794: fa_rx_util_pkg.Where_Clause ||

1790: line_select_statement := null;
1791: end if;
1792:
1793: fa_rx_util_pkg.Where_Clause :=
1794: fa_rx_util_pkg.Where_Clause ||
1795: line_select_statement ||
1796: transaction_number_where ||
1797: natural_account_where ||'
1798: AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID

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

1804: AND DIST.ACCOUNT_SET_FLAG = ''N''
1805: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID ';
1806: end if;
1807:
1808: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()-');
1809:
1810: end sales_before_report;
1811:
1812: procedure sales_bind(c in integer)

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

1811:
1812: procedure sales_bind(c in integer)
1813: is
1814: begin
1815: fa_rx_util_pkg.debug('AR_GET_BIND');
1816: --
1817: -- These bind variables(Date Type) were included in the WHERE clause
1818: --
1819: IF var.start_invoice_num IS NOT NULL THEN

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

1839:
1840: --
1841: -- Get FLEX FIELD VALUE and DESCRIPTION
1842: --
1843: fa_rx_util_pkg.debug('AR_GET_FLEX_KEYWORD');
1844:
1845: var.account_desc := substrb(fa_rx_flex_pkg.get_description(
1846: p_application_id => 101,
1847: p_id_flex_code => 'GL#',