APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_RGM_CLAIMS

Line 4460: FROM jai_rcv_rgm_claims

4456: cp_tax_id IN NUMBER,
4457: cp_schedule_id IN NUMBER)
4458: IS
4459: SELECT COUNT(*) count
4460: FROM jai_rcv_rgm_claims
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

Line 4472: FROM jai_rcv_rgm_claims

4468: cp_transaction_id IN NUMBER,
4469: cp_tax_id IN NUMBER)
4470: IS
4471: SELECT COUNT(*) count
4472: FROM jai_rcv_rgm_claims
4473: WHERE rcv_rgm_line_id = cp_rcv_rgm_line_id
4474: AND transaction_id = cp_transaction_id
4475: AND tax_id = cp_tax_id
4476: AND installment_amount <> 0

Line 4572: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;

4568:
4569:
4570: for sch_det in cur_get_schedule(ln_schedule_id)
4571: loop
4572: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;
4573: INSERT
4574: INTO jai_rcv_rgm_claims
4575: (
4576: CLAIM_SCHEDULE_ID,

Line 4574: INTO jai_rcv_rgm_claims

4570: for sch_det in cur_get_schedule(ln_schedule_id)
4571: loop
4572: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;
4573: INSERT
4574: INTO jai_rcv_rgm_claims
4575: (
4576: CLAIM_SCHEDULE_ID,
4577: RCV_RGM_LINE_ID,
4578: Shipment_header_id,

Line 4628: update jai_rcv_rgm_claims

4624: fnd_global.user_id,
4625: SYSDATE,
4626: fnd_global.login_id);
4627: if ln_instpaid_cnt>nvl(ln_cnt,0) then
4628: update jai_rcv_rgm_claims
4629: set claimed_amount=0,
4630: claimed_date=sysdate,
4631: status='Y',
4632: installment_amount=0