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

Line 180: (p_request_id IN ar_receivable_applications.request_id%TYPE DEFAULT NULL

176: | else partial recover.
177: | 14-OCT-2005 jbeckett Bug 4565758 - AR/TM legal entity uptake
178: *=======================================================================*/
179: PROCEDURE claim_creation
180: (p_request_id IN ar_receivable_applications.request_id%TYPE DEFAULT NULL
181: ,p_matched_claim_creation_flag IN ar_system_parameters.matched_claim_creation_flag%TYPE
182: ,p_matched_claim_excl_cm_flag IN ar_system_parameters.matched_claim_excl_cm_flag%TYPE
183: ,x_return_status OUT NOCOPY VARCHAR2
184: )IS

Line 222: FROM ar_receivable_applications ra

218: ,NULL -- x_msg_count
219: ,NULL -- x_msg_data
220: ,NULL -- x_claim_reason_name
221: ,apply_date -- bug 5495310
222: FROM ar_receivable_applications ra
223: WHERE ra.application_ref_type = 'CLAIM'
224: AND ra.status = 'OTHER ACC'
225: AND ra.application_ref_num IS NULL
226: AND ra.application_rule = 90

Line 233: p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type

229:
230: --Cursor to fetch RA info based on the applied PS id retreived by the
231: --primary cursor to process TRX based claims
232: CURSOR get_ra_info (
233: p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type
234: ) IS
235: SELECT
236: ra.receivable_application_id
237: ,ra.amount_applied

Line 267: FROM ar_receivable_applications ra

263: ,NULL -- x_return_status
264: ,NULL -- x_msg_count
265: ,NULL -- x_msg_data
266: ,NULL -- x_claim_reason_name
267: FROM ar_receivable_applications ra
268: WHERE ra.applied_payment_schedule_id = p_trx_ps_id
269: AND ra.request_id = p_request_id
270: AND ra.display = 'Y'
271: AND ra.receivable_application_id = (

Line 273: from ar_receivable_applications ra1

269: AND ra.request_id = p_request_id
270: AND ra.display = 'Y'
271: AND ra.receivable_application_id = (
272: select max(ra1.receivable_application_id)
273: from ar_receivable_applications ra1
274: where ra1.applied_payment_schedule_id
275: = ra.applied_payment_schedule_id);
276:
277: --Primary cursor for processing TRX based claims

Line 280: FROM ar_receivable_applications ra

276:
277: --Primary cursor for processing TRX based claims
278: CURSOR get_ra_rec IS
279: SELECT distinct ra.applied_payment_schedule_id
280: FROM ar_receivable_applications ra
281: WHERE ra.applied_payment_schedule_id NOT IN (-4,-1)
282: AND ra.status = 'APP'
283: AND ra.display = 'Y'
284: AND ra.request_id = p_request_id;

Line 289: (p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type

285:
286: --Get TRX based info from ra_customer_trx and ar_payment_schedules
287: --Exclude CLASS=PMT
288: CURSOR get_ps_trx_info
289: (p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type
290: ) IS
291: SELECT ct.customer_trx_id --customer_trx_id
292: ,ct.trx_number --trx_number
293: ,ct.cust_trx_type_id --trx_type_id

Line 315: p_receipt_ps_id ar_receivable_applications.payment_schedule_id%type

311: AND ps.class <> 'PMT';
312:
313: --Fetch receipt info using payment schedule id of the receipt
314: CURSOR get_receipt_info (
315: p_receipt_ps_id ar_receivable_applications.payment_schedule_id%type
316: ) IS
317: SELECT ps.cash_receipt_id --cash_receipt_id
318: ,cr.receipt_number --receipt_number
319: ,cr.currency_code --currency_code

Line 337: p_receipt_ps_id ar_receivable_applications.applied_payment_schedule_id%type

333: AND crh.current_record_flag = 'Y';
334:
335: --Fetch receipt info using applied payment schedule id of the trx
336: CURSOR get_receipt_num (
337: p_receipt_ps_id ar_receivable_applications.applied_payment_schedule_id%type
338: ) IS
339: SELECT ps.cash_receipt_id --cash_receipt_id
340: ,cr.receipt_number --receipt_number
341: FROM ar_payment_schedules ps

Line 348: ( p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type

344: AND cr.cash_receipt_id = ps.cash_receipt_id;
345:
346: --Fetch Receivable application info required for subsequent receipt application
347: CURSOR get_trx_app_info
348: ( p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type
349: ) IS
350: SELECT SUM(ra.amount_applied), MAX(ra.apply_date)
351: FROM ar_receivable_applications ra
352: WHERE ra.applied_payment_schedule_id = p_trx_ps_id

Line 351: FROM ar_receivable_applications ra

347: CURSOR get_trx_app_info
348: ( p_trx_ps_id ar_receivable_applications.applied_payment_schedule_id%type
349: ) IS
350: SELECT SUM(ra.amount_applied), MAX(ra.apply_date)
351: FROM ar_receivable_applications ra
352: WHERE ra.applied_payment_schedule_id = p_trx_ps_id
353: AND ra.request_id = p_request_id
354: AND ra.status = 'APP'
355: AND ra.display = 'Y';

Line 359: ( p_cr_id ar_receivable_applications.cash_receipt_id%type

355: AND ra.display = 'Y';
356:
357: -- Fetch the amount_applied from the initial UNAPP record for the cash receipt
358: CURSOR unapp_amt_rec
359: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
360: ) IS
361: select ra.amount_applied
362: from ar_receivable_applications ra
363: ,ar_distributions ard

Line 362: from ar_receivable_applications ra

358: CURSOR unapp_amt_rec
359: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
360: ) IS
361: select ra.amount_applied
362: from ar_receivable_applications ra
363: ,ar_distributions ard
364: where ra.cash_receipt_id = p_cr_id
365: and ra.status = 'UNAPP'
366: and nvl(ra.confirmed_flag,'Y') = 'Y'

Line 373: ( p_cr_id ar_receivable_applications.cash_receipt_id%type

369: and ard.source_id_secondary IS NULL;
370:
371: -- Fetch the amount_applied from the Paired UNAPP records for the cash receipt
372: CURSOR pair_unapp_amt_rec
373: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
374: ) IS
375: select sum(ra.amount_applied)
376: from ar_receivable_applications ra
377: ,ar_distributions ard

Line 376: from ar_receivable_applications ra

372: CURSOR pair_unapp_amt_rec
373: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
374: ) IS
375: select sum(ra.amount_applied)
376: from ar_receivable_applications ra
377: ,ar_distributions ard
378: where ra.cash_receipt_id = p_cr_id
379: and ra.status = 'UNAPP'
380: and nvl(ra.confirmed_flag,'Y') = 'Y'

Line 387: ( p_cr_id ar_receivable_applications.cash_receipt_id%type

383: and ard.source_id_secondary IS NOT NULL;
384:
385: -- Fetch rapp_id for all application for a full claim creation failure recovery
386: CURSOR fail_rec_rapp_id
387: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
388: ) IS
389: select ra.receivable_application_id
390: from ar_receivable_applications ra
391: where ra.cash_receipt_id = p_cr_id

Line 390: from ar_receivable_applications ra

386: CURSOR fail_rec_rapp_id
387: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
388: ) IS
389: select ra.receivable_application_id
390: from ar_receivable_applications ra
391: where ra.cash_receipt_id = p_cr_id
392: and ra.status <> 'UNAPP'
393: and nvl(ra.confirmed_flag,'Y') = 'Y';
394:

Line 441: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE

437: ra_tbl_null ra_trx_rec_type;
438:
439:
440: TYPE ra_claim_rec_type IS RECORD (
441: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
442: ,amount_applied ar_receivable_applications.amount_applied%TYPE
443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE

Line 442: ,amount_applied ar_receivable_applications.amount_applied%TYPE

438:
439:
440: TYPE ra_claim_rec_type IS RECORD (
441: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
442: ,amount_applied ar_receivable_applications.amount_applied%TYPE
443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE

Line 443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE

439:
440: TYPE ra_claim_rec_type IS RECORD (
441: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
442: ,amount_applied ar_receivable_applications.amount_applied%TYPE
443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE

Line 444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE

440: TYPE ra_claim_rec_type IS RECORD (
441: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
442: ,amount_applied ar_receivable_applications.amount_applied%TYPE
443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE

Line 445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE

441: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE
442: ,amount_applied ar_receivable_applications.amount_applied%TYPE
443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE

Line 446: ,comments ar_receivable_applications.comments%TYPE

442: ,amount_applied ar_receivable_applications.amount_applied%TYPE
443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE

Line 447: ,attribute_category ar_receivable_applications.attribute_category%TYPE

443: ,payment_schedule_id ar_receivable_applications.payment_schedule_id%TYPE
444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE

Line 448: ,attribute1 ar_receivable_applications.attribute1%TYPE

444: ,applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE
445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE

Line 449: ,attribute2 ar_receivable_applications.attribute2%TYPE

445: ,applied_customer_trx_id ar_receivable_applications.applied_customer_trx_id%TYPE
446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE

Line 450: ,attribute3 ar_receivable_applications.attribute3%TYPE

446: ,comments ar_receivable_applications.comments%TYPE
447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE

Line 451: ,attribute4 ar_receivable_applications.attribute4%TYPE

447: ,attribute_category ar_receivable_applications.attribute_category%TYPE
448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE

Line 452: ,attribute5 ar_receivable_applications.attribute5%TYPE

448: ,attribute1 ar_receivable_applications.attribute1%TYPE
449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE

Line 453: ,attribute6 ar_receivable_applications.attribute6%TYPE

449: ,attribute2 ar_receivable_applications.attribute2%TYPE
450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE

Line 454: ,attribute7 ar_receivable_applications.attribute7%TYPE

450: ,attribute3 ar_receivable_applications.attribute3%TYPE
451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE

Line 455: ,attribute8 ar_receivable_applications.attribute8%TYPE

451: ,attribute4 ar_receivable_applications.attribute4%TYPE
452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE

Line 456: ,attribute9 ar_receivable_applications.attribute9%TYPE

452: ,attribute5 ar_receivable_applications.attribute5%TYPE
453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE

Line 457: ,attribute10 ar_receivable_applications.attribute10%TYPE

453: ,attribute6 ar_receivable_applications.attribute6%TYPE
454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE

Line 458: ,attribute11 ar_receivable_applications.attribute11%TYPE

454: ,attribute7 ar_receivable_applications.attribute7%TYPE
455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE

Line 459: ,attribute12 ar_receivable_applications.attribute12%TYPE

455: ,attribute8 ar_receivable_applications.attribute8%TYPE
456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE

Line 460: ,attribute13 ar_receivable_applications.attribute13%TYPE

456: ,attribute9 ar_receivable_applications.attribute9%TYPE
457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE

Line 461: ,attribute14 ar_receivable_applications.attribute14%TYPE

457: ,attribute10 ar_receivable_applications.attribute10%TYPE
458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE

Line 462: ,attribute15 ar_receivable_applications.attribute15%TYPE

458: ,attribute11 ar_receivable_applications.attribute11%TYPE
459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE
466: ,customer_reason ar_receivable_applications.customer_reason%TYPE

Line 463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE

459: ,attribute12 ar_receivable_applications.attribute12%TYPE
460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE
466: ,customer_reason ar_receivable_applications.customer_reason%TYPE
467: ,customer_reference ar_receivable_applications.customer_reference%TYPE

Line 464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE

460: ,attribute13 ar_receivable_applications.attribute13%TYPE
461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE
466: ,customer_reason ar_receivable_applications.customer_reason%TYPE
467: ,customer_reference ar_receivable_applications.customer_reference%TYPE
468: ,return_status VARCHAR2(1)

Line 465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE

461: ,attribute14 ar_receivable_applications.attribute14%TYPE
462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE
466: ,customer_reason ar_receivable_applications.customer_reason%TYPE
467: ,customer_reference ar_receivable_applications.customer_reference%TYPE
468: ,return_status VARCHAR2(1)
469: ,msg_count NUMBER

Line 466: ,customer_reason ar_receivable_applications.customer_reason%TYPE

462: ,attribute15 ar_receivable_applications.attribute15%TYPE
463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE
466: ,customer_reason ar_receivable_applications.customer_reason%TYPE
467: ,customer_reference ar_receivable_applications.customer_reference%TYPE
468: ,return_status VARCHAR2(1)
469: ,msg_count NUMBER
470: ,msg_data VARCHAR2(2000)

Line 467: ,customer_reference ar_receivable_applications.customer_reference%TYPE

463: ,application_ref_num ar_receivable_applications.application_ref_num%TYPE
464: ,secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE
465: ,application_ref_reason ar_receivable_applications.application_ref_reason%TYPE
466: ,customer_reason ar_receivable_applications.customer_reason%TYPE
467: ,customer_reference ar_receivable_applications.customer_reference%TYPE
468: ,return_status VARCHAR2(1)
469: ,msg_count NUMBER
470: ,msg_data VARCHAR2(2000)
471: ,claim_reason_name ar_receivable_applications.application_ref_reason%TYPE

Line 471: ,claim_reason_name ar_receivable_applications.application_ref_reason%TYPE

467: ,customer_reference ar_receivable_applications.customer_reference%TYPE
468: ,return_status VARCHAR2(1)
469: ,msg_count NUMBER
470: ,msg_data VARCHAR2(2000)
471: ,claim_reason_name ar_receivable_applications.application_ref_reason%TYPE
472: );
473: claim_rec ra_claim_rec_type;
474: claim_rec_null ra_claim_rec_type;
475:

Line 502: l_applied_date ar_receivable_applications.apply_date%TYPE;

498: l_msg_count NUMBER;
499: l_msg_data VARCHAR2(2000);
500: l_trx_claim_exist VARCHAR2(1); --'Y'=Open Claim in TM;; 'N'=No Claim in TM
501: l_trx_claim_type VARCHAR2(1); --'O'=Over Pay Claim;; 'S'=Short Pay Claim
502: l_applied_date ar_receivable_applications.apply_date%TYPE;
503: l_applied_action_type VARCHAR2(1);
504: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
505: l_applied_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
506: l_applied_receipt_number ar_cash_receipts.receipt_number%TYPE;

Line 504: l_amount_applied ar_receivable_applications.amount_applied%TYPE;

500: l_trx_claim_exist VARCHAR2(1); --'Y'=Open Claim in TM;; 'N'=No Claim in TM
501: l_trx_claim_type VARCHAR2(1); --'O'=Over Pay Claim;; 'S'=Short Pay Claim
502: l_applied_date ar_receivable_applications.apply_date%TYPE;
503: l_applied_action_type VARCHAR2(1);
504: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
505: l_applied_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
506: l_applied_receipt_number ar_cash_receipts.receipt_number%TYPE;
507: l_object_version_number NUMBER;
508: l_claim_reason_code_id NUMBER;

Line 511: l_unapp_amt_appl ar_receivable_applications.amount_applied%TYPE;

507: l_object_version_number NUMBER;
508: l_claim_reason_code_id NUMBER;
509: l_claim_reason_name VARCHAR2(255);
510: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;
511: l_unapp_amt_appl ar_receivable_applications.amount_applied%TYPE;
512: l_sum_pair_unapp_amt_appl ar_receivable_applications.amount_applied%TYPE;
513: l_legal_entity_id NUMBER;
514:
515: invalid_param EXCEPTION;

Line 512: l_sum_pair_unapp_amt_appl ar_receivable_applications.amount_applied%TYPE;

508: l_claim_reason_code_id NUMBER;
509: l_claim_reason_name VARCHAR2(255);
510: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;
511: l_unapp_amt_appl ar_receivable_applications.amount_applied%TYPE;
512: l_sum_pair_unapp_amt_appl ar_receivable_applications.amount_applied%TYPE;
513: l_legal_entity_id NUMBER;
514:
515: invalid_param EXCEPTION;
516: skip_pmt_record EXCEPTION;

Line 807: jg_ar_receivable_applications.delete_interest_adjustment(

803: /* in the case of a full reversal, we have to also
804: if the localization is installed rollback the
805: interest adjustments. */
806:
807: jg_ar_receivable_applications.delete_interest_adjustment(
808: p_cash_receipt_id => l_cash_receipt_id,
809: x_return_status => jg_return_status);
810:
811: IF jg_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 813: arp_standard.debug('Error from jg_ar_receivable_applications.delete_interst_adjustment');

809: x_return_status => jg_return_status);
810:
811: IF jg_return_status <> FND_API.G_RET_STS_SUCCESS then
812: /* print an error message */
813: arp_standard.debug('Error from jg_ar_receivable_applications.delete_interst_adjustment');
814: END IF;
815:
816: END IF; -- IF l_unapp_amt_appl > l_sum_pair_unapp_amt_appl THEN
817:

Line 851: UPDATE ar_receivable_applications

847: IF PG_DEBUG in ('Y','C') THEN
848: arp_standard.debug('Bulk Update RA with DED No, ID and translated oracle reason');
849: END IF;
850: FORALL i IN claim_tbl.l_rowid.FIRST .. claim_tbl.l_rowid.LAST
851: UPDATE ar_receivable_applications
852: SET secondary_application_ref_id = claim_tbl.secondary_application_ref_id(i)
853: ,application_ref_num = claim_tbl.application_ref_num(i)
854: WHERE rowid = claim_tbl.l_rowid(i);
855:

Line 1323: UPDATE ar_receivable_applications

1319:
1320: IF PG_DEBUG in ('Y','C') THEN
1321: arp_standard.debug('Update RA with Ded No,Ded ID,Type,receivables_trx_id');
1322: END IF;
1323: UPDATE ar_receivable_applications
1324: SET secondary_application_ref_id = claim_rec.secondary_application_ref_id
1325: ,application_ref_num = claim_rec.application_ref_num
1326: ,application_ref_type = 'CLAIM'
1327: ,receivables_trx_id = ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID(l_cash_receipt_id)

Line 1708: | ar_receivable_applications |

1704: | 21-JAN-03 CTHANGAI Added parameter receivables_trx_id |
1705: | 05-FEB-03 CTHANGAI Removed paramter application_ref_reason |
1706: | 10-FEB-03 CTHANGAI Initialize customer_reference with NULL |
1707: | before creating UNAPP records in |
1708: | ar_receivable_applications |
1709: | 13-FEB-03 CTHANGAI Removed paramter applied_payment_schedule_id |
1710: | 14-FEB-03 CTHANGAI Initialize receivable_trx_id with NULL for ACC |
1711: | 18-FEB-03 CTHANGAI On Exception write message to concurrent log |
1712: | 19-FEB-03 CTHANGAI Defualt program_application_id = 222 |

Line 1717: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE

1713: | 24-FEB-03 CTHANGAI Defualt postable='Y' for Claim Investigation |
1714: | 24-FEB-03 CTHANGAI On_Account_Customer populated only for ACC |
1715: +===========================================================================*/
1716: PROCEDURE create_claims_rapp_dist
1717: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE

Line 1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE

1714: | 24-FEB-03 CTHANGAI On_Account_Customer populated only for ACC |
1715: +===========================================================================*/
1716: PROCEDURE create_claims_rapp_dist
1717: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE

Line 1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE

1715: +===========================================================================*/
1716: PROCEDURE create_claims_rapp_dist
1717: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE

Line 1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE

1716: PROCEDURE create_claims_rapp_dist
1717: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE

Line 1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE

1717: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE

Line 1722: ,p_status IN ar_receivable_applications.status%TYPE

1718: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE

Line 1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE

1719: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE

Line 1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE

1720: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE

Line 1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE

1721: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE

Line 1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE

1722: ,p_status IN ar_receivable_applications.status%TYPE
1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE

Line 1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE

1723: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE

Line 1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE

1724: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE

Line 1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE

1725: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE

Line 1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE

1726: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE

Line 1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE

1727: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE

Line 1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE

1728: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE

Line 1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE

1729: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE

Line 1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE

1730: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE

Line 1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE

1731: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

Line 1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE

1732: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

Line 1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE

1733: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE

Line 1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE

1734: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE

Line 1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

1735: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

Line 1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

1736: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE

Line 1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE

1737: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

Line 1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE

1738: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

Line 1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

1739: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

Line 1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE

1740: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

Line 1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

1741: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

Line 1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

1742: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

Line 1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

1743: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

Line 1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

1744: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

Line 1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

1745: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

Line 1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

1746: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

Line 1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

1747: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

Line 1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

1748: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

Line 1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

1749: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1757: ,x_return_status OUT NOCOPY VARCHAR2

Line 1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

1750: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1757: ,x_return_status OUT NOCOPY VARCHAR2
1758: ) IS

Line 1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

1751: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1757: ,x_return_status OUT NOCOPY VARCHAR2
1758: ) IS
1759:

Line 1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

1752: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1753: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1754: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1755: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1757: ,x_return_status OUT NOCOPY VARCHAR2
1758: ) IS
1759:
1760: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 1760: l_ra_rec ar_receivable_applications%ROWTYPE;

1756: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1757: ,x_return_status OUT NOCOPY VARCHAR2
1758: ) IS
1759:
1760: l_ra_rec ar_receivable_applications%ROWTYPE;
1761: l_prev_app_id ar_receivable_applications.receivable_application_id%TYPE;
1762: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
1763: l_xla_ev_rec arp_xla_events.xla_events_type;
1764: l_msg_data VARCHAR2(2000);

