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

APPS.FV_APPLY_CASH_RECEIPT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 114: comments ar_receivable_applications.comments%TYPE,

110: anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE,
111: called_from VARCHAR2(100),
112: attribute_rec ar_receipt_api_pub.attribute_rec_type,
113: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
114: comments ar_receivable_applications.comments%TYPE,
115: issuer_name ar_cash_receipts.issuer_name%TYPE,
116: issue_date ar_cash_receipts.issue_date%TYPE,
117: issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE,
118: org_id ar_Cash_receipts.org_id%TYPE

Line 132: amount_applied ar_receivable_applications.amount_applied%TYPE,

128: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
129: trx_number ra_customer_trx.trx_number%TYPE,
130: installment ar_payment_schedules.terms_sequence_number%TYPE,
131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
132: amount_applied ar_receivable_applications.amount_applied%TYPE,
133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,

Line 133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,

129: trx_number ra_customer_trx.trx_number%TYPE,
130: installment ar_payment_schedules.terms_sequence_number%TYPE,
131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
132: amount_applied ar_receivable_applications.amount_applied%TYPE,
133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,

Line 134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,

130: installment ar_payment_schedules.terms_sequence_number%TYPE,
131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
132: amount_applied ar_receivable_applications.amount_applied%TYPE,
133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 135: discount ar_receivable_applications.earned_discount_taken%TYPE,

131: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
132: amount_applied ar_receivable_applications.amount_applied%TYPE,
133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,

Line 136: apply_date ar_receivable_applications.apply_date%TYPE,

132: amount_applied ar_receivable_applications.amount_applied%TYPE,
133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,
140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,

Line 137: apply_gl_date ar_receivable_applications.gl_date%TYPE,

133: amount_applied_from ar_receivable_applications.amount_applied_from%TYPE,
134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,
140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,
141: line_number ra_customer_trx_lines.line_number%TYPE,

Line 138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,

134: trans_to_receipt_rate ar_receivable_applications.trans_to_receipt_rate%TYPE,
135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,
140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,
141: line_number ra_customer_trx_lines.line_number%TYPE,
142: show_closed_invoices VARCHAR2(100),

Line 139: org_id ar_receivable_applications.org_id%TYPE,

135: discount ar_receivable_applications.earned_discount_taken%TYPE,
136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,
140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,
141: line_number ra_customer_trx_lines.line_number%TYPE,
142: show_closed_invoices VARCHAR2(100),
143: called_from VARCHAR2(100),

Line 140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,

136: apply_date ar_receivable_applications.apply_date%TYPE,
137: apply_gl_date ar_receivable_applications.gl_date%TYPE,
138: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
139: org_id ar_receivable_applications.org_id%TYPE,
140: customer_trx_line_id ar_receivable_applications.applied_customer_trx_line_id%TYPE,
141: line_number ra_customer_trx_lines.line_number%TYPE,
142: show_closed_invoices VARCHAR2(100),
143: called_from VARCHAR2(100),
144: move_deferred_tax VARCHAR2(100),

Line 145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,

141: line_number ra_customer_trx_lines.line_number%TYPE,
142: show_closed_invoices VARCHAR2(100),
143: called_from VARCHAR2(100),
144: move_deferred_tax VARCHAR2(100),
145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,
146: attribute_rec ar_receipt_api_pub.attribute_rec_type,
147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,

Line 148: comments ar_receivable_applications.comments%TYPE,

144: move_deferred_tax VARCHAR2(100),
145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,
146: attribute_rec ar_receipt_api_pub.attribute_rec_type,
147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,

Line 149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,

145: link_to_trx_hist_id ar_receivable_applications.link_to_trx_hist_id%TYPE,
146: attribute_rec ar_receipt_api_pub.attribute_rec_type,
147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,

Line 150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,

146: attribute_rec ar_receipt_api_pub.attribute_rec_type,
147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,
154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,

Line 151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,

147: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,
154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,
155: customer_reference ar_receivable_applications.customer_reference%TYPE

Line 152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,

148: comments ar_receivable_applications.comments%TYPE,
149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,
154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,
155: customer_reference ar_receivable_applications.customer_reference%TYPE
156: );

Line 153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,

149: payment_set_id ar_receivable_applications.payment_set_id%TYPE,
150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,
154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,
155: customer_reference ar_receivable_applications.customer_reference%TYPE
156: );
157:

Line 154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,

150: application_ref_type ar_receivable_applications.application_ref_type%TYPE,
151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,
154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,
155: customer_reference ar_receivable_applications.customer_reference%TYPE
156: );
157:
158: ------------------------------------------------------------------------

