DBA Data[Home] [Help]

APPS.IBC_ASSOCIATION_TYPES_PVT SQL Statements

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

Line: 30

PROCEDURE Update_Association_Type(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Validation_Level 			 IN   NUMBER       ,--:= FND_API.G_VALID_LEVEL_FULL,
    P_Association_Type_Rec	 	 IN   Ibc_Association_Types_Pvt.Association_Type_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    );
Line: 156

    SELECT Association_Type_Code
	FROM   ibc_Association_types_b
    WHERE  association_Type_Code = p_Association_Type_Code;
Line: 229

Ibc_Association_Types_Pkg.insert_row (
	x_rowid						 => lx_rowid,
    p_ASSOCIATION_TYPE_CODE	=>	l_association_type_rec.ASSOCIATION_TYPE_CODE,
    p_ASSOCIATION_TYPE_NAME	=>	l_association_type_rec.ASSOCIATION_TYPE_NAME,
    p_CALL_BACK_PKG	=>	l_association_type_rec.CALL_BACK_PKG,
    p_CREATED_BY	=>	l_association_type_rec.CREATED_BY,
    p_CREATION_DATE	=>	l_association_type_rec.CREATION_DATE,
    p_DESCRIPTION	=>	l_association_type_rec.DESCRIPTION,
    p_LAST_UPDATED_BY	=>	l_association_type_rec.LAST_UPDATED_BY,
    p_LAST_UPDATE_DATE	=>	l_association_type_rec.LAST_UPDATE_DATE,
    p_LAST_UPDATE_LOGIN	=>	l_association_type_rec.LAST_UPDATE_LOGIN,
    p_OBJECT_VERSION_NUMBER	=>	l_association_type_rec.OBJECT_VERSION_NUMBER,
    p_SEARCH_PAGE	=>	l_association_type_rec.SEARCH_PAGE
    );
Line: 323

	     FND_MESSAGE.Set_Name('IBC', 'IBC_INSERT_ERROR');
Line: 394

