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

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

Line: 28


    x_pvt_Profile_Variables_rec.SELECT_CLAUSE := P_Profile_Variables_Rec.SELECT_CLAUSE;

Line: 37


    x_pvt_Profile_Variables_rec.LAST_UPDATED_BY := P_Profile_Variables_Rec.LAST_UPDATED_BY;

Line: 38


    x_pvt_Profile_Variables_rec.LAST_UPDATE_DATE := P_Profile_Variables_Rec.LAST_UPDATE_DATE;

Line: 39


    x_pvt_Profile_Variables_rec.LAST_UPDATE_LOGIN := P_Profile_Variables_Rec.LAST_UPDATE_LOGIN;

Line: 67


    p_select_clause		IN  VARCHAR2,
    p_from_clause			IN  VARCHAR2,
    p_where_clause		IN  VARCHAR2,
    p_other_clause	 	IN  VARCHAR2,
    p_block_level               IN  VARCHAR2,
    p_CREATED_BY              IN  NUMBER,
    p_CREATION_DATE           IN  DATE  ,
    p_LAST_UPDATED_BY         IN  NUMBER,
    p_LAST_UPDATE_DATE        IN  DATE  ,
    p_LAST_UPDATE_LOGIN       IN  NUMBER,
    p_OBJECT_VERSION_NUMBER   IN  NUMBER DEFAULT NULL,
    p_APPLICATION_ID          IN  NUMBER,
    x_Profile_Variables_Rec   OUT NOCOPY ProfVar_Rec_Type
    )
  IS
BEGIN
    x_profile_variables_rec.block_id := p_block_id;

Line: 93


    x_Profile_Variables_Rec.select_clause := p_select_clause;

Line: 100


    x_Profile_Variables_Rec.last_updated_by := p_last_updated_by;

Line: 101


    x_Profile_Variables_Rec.last_update_date := p_last_update_date;

Line: 102


    x_Profile_Variables_Rec.last_update_login := p_last_update_login;

Line: 130


    p_select_clause		IN  VARCHAR2,
    p_from_clause		IN  VARCHAR2,
    p_where_clause		IN  VARCHAR2,
    p_other_clause	 	IN  VARCHAR2,
    p_block_level               IN  VARCHAR2,
    p_CREATED_BY                IN  NUMBER,
    p_CREATION_DATE             IN  DATE,
    p_LAST_UPDATED_BY           IN  NUMBER,
    p_LAST_UPDATE_DATE          IN  DATE,
    p_LAST_UPDATE_LOGIN         IN  NUMBER,
    x_OBJECT_VERSION_NUMBER     OUT NOCOPY NUMBER,
    p_APPLICATION_ID            IN  NUMBER,
    x_block_id          	OUT NOCOPY NUMBER )
IS
l_prof_var_rec  ProfVar_Rec_Type;

Line: 159


    p_select_clause		=> p_select_clause,
    p_from_clause		=> p_from_clause,
    p_where_clause		=> p_where_clause,
    p_other_clause	 	=> p_other_clause,
    p_block_level               => p_block_level,
    p_CREATED_BY                => p_CREATED_BY,
    p_CREATION_DATE             => p_CREATION_DATE,
    p_LAST_UPDATED_BY           => p_LAST_UPDATED_BY,
    p_LAST_UPDATE_DATE          => p_LAST_UPDATE_DATE,
    p_LAST_UPDATE_LOGIN         => p_LAST_UPDATE_LOGIN,
    p_APPLICATION_ID            => p_APPLICATION_ID,
    x_Profile_Variables_Rec     => l_prof_var_rec
    );

Line: 413


PROCEDURE Update_Profile_Variable(
    p_api_version_number  IN  NUMBER,
    p_init_msg_list       IN  VARCHAR2,
    p_commit              IN  VARCHAR2,
    p_validation_level    IN  VARCHAR2,
    x_return_status       OUT NOCOPY VARCHAR2,
    x_msg_count           OUT NOCOPY NUMBER,
    x_msg_data            OUT NOCOPY VARCHAR2,
    p_block_id            IN  NUMBER  ,
    p_block_name          IN  VARCHAR2,
    p_block_name_code     IN  VARCHAR2,
    p_description         IN  VARCHAR2,
    p_currency_code       IN  VARCHAR2,
    p_sql_stmnt       	  IN  VARCHAR2,
    p_seeded_flag         IN  VARCHAR2,
    --p_form_function_id    IN	NUMBER  := FND_API.G_MISS_NUM,
    p_object_code	        IN	VARCHAR2,
    p_start_date_active   IN  DATE,
    p_end_date_active     IN  DATE,
    p_select_clause	  IN  VARCHAR2,
    p_from_clause			IN  VARCHAR2,
    p_where_clause		IN  VARCHAR2,
    p_other_clause		IN  VARCHAR2,
    p_block_level               IN  VARCHAR2,
    p_CREATED_BY              IN  NUMBER,
    p_CREATION_DATE           IN  DATE,
    p_LAST_UPDATED_BY         IN  NUMBER,
    p_LAST_UPDATE_DATE        IN  DATE,
    p_LAST_UPDATE_LOGIN       IN  NUMBER,
    px_OBJECT_VERSION_NUMBER   IN OUT NOCOPY NUMBER,
    p_APPLICATION_ID          IN   NUMBER)