Line 155: customer_reference ar_receivable_applications.customer_reference%TYPE

151: application_ref_id ar_receivable_applications.application_ref_id%TYPE,
152: application_ref_num ar_receivable_applications.application_ref_num%TYPE,
153: secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE,
154: application_ref_reason ar_receivable_applications.application_ref_reason%TYPE,
155: customer_reference ar_receivable_applications.customer_reference%TYPE
156: );
157:
158: ------------------------------------------------------------------------
159: -- Parameters Required for OnAccount API --

Line 165: amount_applied ar_receivable_applications.amount_applied%TYPE,

161: TYPE OnAccountRecType IS RECORD
162: (
163: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
164: receipt_number ar_cash_receipts.receipt_number%TYPE,
165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,

Line 166: apply_date ar_receivable_applications.apply_date%TYPE,

162: (
163: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
164: receipt_number ar_cash_receipts.receipt_number%TYPE,
165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,
170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,

Line 167: apply_gl_date ar_receivable_applications.gl_date%TYPE,

163: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
164: receipt_number ar_cash_receipts.receipt_number%TYPE,
165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,
170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
171: comments ar_receivable_applications.comments%TYPE

Line 168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,

164: receipt_number ar_cash_receipts.receipt_number%TYPE,
165: amount_applied ar_receivable_applications.amount_applied%TYPE,
166: apply_date ar_receivable_applications.apply_date%TYPE,
167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,
170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
171: comments ar_receivable_applications.comments%TYPE
172: );

Line 171: comments ar_receivable_applications.comments%TYPE

167: apply_gl_date ar_receivable_applications.gl_date%TYPE,
168: -- ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE,
169: attribute_rec ar_receipt_api_pub.attribute_rec_type,
170: global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type,
171: comments ar_receivable_applications.comments%TYPE
172: );
173:
174: ------------------------------------------------------------------------
175: -- Data Structure Required for Debug. --

Line 1141: --* Tables Used : ar_receivable_applications SELECT *--

1137: --* : debug_msg *--
1138: --* : debug_init *--
1139: --* : debug_exit *--
1140: --* : error *--
1141: --* Tables Used : ar_receivable_applications SELECT *--
1142: --* Logic : For the specific Cash Receipt Id and Invoice Id see if there is any *--
1143: --* : data in the table ar_receivable_applications. *--
1144: --* : If not exit. *--
1145: --* : If there is any data in ar_receivable_applications, then call *--

Line 1143: --* : data in the table ar_receivable_applications. *--

1139: --* : debug_exit *--
1140: --* : error *--
1141: --* Tables Used : ar_receivable_applications SELECT *--
1142: --* Logic : For the specific Cash Receipt Id and Invoice Id see if there is any *--
1143: --* : data in the table ar_receivable_applications. *--
1144: --* : If not exit. *--
1145: --* : If there is any data in ar_receivable_applications, then call *--
1146: --* : ar_receipt_api_pub.unapply to unapply the invoice *--
1147: --* : If there is an error the return code in x_return_status will not be S*--

Line 1145: --* : If there is any data in ar_receivable_applications, then call *--

1141: --* Tables Used : ar_receivable_applications SELECT *--
1142: --* Logic : For the specific Cash Receipt Id and Invoice Id see if there is any *--
1143: --* : data in the table ar_receivable_applications. *--
1144: --* : If not exit. *--
1145: --* : If there is any data in ar_receivable_applications, then call *--
1146: --* : ar_receipt_api_pub.unapply to unapply the invoice *--
1147: --* : If there is an error the return code in x_return_status will not be S*--
1148: --* : If there is an error, check the contents of x_msg_count *--
1149: --* : If x_msg_count is 1 then the error message is obtained from *--

Line 1189: FROM ar_receivable_applications ara

1185: SELECT ara.amount_applied,
1186: ara.receivable_application_id
1187: INTO l_PreviousAmount,
1188: l_ReceivableApplicationId
1189: FROM ar_receivable_applications ara
1190: WHERE ara.cash_receipt_id = p_Receiptid
1191: AND ara.applied_customer_trx_id = p_InvoiceId;
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN

Line 1199: p_ErrorLoc := 'SELECT ar_receivable_applications';

1195: debug_msg (l_module_name, 'No Data Found');
1196: WHEN OTHERS THEN
1197: p_ErrorCode := g_FAILURE;
1198: p_ErrorDesc := SQLERRM;
1199: p_ErrorLoc := 'SELECT ar_receivable_applications';
1200: error
1201: (
1202: p_error_type => p_ErrorCode,
1203: p_pgm => l_module_name,