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_RCV_RND_PKG dependencies on JAI_CMN_RG_ROUND_LINES

Line 250: FROM JAI_CMN_RG_ROUND_LINES

246: v_1st_claim_tot_cnt NUMBER;
247:
248: CURSOR c_1st_claim_cgin_cnt(p_rounding_id IN NUMBER) IS
249: SELECT count(1) total_cnt, sum( decode(item_class, 'CGIN', 1, 'CGEX', 1, 0) ) cgin_cnt
250: FROM JAI_CMN_RG_ROUND_LINES
251: WHERE rounding_id = p_rounding_id
252: GROUP BY rounding_id;
253:
254: r_1st_claim_cgin_cnt c_1st_claim_cgin_cnt%ROWTYPE;

Line 281: - Insert into JAI_CMN_RG_ROUND_HDRS, JAI_CMN_RG_ROUND_LINES tables

277: 1 08/01/2004 Vijay Shankar for Bug# 3213826 Version : 619.1
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.

Line 290: are modified to select JAI_CMN_RG_ROUND_LINES_S.nextval, the all the required data and punch Rounding_id in JAI_CMN_RG_23AC_II_TRXS in CORRECT RG records also

286: all the other scenarios only one rounding entry is passed
287:
288: 2 31/08/2004 Vijay Shankar for Bug# 3496408 Version : 115.1
289: Modified the code to consider CORRECTions of RECEIVE to round the CENVAT amount. Related Selects and Updates
290: are modified to select JAI_CMN_RG_ROUND_LINES_S.nextval, the all the required data and punch Rounding_id in JAI_CMN_RG_23AC_II_TRXS in CORRECT RG records also
291:
292: 3 21/01/2005 Sanjikum for Bug #4049363 Version 116.0 (115.2)
293: Modified the Code to consider the rounding for each tax type instead of total excise amount
294: Changed a lot of code. Can be searched with Bug#4049363

Line 297: New columns are added in the Tables - JAI_CMN_RG_ROUND_HDRS, JAI_CMN_RG_ROUND_LINES

293: Modified the Code to consider the rounding for each tax type instead of total excise amount
294: Changed a lot of code. Can be searched with Bug#4049363
295:
296: Dependency -
297: New columns are added in the Tables - JAI_CMN_RG_ROUND_HDRS, JAI_CMN_RG_ROUND_LINES
298:
299: 4 31/08/2004 Vijay Shankar for Bug# 4103161 Version : 116.1
300: added a new procedure DO_RTV_ROUNDING to take care of RTV Rounding also.
301: And existing procedure do_rounding is modified to make a call to do_rtv_rounding

Line 766: INSERT INTO JAI_CMN_RG_ROUND_LINES (ROUNDING_LINE_ID,

762: ln_cenvat_amount.total := NVL(ln_cenvat_amount.basic,0) + NVL(ln_cenvat_amount.additional,0) + NVL(ln_cenvat_amount.other,0) + NVL(ln_cenvat_amount.excise_edu_cess,0) + NVL(ln_cenvat_amount.cvd_edu_cess,0);
763: v_statement_no := '1.5';
764:
765: -- populate item class
766: INSERT INTO JAI_CMN_RG_ROUND_LINES (ROUNDING_LINE_ID,
767: ROUNDING_ID, SRC_LINE_ID, SRC_TRANSACTION_ID,
768: EXCISE_AMT,
769: BASIC_ED, ADDITIONAL_ED, OTHER_ED, --Added by Sanjikum for Bug #4049363
770: EXCISE_EDU_CESS, CVD_EDU_CESS,--Added by Sanjikum for Bug #4049363

Line 776: VALUES ( JAI_CMN_RG_ROUND_LINES_S.nextval,

772: sh_cvd_edu_cess ,
773: ITEM_CLASS, CREATION_DATE, CREATED_BY,
774: program_application_id, program_id, program_login_id, request_id
775: )
776: VALUES ( JAI_CMN_RG_ROUND_LINES_S.nextval,
777: v_rounding_id,
778: line.shipment_line_id,
779: trx.transaction_id,
780: ln_cenvat_amount.total, --Added by Sanjikum for Bug #4049363

Line 866: UPDATE JAI_CMN_RG_ROUND_LINES

862: NVL(v_tot_amount.sh_excise_edu_cess,0) + -- Date 16/04/2007 by sacsethi for Bug#5989740
863: NVL(v_tot_amount.sh_cvd_edu_cess,0);
864:
865:
866: UPDATE JAI_CMN_RG_ROUND_LINES
867: SET --7 columns added by Sanjikum for Bug #4049363
868: excise_amt = NVL(basic_ed/2,0) +
869: NVL(additional_ed/2,0) +
870: NVL(additional_cvd/2,0) + /*Added by SACSETHI for the bug 5228046 -Additional CVD Enhancement*/

Line 1079: DELETE FROM JAI_CMN_RG_ROUND_LINES WHERE rounding_id = v_rounding_id;

1075: )
1076: )
1077: );
1078:
1079: DELETE FROM JAI_CMN_RG_ROUND_LINES WHERE rounding_id = v_rounding_id;
1080:
1081: FND_FILE.PUT_LINE( FND_FILE.log, '**** Zero Rounded ****');
1082: GOTO next_exc_inv;
1083: ELSIF v_rounded_amount.total > 0 THEN

Line 2487: INSERT INTO JAI_CMN_RG_ROUND_LINES (ROUNDING_LINE_ID,

2483: fnd_file.put_line(fnd_file.log, '2-Before Insert into Entry Lines');
2484: end if;
2485:
2486: -- populate item class
2487: INSERT INTO JAI_CMN_RG_ROUND_LINES (ROUNDING_LINE_ID,
2488: ROUNDING_ID, SRC_LINE_ID, SRC_TRANSACTION_ID,
2489: EXCISE_AMT,
2490: BASIC_ED, ADDITIONAL_ED,ADDITIONAL_CVD , OTHER_ED,
2491: EXCISE_EDU_CESS, CVD_EDU_CESS,

Line 2495: ) VALUES ( JAI_CMN_RG_ROUND_LINES_S.nextval,

2491: EXCISE_EDU_CESS, CVD_EDU_CESS,
2492: sh_excise_edu_cess, sh_cvd_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2493: ITEM_CLASS, CREATION_DATE, CREATED_BY,
2494: program_application_id, program_id, program_login_id, request_id
2495: ) VALUES ( JAI_CMN_RG_ROUND_LINES_S.nextval,
2496: v_rounding_id, line.shipment_line_id, line.transaction_id,
2497: ln_cenvat_amount.total,
2498: ln_cenvat_amount.basic,
2499: ln_cenvat_amount.additional,

Line 2713: DELETE FROM JAI_CMN_RG_ROUND_LINES WHERE rounding_id = v_rounding_id;

2709: );
2710:
2711: end if;
2712:
2713: DELETE FROM JAI_CMN_RG_ROUND_LINES WHERE rounding_id = v_rounding_id;
2714:
2715: fnd_file.put_line(fnd_file.log, '**** Zero Rounded ****');
2716: GOTO next_exc_inv;
2717: