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 1139: -- updating AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM_FLAG

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

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

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

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

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

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

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

Line 2278: (p_ps_id IN ar_payment_schedules.payment_schedule_id%type

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

Line 2279: ,p_claim_status IN ar_payment_schedules.active_claim_flag%type

2275: |
2276: *=======================================================================*/
2277: PROCEDURE UPDATE_CLAIM_CREATE_STATUS
2278: (p_ps_id IN ar_payment_schedules.payment_schedule_id%type
2279: ,p_claim_status IN ar_payment_schedules.active_claim_flag%type
2280: ) IS
2281:
2282: BEGIN
2283:

Line 2287: UPDATE ar_payment_schedules

2283:
2284: -------------------------
2285: -- Update claim status
2286: -------------------------
2287: UPDATE ar_payment_schedules
2288: SET active_claim_flag = p_claim_status
2289: WHERE payment_schedule_id = p_ps_id;
2290:
2291: EXCEPTION

Line 2696: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE

2692: |
2693: *=======================================================================*/
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

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

2721: ) IS
2722:
2723: --Fetch open_cash_receipt_id
2724: CURSOR get_open_cr_id
2725: (p_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE) IS
2726: SELECT ps.cash_receipt_id, cr.receipt_number
2727: FROM ar_payment_schedules ps
2728: ,ar_cash_receipts cr
2729: WHERE ps.payment_schedule_id = p_applied_ps_id

Line 2727: FROM ar_payment_schedules ps

2723: --Fetch open_cash_receipt_id
2724: CURSOR get_open_cr_id
2725: (p_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE) IS
2726: SELECT ps.cash_receipt_id, cr.receipt_number
2727: FROM ar_payment_schedules ps
2728: ,ar_cash_receipts cr
2729: WHERE ps.payment_schedule_id = p_applied_ps_id
2730: AND ps.cash_receipt_id = cr.cash_receipt_id;
2731:

Line 3004: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE)

3000: | 03-JUN-2003 Debbie Jancis Created
3001: |
3002: *=======================================================================*/
3003: FUNCTION GET_ACTIVE_CLAIM_FLAG(
3004: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE)
3005: RETURN VARCHAR2 IS
3006:
3007: l_active_claim_flag ar_payment_schedules.active_claim_flag%type;
3008:

Line 3007: l_active_claim_flag ar_payment_schedules.active_claim_flag%type;

3003: FUNCTION GET_ACTIVE_CLAIM_FLAG(
3004: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE)
3005: RETURN VARCHAR2 IS
3006:
3007: l_active_claim_flag ar_payment_schedules.active_claim_flag%type;
3008:
3009: BEGIN
3010:
3011: SELECT nvl(active_claim_flag,'N')

Line 3013: FROM ar_payment_schedules

3009: BEGIN
3010:
3011: SELECT nvl(active_claim_flag,'N')
3012: INTO l_active_claim_flag
3013: FROM ar_payment_schedules
3014: WHERE payment_schedule_id = p_payment_schedule_id;
3015:
3016: RETURN l_active_claim_flag;
3017: