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.AR_PREPAYMENTS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 107: FROM ar_receivable_applications ra

103: WHERE
104: EXISTS
105: (
106: SELECT 1
107: FROM ar_receivable_applications ra
108: WHERE ra.cash_receipt_id = p_cash_receipt_id
109: AND applied_payment_schedule_id IN (-4, -5)
110: AND display = 'Y'
111: );

Line 179: p_receivable_application_id IN ar_receivable_applications.

175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.
180: receivable_application_id%TYPE DEFAULT NULL,
181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE
183: DEFAULT NULL,

Line 181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,

177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.
180: receivable_application_id%TYPE DEFAULT NULL,
181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE
183: DEFAULT NULL,
184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE

178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.
180: receivable_application_id%TYPE DEFAULT NULL,
181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE
183: DEFAULT NULL,
184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
186: p_ussgl_transaction_code IN ar_receivable_applications.

Line 184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

180: receivable_application_id%TYPE DEFAULT NULL,
181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE
183: DEFAULT NULL,
184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
186: p_ussgl_transaction_code IN ar_receivable_applications.
187: ussgl_transaction_code%TYPE DEFAULT NULL,
188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

Line 185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

181: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE
183: DEFAULT NULL,
184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
186: p_ussgl_transaction_code IN ar_receivable_applications.
187: ussgl_transaction_code%TYPE DEFAULT NULL,
188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
189: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 186: p_ussgl_transaction_code IN ar_receivable_applications.

182: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE
183: DEFAULT NULL,
184: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
185: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
186: p_ussgl_transaction_code IN ar_receivable_applications.
187: ussgl_transaction_code%TYPE DEFAULT NULL,
188: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
189: DEFAULT ar_receipt_api_pub.attribute_rec_const,
190: -- ******* Global Flexfield parameters *******

Line 193: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

189: DEFAULT ar_receipt_api_pub.attribute_rec_const,
190: -- ******* Global Flexfield parameters *******
191: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
192: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
193: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
194:
195: --Multiple Prapayments project, refund of type Credit card or on account
196: p_refund_type IN VARCHAR2 DEFAULT NULL,
197:

Line 201: p_prepay_application_id OUT NOCOPY ar_receivable_applications.

197:
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_prepay_application_id OUT NOCOPY ar_receivable_applications.
202: receivable_application_id%TYPE
203: ) IS
204:
205: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 205: l_ra_rec ar_receivable_applications%ROWTYPE;

201: p_prepay_application_id OUT NOCOPY ar_receivable_applications.
202: receivable_application_id%TYPE
203: ) IS
204:
205: l_ra_rec ar_receivable_applications%ROWTYPE;
206: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
207: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
208:
209: l_cash_receipt_id NUMBER;

Line 218: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;

214: l_def_return_status VARCHAR2(1);
215: l_def_activity_return_status VARCHAR2(1);
216: l_payment_type_return_status VARCHAR2(1);
217: l_val_return_status VARCHAR2(1);
218: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;
219: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
220: l_refund_amount NUMBER;
221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

Line 219: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;

215: l_def_activity_return_status VARCHAR2(1);
216: l_payment_type_return_status VARCHAR2(1);
217: l_val_return_status VARCHAR2(1);
218: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;
219: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
220: l_refund_amount NUMBER;
221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
223: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

Line 221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;

217: l_val_return_status VARCHAR2(1);
218: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;
219: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
220: l_refund_amount NUMBER;
221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
223: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
224: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
225:

Line 222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;

218: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;
219: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
220: l_refund_amount NUMBER;
221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
223: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
224: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
225:
226: --Multiple Prepayments project

Line 223: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

219: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
220: l_refund_amount NUMBER;
221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
223: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
224: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
225:
226: --Multiple Prepayments project
227: l_rec_in_doubt VARCHAR2(1) := 'N';

Line 224: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;

