APPS.PSB_ENTITY_PVT SQL Statements

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

Line: 7

procedure INSERT_ROW (
  p_api_version               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_return_status             OUT  NOCOPY      VARCHAR2,
  p_msg_count                 OUT  NOCOPY      NUMBER,
  p_msg_data                  OUT  NOCOPY      VARCHAR2,
  --
  P_ROWID in OUT  NOCOPY VARCHAR2,
  P_ENTITY_ID in NUMBER,
  P_ENTITY_TYPE in VARCHAR2,
  P_ENTITY_SUBTYPE in VARCHAR2,
  P_NAME in VARCHAR2,
  P_DESCRIPTION in VARCHAR2,
  P_DATA_EXTRACT_ID in NUMBER,
  P_SET_OF_BOOKS_ID in NUMBER,
  P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
  P_ALLOCATION_TYPE in VARCHAR2,
  P_BUDGET_YEAR_TYPE_ID in NUMBER,
  P_BALANCE_TYPE in VARCHAR2,
  P_PARAMETER_AUTOINC_RULE in VARCHAR2,
  P_PARAMETER_COMPOUND_ANNUALLY in VARCHAR2,
  P_CURRENCY_CODE in VARCHAR2,
  P_FTE_CONSTRAINT in VARCHAR2,
  P_CONSTRAINT_DETAILED_FLAG in VARCHAR2,
/* Budget Revision Rules Enhancement Start */
  P_APPLY_ACCOUNT_SET_FLAG in VARCHAR2,
  P_BALANCE_ACCOUNT_SET_FLAG in VARCHAR2,
/* Budget Revision Rules Enhancement End */
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_CONTEXT in VARCHAR2,
  P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
  P_EFFECTIVE_END_DATE   in DATE := FND_API.G_MISS_DATE,
  p_Last_Update_Date                   DATE,
  p_Last_Updated_By                    NUMBER,
  p_Last_Update_Login                  NUMBER,
  p_Created_By                         NUMBER,
  p_Creation_Date                      DATE
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';

Line: 61

  select ROWID
  from PSB_ENTITY
  where ENTITY_ID = P_ENTITY_ID;

Line: 67

  SAVEPOINT Insert_Row_Pvt ;

Line: 85

  insert into PSB_ENTITY (
    ENTITY_ID,
    ENTITY_TYPE,
    ENTITY_SUBTYPE,
    NAME,
    DESCRIPTION,
    DATA_EXTRACT_ID,
    SET_OF_BOOKS_ID,
    BUDGET_GROUP_ID,
    ALLOCATION_TYPE,
    BUDGET_YEAR_TYPE_ID,
    BALANCE_TYPE,
    PARAMETER_AUTOINC_RULE,
    PARAMETER_COMPOUND_ANNUALLY,
    CURRENCY_CODE,
    FTE_CONSTRAINT,
    CONSTRAINT_DETAILED_FLAG,
/* Budget Revision Rules Enhancement Start */
    APPLY_ACCOUNT_SET_FLAG,
    BALANCE_ACCOUNT_SET_FLAG,
/* Budget Revision Rules Enhancement End */
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    CONTEXT,
    EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_ENTITY_ID,
    P_ENTITY_TYPE,
    P_ENTITY_SUBTYPE,
    P_NAME,
    P_DESCRIPTION,
    P_DATA_EXTRACT_ID,
    P_SET_OF_BOOKS_ID,
    decode(P_BUDGET_GROUP_ID, FND_API.G_MISS_NUM, null, P_BUDGET_GROUP_ID),
    P_ALLOCATION_TYPE,
    P_BUDGET_YEAR_TYPE_ID,
    P_BALANCE_TYPE,
    P_PARAMETER_AUTOINC_RULE,
    P_PARAMETER_COMPOUND_ANNUALLY,
    P_CURRENCY_CODE,
    P_FTE_CONSTRAINT,
    P_CONSTRAINT_DETAILED_FLAG,
/* Budget Revision Rules Enhancement Start */
    P_APPLY_ACCOUNT_SET_FLAG,
    P_BALANCE_ACCOUNT_SET_FLAG,
/* Budget Revision Rules Enhancement End */
    P_ATTRIBUTE1,
    P_ATTRIBUTE2,
    P_ATTRIBUTE3,
    P_ATTRIBUTE4,
    P_ATTRIBUTE5,
    P_ATTRIBUTE6,
    P_ATTRIBUTE7,
    P_ATTRIBUTE8,
    P_ATTRIBUTE9,
    P_ATTRIBUTE10,
    P_CONTEXT,
    decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, null,
			       P_EFFECTIVE_START_DATE),
    decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, null,
			       P_EFFECTIVE_END_DATE),
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 187

    ROLLBACK TO Insert_Row_Pvt ;

Line: 194

    ROLLBACK TO Insert_Row_Pvt ;

