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 1327: UPDATE ar_receivable_applications

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

Line 1712: | ar_receivable_applications |

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

Line 1721: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE

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

Line 1722: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE

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

Line 1723: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE

1719: +===========================================================================*/
1720: PROCEDURE create_claims_rapp_dist
1721: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1722: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1723: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE

Line 1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE

1720: PROCEDURE create_claims_rapp_dist
1721: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1722: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1723: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE

Line 1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE

1721: (p_cash_receipt_id IN ar_receivable_applications.cash_receipt_id%TYPE
1722: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1723: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE

Line 1726: ,p_status IN ar_receivable_applications.status%TYPE

1722: ,p_unapp_ccid IN ar_receivable_applications.code_combination_id%TYPE
1723: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE

Line 1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE

1723: ,p_other_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE

Line 1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE

1724: ,p_acc_ccid IN ar_receivable_applications.code_combination_id%TYPE
1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE

Line 1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE

1725: ,p_gl_date IN ar_receivable_applications.gl_date%TYPE
1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE

Line 1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE

1726: ,p_status IN ar_receivable_applications.status%TYPE
1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE

Line 1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE

1727: ,p_amount_applied IN ar_receivable_applications.amount_applied%TYPE
1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE

Line 1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE

1728: ,p_created_by IN ar_receivable_applications.created_by%TYPE
1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE

Line 1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE

1729: ,p_creation_date IN ar_receivable_applications.creation_date%TYPE
1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE

Line 1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE

1730: ,p_last_updated_by IN ar_receivable_applications.last_updated_by%TYPE
1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE

Line 1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE

1731: ,p_program_application_id IN ar_receivable_applications.program_application_id%TYPE
1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE

Line 1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE

1732: ,p_program_id IN ar_receivable_applications.program_id%TYPE
1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE

Line 1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE

1733: ,p_request_id IN ar_receivable_applications.request_id%TYPE
1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE

Line 1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE

1734: ,p_sob_id IN ar_receivable_applications.set_of_books_id%TYPE
1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE

Line 1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE

1735: ,p_apply_date IN ar_receivable_applications.apply_date%TYPE
1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

Line 1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE

1736: ,p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE
1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

Line 1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE

1737: ,p_receipt_ps_id IN ar_receivable_applications.payment_schedule_id%TYPE
1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE

Line 1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE

1738: ,p_unapp_application_rule IN ar_receivable_applications.application_rule%TYPE
1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE

Line 1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE

1739: ,p_other_application_rule IN ar_receivable_applications.application_rule%TYPE
1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

Line 1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE

1740: ,p_acc_application_rule IN ar_receivable_applications.application_rule%TYPE
1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE

Line 1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE

1741: ,p_on_account_customer IN ar_receivable_applications.on_account_customer%TYPE
1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

Line 1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE

1742: ,p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE
1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

Line 1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

1743: ,p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

Line 1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE

1744: ,p_customer_reason IN ar_receivable_applications.customer_reason%TYPE
1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

Line 1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

1745: ,p_attribute_category IN ar_receivable_applications.attribute_category%TYPE
1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

Line 1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

1746: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

Line 1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

1747: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

Line 1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

1748: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

Line 1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

1749: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

Line 1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

1750: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1758: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

Line 1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

1751: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1758: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1759: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

Line 1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

1752: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
1753: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
1754: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1758: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1759: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1760: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

Line 1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

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

Line 1758: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

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

Line 1759: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

1755: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1758: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1759: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1760: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1761: ,x_return_status OUT NOCOPY VARCHAR2
1762: ) IS
1763:

Line 1760: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

1756: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
1757: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
1758: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
1759: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
1760: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
1761: ,x_return_status OUT NOCOPY VARCHAR2
1762: ) IS
1763:
1764: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 1764: l_ra_rec ar_receivable_applications%ROWTYPE;

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

Line 1765: l_prev_app_id ar_receivable_applications.receivable_application_id%TYPE;

1761: ,x_return_status OUT NOCOPY VARCHAR2
1762: ) IS
1763:
1764: l_ra_rec ar_receivable_applications%ROWTYPE;
1765: l_prev_app_id ar_receivable_applications.receivable_application_id%TYPE;
1766: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
1767: l_xla_ev_rec arp_xla_events.xla_events_type;
1768: l_msg_data VARCHAR2(2000);
1769:

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

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

Line 2014: (p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE

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

Line 2015: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE

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

Line 2024: from ar_receivable_applications ra

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

Line 2033: from ar_receivable_applications ra

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

Line 2040: from ar_receivable_applications ra1

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

Line 2044: ln_unapp_ra_id ar_receivable_applications.receivable_application_id%TYPE;

2040: from ar_receivable_applications ra1
2041: where ra1.receivable_application_id = p_rapp_id );
2042:
2043: l_ae_doc_rec ARP_ACCT_MAIN.ae_doc_rec_type;
2044: ln_unapp_ra_id ar_receivable_applications.receivable_application_id%TYPE;
2045: ln_ra_id ar_receivable_applications.receivable_application_id%TYPE;
2046:
2047: BEGIN
2048:

Line 2045: ln_ra_id ar_receivable_applications.receivable_application_id%TYPE;

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

Line 2099: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

2095: +---------------------------------*/
2096:
2097: ar_mrc_engine.maintain_mrc_data(
2098: p_event_mode => 'DELETE',
2099: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
2100: p_mode => 'SINGLE',
2101: p_key_value => ln_ra_id);
2102:
2103: ------------------------------------------------

Line 2115: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

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

Line 2406: (p_amount IN ar_receivable_applications.amount_applied%TYPE

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

Line 2407: ,p_rapp_id IN ar_receivable_applications.receivable_application_id%TYPE

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

Line 2408: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE

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

Line 2412: ln_amount_applied ar_receivable_applications.amount_applied%TYPE;

2408: ,p_cr_id IN ar_receivable_applications.cash_receipt_id%TYPE
2409: ) RETURN VARCHAR2 IS
2410:
2411: l_return VARCHAR2(10);
2412: ln_amount_applied ar_receivable_applications.amount_applied%TYPE;
2413:
2414: invalid_param EXCEPTION;
2415:
2416: BEGIN

Line 2426: FROM ar_receivable_applications

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

Line 2433: FROM ar_receivable_applications

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

Line 2521: (p_claim_id IN ar_receivable_applications.secondary_application_ref_id%TYPE

2517: | DD-MON-YYYY Name Bug #####, modified amount ..
2518: |
2519: *=======================================================================*/
2520: FUNCTION GET_TM_ORACLE_REASON
2521: (p_claim_id IN ar_receivable_applications.secondary_application_ref_id%TYPE
2522: ) RETURN VARCHAR2 IS
2523:
2524: l_query_string VARCHAR2(2000);
2525: l_tm_oracle_reason VARCHAR2(80);

Line 2698: ar_receivable_applications.receivable_application_id%TYPE

2694: PROCEDURE apply_open_receipt_cover
2695: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2696: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
2697: ,p_open_rec_app_id IN
2698: ar_receivable_applications.receivable_application_id%TYPE
2699: ,p_amount_applied IN
2700: ar_receivable_applications.amount_applied%TYPE
2701: ,p_attribute_category IN
2702: ar_receivable_applications.attribute_category%TYPE

Line 2700: ar_receivable_applications.amount_applied%TYPE

2696: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
2697: ,p_open_rec_app_id IN
2698: ar_receivable_applications.receivable_application_id%TYPE
2699: ,p_amount_applied IN
2700: ar_receivable_applications.amount_applied%TYPE
2701: ,p_attribute_category IN
2702: ar_receivable_applications.attribute_category%TYPE
2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

Line 2702: ar_receivable_applications.attribute_category%TYPE

2698: ar_receivable_applications.receivable_application_id%TYPE
2699: ,p_amount_applied IN
2700: ar_receivable_applications.amount_applied%TYPE
2701: ,p_attribute_category IN
2702: ar_receivable_applications.attribute_category%TYPE
2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

Line 2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE

2699: ,p_amount_applied IN
2700: ar_receivable_applications.amount_applied%TYPE
2701: ,p_attribute_category IN
2702: ar_receivable_applications.attribute_category%TYPE
2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

Line 2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE

2700: ar_receivable_applications.amount_applied%TYPE
2701: ,p_attribute_category IN
2702: ar_receivable_applications.attribute_category%TYPE
2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

Line 2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE

2701: ,p_attribute_category IN
2702: ar_receivable_applications.attribute_category%TYPE
2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

Line 2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE

2702: ar_receivable_applications.attribute_category%TYPE
2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

Line 2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE

2703: ,p_attribute1 IN ar_receivable_applications.attribute1%TYPE
2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

Line 2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE

2704: ,p_attribute2 IN ar_receivable_applications.attribute2%TYPE
2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

Line 2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE

2705: ,p_attribute3 IN ar_receivable_applications.attribute3%TYPE
2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

Line 2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE

2706: ,p_attribute4 IN ar_receivable_applications.attribute4%TYPE
2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

Line 2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE

2707: ,p_attribute5 IN ar_receivable_applications.attribute5%TYPE
2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

Line 2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE

2708: ,p_attribute6 IN ar_receivable_applications.attribute6%TYPE
2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

Line 2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE

2709: ,p_attribute7 IN ar_receivable_applications.attribute7%TYPE
2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2717: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

Line 2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE

2710: ,p_attribute8 IN ar_receivable_applications.attribute8%TYPE
2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2717: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2718: ,x_return_status OUT NOCOPY VARCHAR2

Line 2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE

2711: ,p_attribute9 IN ar_receivable_applications.attribute9%TYPE
2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2717: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2718: ,x_return_status OUT NOCOPY VARCHAR2
2719: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE

Line 2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE

2712: ,p_attribute10 IN ar_receivable_applications.attribute10%TYPE
2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2717: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2718: ,x_return_status OUT NOCOPY VARCHAR2
2719: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
2720: ,x_apply_type OUT NOCOPY VARCHAR2

Line 2717: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE

2713: ,p_attribute11 IN ar_receivable_applications.attribute11%TYPE
2714: ,p_attribute12 IN ar_receivable_applications.attribute12%TYPE
2715: ,p_attribute13 IN ar_receivable_applications.attribute13%TYPE
2716: ,p_attribute14 IN ar_receivable_applications.attribute14%TYPE
2717: ,p_attribute15 IN ar_receivable_applications.attribute15%TYPE
2718: ,x_return_status OUT NOCOPY VARCHAR2
2719: ,x_receipt_number OUT NOCOPY ar_cash_receipts.receipt_number%TYPE
2720: ,x_apply_type OUT NOCOPY VARCHAR2
2721: ) IS

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

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