Line 1761: l_prev_app_id ar_receivable_applications.receivable_application_id%TYPE;

1757: ,x_return_status OUT NOCOPY VARCHAR2
1758: ) IS
1759:
1760: l_ra_rec ar_receivable_applications%ROWTYPE;
1761: l_prev_app_id ar_receivable_applications.receivable_application_id%TYPE;
1762: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
1763: l_xla_ev_rec arp_xla_events.xla_events_type;
1764: l_msg_data VARCHAR2(2000);
1765:

Line 1849: -- Insert 'OTHER ACC' OR 'ACC' record into AR_RECEIVABLE_APPLICATIONS

1845: l_ra_rec.on_account_customer := p_on_account_customer;
1846: END IF;
1847:
1848: -- ---------------------------------------------------------------------
1849: -- Insert 'OTHER ACC' OR 'ACC' record into AR_RECEIVABLE_APPLICATIONS
1850: -- ---------------------------------------------------------------------
1851: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
1852:
1853: IF l_ra_rec.receivable_application_id IS NOT NULL THEN

Line 2010: (p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE

2006: | 05-MAR-2003 cthangai Removed Payment Schedule ID Parameter.
2007: | 01-Apr-2003 Debbie Jancis Added calls to replicate mrc data
2008: *=======================================================================*/
2009: PROCEDURE claim_create_fail_recover
2010: (p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
2011: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2012: ) IS
2013:
2014: --

Line 2011: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE

2007: | 01-Apr-2003 Debbie Jancis Added calls to replicate mrc data
2008: *=======================================================================*/
2009: PROCEDURE claim_create_fail_recover
2010: (p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
2011: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2012: ) IS
2013:
2014: --
2015: -- Cursor to fetch the ('APP' OR 'OTHER ACC') AND 'UNAPP' applications

Line 2020: from ar_receivable_applications ra

2016: -- for delete
2017: --
2018: CURSOR rapp_rec IS
2019: select ra.* --'APP' OR 'OTHER ACC'
2020: from ar_receivable_applications ra
2021: where ra.receivable_application_id = p_rapp_id
2022: and nvl(ra.confirmed_flag,'Y') = 'Y'
2023: and exists (select 'x'
2024: from ar_distributions_all ard

Line 2029: from ar_receivable_applications ra

2025: where ard.source_table = 'RA'
2026: and ard.source_id = ra.receivable_application_id)
2027: UNION
2028: select ra.* --'UNAPP'
2029: from ar_receivable_applications ra
2030: , ar_distributions ard
2031: where ra.receivable_application_id = ard.SOURCE_ID
2032: and nvl(ra.confirmed_flag,'Y') = 'Y'
2033: and ard.source_table = 'RA'

Line 2036: from ar_receivable_applications ra1

2032: and nvl(ra.confirmed_flag,'Y') = 'Y'
2033: and ard.source_table = 'RA'
2034: and ard.source_id_secondary =
2035: ( select ra1.receivable_application_id
2036: from ar_receivable_applications ra1
2037: where ra1.receivable_application_id = p_rapp_id );
2038:
2039: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
2040: ln_unapp_ra_id ar_receivable_applications.receivable_application_id%TYPE;

Line 2040: ln_unapp_ra_id ar_receivable_applications.receivable_application_id%TYPE;

2036: from ar_receivable_applications ra1
2037: where ra1.receivable_application_id = p_rapp_id );
2038:
2039: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
2040: ln_unapp_ra_id ar_receivable_applications.receivable_application_id%TYPE;
2041: ln_ra_id ar_receivable_applications.receivable_application_id%TYPE;
2042:
2043: BEGIN
2044:

Line 2041: ln_ra_id ar_receivable_applications.receivable_application_id%TYPE;

2037: where ra1.receivable_application_id = p_rapp_id );
2038:
2039: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
2040: ln_unapp_ra_id ar_receivable_applications.receivable_application_id%TYPE;
2041: ln_ra_id ar_receivable_applications.receivable_application_id%TYPE;
2042:
2043: BEGIN
2044:
2045: IF PG_DEBUG in ('Y', 'C') THEN

Line 2095: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

2091: +---------------------------------*/
2092:
2093: ar_mrc_engine.maintain_mrc_data(
2094: p_event_mode => 'DELETE',
2095: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
2096: p_mode => 'SINGLE',
2097: p_key_value => ln_ra_id);
2098:
2099: ------------------------------------------------

Line 2111: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

2107: +---------------------------------*/
2108:
2109: ar_mrc_engine.maintain_mrc_data(
2110: p_event_mode => 'DELETE',
2111: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
2112: p_mode => 'SINGLE',
2113: p_key_value => ln_ra_id);
2114:
2115: IF PG_DEBUG in ('Y', 'C') THEN

Line 2402: (p_amount IN ar_receivable_applications.amount_applied%TYPE

2398: | 17-FEB-2003 CTHANGAI natural application of the receipt is based on
2399: | to the payment schedule of the receipt
2400: *=======================================================================*/
2401: FUNCTION CHECK_APP_VIOLATE
2402: (p_amount IN ar_receivable_applications.amount_applied%TYPE
2403: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
2404: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2405: ) RETURN VARCHAR2 IS
2406:

Line 2403: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE

2399: | to the payment schedule of the receipt
2400: *=======================================================================*/
2401: FUNCTION CHECK_APP_VIOLATE
2402: (p_amount IN ar_receivable_applications.amount_applied%TYPE
2403: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
2404: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2405: ) RETURN VARCHAR2 IS
2406:
2407: l_return VARCHAR2(10);

Line 2404: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE

2400: *=======================================================================*/
2401: FUNCTION CHECK_APP_VIOLATE
2402: (p_amount IN ar_receivable_applications.amount_applied%TYPE
2403: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE
2404: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2405: ) RETURN VARCHAR2 IS
2406:
2407: l_return VARCHAR2(10);
2408: ln_amount_applied ar_receivable_applications.amount_applied%TYPE;

Line 2408: ln_amount_applied ar_receivable_applications.amount_applied%TYPE;

2404: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2405: ) RETURN VARCHAR2 IS
2406:
2407: l_return VARCHAR2(10);
2408: ln_amount_applied ar_receivable_applications.amount_applied%TYPE;
2409:
2410: invalid_param EXCEPTION;
2411:
2412: BEGIN