Line: 201

    ROLLBACK TO Insert_Row_Pvt ;

Line: 212

END Insert_Row;

Line: 263

  cursor c1 is select
      ENTITY_TYPE,
      ENTITY_SUBTYPE,
      NAME,
      DESCRIPTION,
      DATA_EXTRACT_ID,
      SET_OF_BOOKS_ID,
      BUDGET_GROUP_ID,
      ALLOCATION_TYPE,
      BUDGET_YEAR_TYPE_ID,
      BALANCE_TYPE,
      PARAMETER_AUTOINC_RULE,
      PARAMETER_COMPOUND_ANNUALLY,
      CURRENCY_CODE,
      FTE_CONSTRAINT,
      CONSTRAINT_DETAILED_FLAG,
/* Budget Revision Rules Enhancement Start */
      APPLY_ACCOUNT_SET_FLAG,
      BALANCE_ACCOUNT_SET_FLAG,
/* Budget Revision Rules Enhancement End */
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      CONTEXT,
      EFFECTIVE_START_DATE,
      EFFECTIVE_END_DATE
    from PSB_ENTITY
    where ENTITY_ID = P_ENTITY_ID
    for update of ENTITY_ID nowait;

Line: 479

procedure UPDATE_ROW (
  p_api_version               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_return_status             OUT  NOCOPY      VARCHAR2,
  p_msg_count                 OUT  NOCOPY      NUMBER,
  p_msg_data                  OUT  NOCOPY      VARCHAR2,
  --
  P_ENTITY_ID in NUMBER,
  P_ENTITY_TYPE in VARCHAR2,
  P_ENTITY_SUBTYPE in VARCHAR2,
  P_NAME in VARCHAR2,
  P_DESCRIPTION in VARCHAR2,
  P_DATA_EXTRACT_ID in NUMBER,
  P_SET_OF_BOOKS_ID in NUMBER,
  P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
  P_ALLOCATION_TYPE in VARCHAR2,
  P_BUDGET_YEAR_TYPE_ID in NUMBER,
  P_BALANCE_TYPE in VARCHAR2,
  P_PARAMETER_AUTOINC_RULE in VARCHAR2,
  P_PARAMETER_COMPOUND_ANNUALLY in VARCHAR2,
  P_CURRENCY_CODE in VARCHAR2,
  P_FTE_CONSTRAINT in VARCHAR2,
  P_CONSTRAINT_DETAILED_FLAG in VARCHAR2,
/* Budget Revision Rules Enhancement Start */
  P_APPLY_ACCOUNT_SET_FLAG in VARCHAR2,
  P_BALANCE_ACCOUNT_SET_FLAG in VARCHAR2,
/* Budget Revision Rules Enhancement End */
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_CONTEXT in VARCHAR2,
  P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
  P_EFFECTIVE_END_DATE   in DATE := FND_API.G_MISS_DATE,
  p_Last_Update_Date                   DATE,
  p_Last_Updated_By                    NUMBER,
  p_Last_Update_Login                  NUMBER
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 531

  SAVEPOINT Update_Row_Pvt ;

Line: 548

  update PSB_ENTITY set
    ENTITY_TYPE = P_ENTITY_TYPE,
    ENTITY_SUBTYPE = P_ENTITY_SUBTYPE,
    NAME = P_NAME,
    DESCRIPTION = P_DESCRIPTION,
    DATA_EXTRACT_ID = P_DATA_EXTRACT_ID,
    SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID,
    BUDGET_GROUP_ID = decode(P_BUDGET_GROUP_ID, FND_API.G_MISS_NUM,
			      null, P_BUDGET_GROUP_ID),
    ALLOCATION_TYPE = P_ALLOCATION_TYPE,
    BUDGET_YEAR_TYPE_ID = P_BUDGET_YEAR_TYPE_ID,
    BALANCE_TYPE = P_BALANCE_TYPE,
    PARAMETER_AUTOINC_RULE = P_PARAMETER_AUTOINC_RULE,
    PARAMETER_COMPOUND_ANNUALLY = P_PARAMETER_COMPOUND_ANNUALLY,
    CURRENCY_CODE = P_CURRENCY_CODE,
    FTE_CONSTRAINT = P_FTE_CONSTRAINT,
    CONSTRAINT_DETAILED_FLAG = P_CONSTRAINT_DETAILED_FLAG,
/* Budget Revision Rules Enhancement Start */
    APPLY_ACCOUNT_SET_FLAG = P_APPLY_ACCOUNT_SET_FLAG,
    BALANCE_ACCOUNT_SET_FLAG = P_BALANCE_ACCOUNT_SET_FLAG,
/* Budget Revision Rules Enhancement End */
    ATTRIBUTE1 = P_ATTRIBUTE1,
    ATTRIBUTE2 = P_ATTRIBUTE2,
    ATTRIBUTE3 = P_ATTRIBUTE3,
    ATTRIBUTE4 = P_ATTRIBUTE4,
    ATTRIBUTE5 = P_ATTRIBUTE5,
    ATTRIBUTE6 = P_ATTRIBUTE6,
    ATTRIBUTE7 = P_ATTRIBUTE7,
    ATTRIBUTE8 = P_ATTRIBUTE8,
    ATTRIBUTE9 = P_ATTRIBUTE9,
    ATTRIBUTE10 = P_ATTRIBUTE10,
    CONTEXT = P_CONTEXT,
    EFFECTIVE_START_DATE = decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE,
			 null, P_EFFECTIVE_START_DATE),
    EFFECTIVE_END_DATE = decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE,
			 null, P_EFFECTIVE_END_DATE),
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where ENTITY_ID = P_ENTITY_ID
  ;

