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_HDRS

Line 234: FROM JAI_CMN_RG_ROUND_HDRS

230: sum(cvd_edu_cess - rounded_cvd_edu_cess) rounded_cvd_edu_cess,
231: sum(sh_excise_edu_cess - rounded_sh_excise_edu_cess) rounded_sh_excise_edu_cess,
232: sum(sh_cvd_edu_cess - rounded_sh_cvd_edu_cess) rounded_sh_cvd_edu_cess,
233: count(1)
234: FROM JAI_CMN_RG_ROUND_HDRS
235: WHERE source_header_id = p_source_header_id
236: AND excise_invoice_no = p_excise_invoice_no
237: AND excise_invoice_date = p_excise_invoice_date
238: AND src_transaction_type = p_transaction_type

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 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 687: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;

683: -- incase error occured due to code between v_save_point_set = FALSE and v_save_point_set = TRUE
684: v_tot_processed_invoices := v_tot_processed_invoices + 1;
685:
686: v_statement_no := '1.4';
687: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;
688:
689: v_line_type_a_cnt := 0;
690: v_line_type_c_cnt := 0;
691: v_tot_lines_cnt := 0;

Line 1345: INSERT INTO JAI_CMN_RG_ROUND_HDRS(

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,
1347: EXCISE_AMT_BEFORE_ROUNDING, EXCISE_AMT_AFTER_ROUNDING,
1348: --Added the below 3 by Sanjikum for Bug #4049363
1349: BASIC_ED, ROUNDED_BASIC_ED,

Line 1419: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',

1415: p_accounting_date => v_today,
1416: p_reference_10 => 'India Local Rounding Entry for Shipment_Header_id:'||r.shipment_header_id
1417: ||', excise_invoice_no:'||r.excise_invoice_no||', exc_inv_date:'||r.excise_invoice_date,
1418: p_reference_23 => 'ja_in_rg_rounding_p',
1419: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',
1420: p_reference_25 => 'ROUNDING_ID',
1421: p_reference_26 => v_rounding_id
1422: );
1423:

Line 1462: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',

1458: p_accounting_date => v_today,
1459: p_reference_10 => 'India Local Rounding Entry for Shipment_Header_id:'||r.shipment_header_id
1460: ||', excise_invoice_no:'||r.excise_invoice_no||', exc_inv_date:'||r.excise_invoice_date,
1461: p_reference_23 => 'ja_in_rg_rounding_p',
1462: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',
1463: p_reference_25 => 'ROUNDING_ID',
1464: p_reference_26 => v_rounding_id
1465: );
1466:

Line 1820: p_transaction_id number, -- this is the rounding_id passed in JAI_CMN_RG_ROUND_HDRS table

1816: END get_parent_register_id;
1817:
1818: PROCEDURE pass_accounting(
1819: p_organization_id number,
1820: p_transaction_id number, -- this is the rounding_id passed in JAI_CMN_RG_ROUND_HDRS table
1821: p_transaction_date date,
1822: p_shipment_line_id number,
1823: p_acct_type varchar2,
1824: p_acct_nature varchar2,

Line 1847: FROM JAI_CMN_RG_ROUND_HDRS

1843: --v_shipment_header_id NUMBER;
1844:
1845: CURSOR c_shipment_header_id(cp_rounding_id IN NUMBER) IS
1846: SELECt source_header_id shipment_header_id
1847: FROM JAI_CMN_RG_ROUND_HDRS
1848: WHERE rounding_id = cp_rounding_id;
1849:
1850: CURSOR c_receipt_num(cp_shipment_header_id IN NUMBER) IS
1851: SELECt receipt_num

Line 2093: FROM JAI_CMN_RG_ROUND_HDRS

2089: CURSOR c_already_rounded_chk(p_source_header_id IN NUMBER, p_excise_invoice_no IN VARCHAR2,
2090: p_excise_invoice_date IN DATE, p_transaction_type IN VARCHAR2) IS
2091: SELECT max(rounding_id) rounding_id,
2092: count(1)
2093: FROM JAI_CMN_RG_ROUND_HDRS
2094: WHERE source_header_id = p_source_header_id
2095: AND excise_invoice_no = p_excise_invoice_no
2096: AND excise_invoice_date = p_excise_invoice_date
2097: AND src_transaction_type = p_transaction_type

Line 2402: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;

2398:
2399: v_tot_processed_invoices := v_tot_processed_invoices + 1;
2400:
2401: v_statement_no := '1.4';
2402: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;
2403:
2404: v_line_type_c_cnt := 0;
2405: v_tot_lines_cnt := 0;
2406: v_tot_amount := v_zero_record;

Line 3030: INSERT INTO JAI_CMN_RG_ROUND_HDRS(

3026: fnd_file.put_line(fnd_file.log, '6-Before Insert into Rounding Entries. Id:'||v_rounding_id);
3027: end if;
3028:
3029: v_statement_no := '11';
3030: INSERT INTO JAI_CMN_RG_ROUND_HDRS(
3031: ROUNDING_ID, SOURCE_HEADER_ID, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
3032: EXCISE_AMT_BEFORE_ROUNDING, EXCISE_AMT_AFTER_ROUNDING,
3033: BASIC_ED, ROUNDED_BASIC_ED,
3034: ADDITIONAL_ED, ROUNDED_ADDITIONAL_ED,

Line 3105: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',

3101: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_reference_10 => 'India Local Rounding Entry for Shipment_Header_id:'||r.shipment_header_id
3102: p_reference_10 => 'India Local Rounding Entry for RTV batch_group_id:'||ln_rtv_excise_batch_group_id
3103: ||', excise_invoice_no:'||r.excise_invoice_no||', exc_inv_date:'||r.excise_invoice_date,
3104: p_reference_23 => 'ja_in_rg_rounding_p',
3105: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',
3106: p_reference_25 => 'ROUNDING_ID',
3107: p_reference_26 => v_rounding_id
3108: );
3109:

Line 3149: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',

3145: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_reference_10 => 'India Local Rounding Entry for Shipment_Header_id:'||r.shipment_header_id
3146: p_reference_10 => 'India Local Rounding Entry for RTV batch_group_id:'||ln_rtv_excise_batch_group_id
3147: ||', excise_invoice_no:'||r.excise_invoice_no||', exc_inv_date:'||r.excise_invoice_date,
3148: p_reference_23 => 'ja_in_rg_rounding_p',
3149: p_reference_24 => 'JAI_CMN_RG_ROUND_HDRS',
3150: p_reference_25 => 'ROUNDING_ID',
3151: p_reference_26 => v_rounding_id
3152: );
3153: