eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RCV_RGM_LINES

Line 1759: jai_rcv_rgm_lines_rec jai_rcv_rgm_lines%ROWTYPE;

1755: IS
1756: --This procedure is used to CLAIm or UNCLAIM VAT to the extent it got modified
1757: --It does the corresponding accounting as well
1758:
1759: jai_rcv_rgm_lines_rec jai_rcv_rgm_lines%ROWTYPE;
1760: rcv_transactions_rec rcv_transactions%ROWTYPE;
1761: ln_tot_clm_instl_amt NUMBER;
1762: ln_tot_instl_amt NUMBER;
1763: ln_installment_cnt NUMBER;

Line 1797: CURSOR jai_rcv_rgm_lines_cur (pn_shipment_line_id NUMBER)

1793: rcv_transactions
1794: WHERE
1795: transaction_id = pn_transaction_id;
1796:
1797: CURSOR jai_rcv_rgm_lines_cur (pn_shipment_line_id NUMBER)
1798: IS
1799: SELECT
1800: *
1801: FROM

Line 1802: jai_rcv_rgm_lines

1798: IS
1799: SELECT
1800: *
1801: FROM
1802: jai_rcv_rgm_lines
1803: WHERE shipment_line_id = pn_shipment_line_id ;
1804:
1805: CURSOR jai_rcv_rgm_instl_count_cur
1806: ( pn_rcv_rgm_line_id NUMBER

Line 1871: jai_rcv_rgm_lines jrrl

1867: , jrrl.location_id
1868: , jrl.receipt_num
1869: , jrd.regime_id
1870: FROM
1871: jai_rcv_rgm_lines jrrl
1872: , jai_rgm_definitions jrd
1873: , jai_rcv_lines jrl
1874: WHERE jrrl.rcv_rgm_line_id = pn_rcv_rgm_line_id
1875: AND jrrl.shipment_line_id = jrl.shipment_line_id

Line 1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )

1901: INTO lv_receipt_number
1902: FROM jai_rcv_lines
1903: WHERE shipment_line_id = pn_shipment_line_id;
1904:
1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1907: FETCH jai_rcv_rgm_lines_cur
1908: INTO jai_rcv_rgm_lines_rec;
1909: CLOSE jai_rcv_rgm_lines_cur;

Line 1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);

1902: FROM jai_rcv_lines
1903: WHERE shipment_line_id = pn_shipment_line_id;
1904:
1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1907: FETCH jai_rcv_rgm_lines_cur
1908: INTO jai_rcv_rgm_lines_rec;
1909: CLOSE jai_rcv_rgm_lines_cur;
1910:

Line 1907: FETCH jai_rcv_rgm_lines_cur

1903: WHERE shipment_line_id = pn_shipment_line_id;
1904:
1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1907: FETCH jai_rcv_rgm_lines_cur
1908: INTO jai_rcv_rgm_lines_rec;
1909: CLOSE jai_rcv_rgm_lines_cur;
1910:
1911:

Line 1908: INTO jai_rcv_rgm_lines_rec;

1904:
1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1907: FETCH jai_rcv_rgm_lines_cur
1908: INTO jai_rcv_rgm_lines_rec;
1909: CLOSE jai_rcv_rgm_lines_cur;
1910:
1911:
1912: --deleted by eric for bug#6968733 on Apr 15,2008,begin

Line 1909: CLOSE jai_rcv_rgm_lines_cur;

1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1907: FETCH jai_rcv_rgm_lines_cur
1908: INTO jai_rcv_rgm_lines_rec;
1909: CLOSE jai_rcv_rgm_lines_cur;
1910:
1911:
1912: --deleted by eric for bug#6968733 on Apr 15,2008,begin
1913: ----------------------------------------------------------------------

Line 1917: ( pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)

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;
1920: CLOSE jai_rcv_rgm_instl_count_cur;
1921: */

Line 1949: ( pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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: );
1952: FETCH jai_rcv_rgm_instl_count_cur
1953: INTO ln_installment_cnt;

Line 1965: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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:
1968:
1969: --get no of installments which are claimed for this tax_id by counting the records for which

Line 1972: ( pn_rcv_rgm_line_id => jai_rcv_rgm_lines_rec.rcv_rgm_line_id

1968:
1969: --get no of installments which are claimed for this tax_id by counting the records for which
1970: --claimed_amount is populated (ln_instl_claimed_cnt)
1971: OPEN jai_rcv_rgm_claimed_count_cur
1972: ( pn_rcv_rgm_line_id => jai_rcv_rgm_lines_rec.rcv_rgm_line_id
1973: , pn_tax_id => jai_retor_tax_changes_rec.tax_id
1974: );
1975: FETCH jai_rcv_rgm_claimed_count_cur
1976: INTO ln_tax_instl_claimed_cnt;

Line 1996: --Update jai_rcv_rgm_lines to increment recoverable_amount

1992: END LOOP; -- (jai_retor_tax_changes_rec IN jai_retro_tax_changes_cur)
1993:
1994: IF ln_tot_instl_amt <> 0
1995: THEN
1996: --Update jai_rcv_rgm_lines to increment recoverable_amount
1997:
1998: UPDATE jai_rcv_rgm_lines
1999: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
2000: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;

Line 1998: UPDATE jai_rcv_rgm_lines

1994: IF ln_tot_instl_amt <> 0
1995: THEN
1996: --Update jai_rcv_rgm_lines to increment recoverable_amount
1997:
1998: UPDATE jai_rcv_rgm_lines
1999: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
2000: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2001: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.
2002:

Line 2000: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;

1996: --Update jai_rcv_rgm_lines to increment recoverable_amount
1997:
1998: UPDATE jai_rcv_rgm_lines
1999: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
2000: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2001: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.
2002:
2003: END IF;-- (ln_tot_instl_amt <> 0 )
2004:

Line 2001: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.

1997:
1998: UPDATE jai_rcv_rgm_lines
1999: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
2000: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2001: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.
2002:
2003: END IF;-- (ln_tot_instl_amt <> 0 )
2004:
2005:

Line 2009: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed

2005:
2006: --IF any amount is claimed THEN
2007: IF ln_tot_clm_instl_amt <>0
2008: THEN
2009: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2010: UPDATE jai_rcv_rgm_lines
2011: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2012: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2013: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.

Line 2010: UPDATE jai_rcv_rgm_lines

2006: --IF any amount is claimed THEN
2007: IF ln_tot_clm_instl_amt <>0
2008: THEN
2009: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2010: UPDATE jai_rcv_rgm_lines
2011: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2012: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2013: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.
2014:

Line 2012: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;

2008: THEN
2009: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2010: UPDATE jai_rcv_rgm_lines
2011: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2012: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2013: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.
2014:
2015: END IF; -- (ln_tot_clm_instl_amt <>0)
2016:

Line 2013: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.

2009: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2010: UPDATE jai_rcv_rgm_lines
2011: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2012: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2013: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id; -- Modified by Jia for bug#6988208, on Apr 21, 2008.
2014:
2015: END IF; -- (ln_tot_clm_instl_amt <>0)
2016:
2017: FOR claim_schedule_rec IN get_claim_schedule_cur

Line 2018: (pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)

2014:
2015: END IF; -- (ln_tot_clm_instl_amt <>0)
2016:
2017: FOR claim_schedule_rec IN get_claim_schedule_cur
2018: (pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)
2019: LOOP
2020: OPEN get_parameters_cur (jai_rcv_rgm_lines_rec.rcv_rgm_line_id);
2021: FETCH get_parameters_cur
2022: INTO

Line 2020: OPEN get_parameters_cur (jai_rcv_rgm_lines_rec.rcv_rgm_line_id);

2016:
2017: FOR claim_schedule_rec IN get_claim_schedule_cur
2018: (pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)
2019: LOOP
2020: OPEN get_parameters_cur (jai_rcv_rgm_lines_rec.rcv_rgm_line_id);
2021: FETCH get_parameters_cur
2022: INTO
2023: ln_organization_id
2024: , ln_location_id

Line 2176: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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;
2179:
2180: END LOOP; -- claimed records