Line 2422: FROM ar_receivable_applications

2418: IF (p_rapp_id IS NOT NULL) AND (p_cr_id IS NOT NULL) THEN --'On Account'
2419:
2420: SELECT amount_applied
2421: INTO ln_amount_applied
2422: FROM ar_receivable_applications
2423: WHERE receivable_application_id = p_rapp_id;
2424:
2425: ELSIF (p_rapp_id IS NULL) AND (p_cr_id IS NOT NULL) THEN --'Unapplied'
2426:

Line 2429: FROM ar_receivable_applications

2425: ELSIF (p_rapp_id IS NULL) AND (p_cr_id IS NOT NULL) THEN --'Unapplied'
2426:
2427: SELECT sum(amount_applied)
2428: INTO ln_amount_applied
2429: FROM ar_receivable_applications
2430: WHERE cash_receipt_id = p_cr_id
2431: AND status = 'UNAPP';
2432:
2433: ELSE --'Raise Invalid Arguments'

Line 2517: (p_claim_id IN ar_receivable_applications.secondary_application_ref_id%TYPE

2513: | DD-MON-YYYY Name Bug #####, modified amount ..
2514: |
2515: *=======================================================================*/
2516: FUNCTION GET_TM_ORACLE_REASON
2517: (p_claim_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
2518: ) RETURN VARCHAR2 IS
2519:
2520: l_query_string VARCHAR2(2000);
2521: l_tm_oracle_reason ar_receivable_applications.customer_reason%type;

Line 2521: l_tm_oracle_reason ar_receivable_applications.customer_reason%type;

2517: (p_claim_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
2518: ) RETURN VARCHAR2 IS
2519:
2520: l_query_string VARCHAR2(2000);
2521: l_tm_oracle_reason ar_receivable_applications.customer_reason%type;
2522:
2523: BEGIN
2524:
2525: l_query_string :=

Line 2693: ar_receivable_applications.receivable_application_id%TYPE

2689: PROCEDURE apply_open_receipt_cover
2690: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2691: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
2692: ,p_open_rec_app_id IN
2693: ar_receivable_applications.receivable_application_id%TYPE
2694: ,p_amount_applied IN
2695: ar_receivable_applications.amount_applied%TYPE
2696: ,p_attribute_category IN
2697: ar_receivable_applications.attribute_category%TYPE

Line 2695: ar_receivable_applications.amount_applied%TYPE

2691: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
2692: ,p_open_rec_app_id IN
2693: ar_receivable_applications.receivable_application_id%TYPE
2694: ,p_amount_applied IN
2695: ar_receivable_applications.amount_applied%TYPE
2696: ,p_attribute_category IN
2697: ar_receivable_applications.attribute_category%TYPE
2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

Line 2697: ar_receivable_applications.attribute_category%TYPE

2693: ar_receivable_applications.receivable_application_id%TYPE
2694: ,p_amount_applied IN
2695: ar_receivable_applications.amount_applied%TYPE
2696: ,p_attribute_category IN
2697: ar_receivable_applications.attribute_category%TYPE
2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

Line 2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE

2694: ,p_amount_applied IN
2695: ar_receivable_applications.amount_applied%TYPE
2696: ,p_attribute_category IN
2697: ar_receivable_applications.attribute_category%TYPE
2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

Line 2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

2695: ar_receivable_applications.amount_applied%TYPE
2696: ,p_attribute_category IN
2697: ar_receivable_applications.attribute_category%TYPE
2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

Line 2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE

2696: ,p_attribute_category IN
2697: ar_receivable_applications.attribute_category%TYPE
2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

Line 2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

2697: ar_receivable_applications.attribute_category%TYPE
2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

Line 2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

2698: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

Line 2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

2699: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

Line 2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

2700: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

Line 2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

2701: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

Line 2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

2702: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

Line 2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

2703: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

Line 2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

2704: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

Line 2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

2705: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2713: ,x_return_status OUT NOCOPY VARCHAR2

Line 2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

2706: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2713: ,x_return_status OUT NOCOPY VARCHAR2
2714: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE

Line 2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

2707: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2713: ,x_return_status OUT NOCOPY VARCHAR2
2714: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
2715: ,x_apply_type OUT NOCOPY VARCHAR2

Line 2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

2708: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2709: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2710: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2711: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2712: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2713: ,x_return_status OUT NOCOPY VARCHAR2
2714: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
2715: ,x_apply_type OUT NOCOPY VARCHAR2
2716: ) IS

