APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RCV_RGM_CLAIMS

Line 4902: FROM jai_rcv_rgm_claims

4898: cp_tax_id IN NUMBER,
4899: cp_schedule_id IN NUMBER)
4900: IS
4901: SELECT COUNT(*) count
4902: FROM jai_rcv_rgm_claims
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

Line 4914: FROM jai_rcv_rgm_claims

4910: cp_transaction_id IN NUMBER,
4911: cp_tax_id IN NUMBER)
4912: IS
4913: SELECT COUNT(*) count
4914: FROM jai_rcv_rgm_claims
4915: WHERE rcv_rgm_line_id = cp_rcv_rgm_line_id
4916: AND transaction_id = cp_transaction_id
4917: AND tax_id = cp_tax_id
4918: AND installment_amount <> 0

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

5011:
5012:
5013: for sch_det in cur_get_schedule(ln_schedule_id)
5014: loop
5015: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;
5016: INSERT
5017: INTO jai_rcv_rgm_claims
5018: (
5019: CLAIM_SCHEDULE_ID,

Line 5017: INTO jai_rcv_rgm_claims

5013: for sch_det in cur_get_schedule(ln_schedule_id)
5014: loop
5015: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;
5016: INSERT
5017: INTO jai_rcv_rgm_claims
5018: (
5019: CLAIM_SCHEDULE_ID,
5020: RCV_RGM_LINE_ID,
5021: Shipment_header_id,

Line 5071: update jai_rcv_rgm_claims

5067: fnd_global.user_id,
5068: SYSDATE,
5069: fnd_global.login_id);
5070: if ln_instpaid_cnt>nvl(ln_cnt,0) then
5071: update jai_rcv_rgm_claims
5072: set claimed_amount=0,
5073: claimed_date=sysdate,
5074: status='Y',
5075: installment_amount=0