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.AS_MULTI_CURRENCIES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14


PROCEDURE Insert_Type_Mappings(
          p_TYPE_MAPPINGS_TBL  IN   TYPE_MAPPINGS_Tbl_Type
                                    DEFAULT G_MISS_TYPE_MAPPINGS_TBL,
          X_Return_Status      OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
          X_Msg_Count          OUT NOCOPY /* file.sql.39 change */  NUMBER,
          X_Msg_Data           OUT NOCOPY /* file.sql.39 change */  VARCHAR2)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Insert_Type_Mappings';

Line: 25


l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Insert_Type_Mappings';

Line: 28


   SAVEPOINT INSERT_TYPE_MAPPINGS_PUB;

Line: 43


       INSERT INTO AS_MC_TYPE_MAPPINGS(
               PERIOD_SET_NAME,
               PERIOD_TYPE,
               CONVERSION_TYPE,
               DESCRIPTION,
               UPDATEABLE_FLAG,
               DELETEABLE_FLAG,
               LAST_UPDATE_DATE,
               LAST_UPDATED_BY,
               CREATION_DATE,
               CREATED_BY,
               LAST_UPDATE_LOGIN
               --,
               -- SECURITY_GROUP_ID
       ) VALUES (
               decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
                       FND_API.G_MISS_CHAR, NULL,
                       p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
               decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
                       FND_API.G_MISS_CHAR, NULL,
                       p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
               decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
                       FND_API.G_MISS_CHAR, NULL,
                       p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
               decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
                       FND_API.G_MISS_CHAR, NULL,
                       p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
               decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
                       FND_API.G_MISS_CHAR, NULL,
                       p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
               decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
                       FND_API.G_MISS_CHAR, NULL,
                       p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
               SYSDATE,
               FND_GLOBAL.USER_ID,
               SYSDATE,
               FND_GLOBAL.USER_ID,
               FND_GLOBAL.CONC_LOGIN_ID
               --,
               -- decode( p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID,
               --        FND_API.G_MISS_NUM, NULL,
               --        p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID)
                       );

Line: 129


End Insert_Type_Mappings;

Line: 131


PROCEDURE Update_Type_Mappings(
          p_TYPE_MAPPINGS_TBL  IN   TYPE_MAPPINGS_Tbl_Type
                                    DEFAULT G_MISS_TYPE_MAPPINGS_TBL,
          X_Return_Status      OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
          X_Msg_Count          OUT NOCOPY /* file.sql.39 change */  NUMBER,
          X_Msg_Data           OUT NOCOPY /* file.sql.39 change */  VARCHAR2)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_Type_Mappings';

Line: 142


l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Update_Type_Mappings';

Line: 145


   SAVEPOINT UPDATE_TYPE_MAPPINGS_PUB;

Line: 165


       UPDATE AS_MC_TYPE_MAPPINGS
       SET
           PERIOD_SET_NAME = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
               FND_API.G_MISS_CHAR, PERIOD_SET_NAME,
               p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
           PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
               FND_API.G_MISS_CHAR, PERIOD_TYPE,
               p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
           CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
               FND_API.G_MISS_CHAR, CONVERSION_TYPE,
               p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
           DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
               FND_API.G_MISS_CHAR, DESCRIPTION,
               p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
           UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
               FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
               p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
           DELETEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
               FND_API.G_MISS_CHAR, DELETEABLE_FLAG,
               p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
           LAST_UPDATE_DATE = SYSDATE,
           LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
           LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
           --,
           -- SECURITY_GROUP_ID = decode(
           --    p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID,
           --    FND_API.G_MISS_NUM, SECURITY_GROUP_ID,
           --   p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID)
       WHERE PERIOD_SET_NAME = p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME
       AND   PERIOD_TYPE = p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE;

Line: 242


END Update_Type_Mappings;

Line: 244


PROCEDURE Delete_Type_Mappings(
          p_TYPE_MAPPINGS_TBL  IN   TYPE_MAPPINGS_Tbl_Type
                                    DEFAULT G_MISS_TYPE_MAPPINGS_TBL,
          X_Return_Status      OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
          X_Msg_Count          OUT NOCOPY /* file.sql.39 change */  NUMBER,
          X_Msg_Data           OUT NOCOPY /* file.sql.39 change */  VARCHAR2)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_Type_Mappings';

Line: 255


l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Delete_Type_Mappings';