Line 2737: FROM ar_receivable_applications

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

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

2740:
2741: --Fetch from receivable application if application is valid
2742: --for receipt to receipt application. Application is 'UNAPP'
2743: CURSOR c2_validate
2744: (p_cr_id ar_receivable_applications.cash_receipt_id%TYPE) IS
2745: SELECT sum(amount_applied)
2746: FROM ar_receivable_applications
2747: WHERE cash_receipt_id = p_cr_id
2748: AND status = 'UNAPP'

Line 2746: FROM ar_receivable_applications

2742: --for receipt to receipt application. Application is 'UNAPP'
2743: CURSOR c2_validate
2744: (p_cr_id ar_receivable_applications.cash_receipt_id%TYPE) IS
2745: SELECT sum(amount_applied)
2746: FROM ar_receivable_applications
2747: WHERE cash_receipt_id = p_cr_id
2748: AND status = 'UNAPP'
2749: HAVING sum(amount_applied) >= p_amount_applied;
2750:

Line 2759: l_amount_applied ar_receivable_applications.amount_applied%TYPE;

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

Line 2762: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

2758: l_process VARCHAR2(1); --'Y'=Process 'N'=Stop Process
2759: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2760: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2761: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2762: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2763: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2764: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2765: l_acctd_amount_applied_from NUMBER;
2766: l_acctd_amount_applied_to NUMBER;

Line 2763: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;

2759: l_amount_applied ar_receivable_applications.amount_applied%TYPE;
2760: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2761: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2762: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2763: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2764: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2765: l_acctd_amount_applied_from NUMBER;
2766: l_acctd_amount_applied_to NUMBER;
2767:

Line 2764: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

2760: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2761: l_open_receipt_number ar_cash_receipts.receipt_number%type;
2762: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2763: l_receivable_application_id ar_receivable_applications.application_ref_num%TYPE;
2764: l_applied_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
2765: l_acctd_amount_applied_from NUMBER;
2766: l_acctd_amount_applied_to NUMBER;
2767:
2768: invalid_param EXCEPTION;