APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RGM_TRM_SCHEDULES_T

Line 437: FROM jai_rgm_trm_schedules_t

433:
434: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
435: IS
436: SELECT SUM(installment_amount) total_installment_amount, MAX(installment_no) max_installment_no
437: FROM jai_rgm_trm_schedules_t
438: WHERE schedule_id = cp_schedule_id;
439:
440: --Added the cursor for Bug#4950914
441: CURSOR cur_installment_count( cp_rcv_rgm_line_id IN NUMBER,

Line 452: FROM jai_rgm_trm_schedules_t

448: WHERE rcv_rgm_line_id = cp_rcv_rgm_line_id
449: AND transaction_id = cp_transaction_id
450: AND tax_id = cp_tax_id
451: AND installment_no IN ( SELECT installment_no
452: FROM jai_rgm_trm_schedules_t
453: WHERE schedule_id = cp_schedule_id);
454:
455:
456: r_term cur_term%ROWTYPE;

Line 522: DELETE jai_rgm_trm_schedules_t

518:
519: IF lv_process_flag <> jai_constants.successful THEN
520:
521: --Added for Bug#4950914
522: DELETE jai_rgm_trm_schedules_t
523: WHERE schedule_id = ln_schedule_id;
524: fnd_file.put_line(fnd_file.log, ' After Generating jai_cmn_rgm_terms_pkg.generate_term_schedules');
525: p_process_status := lv_process_flag;
526: p_process_message := lv_process_msg;

Line 542: DELETE jai_rgm_trm_schedules_t

538: FETCH cur_installment_count INTO r_installment_count;
539: CLOSE cur_installment_count;
540:
541: IF r_installment_count.count > 0 THEN
542: DELETE jai_rgm_trm_schedules_t
543: WHERE schedule_id = ln_schedule_id;
544:
545: IF p_simulate_flag = 'Y' THEN
546: p_process_status := jai_constants.expected_error;

Line 560: UPDATE jai_rgm_trm_schedules_t

556:
557: IF p_simulate_flag = 'N' THEN
558: --End Added by Sanjikum for Bug#4950914
559:
560: UPDATE jai_rgm_trm_schedules_t
561: SET installment_amount = ROUND(installment_amount, tax_rec.rounding_factor)
562: WHERE schedule_id = ln_schedule_id;
563:
564: OPEN cur_sum_schedules(ln_schedule_id);

Line 568: UPDATE jai_rgm_trm_schedules_t

564: OPEN cur_sum_schedules(ln_schedule_id);
565: FETCH cur_sum_schedules INTO r_sum_schedules;
566: CLOSE cur_sum_schedules;
567: IF NVL(r_sum_schedules.total_installment_amount,0) <> NVL(ln_amount,0) THEN
568: UPDATE jai_rgm_trm_schedules_t
569: SET installment_amount = installment_amount + ln_amount - r_sum_schedules.total_installment_amount
570: WHERE installment_no = r_sum_schedules.max_installment_no
571: AND schedule_id = ln_schedule_id;
572: END IF;

Line 574: UPDATE jai_rgm_trm_schedules_t

570: WHERE installment_no = r_sum_schedules.max_installment_no
571: AND schedule_id = ln_schedule_id;
572: END IF;
573:
574: UPDATE jai_rgm_trm_schedules_t
575: SET installment_amount = installment_amount*rec_txns.quantity_multiplier
576: WHERE schedule_id = ln_schedule_id;
577:
578: INSERT

Line 632: FROM jai_rgm_trm_schedules_t

628: SYSDATE,
629: fnd_global.user_id,
630: SYSDATE,
631: fnd_global.login_id
632: FROM jai_rgm_trm_schedules_t
633: WHERE schedule_id = ln_schedule_id;
634: END IF; --end of p_simulate_flag
635:
636:

Line 637: DELETE jai_rgm_trm_schedules_t

633: WHERE schedule_id = ln_schedule_id;
634: END IF; --end of p_simulate_flag
635:
636:
637: DELETE jai_rgm_trm_schedules_t
638: WHERE schedule_id = ln_schedule_id;
639:
640: END LOOP;
641: END LOOP;