APPS.JAI_CMN_RG_23AC_II_PKG dependencies on JAI_CMN_RG_COMP_BALS

Line 591: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS

587: 1. 2002/07/28 Nagaraj.s - For Enh#2371031
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: -----------------------------------------------------------------------------------------------

Line 593: into JAI_CMN_RG_COMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.

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

Line 639: FROM JAI_CMN_RG_COMP_BALS

635: V_OTHER_OPENING_BALANCE_A,
636: V_BASIC_OPENING_BALANCE_C,
637: V_ADDITIONAL_OPENING_BALANCE_C,
638: V_OTHER_OPENING_BALANCE_C
639: FROM JAI_CMN_RG_COMP_BALS
640: WHERE ORGANIZATION_ID= CUR_REC.ORGANIZATION_ID AND
641: LOCATION_ID= CUR_REC.LOCATION_ID;
642: EXCEPTION
643: WHEN NO_DATA_FOUND THEN

Line 657: INSERT INTO JAI_CMN_RG_COMP_BALS

653: UTL_FILE.PUT_LINE(v_myfilehandle,'Inside NDF' ||'The Location id is ' || CUR_REC.LOCATION_ID);
654: END IF;
655: --DBMS_OUTPUT.PUT_LINE('Before Insert');
656: --If the combination of Organization and Location do not exist then
657: INSERT INTO JAI_CMN_RG_COMP_BALS
658: (COMPONENT_BALANCE_ID,
659: ORGANIZATION_ID,
660: LOCATION_ID,
661: BASIC_RG23A_BALANCE,

Line 677: ( JAI_CMN_RG_COMP_BALS_S.nextval,

673: LAST_UPDATED_BY,
674: LAST_UPDATE_LOGIN
675: )
676: VALUES
677: ( JAI_CMN_RG_COMP_BALS_S.nextval,
678: CUR_REC.ORGANIZATION_ID,
679: CUR_REC.LOCATION_ID,
680: 0,
681: 0,

Line 780: UPDATE JAI_CMN_RG_COMP_BALS

776: CUR_REC.LAST_UPDATE_LOGIN
777: );
778: --To Update Register Balances.................
779: IF CUR_REC.REGISTER_TYPE = 'A' THEN
780: UPDATE JAI_CMN_RG_COMP_BALS
781: SET
782: BASIC_RG23A_BALANCE = V_BASIC_CLOSING_BALANCE,
783: ADDITIONAL_RG23A_BALANCE = V_ADDITIONAL_CLOSING_BALANCE,
784: OTHER_RG23A_BALANCE = V_OTHER_CLOSING_BALANCE,

Line 790: UPDATE JAI_CMN_RG_COMP_BALS

786: LAST_UPDATED_BY = CUR_REC.LAST_UPDATED_BY
787: WHERE ORGANIZATION_ID = CUR_REC.ORGANIZATION_ID AND
788: LOCATION_ID = CUR_REC.LOCATION_ID;
789: ELSIF CUR_REC.REGISTER_TYPE = 'C' THEN
790: UPDATE JAI_CMN_RG_COMP_BALS
791: SET
792: BASIC_RG23C_BALANCE = V_BASIC_CLOSING_BALANCE,
793: ADDITIONAL_RG23C_BALANCE = V_ADDITIONAL_CLOSING_BALANCE,
794: OTHER_RG23C_BALANCE = V_OTHER_CLOSING_BALANCE,