220: l_refund_amount NUMBER;
221: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
222: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
223: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
224: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
225:
226: --Multiple Prepayments project
227: l_rec_in_doubt VARCHAR2(1) := 'N';
228: l_rid_reason VARCHAR2(2000) := ' ';

Line 229: l_comments ar_receivable_applications.comments%TYPE;

225:
226: --Multiple Prepayments project
227: l_rec_in_doubt VARCHAR2(1) := 'N';
228: l_rid_reason VARCHAR2(2000) := ' ';
229: l_comments ar_receivable_applications.comments%TYPE;
230: l_refund_type VARCHAR2(30) := null;
231:
232: l_cr_unapp_amount NUMBER; /* Bug fix 3569640 */
233:

Line 235: l_ra_refund_rec ar_receivable_applications%ROWTYPE;

231:
232: l_cr_unapp_amount NUMBER; /* Bug fix 3569640 */
233:
234: --Bug 3628401
235: l_ra_refund_rec ar_receivable_applications%ROWTYPE;
236: l_on_acc_rec_app_id ar_receivable_applications.receivable_application_id%type;
237: l_actual_refund_amount ar_receivable_applications.amount_applied%TYPE;
238:
239: BEGIN

Line 236: l_on_acc_rec_app_id ar_receivable_applications.receivable_application_id%type;

232: l_cr_unapp_amount NUMBER; /* Bug fix 3569640 */
233:
234: --Bug 3628401
235: l_ra_refund_rec ar_receivable_applications%ROWTYPE;
236: l_on_acc_rec_app_id ar_receivable_applications.receivable_application_id%type;
237: l_actual_refund_amount ar_receivable_applications.amount_applied%TYPE;
238:
239: BEGIN
240: IF PG_DEBUG in ('Y', 'C') THEN

Line 237: l_actual_refund_amount ar_receivable_applications.amount_applied%TYPE;

233:
234: --Bug 3628401
235: l_ra_refund_rec ar_receivable_applications%ROWTYPE;
236: l_on_acc_rec_app_id ar_receivable_applications.receivable_application_id%type;
237: l_actual_refund_amount ar_receivable_applications.amount_applied%TYPE;
238:
239: BEGIN
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_util.debug(

Line 770: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

766: -- ** OUT NOCOPY variables for Creating receipt
767: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
768: -- Receipt application parameters
769: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
770: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
771: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
772: p_application_ref_id IN OUT NOCOPY NUMBER ,
773: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
774: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,

Line 775: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,

771: p_application_ref_type IN VARCHAR2 DEFAULT NULL,
772: p_application_ref_id IN OUT NOCOPY NUMBER ,
773: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
774: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
775: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
776: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
777: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 776: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

772: p_application_ref_id IN OUT NOCOPY NUMBER ,
773: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
774: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
775: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
776: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
777: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
780: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',

Line 777: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

773: p_application_ref_num IN OUT NOCOPY VARCHAR2 ,
774: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
775: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
776: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
777: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
780: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
781: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

774: p_secondary_application_ref_id IN OUT NOCOPY NUMBER ,
775: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
776: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
777: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
780: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
781: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

Line 779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

775: p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
776: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
777: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
778: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
779: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
780: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
781: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
782: app_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
783: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

783: DEFAULT ar_receipt_api_pub.attribute_rec_const,
784: -- ******* Global Flexfield parameters *******
785: app_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
786: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
787: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
788: -- processor such as iPayments
789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
790: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
791: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---

Line 796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

792: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
793:
794: p_payment_response_error_code OUT NOCOPY VARCHAR2,
795: -- OUT NOCOPY parameter for the Application
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797: p_payment_set_id IN OUT NOCOPY NUMBER,
798: p_org_id IN NUMBER DEFAULT NULL,
799: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE
800: ) IS

Line 964: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

960: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
961: x_return_status OUT NOCOPY VARCHAR2,
962: x_msg_count OUT NOCOPY NUMBER,
963: x_msg_data OUT NOCOPY VARCHAR2,
964: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
965: p_number_of_refund_receipts OUT NOCOPY NUMBER,
966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

