APPS.JAI_CMN_RG_PLA_TRXS_PKG dependencies on JAI_CMN_RG_COMP_BALS

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

607: 1. 2002/07/28 Nagaraj.s - For Enh#2371031
608: This Procedure is Created for Textile Industry specifically wherin individual
609: balances of Excise components are to be maintained.
610: In case of data not existing in Excise Component Balances for an combination of
611: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data
613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
614:
615: -----------------------------------------------------------------------------------------------

Line 613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.

609: balances of Excise components are to be maintained.
610: In case of data not existing in Excise Component Balances for an combination of
611: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data
613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
614:
615: -----------------------------------------------------------------------------------------------
616: */
617:

Line 628: FROM JAI_CMN_RG_COMP_BALS

624: NVL(OTHER_PLA_BALANCE,0)
625: INTO V_BASIC_OPENING_BALANCE,
626: V_ADDITIONAL_OPENING_BALANCE,
627: V_OTHER_OPENING_BALANCE
628: FROM JAI_CMN_RG_COMP_BALS
629: WHERE ORGANIZATION_ID= CUR_REC.ORGANIZATION_ID AND
630: LOCATION_ID= CUR_REC.LOCATION_ID;
631:
632: EXCEPTION

Line 635: INSERT INTO JAI_CMN_RG_COMP_BALS

631:
632: EXCEPTION
633: WHEN NO_DATA_FOUND THEN
634: --If the combination of Organization and Location do not exist then
635: INSERT INTO JAI_CMN_RG_COMP_BALS
636: (COMPONENT_BALANCE_ID,
637: ORGANIZATION_ID,
638: LOCATION_ID,
639: BASIC_RG23A_BALANCE,

Line 655: ( JAI_CMN_RG_COMP_BALS_S.nextval,

651: LAST_UPDATED_BY,
652: LAST_UPDATE_LOGIN
653: )
654: VALUES
655: ( JAI_CMN_RG_COMP_BALS_S.nextval,
656: CUR_REC.ORGANIZATION_ID,
657: CUR_REC.LOCATION_ID,
658: 0,
659: 0,

Line 745: UPDATE JAI_CMN_RG_COMP_BALS

741: CUR_REC.TRANSACTION_DATE
742: );
743:
744: --To Update Register Balances.................
745: UPDATE JAI_CMN_RG_COMP_BALS
746: SET
747: BASIC_PLA_BALANCE = V_BASIC_CLOSING_BALANCE,
748: ADDITIONAL_PLA_BALANCE = V_ADDITIONAL_CLOSING_BALANCE,
749: OTHER_PLA_BALANCE = V_OTHER_CLOSING_BALANCE,