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 1754: jai_rcv_rgm_lines_rec jai_rcv_rgm_lines%ROWTYPE;

1750: IS
1751: --This procedure is used to CLAIm or UNCLAIM VAT to the extent it got modified
1752: --It does the corresponding accounting as well
1753:
1754: jai_rcv_rgm_lines_rec jai_rcv_rgm_lines%ROWTYPE;
1755: rcv_transactions_rec rcv_transactions%ROWTYPE;
1756: ln_tot_clm_instl_amt NUMBER;
1757: ln_tot_instl_amt NUMBER;
1758: ln_installment_cnt NUMBER;

Line 1792: CURSOR jai_rcv_rgm_lines_cur (pn_shipment_line_id NUMBER)

1788: rcv_transactions
1789: WHERE
1790: transaction_id = pn_transaction_id;
1791:
1792: CURSOR jai_rcv_rgm_lines_cur (pn_shipment_line_id NUMBER)
1793: IS
1794: SELECT
1795: *
1796: FROM

Line 1797: jai_rcv_rgm_lines

1793: IS
1794: SELECT
1795: *
1796: FROM
1797: jai_rcv_rgm_lines
1798: WHERE shipment_line_id = pn_shipment_line_id ;
1799:
1800: CURSOR jai_rcv_rgm_instl_count_cur
1801: ( pn_rcv_rgm_line_id NUMBER

Line 1866: jai_rcv_rgm_lines jrrl

1862: , jrrl.location_id
1863: , jrl.receipt_num
1864: , jrd.regime_id
1865: FROM
1866: jai_rcv_rgm_lines jrrl
1867: , jai_rgm_definitions jrd
1868: , jai_rcv_lines jrl
1869: WHERE jrrl.rcv_rgm_line_id = pn_rcv_rgm_line_id
1870: AND jrrl.shipment_line_id = jrl.shipment_line_id

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

1896: INTO lv_receipt_number
1897: FROM jai_rcv_lines
1898: WHERE shipment_line_id = pn_shipment_line_id;
1899:
1900: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1901: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1902: FETCH jai_rcv_rgm_lines_cur
1903: INTO jai_rcv_rgm_lines_rec;
1904: CLOSE jai_rcv_rgm_lines_cur;

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

1897: FROM jai_rcv_lines
1898: WHERE shipment_line_id = pn_shipment_line_id;
1899:
1900: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1901: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1902: FETCH jai_rcv_rgm_lines_cur
1903: INTO jai_rcv_rgm_lines_rec;
1904: CLOSE jai_rcv_rgm_lines_cur;
1905:

Line 1902: FETCH jai_rcv_rgm_lines_cur

1898: WHERE shipment_line_id = pn_shipment_line_id;
1899:
1900: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1901: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1902: FETCH jai_rcv_rgm_lines_cur
1903: INTO jai_rcv_rgm_lines_rec;
1904: CLOSE jai_rcv_rgm_lines_cur;
1905:
1906:

Line 1903: INTO jai_rcv_rgm_lines_rec;

1899:
1900: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1901: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);
1902: FETCH jai_rcv_rgm_lines_cur
1903: INTO jai_rcv_rgm_lines_rec;
1904: CLOSE jai_rcv_rgm_lines_cur;
1905:
1906:
1907: --deleted by eric for bug#6968733 on Apr 15,2008,begin

Line 1904: CLOSE jai_rcv_rgm_lines_cur;

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

Line 1912: ( pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)

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;
1915: CLOSE jai_rcv_rgm_instl_count_cur;
1916: */

Line 1944: ( pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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: );
1947: FETCH jai_rcv_rgm_instl_count_cur
1948: INTO ln_installment_cnt;

Line 1960: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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

Line 1967: ( pn_rcv_rgm_line_id => jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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

Line 1991: --Update jai_rcv_rgm_lines to increment recoverable_amount

1987: END LOOP; -- (jai_retor_tax_changes_rec IN jai_retro_tax_changes_cur)
1988:
1989: IF ln_tot_instl_amt <> 0
1990: THEN
1991: --Update jai_rcv_rgm_lines to increment recoverable_amount
1992:
1993: UPDATE jai_rcv_rgm_lines
1994: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
1995: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;

Line 1993: UPDATE jai_rcv_rgm_lines

1989: IF ln_tot_instl_amt <> 0
1990: THEN
1991: --Update jai_rcv_rgm_lines to increment recoverable_amount
1992:
1993: UPDATE jai_rcv_rgm_lines
1994: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
1995: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
1996: 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:

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

1991: --Update jai_rcv_rgm_lines to increment recoverable_amount
1992:
1993: UPDATE jai_rcv_rgm_lines
1994: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
1995: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
1996: 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: END IF;-- (ln_tot_instl_amt <> 0 )
1999:

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

1992:
1993: UPDATE jai_rcv_rgm_lines
1994: SET recoverable_amount = recoverable_amount + ln_tot_instl_amt
1995: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
1996: 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: END IF;-- (ln_tot_instl_amt <> 0 )
1999:
2000:

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

2000:
2001: --IF any amount is claimed THEN
2002: IF ln_tot_clm_instl_amt <>0
2003: THEN
2004: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2005: UPDATE jai_rcv_rgm_lines
2006: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2007: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2008: 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 2005: UPDATE jai_rcv_rgm_lines

2001: --IF any amount is claimed THEN
2002: IF ln_tot_clm_instl_amt <>0
2003: THEN
2004: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2005: UPDATE jai_rcv_rgm_lines
2006: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2007: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2008: 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:

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

2003: THEN
2004: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2005: UPDATE jai_rcv_rgm_lines
2006: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2007: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2008: 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:
2010: END IF; -- (ln_tot_clm_instl_amt <>0)
2011:

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

2004: --UPDATE jai_rcv_rgm_lines to increment the recovered_amount by the amount claimed
2005: UPDATE jai_rcv_rgm_lines
2006: SET recovered_amount = recovered_amount + ln_tot_clm_instl_amt
2007: --WHERE rcv_rgm_line_id = jai_rcv_rgm_lines.rcv_rgm_line_id;
2008: 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:
2010: END IF; -- (ln_tot_clm_instl_amt <>0)
2011:
2012: FOR claim_schedule_rec IN get_claim_schedule_cur

Line 2013: (pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)

2009:
2010: END IF; -- (ln_tot_clm_instl_amt <>0)
2011:
2012: FOR claim_schedule_rec IN get_claim_schedule_cur
2013: (pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)
2014: LOOP
2015: OPEN get_parameters_cur (jai_rcv_rgm_lines_rec.rcv_rgm_line_id);
2016: FETCH get_parameters_cur
2017: INTO

Line 2015: OPEN get_parameters_cur (jai_rcv_rgm_lines_rec.rcv_rgm_line_id);

2011:
2012: FOR claim_schedule_rec IN get_claim_schedule_cur
2013: (pn_rcv_rgm_line_id =>jai_rcv_rgm_lines_rec.rcv_rgm_line_id)
2014: LOOP
2015: OPEN get_parameters_cur (jai_rcv_rgm_lines_rec.rcv_rgm_line_id);
2016: FETCH get_parameters_cur
2017: INTO
2018: ln_organization_id
2019: , ln_location_id

Line 2167: WHERE rcv_rgm_line_id = jai_rcv_rgm_lines_rec.rcv_rgm_line_id

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;
2170:
2171: END LOOP; -- claimed records