Line 968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

964: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
965: p_number_of_refund_receipts OUT NOCOPY NUMBER,
966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,

965: p_number_of_refund_receipts OUT NOCOPY NUMBER,
966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

966: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type

Line 971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

967: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,

Line 972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

968: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******

Line 973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

969: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
970: p_refund_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
971: p_refund_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
972: p_refund_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
973: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
974: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type
975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******
977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type

Line 979: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,

975: DEFAULT ar_receipt_api_pub.attribute_rec_const,
976: -- ******* Global Flexfield parameters *******
977: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type
978: DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
979: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
980: p_payment_set_id IN NUMBER DEFAULT NULL
981: ) IS
982:
983: --Multiple Prepayments project, get all the receipts

Line 990: FROM ar_receivable_applications ra , ar_cash_receipts cr

986: c_bank_account_id IN NUMBER) IS
987: SELECT ra.cash_receipt_id,
988: SUM(DECODE(ra.status,'OTHER ACC',DECODE(applied_payment_schedule_id,
989: -7,NVL(nvl(ra.amount_applied_from, ra.amount_applied),0),0),0)) prepayment_amount
990: FROM ar_receivable_applications ra , ar_cash_receipts cr
991: WHERE ra.payment_set_id= c_payment_set_id
992: AND cr.cash_receipt_id = ra.cash_receipt_id
993: AND ra.display = 'Y'
994: AND decode(c_receipt_method_id, null,'1',cr.receipt_method_id ) =

Line 1004: l_ra_rec ar_receivable_applications%ROWTYPE;

1000:
1001: l_api_name CONSTANT VARCHAR2(20) := 'Refund_Prepayment';
1002: l_api_version CONSTANT NUMBER := 1.0;
1003:
1004: l_ra_rec ar_receivable_applications%ROWTYPE;
1005: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1006: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1007:
1008: l_cash_receipt_id NUMBER;

Line 1016: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;

1012: l_apply_gl_date DATE;
1013: l_def_return_status VARCHAR2(1);
1014: l_def_activity_return_status VARCHAR2(1);
1015: l_val_return_status VARCHAR2(1);
1016: l_reapply_amount ar_receivable_applications.amount_applied%TYPE;
1017: l_payment_set_id NUMBER;
1018: l_refund_amount NUMBER;
1019: l_rcpt_refund_amount NUMBER;
1020: l_number_of_refund_receipts NUMBER :=0;

Line 1150: FROM ar_receivable_applications ra

1146: SELECT
1147: SUM(DECODE(ra.status,'OTHER ACC',DECODE(applied_payment_schedule_id,
1148: -7,NVL(nvl(ra.amount_applied_from, ra.amount_applied),0),0),0)) max_refund_amt
1149: into l_max_refund_amt
1150: FROM ar_receivable_applications ra
1151: WHERE ra.cash_receipt_id = l_cash_receipt_id
1152: AND ra.display = 'Y';
1153:
1154: ---Bug: 3504678

Line 1239: from ar_cash_receipts_all cr, ar_receivable_applications ra

1235: /*--------------------------------------
1236: Check if payment set id is valid
1237: ---------------------------------------*/
1238: select count(*) into l_dummy
1239: from ar_cash_receipts_all cr, ar_receivable_applications ra
1240: where ra.payment_set_id= l_payment_set_id
1241: AND cr.cash_receipt_id = ra.cash_receipt_id;
1242:
1243: if l_dummy = 0 then

Line 1266: from ar_cash_receipts_all cr, ar_receivable_applications ra

1262: /*--------------------------------------
1263: Check if t_bank_account_id is valid
1264: ---------------------------------------*/
1265: select count(*) into l_dummy
1266: from ar_cash_receipts_all cr, ar_receivable_applications ra
1267: where ra.payment_set_id= l_payment_set_id
1268: AND cr.cash_receipt_id = ra.cash_receipt_id
1269: and cr.customer_bank_account_id = t_bank_account_id;
1270:

