APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RGM_TRM_SCHEDULES_T

Line 11: Also removed a delete statement which was deleting from jai_rgm_trm_schedules_t if

7: ------------------------------------------------------------------------------------------------------------------------
8: 1 24-Jan-2007 rchandan for #2942973 for File Version 115.6 (INTER ORG Impl.)
9: The parameter p_receipt_num in claim_balance_cgvat was defined as NUMBER and
10: so the query was not happening properly. Now it is defined as VARCHAR2.
11: Also removed a delete statement which was deleting from jai_rgm_trm_schedules_t if
12: there were any installments generated already.
13:
14: 2 26/01/2007 cbabu for bug#2942973 Version: 115.9 (INTER ORG Impl.)
15: Added the procedures

Line 4450: FROM jai_rgm_trm_schedules_t

4446:
4447: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
4448: IS
4449: SELECT SUM(installment_amount) total_installment_amount, MAX(installment_no) max_installment_no
4450: FROM jai_rgm_trm_schedules_t
4451: WHERE schedule_id = cp_schedule_id;
4452:
4453:
4454: CURSOR cur_installment_count( cp_rcv_rgm_line_id IN NUMBER,

Line 4465: FROM jai_rgm_trm_schedules_t

4461: WHERE rcv_rgm_line_id = cp_rcv_rgm_line_id
4462: AND transaction_id = cp_transaction_id
4463: AND tax_id = cp_tax_id
4464: AND installment_no IN ( SELECT installment_no
4465: FROM jai_rgm_trm_schedules_t
4466: WHERE schedule_id = cp_schedule_id);
4467: CURSOR cur_installpaid_count( cp_rcv_rgm_line_id IN NUMBER,
4468: cp_transaction_id IN NUMBER,
4469: cp_tax_id IN NUMBER)

Line 4483: select * from jai_rgm_trm_schedules_t

4479:
4480:
4481: cursor cur_get_schedule(cp_schedule_id in number)
4482: is
4483: select * from jai_rgm_trm_schedules_t
4484: where schedule_id=cp_schedule_id
4485: order by installment_no;
4486:
4487: r_term cur_term%ROWTYPE;

Line 4535: DELETE jai_rgm_trm_schedules_t

4531: p_process_msg => lv_process_msg);
4532:
4533: IF lv_process_flag <> jai_constants.successful THEN
4534:
4535: DELETE jai_rgm_trm_schedules_t
4536: WHERE schedule_id = ln_schedule_id;
4537:
4538: p_process_status := lv_process_flag;
4539: p_process_message := lv_process_msg;

Line 4544: UPDATE jai_rgm_trm_schedules_t

4540: RETURN;
4541: END IF;
4542:
4543:
4544: UPDATE jai_rgm_trm_schedules_t
4545: SET installment_amount = ROUND(installment_amount, tax_rec.rounding_factor)
4546: WHERE schedule_id = ln_schedule_id;
4547:
4548: OPEN cur_sum_schedules(ln_schedule_id);

Line 4553: UPDATE jai_rgm_trm_schedules_t

4549: FETCH cur_sum_schedules INTO r_sum_schedules;
4550: CLOSE cur_sum_schedules;
4551:
4552: IF NVL(r_sum_schedules.total_installment_amount,0) <> NVL(ln_amount,0) THEN
4553: UPDATE jai_rgm_trm_schedules_t
4554: SET installment_amount = installment_amount + ln_amount - r_sum_schedules.total_installment_amount
4555: WHERE installment_no = r_sum_schedules.max_installment_no
4556: AND schedule_id = ln_schedule_id;
4557: END IF;

Line 4565: UPDATE jai_rgm_trm_schedules_t

4561:
4562: FETCH cur_installpaid_count INTO ln_instpaid_cnt;
4563: CLOSE cur_installpaid_count;
4564:
4565: UPDATE jai_rgm_trm_schedules_t
4566: SET installment_amount = installment_amount * (-1) /*This is to reduce the quantity available for claim*/
4567: WHERE schedule_id = ln_schedule_id;
4568:
4569:

Line 4662: DELETE jai_rgm_trm_schedules_t

4658: if lv_process_flag<> jai_constants.successful THEN
4659: app_exception.raise_exception;
4660: end if;
4661:
4662: DELETE jai_rgm_trm_schedules_t
4663: WHERE schedule_id = ln_schedule_id;
4664:
4665: END LOOP;
4666: