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.

[Home] [Help]

APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 264: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */

260: jrcttl.tax_id = jtc.tax_id AND
261: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND
262: jrctl.customer_trx_line_id = cp_trx_line_id;
263:
264: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */
265: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */
266:
267:
268: /* End of bug 4566054 */

Line 265: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */

261: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND
262: jrctl.customer_trx_line_id = cp_trx_line_id;
263:
264: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */
265: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */
266:
267:
268: /* End of bug 4566054 */
269:

Line 361: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.

357: Issue :-
358: Rg does not show correct cess value in case of Shipment transactions.
359:
360: Fix:-
361: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
362: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
363: as 'WSH' from jai_om_wsh.plb procedure Shipment.
364: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
365: For shipment and Ar receivable transaction currently the transaction_id is 33 and in some cases where the jai_cmn_rg_i_trxs.ref_doc_id

Line 365: For shipment and Ar receivable transaction currently the transaction_id is 33 and in some cases where the jai_cmn_rg_i_trxs.ref_doc_id

361: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
362: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
363: as 'WSH' from jai_om_wsh.plb procedure Shipment.
364: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
365: For shipment and Ar receivable transaction currently the transaction_id is 33 and in some cases where the jai_cmn_rg_i_trxs.ref_doc_id
366: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
367: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
368:
369: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.

Line 375: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields

371:
372: A migration script has been provided to migrate the value for cess and source.
373:
374: Dependency due to this bug:-
375: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
376: 2. Added two new parameters in jai_om_rg_pkg.ja_in_rg_i_entry procedure to insert data into JAI_CMN_RG_I_TRXS table
377: 3. Modified the trigger jai_jar_t_aru_t1
378: 4. Procedure jai_om_wsh_pkg.process_delivery
379: 5. Report JAICMNRG1.rdf

Line 376: 2. Added two new parameters in jai_om_rg_pkg.ja_in_rg_i_entry procedure to insert data into JAI_CMN_RG_I_TRXS table

372: A migration script has been provided to migrate the value for cess and source.
373:
374: Dependency due to this bug:-
375: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
376: 2. Added two new parameters in jai_om_rg_pkg.ja_in_rg_i_entry procedure to insert data into JAI_CMN_RG_I_TRXS table
377: 3. Modified the trigger jai_jar_t_aru_t1
378: 4. Procedure jai_om_wsh_pkg.process_delivery
379: 5. Report JAICMNRG1.rdf
380: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.

Line 650: ||The cess amount is also being maintained in jai_cmn_rg_i_trxs table at a delivery_detail_level

646:
647: /*
648: || Start of bug 4566054
649: ||Code added by aiyer for the bug 4566054
650: ||The cess amount is also being maintained in jai_cmn_rg_i_trxs table at a delivery_detail_level
651: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
652: */
653:
654: OPEN cur_get_trx_cess_amt(l_rec.line_id) ;

Line 714: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

710: );
711:
712:
713: vsqlstmt := '20';
714: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
715: ELSIF v_item_class IN ('CGEX','CGIN') THEN
716: v_reg_type := 'C';
717: ELSIF v_item_class IN ('RMIN','RMEX') THEN
718: v_reg_type := 'A';

Line 830: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

826: );
827: vsqlstmt := '26';
828: END IF;
829: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
830: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
831: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
832: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
833: UPDATE JAI_CMN_RG_I_TRXS
834: SET register_id_part_ii = v_rg23_part_ii_no,

Line 833: UPDATE JAI_CMN_RG_I_TRXS

829: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
830: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
831: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
832: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
833: UPDATE JAI_CMN_RG_I_TRXS
834: SET register_id_part_ii = v_rg23_part_ii_no,
835: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
836: WHERE register_id = v_rg23_part_ii_no)
837: WHERE register_id = v_rg23_part_i_no;

Line 840: UPDATE JAI_CMN_RG_I_TRXS

836: WHERE register_id = v_rg23_part_ii_no)
837: WHERE register_id = v_rg23_part_i_no;
838: ELSIF l_rec.payment_register IN( 'PLA') THEN
839: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
840: UPDATE JAI_CMN_RG_I_TRXS
841: SET register_id_part_ii = v_pla_register_no,
842: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
843: WHERE register_id = v_pla_register_no)
844: WHERE register_id = v_rg23_part_i_no;