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_PAYMENT_SCHEDULES

Line 286: --Get TRX based info from ra_customer_trx and ar_payment_schedules

282: AND ra.status = 'APP'
283: AND ra.display = 'Y'
284: AND ra.request_id = p_request_id;
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

Line 308: ,ar_payment_schedules ps

304: ,ps.class --class
305: ,ps.active_claim_flag --active_claim_flag
306: ,ct.legal_entity_id
307: FROM ra_customer_trx ct
308: ,ar_payment_schedules ps
309: WHERE ct.customer_trx_id = ps.customer_trx_id
310: AND ps.payment_schedule_id = p_trx_ps_id
311: AND ps.class <> 'PMT';
312:

Line 327: FROM ar_payment_schedules ps

323: ,cr.pay_from_customer --customer_id
324: ,cr.customer_site_use_id --bill_to_site_use_id
325: ,NULL --ship_to_site_use_id
326: ,cr.legal_entity_id
327: FROM ar_payment_schedules ps
328: ,ar_cash_receipts cr
329: ,ar_cash_receipt_history crh
330: WHERE ps.payment_schedule_id = p_receipt_ps_id
331: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 341: FROM ar_payment_schedules ps

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
342: ,ar_cash_receipts cr
343: WHERE ps.payment_schedule_id = p_receipt_ps_id
344: AND cr.cash_receipt_id = ps.cash_receipt_id;
345:

Line 485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;

481: l_bill_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;
487: l_class ar_payment_schedules_all.class%type;
488: l_claim_amount NUMBER;
489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;

482: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%type;
483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;
487: l_class ar_payment_schedules_all.class%type;
488: l_claim_amount NUMBER;
489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
490: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

Line 487: l_class ar_payment_schedules_all.class%type;

483: l_receipt_number ar_cash_receipts.receipt_number%type;
484: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
485: l_amount_due_remaining ar_payment_schedules_all.amount_due_remaining%type;
486: l_amount_due_original ar_payment_schedules_all.amount_due_original%type;
487: l_class ar_payment_schedules_all.class%type;
488: l_claim_amount NUMBER;
489: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
490: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
491: l_trx_number ra_customer_trx.trx_number%type;

Line 496: l_claim_status ar_payment_schedules.active_claim_flag%type;

492: l_salesrep_id ra_customer_trx.primary_salesrep_id%type;
493: l_index NUMBER;
494: l_bulk_fetch_rows NUMBER := 400;
495: l_last_fetch BOOLEAN := FALSE;
496: l_claim_status ar_payment_schedules.active_claim_flag%type;
497: l_return_status VARCHAR2(1); --'E','U' = ERROR ;; 'S'=Success;;
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

Line 510: l_active_claim_flag ar_payment_schedules.active_claim_flag%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;
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:

Line 833: -- Update AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM appropriately

829: ELSE -- Claim Creation was successful
830:
831: l_claim_status := 'Y';
832: ---------------------------------------------------------
833: -- Update AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM appropriately
834: ---------------------------------------------------------
835: arp_deduction.update_claim_create_status
836: (p_ps_id => claim_tbl.payment_schedule_id(i)
837: ,p_claim_status => l_claim_status

Line 1135: -- updating AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM_FLAG

1131:
1132: IF l_trx_claim_exist = 'Y' THEN
1133: --------------------------------------------------
1134: -- Claim Status is set appropriately for
1135: -- updating AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM_FLAG
1136: --------------------------------------------------
1137: IF (l_claim_amount = 0) THEN -- Claim Cancel
1138: l_claim_status := 'C';
1139: ELSE -- Claim Open

Line 1294: -- AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM = 'C' for subsequent receipt

1290: IF claim_rec.return_status = 'S' THEN --TM API Return Status = Success
1291:
1292: --------------------------------------------------------------------------
1293: -- Update Payment Schedules with apporpriate claim status in TM
1294: -- AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM = 'C' for subsequent receipt
1295: -- application of Over Pay Claim.
1296: -- AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM = 'Y' for Short Pay Claim Creation
1297: --------------------------------------------------------------------------
1298: IF ( ((l_trx_claim_type = 'S') AND (l_trx_claim_exist = 'N'))

Line 1296: -- AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM = 'Y' for Short Pay Claim Creation

1292: --------------------------------------------------------------------------
1293: -- Update Payment Schedules with apporpriate claim status in TM
1294: -- AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM = 'C' for subsequent receipt
1295: -- application of Over Pay Claim.
1296: -- AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM = 'Y' for Short Pay Claim Creation
1297: --------------------------------------------------------------------------
1298: IF ( ((l_trx_claim_type = 'S') AND (l_trx_claim_exist = 'N'))
1299: OR ((l_trx_claim_exist = 'Y') AND (l_claim_amount = 0))
1300: ) THEN

Line 2250: | This function is called to update ar_payment_schedules,

2246: /*========================================================================
2247: | PUBLIC PROCEDURE UPDATE_CLAIM_CREATE_STATUS
2248: |
2249: | DESCRIPTION
2250: | This function is called to update ar_payment_schedules,
2251: | active_claim_flag column with the appropriate claim status returned
2252: | from TM
2253: |
2254: | SCOPE - PUBLIC

Line 2274: (p_ps_id IN ar_payment_schedules.payment_schedule_id%type

2270: | DD-MON-YYYY Name Bug #####, modified amount ..
2271: |
2272: *=======================================================================*/
2273: PROCEDURE UPDATE_CLAIM_CREATE_STATUS
2274: (p_ps_id IN ar_payment_schedules.payment_schedule_id%type
2275: ,p_claim_status IN ar_payment_schedules.active_claim_flag%type
2276: ) IS
2277:
2278: BEGIN

Line 2275: ,p_claim_status IN ar_payment_schedules.active_claim_flag%type

2271: |
2272: *=======================================================================*/
2273: PROCEDURE UPDATE_CLAIM_CREATE_STATUS
2274: (p_ps_id IN ar_payment_schedules.payment_schedule_id%type
2275: ,p_claim_status IN ar_payment_schedules.active_claim_flag%type
2276: ) IS
2277:
2278: BEGIN
2279:

Line 2283: UPDATE ar_payment_schedules

2279:
2280: -------------------------
2281: -- Update claim status
2282: -------------------------
2283: UPDATE ar_payment_schedules
2284: SET active_claim_flag = p_claim_status
2285: WHERE payment_schedule_id = p_ps_id;
2286:
2287: EXCEPTION

Line 2691: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE

2687: |
2688: *=======================================================================*/
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

Line 2720: (p_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE) IS

2716: ) IS
2717:
2718: --Fetch open_cash_receipt_id
2719: CURSOR get_open_cr_id
2720: (p_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE) IS
2721: SELECT ps.cash_receipt_id, cr.receipt_number
2722: FROM ar_payment_schedules ps
2723: ,ar_cash_receipts cr
2724: WHERE ps.payment_schedule_id = p_applied_ps_id

Line 2722: FROM ar_payment_schedules ps

2718: --Fetch open_cash_receipt_id
2719: CURSOR get_open_cr_id
2720: (p_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE) IS
2721: SELECT ps.cash_receipt_id, cr.receipt_number
2722: FROM ar_payment_schedules ps
2723: ,ar_cash_receipts cr
2724: WHERE ps.payment_schedule_id = p_applied_ps_id
2725: AND ps.cash_receipt_id = cr.cash_receipt_id;
2726:

Line 2999: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE)

2995: | 03-JUN-2003 Debbie Jancis Created
2996: |
2997: *=======================================================================*/
2998: FUNCTION GET_ACTIVE_CLAIM_FLAG(
2999: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE)
3000: RETURN VARCHAR2 IS
3001:
3002: l_active_claim_flag ar_payment_schedules.active_claim_flag%type;
3003:

Line 3002: l_active_claim_flag ar_payment_schedules.active_claim_flag%type;

2998: FUNCTION GET_ACTIVE_CLAIM_FLAG(
2999: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE)
3000: RETURN VARCHAR2 IS
3001:
3002: l_active_claim_flag ar_payment_schedules.active_claim_flag%type;
3003:
3004: BEGIN
3005:
3006: SELECT nvl(active_claim_flag,'N')

Line 3008: FROM ar_payment_schedules

3004: BEGIN
3005:
3006: SELECT nvl(active_claim_flag,'N')
3007: INTO l_active_claim_flag
3008: FROM ar_payment_schedules
3009: WHERE payment_schedule_id = p_payment_schedule_id;
3010:
3011: RETURN l_active_claim_flag;
3012: