APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RGM_TRM_SCHEDULES_T

Line 504: FROM jai_rgm_trm_schedules_t

500:
501: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
502: IS
503: SELECT SUM(installment_amount) total_installment_amount, MAX(installment_no) max_installment_no
504: FROM jai_rgm_trm_schedules_t
505: WHERE schedule_id = cp_schedule_id;
506:
507: --Added the cursor for Bug#4950914
508: CURSOR cur_installment_count( cp_rcv_rgm_line_id IN NUMBER,

Line 519: FROM jai_rgm_trm_schedules_t

515: WHERE rcv_rgm_line_id = cp_rcv_rgm_line_id
516: AND transaction_id = cp_transaction_id
517: AND tax_id = cp_tax_id
518: AND installment_no IN ( SELECT installment_no
519: FROM jai_rgm_trm_schedules_t
520: WHERE schedule_id = cp_schedule_id);
521:
522:
523: r_term cur_term%ROWTYPE;

Line 592: DELETE jai_rgm_trm_schedules_t

588:
589: IF lv_process_flag <> jai_constants.successful THEN
590:
591: --Added for Bug#4950914
592: DELETE jai_rgm_trm_schedules_t
593: WHERE schedule_id = ln_schedule_id;
594: fnd_file.put_line(fnd_file.log, ' After Generating jai_cmn_rgm_terms_pkg.generate_term_schedules');
595: p_process_status := lv_process_flag;
596: p_process_message := lv_process_msg;

Line 612: DELETE jai_rgm_trm_schedules_t

608: FETCH cur_installment_count INTO r_installment_count;
609: CLOSE cur_installment_count;
610:
611: IF r_installment_count.count > 0 THEN
612: DELETE jai_rgm_trm_schedules_t
613: WHERE schedule_id = ln_schedule_id;
614:
615: IF p_simulate_flag = 'Y' THEN
616: p_process_status := jai_constants.expected_error;

Line 630: UPDATE jai_rgm_trm_schedules_t

626:
627: IF p_simulate_flag = 'N' THEN
628: --End Added by Sanjikum for Bug#4950914
629:
630: UPDATE jai_rgm_trm_schedules_t
631: SET installment_amount = ROUND(installment_amount, tax_rec.rounding_factor)
632: WHERE schedule_id = ln_schedule_id;
633:
634: OPEN cur_sum_schedules(ln_schedule_id);

Line 638: UPDATE jai_rgm_trm_schedules_t

634: OPEN cur_sum_schedules(ln_schedule_id);
635: FETCH cur_sum_schedules INTO r_sum_schedules;
636: CLOSE cur_sum_schedules;
637: IF NVL(r_sum_schedules.total_installment_amount,0) <> NVL(ln_amount,0) THEN
638: UPDATE jai_rgm_trm_schedules_t
639: SET installment_amount = installment_amount + ln_amount - r_sum_schedules.total_installment_amount
640: WHERE installment_no = r_sum_schedules.max_installment_no
641: AND schedule_id = ln_schedule_id;
642: END IF;

Line 644: UPDATE jai_rgm_trm_schedules_t

640: WHERE installment_no = r_sum_schedules.max_installment_no
641: AND schedule_id = ln_schedule_id;
642: END IF;
643:
644: UPDATE jai_rgm_trm_schedules_t
645: SET installment_amount = installment_amount*rec_txns.quantity_multiplier
646: WHERE schedule_id = ln_schedule_id;
647:
648: INSERT

Line 702: FROM jai_rgm_trm_schedules_t

698: SYSDATE,
699: fnd_global.user_id,
700: SYSDATE,
701: fnd_global.login_id
702: FROM jai_rgm_trm_schedules_t
703: WHERE schedule_id = ln_schedule_id;
704: END IF; --end of p_simulate_flag
705:
706:

Line 707: DELETE jai_rgm_trm_schedules_t

703: WHERE schedule_id = ln_schedule_id;
704: END IF; --end of p_simulate_flag
705:
706:
707: DELETE jai_rgm_trm_schedules_t
708: WHERE schedule_id = ln_schedule_id;
709:
710: END LOOP;
711: END LOOP;