[Home] [Help]
553: A.LAST_UPDATE_LOGIN,
554: A.TRANSACTION_DATE
555: FROM JAI_CMN_RG_23AC_II_TRXS A
556: WHERE NOT EXISTS ( SELECT '1'
557: FROM JAI_CMN_RG_COMP_DTLS B
558: WHERE B.REGISTER_ID = A.REGISTER_ID)
559: ORDER BY ORGANIZATION_ID,LOCATION_ID,REGISTER_ID;
560: --Variable Declarations starts here.......
561: V_BASIC_OPENING_BALANCE NUMBER;
588: This Procedure is Created for Textile Industry specifically wherin individual
589: balances of Excise components are to be maintained.
590: In case of data not existing in Excise Component Balances for an combination of
591: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
592: and JAI_CMN_RG_COMP_DTLS tables and if data exists, then it will insert data
593: into JAI_CMN_RG_COMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
594:
595: -----------------------------------------------------------------------------------------------
596: */
589: balances of Excise components are to be maintained.
590: In case of data not existing in Excise Component Balances for an combination of
591: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
592: and JAI_CMN_RG_COMP_DTLS tables and if data exists, then it will insert data
593: into JAI_CMN_RG_COMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
594:
595: -----------------------------------------------------------------------------------------------
596: */
597: v_debug_flag := 'N';
718: UTL_FILE.PUT_LINE(v_myfilehandle,'Before Insert into Details table' ||'The V_BASIC_OPENING_BALANCE is ' || V_BASIC_OPENING_BALANCE);
719: UTL_FILE.PUT_LINE(v_myfilehandle,'Before Insert into Details table' ||'The V_BASIC_CLOSING_BALANCE is ' || V_BASIC_CLOSING_BALANCE);
720: END IF;
721:
722: INSERT INTO JAI_CMN_RG_COMP_DTLS
723: (EXCISE_COMP_DTL_ID,
724: ORGANIZATION_ID,
725: LOCATION_ID,
726: INVENTORY_ITEM_ID,
747: TRANSACTION_DATE,
748: LAST_UPDATE_LOGIN
749: )
750: VALUES
751: ( JAI_CMN_RG_COMP_DTLS_S.nextval,
752: CUR_REC.ORGANIZATION_ID,
753: CUR_REC.LOCATION_ID,
754: CUR_REC.INVENTORY_ITEM_ID,
755: CUR_REC.FIN_YEAR,