APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RCV_RGM_CLAIMS

Line 1808: jai_rcv_rgm_claims

1804: IS
1805: SELECT
1806: COUNT(*)
1807: FROM
1808: jai_rcv_rgm_claims
1809: WHERE rcv_rgm_line_id = pn_rcv_rgm_line_id
1810: AND tax_id = NVL(pn_tax_id,tax_id); --added by eric for bug#6968733 on Apr 15,2008
1811:
1812:

Line 1821: jai_rcv_rgm_claims

1817: IS
1818: SELECT
1819: COUNT(*)
1820: FROM
1821: jai_rcv_rgm_claims
1822: WHERE rcv_rgm_line_id = pn_rcv_rgm_line_id
1823: AND tax_id = NVL(pn_tax_id,tax_id)
1824: AND claimed_amount IS NOT NULL;
1825:

Line 1853: jai_rcv_rgm_claims A

1849: SUM( a.installment_amount - a.claimed_amount ) claim_amount
1850: , tax_type
1851: , MIN(claim_schedule_id) claim_schedule_id
1852: FROM
1853: jai_rcv_rgm_claims A
1854: WHERE rcv_rgm_line_id = pn_rcv_rgm_line_id
1855: AND claimed_amount IS NOT NULL
1856: GROUP BY a.tax_type;
1857:

Line 1910: --Get the count of installments from jai_rcv_rgm_claims for the rcv_rgm_line_id from the above record(ln_installment_cnt)

1906:
1907: --deleted by eric for bug#6968733 on Apr 15,2008,begin
1908: ----------------------------------------------------------------------
1909: /*
1910: --Get the count of installments from jai_rcv_rgm_claims for the rcv_rgm_line_id from the above record(ln_installment_cnt)
1911: OPEN jai_rcv_rgm_instl_count_cur
1912: ( pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)
1913: FETCH jai_rcv_rgm_instl_count_cur
1914: INTO ln_installment_cnt;

Line 1942: --Get the count of installments from jai_rcv_rgm_claims for the rcv_rgm_line_id from the above record(ln_installment_cnt)

1938: ln_diff_re_tax_amt := ln_new_re_tax_amt - ln_orig_re_tax_amt;
1939:
1940: --added by eric for bug#6968733 on Apr 15,2008,begin
1941: ----------------------------------------------------------------------
1942: --Get the count of installments from jai_rcv_rgm_claims for the rcv_rgm_line_id from the above record(ln_installment_cnt)
1943: OPEN jai_rcv_rgm_instl_count_cur
1944: ( pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id
1945: , pn_tax_id => jai_retor_tax_changes_rec.tax_id
1946: );

Line 1957: --Update jai_rcv_rgm_claims to increment installment amount

1953:
1954: -- calculate the installment difference amount by doing ln_diff_re_tax_amt / ln_installment_cnt( ln_instl_diff )
1955: ln_instl_diff := ln_diff_re_tax_amt/ln_installment_cnt;
1956:
1957: --Update jai_rcv_rgm_claims to increment installment amount
1958: UPDATE jai_rcv_rgm_claims
1959: SET installment_amount = installment_amount + ln_instl_diff
1960: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id
1961: AND tax_id = jai_retor_tax_changes_rec.tax_id;

Line 1958: UPDATE jai_rcv_rgm_claims

1954: -- calculate the installment difference amount by doing ln_diff_re_tax_amt / ln_installment_cnt( ln_instl_diff )
1955: ln_instl_diff := ln_diff_re_tax_amt/ln_installment_cnt;
1956:
1957: --Update jai_rcv_rgm_claims to increment installment amount
1958: UPDATE jai_rcv_rgm_claims
1959: SET installment_amount = installment_amount + ln_instl_diff
1960: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id
1961: AND tax_id = jai_retor_tax_changes_rec.tax_id;
1962:

Line 2163: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made

2159: IF lv_process_status <> jai_constants.successful THEN
2160: raise_application_error(-20120,'VAT Claim accounting retruned with error : '||lv_process_message);
2161: END IF;
2162:
2163: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made
2164:
2165: UPDATE jai_rcv_rgm_claims
2166: SET claimed_amount = installment_amount
2167: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id

Line 2165: UPDATE jai_rcv_rgm_claims

2161: END IF;
2162:
2163: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made
2164:
2165: UPDATE jai_rcv_rgm_claims
2166: SET claimed_amount = installment_amount
2167: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id
2168: AND tax_type = claim_schedule_rec.tax_type -- Current tax type in the loop
2169: AND claimed_amount IS NOT NULL;