Line: 258


   SAVEPOINT DELETE_TYPE_MAPPINGS_PUB;

Line: 273


       DELETE FROM AS_MC_TYPE_MAPPINGS
       WHERE PERIOD_SET_NAME = p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME
       AND   PERIOD_TYPE = p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE;

Line: 324


END Delete_Type_Mappings;

Line: 327


PROCEDURE Insert_Period_Rates(
          p_PERIOD_RATES_TBL   IN   PERIOD_RATES_Tbl_Type
                                    DEFAULT G_MISS_PERIOD_RATES_TBL,
          X_Return_Status      OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
          X_Msg_Count          OUT NOCOPY /* file.sql.39 change */  NUMBER,
          X_Msg_Data           OUT NOCOPY /* file.sql.39 change */  VARCHAR2)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Insert_Period_Rates';

Line: 338


l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Insert_Period_Rates';

Line: 341


   SAVEPOINT INSERT_PERIOD_RATES_PUB;

Line: 356


       INSERT INTO GL_DAILY_RATES_INTERFACE(
           FROM_CURRENCY,
           TO_CURRENCY,
           FROM_CONVERSION_DATE,
           TO_CONVERSION_DATE,
           USER_CONVERSION_TYPE,
           CONVERSION_RATE,
           MODE_FLAG,
           INVERSE_CONVERSION_RATE
       ) VALUES (
               decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
               decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).TO_CURRENCY),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
                       FND_API.G_MISS_DATE, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
                       FND_API.G_MISS_DATE, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
                       FND_API.G_MISS_NUM, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
               'I',
               NULL);

Line: 430


End Insert_Period_Rates;

Line: 434


PROCEDURE Update_Period_Rates(
          p_PERIOD_RATES_TBL   IN   PERIOD_RATES_Tbl_Type
                                    DEFAULT G_MISS_PERIOD_RATES_TBL,
          X_Return_Status      OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
          X_Msg_Count          OUT NOCOPY /* file.sql.39 change */  NUMBER,
          X_Msg_Data           OUT NOCOPY /* file.sql.39 change */  VARCHAR2)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_Period_Rates';

Line: 445


l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Update_Period_Rates';

Line: 448


   SAVEPOINT UPDATE_PERIOD_RATES_PUB;

Line: 463


       INSERT INTO GL_DAILY_RATES_INTERFACE(
           FROM_CURRENCY,
           TO_CURRENCY,
           FROM_CONVERSION_DATE,
           TO_CONVERSION_DATE,
           USER_CONVERSION_TYPE,
           CONVERSION_RATE,
           MODE_FLAG,
           INVERSE_CONVERSION_RATE
       ) VALUES (
               decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
               decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).TO_CURRENCY),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
                       FND_API.G_MISS_DATE, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
                       FND_API.G_MISS_DATE, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
                       FND_API.G_MISS_NUM, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
               'I',
               NULL);

Line: 537


End Update_Period_Rates;

Line: 541


PROCEDURE Delete_Period_Rates(
          p_PERIOD_RATES_TBL   IN   PERIOD_RATES_Tbl_Type
                                    DEFAULT G_MISS_PERIOD_RATES_TBL,
          X_Return_Status      OUT NOCOPY /* file.sql.39 change */  VARCHAR2,
          X_Msg_Count          OUT NOCOPY /* file.sql.39 change */  NUMBER,
          X_Msg_Data           OUT NOCOPY /* file.sql.39 change */  VARCHAR2)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_Period_Rates';

Line: 552


l_module CONSTANT VARCHAR2(255) := 'as.plsql.mcpk.Delete_Period_Rates';

Line: 555


   SAVEPOINT DELETE_PERIOD_RATES_PUB;

Line: 570


       INSERT INTO GL_DAILY_RATES_INTERFACE(
           FROM_CURRENCY,
           TO_CURRENCY,
           FROM_CONVERSION_DATE,
           TO_CONVERSION_DATE,
           USER_CONVERSION_TYPE,
           CONVERSION_RATE,
           MODE_FLAG,
           INVERSE_CONVERSION_RATE
       ) VALUES (
               decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
               decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).TO_CURRENCY),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
                       FND_API.G_MISS_DATE, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
                       FND_API.G_MISS_DATE, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
                       FND_API.G_MISS_CHAR, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
               decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
                       FND_API.G_MISS_NUM, NULL,
                       p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
               'D',
               NULL);

Line: 643


End Delete_Period_Rates;