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.

[Home] [Help]

APPS.PSB_CONSTRAINT_FORMULAS_PVT SQL Statements

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

Line: 6


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_CONSTRAINT_FORMULA_ID in NUMBER,
  P_CONSTRAINT_ID in NUMBER,
  P_STEP_NUMBER in NUMBER,
  P_BUDGET_YEAR_TYPE_ID in NUMBER,
  P_BALANCE_TYPE in VARCHAR2,
  P_CURRENCY_CODE in VARCHAR2,
  P_TEMPLATE_ID in NUMBER,
  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_AMOUNT in NUMBER,
  P_PREFIX_OPERATOR in VARCHAR2,
  P_POSTFIX_OPERATOR in VARCHAR2,
  P_PAY_ELEMENT_ID in NUMBER,
  P_PAY_ELEMENT_OPTION_ID in NUMBER,
  P_ALLOW_MODIFY in VARCHAR2,
  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_CONTEXT in VARCHAR2,
  P_CONCATENATED_SEGMENTS 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: 80


    cursor C is select ROWID from PSB_CONSTRAINT_FORMULAS
      where CONSTRAINT_FORMULA_ID = P_CONSTRAINT_FORMULA_ID;

Line: 85


  SAVEPOINT Insert_Row_Pvt ;

Line: 103


  insert into PSB_CONSTRAINT_FORMULAS (
    CONSTRAINT_ID,
    CONSTRAINT_FORMULA_ID,
    STEP_NUMBER,
    BUDGET_YEAR_TYPE_ID,
    BALANCE_TYPE,
    CURRENCY_CODE,
    TEMPLATE_ID,
    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,
    AMOUNT,
    PREFIX_OPERATOR,
    POSTFIX_OPERATOR,
    PAY_ELEMENT_ID,
    PAY_ELEMENT_OPTION_ID,
    ALLOW_MODIFY,
    ELEMENT_VALUE,
    ELEMENT_VALUE_TYPE,
    EFFECTIVE_START_DATE,
    EFFECTIVE_END_DATE,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    CONTEXT,
    CONCATENATED_SEGMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_CONSTRAINT_ID,
    P_CONSTRAINT_FORMULA_ID,
    P_STEP_NUMBER,
    P_BUDGET_YEAR_TYPE_ID,
    P_BALANCE_TYPE,
    P_CURRENCY_CODE,
    P_TEMPLATE_ID,
    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_AMOUNT,
    P_PREFIX_OPERATOR,
    P_POSTFIX_OPERATOR,
    P_PAY_ELEMENT_ID,
    P_PAY_ELEMENT_OPTION_ID,
    P_ALLOW_MODIFY,
    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_CONTEXT,
    P_CONCATENATED_SEGMENTS,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 246


    ROLLBACK TO Insert_Row_Pvt ;

Line: 253


    ROLLBACK TO Insert_Row_Pvt ;

Line: 260


    ROLLBACK TO Insert_Row_Pvt ;

Line: 271


END Insert_Row;

Line: 343


  cursor c1 is select
      CONSTRAINT_ID,
      STEP_NUMBER,
      BUDGET_YEAR_TYPE_ID,
      BALANCE_TYPE,
      CURRENCY_CODE,
      TEMPLATE_ID,
      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,
      AMOUNT,
      PREFIX_OPERATOR,
      POSTFIX_OPERATOR,
      PAY_ELEMENT_ID,
      PAY_ELEMENT_OPTION_ID,
      ALLOW_MODIFY,
      ELEMENT_VALUE,
      ELEMENT_VALUE_TYPE,
      EFFECTIVE_START_DATE,
      EFFECTIVE_END_DATE,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      CONTEXT,
      CONCATENATED_SEGMENTS
    from PSB_CONSTRAINT_FORMULAS
    where CONSTRAINT_FORMULA_ID = P_CONSTRAINT_FORMULA_ID
    for update of CONSTRAINT_FORMULA_ID nowait;

Line: 644


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_CONSTRAINT_FORMULA_ID in NUMBER,
  P_CONSTRAINT_ID in NUMBER,
  P_STEP_NUMBER in NUMBER,
  P_BUDGET_YEAR_TYPE_ID in NUMBER,
  P_BALANCE_TYPE in VARCHAR2,
  P_CURRENCY_CODE in VARCHAR2,
  P_TEMPLATE_ID in NUMBER,
  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_AMOUNT in NUMBER,
  P_PREFIX_OPERATOR in VARCHAR2,
  P_POSTFIX_OPERATOR in VARCHAR2,
  P_PAY_ELEMENT_ID in NUMBER,
  P_PAY_ELEMENT_OPTION_ID in NUMBER,
  P_ALLOW_MODIFY in VARCHAR2,
  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_CONTEXT in VARCHAR2,
  P_CONCATENATED_SEGMENTS 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: 718


  SAVEPOINT Update_Row_Pvt ;

Line: 736


  update PSB_CONSTRAINT_FORMULAS set
    CONSTRAINT_ID = P_CONSTRAINT_ID,
    STEP_NUMBER = P_STEP_NUMBER,
    BUDGET_YEAR_TYPE_ID = P_BUDGET_YEAR_TYPE_ID,
    BALANCE_TYPE = P_BALANCE_TYPE,
    CURRENCY_CODE = P_CURRENCY_CODE,
    TEMPLATE_ID = P_TEMPLATE_ID,
    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,
    AMOUNT = P_AMOUNT,
    PREFIX_OPERATOR = P_PREFIX_OPERATOR,
    POSTFIX_OPERATOR = P_POSTFIX_OPERATOR,
    PAY_ELEMENT_ID = P_PAY_ELEMENT_ID,
    PAY_ELEMENT_OPTION_ID = P_PAY_ELEMENT_OPTION_ID,
    ALLOW_MODIFY = P_ALLOW_MODIFY,
    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,
    CONTEXT = P_CONTEXT,
    CONCATENATED_SEGMENTS = P_CONCATENATED_SEGMENTS,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where CONSTRAINT_FORMULA_ID = P_CONSTRAINT_FORMULA_ID
  ;

Line: 811


    ROLLBACK TO Update_Row_Pvt ;

Line: 818


    ROLLBACK TO Update_Row_Pvt ;

Line: 825


    ROLLBACK TO Update_Row_Pvt ;

Line: 836


END Update_Row;

Line: 838


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_CONSTRAINT_FORMULA_ID in NUMBER
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 858


  SAVEPOINT Delete_Row_Pvt ;

Line: 876


  delete from PSB_CONSTRAINT_FORMULAS
  where CONSTRAINT_FORMULA_ID = P_CONSTRAINT_FORMULA_ID;

Line: 895


    ROLLBACK TO Delete_Row_Pvt ;

Line: 902


    ROLLBACK TO Delete_Row_Pvt ;

Line: 909


    ROLLBACK TO Delete_Row_Pvt ;

Line: 920


END Delete_Row;