Line 1295: from ar_cash_receipts_all cr, ar_receivable_applications ra

1291: /*--------------------------------------
1292: Check if t_receipt_method_id is valid
1293: ---------------------------------------*/
1294: select count(*) into l_dummy
1295: from ar_cash_receipts_all cr, ar_receivable_applications ra
1296: where ra.payment_set_id= l_payment_set_id
1297: AND cr.cash_receipt_id = ra.cash_receipt_id
1298: and cr.receipt_method_id = t_receipt_method_id;
1299:

Line 1317: FROM ar_receivable_applications ra , ar_cash_receipts cr

1313: SELECT
1314: SUM(DECODE(ra.status,'OTHER ACC',DECODE(applied_payment_schedule_id,
1315: -7,NVL(nvl(ra.amount_applied_from, ra.amount_applied),0),0),0)) max_refund_amt
1316: into l_max_refund_amt
1317: FROM ar_receivable_applications ra , ar_cash_receipts cr
1318: WHERE ra.payment_set_id= l_payment_set_id
1319: AND cr.cash_receipt_id = ra.cash_receipt_id
1320: AND ra.display = 'Y'
1321: AND decode(t_receipt_method_id, null,'1',cr.receipt_method_id ) =

Line 1348: FROM ar_receivable_applications ra,

1344: as pmt_type_count,
1345: sum(DECODE(rm.payment_channel_code, 'CREDIT_CARD', 1, 0))
1346: as credit_pmt_type_count
1347: INTO l_total_pmt_types, l_credit_pmt_type_count
1348: FROM ar_receivable_applications ra,
1349: ar_cash_receipts cr,
1350: ar_receipt_methods rm
1351: WHERE ra.payment_set_id = l_payment_set_id
1352: AND ra.cash_receipt_id = cr.cash_receipt_id

Line 1590: FROM ar_receivable_applications

1586: AND ctl.customer_trx_id= c_customer_trx_id;
1587:
1588: CURSOR prepayapp_cur(c_payment_set_id NUMBER) IS
1589: SELECT *
1590: FROM ar_receivable_applications
1591: WHERE display ='Y'
1592: AND applied_payment_schedule_id = -7
1593: AND payment_set_id = c_payment_set_id
1594: order by amount_applied;

Line 1603: l_amount_applied ar_receivable_applications.amount_applied%TYPE := 0;

1599: l_api_name CONSTANT VARCHAR2(20) := 'MATCH_PREPAYMENT';
1600: l_return_status VARCHAR2(1);
1601: l_msg_count NUMBER;
1602: l_msg_data VARCHAR2(2000);
1603: l_amount_applied ar_receivable_applications.amount_applied%TYPE := 0;
1604: l_prepay_amount_reapplied ar_receivable_applications.amount_applied%TYPE := 0;
1605: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1606: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1607: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;

Line 1604: l_prepay_amount_reapplied ar_receivable_applications.amount_applied%TYPE := 0;

1600: l_return_status VARCHAR2(1);
1601: l_msg_count NUMBER;
1602: l_msg_data VARCHAR2(2000);
1603: l_amount_applied ar_receivable_applications.amount_applied%TYPE := 0;
1604: l_prepay_amount_reapplied ar_receivable_applications.amount_applied%TYPE := 0;
1605: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1606: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1607: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1608: l_prepayment_exist_flag VARCHAR2(1);

Line 1605: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

1601: l_msg_count NUMBER;
1602: l_msg_data VARCHAR2(2000);
1603: l_amount_applied ar_receivable_applications.amount_applied%TYPE := 0;
1604: l_prepay_amount_reapplied ar_receivable_applications.amount_applied%TYPE := 0;
1605: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1606: l_attribute_rec ar_receipt_api_pub.attribute_rec_type;
1607: l_global_attribute_rec ar_receipt_api_pub.global_attribute_rec_type;
1608: l_prepayment_exist_flag VARCHAR2(1);
1609: l_complete_applied_flag BOOLEAN := FALSE;