Line: 604

    ROLLBACK TO Update_Row_Pvt ;

Line: 611

    ROLLBACK TO Update_Row_Pvt ;

Line: 618

    ROLLBACK TO Update_Row_Pvt ;

Line: 629

END Update_Row;

Line: 674

  p_Last_Update_Date                DATE,
  p_Last_Updated_By                 NUMBER,
  p_Last_Update_Login               NUMBER,
  p_Created_By                      NUMBER,
  p_Creation_Date                   DATE
) IS

  cursor c is
  select rowid
  from psb_entity
  where entity_id = p_entity_id;

Line: 707

    INSERT_ROW (
     p_api_version,
     p_init_msg_list,
     p_commit,
     p_validation_level,
     p_return_status,
     p_msg_count,
     p_msg_data,

     p_rowid ,
     p_entity_id ,
     p_entity_type ,
     p_entity_subtype ,
     p_name ,
     p_description ,
     p_data_extract_id ,
     p_set_of_books_id ,
     p_budget_group_id,
     p_allocation_type ,
     p_budget_year_type_id ,
     p_balance_type ,
     p_parameter_autoinc_rule ,
     p_parameter_compound_annually ,
     p_currency_code ,
     p_fte_constraint ,
     p_constraint_detailed_flag ,
/* Budget Revision Rules Enhancement Start */
     p_apply_account_set_flag ,
     p_balance_account_set_flag ,
/* Budget Revision Rules Enhancement End */
     p_attribute1 ,
     p_attribute2 ,
     p_attribute3 ,
     p_attribute4 ,
     p_attribute5 ,
     p_attribute6 ,
     p_attribute7 ,
     p_attribute8 ,
     p_attribute9 ,
     p_attribute10 ,
     p_context ,
     p_effective_start_date,
     p_effective_end_date,
     p_last_update_date ,
     p_last_updated_by ,
     p_last_update_login ,
     p_created_by ,
     p_creation_date);

Line: 759

  UPDATE_ROW(
     p_api_version,
     p_init_msg_list,
     p_commit,
     p_validation_level,
     p_return_status,
     p_msg_count,
     p_msg_data,

     p_entity_id ,
     p_entity_type ,
     p_entity_subtype ,
     p_name ,
     p_description ,
     p_data_extract_id ,
     p_set_of_books_id ,
     p_budget_group_id,
     p_allocation_type ,
     p_budget_year_type_id ,
     p_balance_type ,
     p_parameter_autoinc_rule ,
     p_parameter_compound_annually ,
     p_currency_code ,
     p_fte_constraint ,
     p_constraint_detailed_flag ,
/* Budget Revision Rules Enhancement Start */
     p_apply_account_set_flag ,
     p_balance_account_set_flag ,
/* Budget Revision Rules Enhancement End */
     p_attribute1 ,
     p_attribute2 ,
     p_attribute3 ,
     p_attribute4 ,
     p_attribute5 ,
     p_attribute6 ,
     p_attribute7 ,
     p_attribute8 ,
     p_attribute9 ,
     p_attribute10 ,
     p_context ,
     p_effective_start_date,
     p_effective_end_date,
     p_last_update_date ,
     p_last_updated_by ,
     p_last_update_login );

Line: 845

procedure DELETE_ROW (
  p_api_version               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_return_status             OUT  NOCOPY      VARCHAR2,
  p_msg_count                 OUT  NOCOPY      NUMBER,
  p_msg_data                  OUT  NOCOPY      VARCHAR2,
  --
  P_ENTITY_ID in NUMBER
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 862

  SAVEPOINT Delete_Row_Pvt ;

Line: 879

  delete from PSB_ENTITY
  where ENTITY_ID = P_ENTITY_ID;

Line: 896

    ROLLBACK TO Delete_Row_Pvt ;

Line: 903

    ROLLBACK TO Delete_Row_Pvt ;

Line: 910

    ROLLBACK TO Delete_Row_Pvt ;

Line: 921

END Delete_Row;