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_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_TRX_REFS

Line 1556: INSERT INTO jai_rgm_trx_refs(

1552: ) IS
1553:
1554: BEGIN
1555:
1556: INSERT INTO jai_rgm_trx_refs(
1557: reference_id,
1558: organization_id,
1559: source,
1560: invoice_id,

Line 1588: jai_rgm_trx_refs_s.nextval,

1584: last_update_date,
1585: last_updated_by,
1586: last_update_login
1587: ) VALUES (
1588: jai_rgm_trx_refs_s.nextval,
1589: p_organization_id,
1590: p_source,
1591: p_invoice_id,
1592: p_line_id,

Line 2074: UPDATE jai_rgm_trx_refs

2070:
2071: lv_statement VARCHAR2(2); -- := '1' File.Sql.35 by Brathod
2072: BEGIN
2073: lv_statement :='1' ; -- File.Sql.35 by Brathod
2074: UPDATE jai_rgm_trx_refs
2075: SET recovered_amount = nvl(recovered_amount,0) + nvl(p_recovered_amount, 0),
2076: discounted_amount = nvl(discounted_amount,0) + nvl(p_discounted_amount,0),
2077: -- recoverable_amount = recoverable_amount - nvl(p_amount, 0),
2078: last_update_date = sysdate,