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 4892: FROM jai_rgm_trm_schedules_t

4888:
4889: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
4890: IS
4891: SELECT SUM(installment_amount) total_installment_amount, MAX(installment_no) max_installment_no
4892: FROM jai_rgm_trm_schedules_t
4893: WHERE schedule_id = cp_schedule_id;
4894:
4895:
4896: CURSOR cur_installment_count( cp_rcv_rgm_line_id IN NUMBER,

Line 4907: FROM jai_rgm_trm_schedules_t

4903: WHERE rcv_rgm_line_id = cp_rcv_rgm_line_id
4904: AND transaction_id = cp_transaction_id
4905: AND tax_id = cp_tax_id
4906: AND installment_no IN ( SELECT installment_no
4907: FROM jai_rgm_trm_schedules_t
4908: WHERE schedule_id = cp_schedule_id);
4909: CURSOR cur_installpaid_count( cp_rcv_rgm_line_id IN NUMBER,
4910: cp_transaction_id IN NUMBER,
4911: cp_tax_id IN NUMBER)

Line 4925: select * from jai_rgm_trm_schedules_t

4921:
4922:
4923: cursor cur_get_schedule(cp_schedule_id in number)
4924: is
4925: select * from jai_rgm_trm_schedules_t
4926: where schedule_id=cp_schedule_id
4927: order by installment_no;
4928:
4929: r_term cur_term%ROWTYPE;

Line 4978: DELETE jai_rgm_trm_schedules_t

4974: p_process_msg => lv_process_msg);
4975:
4976: IF lv_process_flag <> jai_constants.successful THEN
4977:
4978: DELETE jai_rgm_trm_schedules_t
4979: WHERE schedule_id = ln_schedule_id;
4980:
4981: p_process_status := lv_process_flag;
4982: p_process_message := lv_process_msg;

Line 4987: UPDATE jai_rgm_trm_schedules_t

4983: RETURN;
4984: END IF;
4985:
4986:
4987: UPDATE jai_rgm_trm_schedules_t
4988: SET installment_amount = ROUND(installment_amount, tax_rec.rounding_factor)
4989: WHERE schedule_id = ln_schedule_id;
4990:
4991: OPEN cur_sum_schedules(ln_schedule_id);

Line 4996: UPDATE jai_rgm_trm_schedules_t

4992: FETCH cur_sum_schedules INTO r_sum_schedules;
4993: CLOSE cur_sum_schedules;
4994:
4995: IF NVL(r_sum_schedules.total_installment_amount,0) <> NVL(ln_amount,0) THEN
4996: UPDATE jai_rgm_trm_schedules_t
4997: SET installment_amount = installment_amount + ln_amount - r_sum_schedules.total_installment_amount
4998: WHERE installment_no = r_sum_schedules.max_installment_no
4999: AND schedule_id = ln_schedule_id;
5000: END IF;

Line 5008: UPDATE jai_rgm_trm_schedules_t

5004:
5005: FETCH cur_installpaid_count INTO ln_instpaid_cnt;
5006: CLOSE cur_installpaid_count;
5007:
5008: UPDATE jai_rgm_trm_schedules_t
5009: SET installment_amount = installment_amount * (-1) /*This is to reduce the quantity available for claim*/
5010: WHERE schedule_id = ln_schedule_id;
5011:
5012:

Line 5105: DELETE jai_rgm_trm_schedules_t

5101: if lv_process_flag<> jai_constants.successful THEN
5102: app_exception.raise_exception;
5103: end if;
5104:
5105: DELETE jai_rgm_trm_schedules_t
5106: WHERE schedule_id = ln_schedule_id;
5107:
5108: END LOOP;
5109: