APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RCV_RGM_CLAIMS

Line 1813: jai_rcv_rgm_claims

1809: IS
1810: SELECT
1811: COUNT(*)
1812: FROM
1813: jai_rcv_rgm_claims
1814: WHERE rcv_rgm_line_id = pn_rcv_rgm_line_id
1815: AND tax_id = NVL(pn_tax_id,tax_id); --added by eric for bug#6968733 on Apr 15,2008
1816:
1817:

Line 1826: jai_rcv_rgm_claims

1822: IS
1823: SELECT
1824: COUNT(*)
1825: FROM
1826: jai_rcv_rgm_claims
1827: WHERE rcv_rgm_line_id = pn_rcv_rgm_line_id
1828: AND tax_id = NVL(pn_tax_id,tax_id)
1829: AND claimed_amount IS NOT NULL;
1830:

Line 1858: jai_rcv_rgm_claims A

1854: SUM( a.installment_amount - a.claimed_amount ) claim_amount
1855: , tax_type
1856: , MIN(claim_schedule_id) claim_schedule_id
1857: FROM
1858: jai_rcv_rgm_claims A
1859: WHERE rcv_rgm_line_id = pn_rcv_rgm_line_id
1860: AND claimed_amount IS NOT NULL
1861: GROUP BY a.tax_type;
1862:

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

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

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

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

Line 1962: --Update jai_rcv_rgm_claims to increment installment amount

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

Line 1963: UPDATE jai_rcv_rgm_claims

1959: -- calculate the installment difference amount by doing ln_diff_re_tax_amt / ln_installment_cnt( ln_instl_diff )
1960: ln_instl_diff := ln_diff_re_tax_amt/ln_installment_cnt;
1961:
1962: --Update jai_rcv_rgm_claims to increment installment amount
1963: UPDATE jai_rcv_rgm_claims
1964: SET installment_amount = installment_amount + ln_instl_diff
1965: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id
1966: AND tax_id = jai_retor_tax_changes_rec.tax_id;
1967:

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

2168: IF lv_process_status <> jai_constants.successful THEN
2169: raise_application_error(-20120,'VAT Claim accounting retruned with error : '||lv_process_message);
2170: END IF;
2171:
2172: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made
2173:
2174: UPDATE jai_rcv_rgm_claims
2175: SET claimed_amount = installment_amount
2176: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id

Line 2174: UPDATE jai_rcv_rgm_claims

2170: END IF;
2171:
2172: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made
2173:
2174: UPDATE jai_rcv_rgm_claims
2175: SET claimed_amount = installment_amount
2176: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id
2177: AND tax_type = claim_schedule_rec.tax_type -- Current tax type in the loop
2178: AND claimed_amount IS NOT NULL;