IS
l_prof_var_rec  ProfVar_Rec_Type;

Line: 461


    p_select_clause		=> p_select_clause,
    p_from_clause		=> p_from_clause,
    p_where_clause		=> p_where_clause,
    p_other_clause	 	=> p_other_clause,
    p_block_level               => p_block_level,
    p_CREATED_BY                => p_CREATED_BY,
    p_CREATION_DATE             => p_CREATION_DATE,
    p_LAST_UPDATED_BY           => p_LAST_UPDATED_BY,
    p_LAST_UPDATE_DATE          => p_LAST_UPDATE_DATE,
    p_LAST_UPDATE_LOGIN         => p_LAST_UPDATE_LOGIN,
    p_OBJECT_VERSION_NUMBER     => px_OBJECT_VERSION_NUMBER,
    p_APPLICATION_ID            => p_APPLICATION_ID,
    x_Profile_Variables_Rec     => l_prof_var_rec
    );

Line: 477


    Update_Profile_Variable(
    p_api_version_number => p_api_version_number,
    p_init_msg_list	=> p_init_msg_list,
    p_commit		=> p_Commit ,
    p_validation_level	=> p_validation_level,
    p_prof_var_rec 	=> l_prof_var_Rec,
    px_OBJECT_VERSION_NUMBER   => px_OBJECT_VERSION_NUMBER,
    x_msg_data 		=> x_msg_data,
    x_msg_count 		=> x_msg_count,
    x_return_status 	=> x_return_status );

Line: 492


PROCEDURE Update_Profile_Variable (
    p_api_version_number	IN	VARCHAR2,
    p_init_msg_list		IN	VARCHAR2,
    p_commit			IN	VARCHAR2,
    p_validation_level		IN	VARCHAR2,
    p_prof_var_rec 		IN  	ProfVar_Rec_Type,
    px_OBJECT_VERSION_NUMBER   IN OUT NOCOPY NUMBER ,
    x_return_status		OUT NOCOPY	VARCHAR2,
    x_msg_data			OUT NOCOPY	VARCHAR2,
    x_msg_count			OUT NOCOPY	NUMBER )
IS
l_api_name       CONSTANT  VARCHAR2(30) := 'Update_Profile_Variable' ;

Line: 512


    SAVEPOINT Update_Profile_Variable_Pub ;

Line: 541


    CSC_Profile_Variable_PVT.Update_Profile_Variable(
    p_api_version_number  => 1.0,
    p_init_msg_list       => FND_API.G_FALSE,
    p_commit              => FND_API.G_FALSE,
    p_validation_level    => FND_API.G_VALID_LEVEL_FULL,
    p_prof_var_rec 	  => l_pvt_prof_var_rec,
    px_OBJECT_VERSION_NUMBER   => px_OBJECT_VERSION_NUMBER,
    x_return_status       => x_return_status,
    x_msg_count           => x_msg_count,
    x_msg_data            => x_msg_data
    );

Line: 572


           ROLLBACK TO Update_Profile_Variable_Pub  ;

Line: 578


           ROLLBACK TO Update_Profile_Variable_Pub  ;

Line: 583


           ROLLBACK TO Update_Profile_Variable_Pub  ;

Line: 593


END Update_Profile_Variable;

Line: 596


PROCEDURE Update_table_column(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_Validation_Level		 IN   NUMBER,
    p_Table_Column_Rec		 IN   CSC_Profile_Variable_PVT.Table_Column_Rec_Type,
    --p_Sql_Stmnt_For_Drilldown    IN   VARCHAR2 := FND_API.G_MISS_CHAR,
    --p_BLOCK_ID			   IN	  NUMBER := FND_API.G_MISS_NUM,
    px_OBJECT_VERSION_NUMBER   IN OUT NOCOPY NUMBER ,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_table_column';

Line: 615


      SAVEPOINT UPDATE_Table_Column_PUB;

Line: 640


      CSC_profile_variable_PVT.Update_table_column(
       P_Api_Version_Number         => l_api_version_number,
       P_Init_Msg_List              => FND_API.G_FALSE,
       P_Commit                     => p_commit,
       P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
       p_Table_Column_REC		=> p_table_Column_REC,
       --p_Sql_Stmnt_for_drilldown 	=> p_sql_stmnt_for_drilldown,
       px_OBJECT_VERSION_NUMBER   => px_OBJECT_VERSION_NUMBER,
       X_Return_Status              => x_return_status,
       X_Msg_Count                  => x_msg_count,
       X_Msg_Data                   => x_msg_data);

Line: 678


           ROLLBACK TO UPDATE_Table_Column_PUB  ;

Line: 683


           ROLLBACK TO UPDATE_Table_Column_PUB  ;

Line: 688


           ROLLBACK TO UPDATE_Table_Column_PUB  ;

Line: 699


End Update_table_column;