Line 2730: (p_rapp_id ar_receivable_applications.receivable_application_id%TYPE) IS

2726:
2727: --Fetch from receivable application if application is valid
2728: --for receipt to receipt application. Application is 'ACC' or 'OTHER ACC'
2729: CURSOR c1_validate
2730: (p_rapp_id ar_receivable_applications.receivable_application_id%TYPE) IS
2731: SELECT amount_applied --'Y'
2732: FROM ar_receivable_applications
2733: WHERE receivable_application_id = p_rapp_id
2734: AND display = 'Y';

Line 2732: FROM ar_receivable_applications

2728: --for receipt to receipt application. Application is 'ACC' or 'OTHER ACC'
2729: CURSOR c1_validate
2730: (p_rapp_id ar_receivable_applications.receivable_application_id%TYPE) IS
2731: SELECT amount_applied --'Y'
2732: FROM ar_receivable_applications
2733: WHERE receivable_application_id = p_rapp_id
2734: AND display = 'Y';
2735:
2736: --Fetch from receivable application if application is valid

Line 2739: (p_cr_id ar_receivable_applications.cash_receipt_id%TYPE) IS

2735:
2736: --Fetch from receivable application if application is valid
2737: --for receipt to receipt application. Application is 'UNAPP'
2738: CURSOR c2_validate
2739: (p_cr_id ar_receivable_applications.cash_receipt_id%TYPE) IS
2740: SELECT sum(amount_applied)
2741: FROM ar_receivable_applications
2742: WHERE cash_receipt_id = p_cr_id
2743: AND status = 'UNAPP'

