[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
1339:
1340: v_statement_no := '10a';
1341: -- this call will update Rounding RG23 PartII entry with Period_balance_id and updates all records of JAI_CMN_RG_PERIOD_BALS
1342: -- that come after the period in which parent Excise invoice has hit RG
1343: jai_cmn_rg_period_bals_pkg.adjust_rounding(v_register_id_part_ii, v_period_balance_id, v_no_of_periods_updated);
1344:
1345: v_statement_no := '11';
1346: INSERT INTO JAI_CMN_RG_ROUND_HDRS(
1347: ROUNDING_ID, SOURCE_HEADER_ID, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
3021: v_statement_no := '10a';
3022: -- this call will update Rounding RG23 PartII entry with Period_balance_id and updates all records of JAI_CMN_RG_PERIOD_BALS
3023: -- that come after the period in which parent Excise invoice has hit RG
3024: if r.register = LV_RG23_REGISTER then
3025: jai_cmn_rg_period_bals_pkg.adjust_rounding(v_register_id_part_ii, v_period_balance_id, v_no_of_periods_updated);
3026: end if;
3027:
3028: if gb_debug then
3029: fnd_file.put_line(fnd_file.log, '6-Before Insert into Rounding Entries. Id:'||v_rounding_id);