APPS.PSB_PARAMETER_FORMULAS_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_PARAMETER_FORMULA_ID in NUMBER,
  P_PARAMETER_ID in NUMBER,
  P_STEP_NUMBER in NUMBER,
  P_BUDGET_YEAR_TYPE_ID in NUMBER,
  P_BALANCE_TYPE in VARCHAR2,
  P_TEMPLATE_ID in NUMBER,
  P_CONCATENATED_SEGMENTS in VARCHAR2,
  P_SEGMENT1 in VARCHAR2,
  P_SEGMENT2 in VARCHAR2,
  P_SEGMENT3 in VARCHAR2,
  P_SEGMENT4 in VARCHAR2,
  P_SEGMENT5 in VARCHAR2,
  P_SEGMENT6 in VARCHAR2,
  P_SEGMENT7 in VARCHAR2,
  P_SEGMENT8 in VARCHAR2,
  P_SEGMENT9 in VARCHAR2,
  P_SEGMENT10 in VARCHAR2,
  P_SEGMENT11 in VARCHAR2,
  P_SEGMENT12 in VARCHAR2,
  P_SEGMENT13 in VARCHAR2,
  P_SEGMENT14 in VARCHAR2,
  P_SEGMENT15 in VARCHAR2,
  P_SEGMENT16 in VARCHAR2,
  P_SEGMENT17 in VARCHAR2,
  P_SEGMENT18 in VARCHAR2,
  P_SEGMENT19 in VARCHAR2,
  P_SEGMENT20 in VARCHAR2,
  P_SEGMENT21 in VARCHAR2,
  P_SEGMENT22 in VARCHAR2,
  P_SEGMENT23 in VARCHAR2,
  P_SEGMENT24 in VARCHAR2,
  P_SEGMENT25 in VARCHAR2,
  P_SEGMENT26 in VARCHAR2,
  P_SEGMENT27 in VARCHAR2,
  P_SEGMENT28 in VARCHAR2,
  P_SEGMENT29 in VARCHAR2,
  P_SEGMENT30 in VARCHAR2,
  P_CURRENCY_CODE in VARCHAR2,
  P_AMOUNT in NUMBER,
  P_PREFIX_OPERATOR in VARCHAR2,
  P_POSTFIX_OPERATOR in VARCHAR2,
  P_HIREDATE_BETWEEN_FROM in NUMBER,
  P_HIREDATE_BETWEEN_TO in NUMBER,
  P_ADJDATE_BETWEEN_FROM in NUMBER,
  P_ADJDATE_BETWEEN_TO in NUMBER,
  P_INCREMENT_BY in NUMBER,
  P_INCREMENT_TYPE in VARCHAR2,
  P_ASSIGNMENT_TYPE IN VARCHAR2,
  P_ATTRIBUTE_ID IN NUMBER,
  P_ATTRIBUTE_VALUE IN VARCHAR2,
  P_PAY_ELEMENT_ID in NUMBER,
  P_PAY_ELEMENT_OPTION_ID IN NUMBER,
  P_GRADE_STEP IN NUMBER,
  P_ELEMENT_VALUE in NUMBER,
  P_ELEMENT_VALUE_TYPE in VARCHAR2,
  P_EFFECTIVE_START_DATE in DATE,
  P_EFFECTIVE_END_DATE in DATE,
  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_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: 95

    cursor C is select ROWID from PSB_PARAMETER_FORMULAS
      where PARAMETER_FORMULA_ID = P_PARAMETER_FORMULA_ID;

Line: 99

  SAVEPOINT Insert_Row_Pvt ;

