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 344: Because , this procedure gets called from individual line in the JAI_AR_TRX_LINES table

340:
341: 11. 2005/01/28 ssumaith - bug#4136981
342:
343: IN call to the ja_in_register_txn_entry procedure , passing the customer_Trx_line_id instead of customer_trx_id
344: Because , this procedure gets called from individual line in the JAI_AR_TRX_LINES table
345: when 'COMPLETE' action is done.
346:
347: 12. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
348: DB Entity as required for CASE COMPLAINCE. Version 116.2

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

728: v_customer_trx_id, SYSDATE, v_reg_code,
729: v_creation_date, v_created_by,v_last_update_date,
730: v_last_updated_by, v_last_update_login );
731: vsqlstmt := '22';
732: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
733: END IF;
734: END IF;
735: IF v_reg_code in ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
736:

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 832: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

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

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

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

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

843: WHERE register_id = v_pla_register_no)
844: WHERE register_id = v_rg23_part_i_no;
845: END IF;
846: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
847: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
848: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
849: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
850: UPDATE JAI_CMN_RG_23AC_I_TRXS
851: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,

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

845: END IF;
846: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
847: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
848: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
849: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
850: UPDATE JAI_CMN_RG_23AC_I_TRXS
851: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
853: WHERE register_id = v_rg23_part_ii_no)

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

852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
853: WHERE register_id = v_rg23_part_ii_no)
854: WHERE register_id = v_rg23_part_i_no;
855: ELSIF l_rec.payment_register IN( 'PLA') THEN
856: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
857: UPDATE JAI_CMN_RG_23AC_I_TRXS
858: SET REGISTER_ID_PART_II = v_pla_register_no,
859: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
860: WHERE register_id = v_pla_register_no)

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

916: v_match_tax_rate := v_match_tax_rate/v_tax_rate_counter;
917: END IF;
918: END LOOP;
919:
920: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;
921: IF match_rec.transaction_type = 'R'
922: THEN
923: v_rg23d_receipt_id := match_rec.receipt_id;
924: ELSIF match_rec.transaction_type = 'CR'