[Home] [Help]
278: Created the Package to handle Receipts related RG Rounding.
279: DO_ROUNDING Procedue is called from concurrent program JAINRGRND. This procedure posts excise amount Rounding differences to
280: - RG_PART_II, GL Accouting, Update RG balances
281: - Insert into JAI_CMN_RG_ROUND_HDRS, JAI_CMN_RG_ROUND_LINES tables
282: - Makes a call to jai_cmn_rg_period_bals_pkg.adjust_rounding to adjust this rounding amount in PERIOD Balance if
283: the min(ROUNDING_LINE_ID,register_id) of excise invoice is already consolidated in another period
284:
285: Only for Excise Invoice having all CGIN Items is considered as a case where in two rounding entries were passed.
286: all the other scenarios only one rounding entry is passed
1338:
1339: v_statement_no := '10a';
1340: -- this call will update Rounding RG23 PartII entry with Period_balance_id and updates all records of JAI_CMN_RG_PERIOD_BALS
1341: -- that come after the period in which parent Excise invoice has hit RG
1342: jai_cmn_rg_period_bals_pkg.adjust_rounding(v_register_id_part_ii, v_period_balance_id, v_no_of_periods_updated);
1343:
1344: v_statement_no := '11';
1345: INSERT INTO JAI_CMN_RG_ROUND_HDRS(
1346: ROUNDING_ID, SOURCE_HEADER_ID, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
3018: v_statement_no := '10a';
3019: -- this call will update Rounding RG23 PartII entry with Period_balance_id and updates all records of JAI_CMN_RG_PERIOD_BALS
3020: -- that come after the period in which parent Excise invoice has hit RG
3021: if r.register = LV_RG23_REGISTER then
3022: jai_cmn_rg_period_bals_pkg.adjust_rounding(v_register_id_part_ii, v_period_balance_id, v_no_of_periods_updated);
3023: end if;
3024:
3025: if gb_debug then
3026: fnd_file.put_line(fnd_file.log, '6-Before Insert into Rounding Entries. Id:'||v_rounding_id);