Line: 116

  insert into PSB_PARAMETER_FORMULAS (
    PARAMETER_ID,
    PARAMETER_FORMULA_ID,
    STEP_NUMBER,
    BUDGET_YEAR_TYPE_ID,
    BALANCE_TYPE,
    TEMPLATE_ID,
    CONCATENATED_SEGMENTS,
    SEGMENT1,
    SEGMENT2,
    SEGMENT3,
    SEGMENT4,
    SEGMENT5,
    SEGMENT6,
    SEGMENT7,
    SEGMENT8,
    SEGMENT9,
    SEGMENT10,
    SEGMENT11,
    SEGMENT12,
    SEGMENT13,
    SEGMENT14,
    SEGMENT15,
    SEGMENT16,
    SEGMENT17,
    SEGMENT18,
    SEGMENT19,
    SEGMENT20,
    SEGMENT21,
    SEGMENT22,
    SEGMENT23,
    SEGMENT24,
    SEGMENT25,
    SEGMENT26,
    SEGMENT27,
    SEGMENT28,
    SEGMENT29,
    SEGMENT30,
    CURRENCY_CODE,
    AMOUNT,
    PREFIX_OPERATOR,
    POSTFIX_OPERATOR,
    HIREDATE_BETWEEN_FROM,
    HIREDATE_BETWEEN_TO,
    ADJDATE_BETWEEN_FROM,
    ADJDATE_BETWEEN_TO,
    INCREMENT_BY,
    INCREMENT_TYPE,
    ASSIGNMENT_TYPE,
    ATTRIBUTE_ID,
    ATTRIBUTE_VALUE,
    PAY_ELEMENT_ID,
    PAY_ELEMENT_OPTION_ID,
    GRADE_STEP,
    ELEMENT_VALUE,
    ELEMENT_VALUE_TYPE,
    EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    CONTEXT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_PARAMETER_ID,
    P_PARAMETER_FORMULA_ID,
    P_STEP_NUMBER,
    P_BUDGET_YEAR_TYPE_ID,
    P_BALANCE_TYPE,
    P_TEMPLATE_ID,
    P_CONCATENATED_SEGMENTS,
    P_SEGMENT1,
    P_SEGMENT2,
    P_SEGMENT3,
    P_SEGMENT4,
    P_SEGMENT5,
    P_SEGMENT6,
    P_SEGMENT7,
    P_SEGMENT8,
    P_SEGMENT9,
    P_SEGMENT10,
    P_SEGMENT11,
    P_SEGMENT12,
    P_SEGMENT13,
    P_SEGMENT14,
    P_SEGMENT15,
    P_SEGMENT16,
    P_SEGMENT17,
    P_SEGMENT18,
    P_SEGMENT19,
    P_SEGMENT20,
    P_SEGMENT21,
    P_SEGMENT22,
    P_SEGMENT23,
    P_SEGMENT24,
    P_SEGMENT25,
    P_SEGMENT26,
    P_SEGMENT27,
    P_SEGMENT28,
    P_SEGMENT29,
    P_SEGMENT30,
    P_CURRENCY_CODE,
    P_AMOUNT,
    P_PREFIX_OPERATOR,
    P_POSTFIX_OPERATOR,
    P_HIREDATE_BETWEEN_FROM,
    P_HIREDATE_BETWEEN_TO,
    P_ADJDATE_BETWEEN_FROM,
    P_ADJDATE_BETWEEN_TO,
    P_INCREMENT_BY,
    P_INCREMENT_TYPE,
    P_ASSIGNMENT_TYPE,
    P_ATTRIBUTE_ID,
    P_ATTRIBUTE_VALUE,
    P_PAY_ELEMENT_ID,
    P_PAY_ELEMENT_OPTION_ID,
    P_GRADE_STEP,
    P_ELEMENT_VALUE,
    P_ELEMENT_VALUE_TYPE,
    P_EFFECTIVE_START_DATE,
    P_EFFECTIVE_END_DATE,
    P_ATTRIBUTE1,
    P_ATTRIBUTE2,
    P_ATTRIBUTE3,
    P_ATTRIBUTE4,
    P_ATTRIBUTE5,
    P_ATTRIBUTE6,
    P_ATTRIBUTE7,
    P_ATTRIBUTE8,
    P_ATTRIBUTE9,
    P_ATTRIBUTE10,
    P_CONTEXT,
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 286

    ROLLBACK TO Insert_Row_Pvt ;

Line: 293

    ROLLBACK TO Insert_Row_Pvt ;

Line: 300

    ROLLBACK TO Insert_Row_Pvt ;

Line: 311

END Insert_Row;

Line: 399

    SELECT *
    FROM psb_parameter_formulas
    WHERE rowid = p_rowid
    FOR UPDATE OF parameter_formula_id NOWAIT;

Line: 430

     FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 761

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_ROWID IN VARCHAR2,
  P_PARAMETER_FORMULA_ID in NUMBER,
  P_PARAMETER_ID in NUMBER,
  P_STEP_NUMBER in NUMBER,
  P_BUDGET_YEAR_TYPE_ID in NUMBER,
  P_BALANCE_TYPE in VARCHAR2,
  P_TEMPLATE_ID in NUMBER,
  P_CONCATENATED_SEGMENTS in VARCHAR2,
  P_SEGMENT1 in VARCHAR2,
  P_SEGMENT2 in VARCHAR2,
  P_SEGMENT3 in VARCHAR2,
  P_SEGMENT4 in VARCHAR2,
  P_SEGMENT5 in VARCHAR2,
  P_SEGMENT6 in VARCHAR2,
  P_SEGMENT7 in VARCHAR2,
  P_SEGMENT8 in VARCHAR2,
  P_SEGMENT9 in VARCHAR2,
  P_SEGMENT10 in VARCHAR2,
  P_SEGMENT11 in VARCHAR2,
  P_SEGMENT12 in VARCHAR2,
  P_SEGMENT13 in VARCHAR2,
  P_SEGMENT14 in VARCHAR2,
  P_SEGMENT15 in VARCHAR2,
  P_SEGMENT16 in VARCHAR2,
  P_SEGMENT17 in VARCHAR2,
  P_SEGMENT18 in VARCHAR2,
  P_SEGMENT19 in VARCHAR2,
  P_SEGMENT20 in VARCHAR2,
  P_SEGMENT21 in VARCHAR2,
  P_SEGMENT22 in VARCHAR2,
  P_SEGMENT23 in VARCHAR2,
  P_SEGMENT24 in VARCHAR2,
  P_SEGMENT25 in VARCHAR2,
  P_SEGMENT26 in VARCHAR2,
  P_SEGMENT27 in VARCHAR2,
  P_SEGMENT28 in VARCHAR2,
  P_SEGMENT29 in VARCHAR2,
  P_SEGMENT30 in VARCHAR2,
  P_CURRENCY_CODE in VARCHAR2,
  P_AMOUNT in NUMBER,
  P_PREFIX_OPERATOR in VARCHAR2,
  P_POSTFIX_OPERATOR in VARCHAR2,
  P_HIREDATE_BETWEEN_FROM in NUMBER,
  P_HIREDATE_BETWEEN_TO in NUMBER,
  P_ADJDATE_BETWEEN_FROM in NUMBER,
  P_ADJDATE_BETWEEN_TO in NUMBER,
  P_INCREMENT_BY in NUMBER,
  P_INCREMENT_TYPE in VARCHAR2,
  P_ASSIGNMENT_TYPE IN VARCHAR2,
  P_ATTRIBUTE_ID IN NUMBER,
  P_ATTRIBUTE_VALUE IN VARCHAR2,
  P_PAY_ELEMENT_ID in NUMBER,
  P_PAY_ELEMENT_OPTION_ID IN NUMBER,
  P_GRADE_STEP IN NUMBER,
  P_ELEMENT_VALUE in NUMBER,
  P_ELEMENT_VALUE_TYPE in VARCHAR2,
  P_EFFECTIVE_START_DATE in DATE,
  P_EFFECTIVE_END_DATE in DATE,
  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_Last_Update_Date                   DATE,
  p_Last_Updated_By                    NUMBER,
  p_Last_Update_Login                  NUMBER
) is

  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 849

  SAVEPOINT Update_Row_Pvt ;