PROCEDURE Update_Association_Types(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Validation_Level 			 IN   NUMBER       ,--:= FND_API.G_VALID_LEVEL_FULL,
    P_Association_Type_Tbl	 	 IN   Ibc_Association_Types_Pvt.Association_Type_Tbl_Type ,--:= Ibc_Association_Types_Pvt.G_Miss_Association_Type_Tbl,
    x_Association_Type_Tbl	 	 OUT NOCOPY  Ibc_Association_Types_Pvt.Association_Type_Tbl_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS

    l_temp					  CHAR(1);
Line: 411

	l_api_name 				  VARCHAR2(50) := 'Update_Association_Type';
Line: 450

		    Update_Association_Type(
                P_Api_Version_Number   =>P_Api_Version_Number,
                P_Init_Msg_List        =>P_Init_Msg_List,
                P_Commit               =>P_Commit,
                P_Validation_Level 	   =>FND_API.G_VALID_LEVEL_FULL,
                P_Association_Type_Rec =>l_Association_Type_Tbl(i),
                X_Return_Status        =>X_Return_Status,
                X_Msg_Count            =>X_Msg_Count,
                X_Msg_Data             =>X_Msg_Data);
Line: 468

	     FND_MESSAGE.Set_Name('IBC', 'IBC_UPDATE_ERROR');
Line: 536

END Update_Association_types;
Line: 539

PROCEDURE delete_Association_Type(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Validation_Level 			 IN   NUMBER       ,--:= FND_API.G_VALID_LEVEL_FULL,
    P_Association_Type_Code		 IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS

    CURSOR C_Association_Type IS
    SELECT
    Association_Type_Code
	FROM ibc_Association_types_b
    WHERE Association_Type_Code = p_Association_Type_Code;
Line: 561

	l_api_name 				  VARCHAR2(50) := 'Delete_Association_Type';
Line: 610

               FND_MESSAGE.Set_Name('IBC', 'Cannot Find Record to be Deleted');
Line: 642

		Ibc_Association_Types_Pkg.delete_row (
              p_Association_type_code 		   =>p_Association_type_code
            );
Line: 647

        Ibc_Association_Types_Pkg.DELETE_ROW (
             p_Association_TYPE_CODE 		 =>p_Association_TYPE_CODE);
Line: 653

	     FND_MESSAGE.Set_Name('IBC', 'IBC_DELETE_ERROR');
Line: 721

END delete_Association_type;
Line: 723

PROCEDURE Update_Association_Type(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Validation_Level 			 IN   NUMBER       ,--:= FND_API.G_VALID_LEVEL_FULL,
    P_Association_Type_Rec	 	 IN   Ibc_Association_Types_Pvt.Association_Type_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS

    CURSOR C_Association_Type(p_Association_Type_Code IN VARCHAR2) IS
    SELECT Association_Type_Code
	FROM ibc_Association_types_b
    WHERE Association_Type_Code = p_Association_Type_Code;
Line: 744

	l_api_name 				  VARCHAR2(50) := 'Update_Association_Type';
Line: 796

		Ibc_Association_Types_Pkg.Update_row (
         p_ASSOCIATION_TYPE_CODE	=>	l_association_type_rec.ASSOCIATION_TYPE_CODE,
         p_ASSOCIATION_TYPE_NAME	=>	l_association_type_rec.ASSOCIATION_TYPE_NAME,
         p_CALL_BACK_PKG			=>	l_association_type_rec.CALL_BACK_PKG,
         p_DESCRIPTION				=>	l_association_type_rec.DESCRIPTION,
         p_LAST_UPDATED_BY			=>	l_association_type_rec.LAST_UPDATED_BY,
         p_LAST_UPDATE_DATE			=>	l_association_type_rec.LAST_UPDATE_DATE,
         p_LAST_UPDATE_LOGIN		=>	l_association_type_rec.LAST_UPDATE_LOGIN,
         p_OBJECT_VERSION_NUMBER	=>	l_association_type_rec.OBJECT_VERSION_NUMBER,
         p_SEARCH_PAGE				=>	l_association_type_rec.SEARCH_PAGE);
Line: 807

END Update_Association_type;
Line: 810

PROCEDURE delete_Association_Type(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     ,--:= FND_API.G_FALSE,
    P_Validation_Level 			 IN   NUMBER       ,--:= FND_API.G_VALID_LEVEL_FULL,
    P_Association_Type_Rec	 	 IN   Ibc_Association_Types_Pvt.Association_Type_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS

    CURSOR C_Association_Type(p_Association_Type_Code IN VARCHAR2) IS
    SELECT Association_Type_Code
	FROM ibc_Association_types_b
    WHERE Association_Type_Code = p_Association_Type_Code;
Line: 831

	l_api_name 				  VARCHAR2(50) := 'delete_Association_Type';
Line: 879

		Ibc_Association_Types_Pkg.delete_row (
              p_Association_type_code 	   =>l_Association_type_rec.Association_type_code);
Line: 882

END delete_Association_type;
Line: 891

   SELECT
     ASSOCIATION_TYPE_CODE
     ,CALL_BACK_PKG
     ,SEARCH_PAGE
     ,CREATED_BY
     ,CREATION_DATE
     ,LAST_UPDATED_BY
     ,LAST_UPDATE_DATE
     ,LAST_UPDATE_LOGIN
     ,OBJECT_VERSION_NUMBER
     ,ASSOCIATION_TYPE_NAME
     ,DESCRIPTION
   INTO
     l_Association_Type_Rec.ASSOCIATION_TYPE_CODE	,
     l_Association_Type_Rec.CALL_BACK_PKG	,
     l_Association_Type_Rec.SEARCH_PAGE	,
     l_Association_Type_Rec.CREATED_BY	,
     l_Association_Type_Rec.CREATION_DATE	,
     l_Association_Type_Rec.LAST_UPDATED_BY	,
     l_Association_Type_Rec.LAST_UPDATE_DATE	,
     l_Association_Type_Rec.LAST_UPDATE_LOGIN	,
     l_Association_Type_Rec.OBJECT_VERSION_NUMBER	,
     l_Association_Type_Rec.ASSOCIATION_TYPE_NAME	,
     l_Association_Type_Rec.DESCRIPTION
   FROM IBC_Association_TYPES_VL
   WHERE   Association_type_code = p_Association_type_code;