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_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_I_TRXS

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

286: ln_external_flag NUMBER;
287: ln_open_source NUMBER;
288: --------------------------------------------------------------------------------------
289: --Added by Xiao for Open Interface ER bug#11683927 on 16-Feb-2011, end
290: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */
291: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */
292:
293:
294: /* End of bug 4566054 */

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

287: ln_open_source NUMBER;
288: --------------------------------------------------------------------------------------
289: --Added by Xiao for Open Interface ER bug#11683927 on 16-Feb-2011, end
290: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */
291: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */
292:
293:
294: /* End of bug 4566054 */
295:

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

383: Issue :-
384: Rg does not show correct cess value in case of Shipment transactions.
385:
386: Fix:-
387: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
388: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
389: as 'WSH' from jai_om_wsh.plb procedure Shipment.
390: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
391: 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 391: 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

387: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
388: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
389: as 'WSH' from jai_om_wsh.plb procedure Shipment.
390: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
391: 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
392: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
393: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
394:
395: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.

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

397:
398: A migration script has been provided to migrate the value for cess and source.
399:
400: Dependency due to this bug:-
401: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
402: 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
403: 3. Modified the trigger jai_jar_t_aru_t1
404: 4. Procedure jai_om_wsh_pkg.process_delivery
405: 5. Report JAICMNRG1.rdf

Line 402: 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

398: A migration script has been provided to migrate the value for cess and source.
399:
400: Dependency due to this bug:-
401: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
402: 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
403: 3. Modified the trigger jai_jar_t_aru_t1
404: 4. Procedure jai_om_wsh_pkg.process_delivery
405: 5. Report JAICMNRG1.rdf
406: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.

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

721:
722: /*
723: || Start of bug 4566054
724: ||Code added by aiyer for the bug 4566054
725: ||The cess amount is also being maintained in jai_cmn_rg_i_trxs table at a delivery_detail_level
726: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
727: */
728:
729: OPEN cur_get_trx_cess_amt(l_rec.line_id) ;

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

789: );
790:
791:
792: vsqlstmt := '20';
793: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
794: END IF ; --Added by Xiao for Open Interface ER bug#11683927.
795: ELSIF v_item_class IN ('CGEX','CGIN') THEN
796: v_reg_type := 'C';
797: ELSIF v_item_class IN ('RMIN','RMEX') THEN

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

932: ------------------------------------------------------------------------------------
933: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
934:
935: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
936: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
937: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
939: UPDATE JAI_CMN_RG_I_TRXS
940: SET register_id_part_ii = v_rg23_part_ii_no,

Line 939: UPDATE JAI_CMN_RG_I_TRXS

935: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
936: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
937: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
939: UPDATE JAI_CMN_RG_I_TRXS
940: SET register_id_part_ii = v_rg23_part_ii_no,
941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
942: WHERE register_id = v_rg23_part_ii_no)
943: WHERE register_id = v_rg23_part_i_no;

Line 946: UPDATE JAI_CMN_RG_I_TRXS

942: WHERE register_id = v_rg23_part_ii_no)
943: WHERE register_id = v_rg23_part_i_no;
944: ELSIF l_rec.payment_register IN( 'PLA') THEN
945: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
946: UPDATE JAI_CMN_RG_I_TRXS
947: SET register_id_part_ii = v_pla_register_no,
948: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
949: WHERE register_id = v_pla_register_no)
950: WHERE register_id = v_rg23_part_i_no;