Line: 866

  update PSB_PARAMETER_FORMULAS set
    PARAMETER_ID = P_PARAMETER_ID,
    PARAMETER_FORMULA_ID = P_PARAMETER_FORMULA_ID,
    STEP_NUMBER = P_STEP_NUMBER,
    BUDGET_YEAR_TYPE_ID = P_BUDGET_YEAR_TYPE_ID,
    BALANCE_TYPE = P_BALANCE_TYPE,
    TEMPLATE_ID = P_TEMPLATE_ID,
    CONCATENATED_SEGMENTS = P_CONCATENATED_SEGMENTS,
    SEGMENT1 = P_SEGMENT1,
    SEGMENT2 = P_SEGMENT2,
    SEGMENT3 = P_SEGMENT3,
    SEGMENT4 = P_SEGMENT4,
    SEGMENT5 = P_SEGMENT5,
    SEGMENT6 = P_SEGMENT6,
    SEGMENT7 = P_SEGMENT7,
    SEGMENT8 = P_SEGMENT8,
    SEGMENT9 = P_SEGMENT9,
    SEGMENT10 = P_SEGMENT10,
    SEGMENT11 = P_SEGMENT11,
    SEGMENT12 = P_SEGMENT12,
    SEGMENT13 = P_SEGMENT13,
    SEGMENT14 = P_SEGMENT14,
    SEGMENT15 = P_SEGMENT15,
    SEGMENT16 = P_SEGMENT16,
    SEGMENT17 = P_SEGMENT17,
    SEGMENT18 = P_SEGMENT18,
    SEGMENT19 = P_SEGMENT19,
    SEGMENT20 = P_SEGMENT20,
    SEGMENT21 = P_SEGMENT21,
    SEGMENT22 = P_SEGMENT22,
    SEGMENT23 = P_SEGMENT23,
    SEGMENT24 = P_SEGMENT24,
    SEGMENT25 = P_SEGMENT25,
    SEGMENT26 = P_SEGMENT26,
    SEGMENT27 = P_SEGMENT27,
    SEGMENT28 = P_SEGMENT28,
    SEGMENT29 = P_SEGMENT29,
    SEGMENT30 = P_SEGMENT30,
    CURRENCY_CODE = P_CURRENCY_CODE,
    AMOUNT = P_AMOUNT,
    PREFIX_OPERATOR = P_PREFIX_OPERATOR,
    POSTFIX_OPERATOR = P_POSTFIX_OPERATOR,
    HIREDATE_BETWEEN_FROM = P_HIREDATE_BETWEEN_FROM,
    HIREDATE_BETWEEN_TO = P_HIREDATE_BETWEEN_TO,
    ADJDATE_BETWEEN_FROM = P_ADJDATE_BETWEEN_FROM,
    ADJDATE_BETWEEN_TO = P_ADJDATE_BETWEEN_TO,
    INCREMENT_BY = P_INCREMENT_BY,
    INCREMENT_TYPE = P_INCREMENT_TYPE,
    ASSIGNMENT_TYPE = P_ASSIGNMENT_TYPE,
    ATTRIBUTE_ID = P_ATTRIBUTE_ID,
    ATTRIBUTE_VALUE = P_ATTRIBUTE_VALUE,
    PAY_ELEMENT_ID = P_PAY_ELEMENT_ID,
    PAY_ELEMENT_OPTION_ID = P_PAY_ELEMENT_OPTION_ID,
    GRADE_STEP = P_GRADE_STEP,
    ELEMENT_VALUE = P_ELEMENT_VALUE,
    ELEMENT_VALUE_TYPE = P_ELEMENT_VALUE_TYPE,
    EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
    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,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where ROWID = P_ROWID;

Line: 956

    ROLLBACK TO Update_Row_Pvt ;

Line: 963

    ROLLBACK TO Update_Row_Pvt ;

Line: 970

    ROLLBACK TO Update_Row_Pvt ;

Line: 981

END Update_Row;

Line: 983

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_PARAMETER_FORMULA_ID in NUMBER
) is

  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 1000

  SAVEPOINT Delete_Row_Pvt ;

Line: 1017

  delete from PSB_PARAMETER_FORMULAS
  where PARAMETER_FORMULA_ID = P_PARAMETER_FORMULA_ID;

Line: 1034

    ROLLBACK TO Delete_Row_Pvt ;

Line: 1041

    ROLLBACK TO Delete_Row_Pvt ;

Line: 1048

    ROLLBACK TO Delete_Row_Pvt ;

Line: 1059

END Delete_Row;