APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_TRX_REFS

Line 1111: INSERT INTO jai_rgm_trx_refs(

1107: ) IS
1108:
1109: BEGIN
1110:
1111: INSERT INTO jai_rgm_trx_refs(
1112: reference_id,
1113: organization_id,
1114: source,
1115: invoice_id,

Line 1143: jai_rgm_trx_refs_s.nextval,

1139: last_update_date,
1140: last_updated_by,
1141: last_update_login
1142: ) VALUES (
1143: jai_rgm_trx_refs_s.nextval,
1144: p_organization_id,
1145: p_source,
1146: p_invoice_id,
1147: p_line_id,

Line 1622: UPDATE jai_rgm_trx_refs

1618:
1619: lv_statement VARCHAR2(2); -- := '1' File.Sql.35 by Brathod
1620: BEGIN
1621: lv_statement :='1' ; -- File.Sql.35 by Brathod
1622: UPDATE jai_rgm_trx_refs
1623: SET recovered_amount = nvl(recovered_amount,0) + nvl(p_recovered_amount, 0),
1624: discounted_amount = nvl(discounted_amount,0) + nvl(p_discounted_amount,0),
1625: -- recoverable_amount = recoverable_amount - nvl(p_amount, 0),
1626: last_update_date = sysdate,