Line 2741: FROM ar_receivable_applications

2737: --for receipt to receipt application. Application is 'UNAPP'
2738: CURSOR c2_validate
2739: (p_cr_id ar_receivable_applications.cash_receipt_id%TYPE) IS
2740: SELECT sum(amount_applied)
2741: FROM ar_receivable_applications
2742: WHERE cash_receipt_id = p_cr_id
2743: AND status = 'UNAPP'
2744: HAVING sum(amount_applied) >= p_amount_applied;
2745:

Line 2754: l_amount_applied ar_receivable_applications.amount_applied%TYPE;

2750: l_msg_count NUMBER;
2751: l_msg_data VARCHAR2(2000);
2752: l_called_from VARCHAR2(255) := 'ARCABP'; --PostBatch Pro*C
2753: l_process VARCHAR2(1); --'Y'=Process 'N'=Stop Process
2754: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;

Line 2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

2753: l_process VARCHAR2(1); --'Y'=Process 'N'=Stop Process
2754: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2759: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2760: l_acctd_amount_applied_from NUMBER;
2761: l_acctd_amount_applied_to NUMBER;

Line 2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;

2754: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2759: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2760: l_acctd_amount_applied_from NUMBER;
2761: l_acctd_amount_applied_to NUMBER;
2762:

Line 2759: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

2755: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2756: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2757: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2758: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2759: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2760: l_acctd_amount_applied_from NUMBER;
2761: l_acctd_amount_applied_to NUMBER;
2762:
2763: invalid_param EXCEPTION;