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 DUAL

Line 370: Because , this procedure gets called from individual line in the JAI_AR_TRX_LINES table

366:
367: 11. 2005/01/28 ssumaith - bug#4136981
368:
369: IN call to the ja_in_register_txn_entry procedure , passing the customer_Trx_line_id instead of customer_trx_id
370: Because , this procedure gets called from individual line in the JAI_AR_TRX_LINES table
371: when 'COMPLETE' action is done.
372:
373: 12. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
374: DB Entity as required for CASE COMPLAINCE. Version 116.2

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 816: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

812: v_customer_trx_id, SYSDATE, v_reg_code,
813: v_creation_date, v_created_by,v_last_update_date,
814: v_last_updated_by, v_last_update_login );
815: vsqlstmt := '22';
816: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
817: END IF ;--Added by Xiao for Open Interface ER bug#11683927.
818: END IF;
819: END IF;
820: IF v_reg_code in ('DOMESTIC_EXCISE','EXPORT_EXCISE') 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 938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

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,
941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
942: WHERE register_id = v_rg23_part_ii_no)

Line 945: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

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;
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)

Line 953: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

949: WHERE register_id = v_pla_register_no)
950: WHERE register_id = v_rg23_part_i_no;
951: END IF;
952: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
953: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
954: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
956: UPDATE JAI_CMN_RG_23AC_I_TRXS
957: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,

Line 955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

951: END IF;
952: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
953: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
954: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
956: UPDATE JAI_CMN_RG_23AC_I_TRXS
957: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
959: WHERE register_id = v_rg23_part_ii_no)

Line 962: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
959: WHERE register_id = v_rg23_part_ii_no)
960: WHERE register_id = v_rg23_part_i_no;
961: ELSIF l_rec.payment_register IN( 'PLA') THEN
962: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
963: UPDATE JAI_CMN_RG_23AC_I_TRXS
964: SET REGISTER_ID_PART_II = v_pla_register_no,
965: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
966: WHERE register_id = v_pla_register_no)

Line 1026: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;

1022: v_match_tax_rate := v_match_tax_rate/v_tax_rate_counter;
1023: END IF;
1024: END LOOP;
1025:
1026: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;
1027: IF match_rec.transaction_type = 'R'
1028: THEN
1029: v_rg23d_receipt_id := match_rec.receipt_id;
1030: ELSIF match_rec.transaction_type = 'CR'