APPS.PSB_ENTITY_SET_PVT SQL Statements

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

Line: 33

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_SET_ID in NUMBER,
  P_ENTITY_TYPE in VARCHAR2,
  P_NAME in VARCHAR2,
  P_DESCRIPTION in VARCHAR2,
  P_BUDGET_GROUP_ID in NUMBER,
  P_SET_OF_BOOKS_ID in NUMBER,
  P_DATA_EXTRACT_ID IN NUMBER,
  P_CONSTRAINT_THRESHOLD in NUMBER,
  /* Budget Revision Rules Enhancement Start */
  P_ENABLE_FLAG in VARCHAR2,
  /* Budget Revision Rules Enhancement End */
  /* Bug 4151746 Start */
  P_EXECUTABLE_FROM_POSITION IN VARCHAR2 DEFAULT NULL,
  /* Bug 4151746 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_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: 78

    cursor C is select ROWID from PSB_ENTITY_SET
      where ENTITY_SET_ID = P_ENTITY_SET_ID;

Line: 82

  SAVEPOINT Insert_Row_Pvt ;

Line: 99

  insert into PSB_ENTITY_SET (
    ENTITY_SET_ID,
    ENTITY_TYPE,
    NAME,
    DESCRIPTION,
    BUDGET_GROUP_ID,
    SET_OF_BOOKS_ID,
    DATA_EXTRACT_ID,
    CONSTRAINT_THRESHOLD,
    /* Budget Revision Rules Enhancement Start */
    ENABLE_FLAG,
    /* Budget Revision Rules Enhancement End */
    /* Bug 4151746 Start */
    EXECUTABLE_FROM_POSITION,
    /* Bug 4151746 End */
    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_ENTITY_SET_ID,
    P_ENTITY_TYPE,
    P_NAME,
    P_DESCRIPTION,
    P_BUDGET_GROUP_ID,
    P_SET_OF_BOOKS_ID,
    P_DATA_EXTRACT_ID,
    P_CONSTRAINT_THRESHOLD,
    /* Budget Revision Rules Enhancement Start */
    P_ENABLE_FLAG,
    /* Budget Revision Rules Enhancement End */
    /* Bug 4151746 Start */
    P_EXECUTABLE_FROM_POSITION,
    /* Bug 4151746 End */
    P_ATTRIBUTE1,
    P_ATTRIBUTE2,
    P_ATTRIBUTE3,
    P_ATTRIBUTE4,
    P_ATTRIBUTE5,
    P_ATTRIBUTE6,
    P_ATTRIBUTE7,
    P_ATTRIBUTE8,
    P_ATTRIBUTE9,
    P_ATTRIBUTE10,
    P_CONTEXT,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 183

    ROLLBACK TO Insert_Row_Pvt ;

Line: 190

    ROLLBACK TO Insert_Row_Pvt ;

Line: 197

    ROLLBACK TO Insert_Row_Pvt ;

Line: 208

END Insert_Row;

Line: 251

  cursor c1 is select
      ENTITY_TYPE,
      NAME,
      DESCRIPTION,
      BUDGET_GROUP_ID,
      SET_OF_BOOKS_ID,
      DATA_EXTRACT_ID,
      CONSTRAINT_THRESHOLD,
      /* Budget Revision Rules Enhancement Start */
      ENABLE_FLAG,
      /* Budget Revision Rules Enhancement End */
      /* Bug 4151746 Start */
      EXECUTABLE_FROM_POSITION,
      /* Bug 4151746 End */
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      CONTEXT
    from PSB_ENTITY_SET
    where ENTITY_SET_ID = P_ENTITY_SET_ID
    for update of ENTITY_SET_ID nowait;

Line: 426

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_SET_ID in NUMBER,
  P_ENTITY_TYPE in VARCHAR2,
  P_NAME in VARCHAR2,
  P_DESCRIPTION in VARCHAR2,
  P_BUDGET_GROUP_ID in NUMBER,
  P_SET_OF_BOOKS_ID in NUMBER,
  P_DATA_EXTRACT_ID IN NUMBER,
  P_CONSTRAINT_THRESHOLD in NUMBER,
  /* Budget Revision Rules Enhancement Start */
  P_ENABLE_FLAG in VARCHAR2,
  /* Budget Revision Rules Enhancement End */
  /* Bug 4151746 Start */
  P_EXECUTABLE_FROM_POSITION IN VARCHAR2 DEFAULT NULL,
  /* Bug 4151746 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_Last_Update_Date                   DATE,
  p_Last_Updated_By                    NUMBER,
  p_Last_Update_Login                  NUMBER
) is
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';

Line: 470

  SAVEPOINT Update_Row_Pvt ;

Line: 487

  update PSB_ENTITY_SET set
    ENTITY_TYPE = P_ENTITY_TYPE,
    NAME = P_NAME,
    DESCRIPTION = P_DESCRIPTION,
    BUDGET_GROUP_ID = P_BUDGET_GROUP_ID,
    SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID,
    DATA_EXTRACT_ID = P_DATA_EXTRACT_ID,
    CONSTRAINT_THRESHOLD = P_CONSTRAINT_THRESHOLD,
    /* Budget Revision Rules Enhancement Start */
    ENABLE_FLAG = P_ENABLE_FLAG,
    /* Budget Revision Rules Enhancement End */
    /* Bug 4151746 Start */
    EXECUTABLE_FROM_POSITION = P_EXECUTABLE_FROM_POSITION,
    /* Bug 4151746 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,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where ENTITY_SET_ID = P_ENTITY_SET_ID
  ;

Line: 534

    ROLLBACK TO Update_Row_Pvt ;

Line: 541

    ROLLBACK TO Update_Row_Pvt ;

Line: 548

    ROLLBACK TO Update_Row_Pvt ;

Line: 559

END Update_Row;

Line: 561

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

Line: 578

  SAVEPOINT Delete_Row_Pvt ;

Line: 595

  delete from PSB_ENTITY_SET
  where ENTITY_SET_ID = P_ENTITY_SET_ID;

Line: 614

    ROLLBACK TO Delete_Row_Pvt ;

Line: 621

    ROLLBACK TO Delete_Row_Pvt ;

Line: 628

    ROLLBACK TO Delete_Row_Pvt ;

Line: 639

END Delete_Row;

Line: 659

  l_last_update_date           DATE;

Line: 660

  l_last_updated_by            NUMBER;

Line: 661

  l_last_update_login          NUMBER;

Line: 706

	 SELECT  *
	 FROM    psb_entity_set
	 WHERE   entity_set_id = p_source_entity_set_id ;

Line: 711

	 SELECT account_position_set_id
	 FROM   psb_account_position_sets
	 WHERE  name                    = l_position_set_name
	 and    data_extract_id         = p_target_data_extract_id ;

Line: 717

	 SELECT attribute_value_id
	 FROM   psb_attribute_values
	 WHERE  attribute_id            = l_attribute_id
	 and    attribute_value         = l_attribute_value
	 and    data_extract_id         = p_target_data_extract_id ;

Line: 724

	 SELECT pay_element_id ,
		option_flag    ,
		salary_flag
	 FROM   psb_pay_elements
	 WHERE  name            = (select name
				   from   psb_pay_elements
				   where  pay_element_id=l_source_pay_element_id)
	 and    data_extract_id = p_target_data_extract_id ;

Line: 734

	 SELECT pay_element_rate_id
	 FROM   psb_pay_element_rates
	 WHERE  pay_element_id  = l_target_pay_element_id
	 and    element_value   = (select element_value
				   from   psb_pay_element_rates
				   where  pay_element_id=l_source_pay_element_id);

Line: 742

	 SELECT pay_element_option_id
	 FROM   psb_pay_element_options
	 WHERE  pay_element_id  = l_target_pay_element_id
	 and    name            = (select name
				   from   psb_pay_element_options
				   where  pay_element_option_id =
					  l_source_pay_element_option_id);

Line: 751

	 SELECT pay_element_rate_id
	 FROM   psb_pay_element_rates
	 WHERE  pay_element_id        = l_target_pay_element_id
	 and    pay_element_option_id = l_target_pay_element_option_id
	 and    element_value         = (select element_value
					 from  psb_pay_element_rates
		    where pay_element_id =l_source_pay_element_id
		    and pay_element_option_id = l_source_pay_element_option_id);

Line: 761

	 SELECT data_extract_id
	 FROM   psb_entity_set
	 WHERE  entity_set_id = p_source_entity_set_id ;

Line: 767

      SELECT  *
      FROM    psb_parameter_formulas
      WHERE   parameter_id = l_source_entity_id;

Line: 773

      SELECT  *
      FROM    psb_constraint_formulas
      WHERE   constraint_id = l_source_entity_id;

Line: 809

  l_last_update_date  := SYSDATE;

Line: 810

  l_last_updated_by   := FND_GLOBAL.USER_ID;

Line: 811

  l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 833

    SELECT business_group_id INTO l_business_group_id
    FROM   psb_data_extracts
    WHERE  data_extract_id = l_source_data_extract_id ;

Line: 879

    SELECT  pe.entity_id, pe.entity_type, pe.entity_subtype,
	    pe.name, pe.description, pe.data_extract_id,
	    pe.set_of_books_id, pe.budget_group_id, pe.allocation_type,
	    pe.budget_year_type_id, pe.balance_type,
	    pe.parameter_autoinc_rule, pe.parameter_compound_annually,
	    pe.currency_code, pe.fte_constraint,
	    pe.constraint_detailed_flag,
/* Budget Revision Rules Enhancement Start */
	    pe.apply_account_set_flag, pe.balance_account_set_flag,
/* Budget Revision Rules Enhancement End */
	    pe.attribute1, pe.attribute2,
	    pe.attribute3, pe.attribute4, pe.attribute5,
	    pe.attribute6, pe.attribute7, pe.attribute8,
	    pe.attribute9, pe.attribute10, pe.context,
	    pe.effective_start_date start_date, pe.effective_end_date end_date,
	    pea.priority,
	    pea.severity_level, pea.effective_start_date,
	    pea.effective_end_date
    FROM    psb_entity pe, psb_entity_assignment pea
    WHERE   pea.entity_set_id = p_source_entity_set_id
    and     pea.entity_id = pe.entity_id
  )
  LOOP

    debug( 'Creating entity for the entity id : ' ||
	    l_entity_rec.entity_id ) ;

Line: 909

    SELECT psb_entity_s.nextval INTO l_entity_id
    FROM dual;

Line: 924

    PSB_ENTITY_PVT.INSERT_ROW
    (
      p_api_version                 => 1.0,
      p_init_msg_list               => null,
      p_commit                      => null,
      p_validation_level            => null,
      p_return_status               => l_return_status,
      p_msg_count                   => l_msg_count,
      p_msg_data                    => l_msg_data,
      p_rowid                       => l_rowid,
      p_entity_id                   => l_entity_id,
      p_entity_type                 => l_entity_rec.entity_type,
      p_entity_subtype              => l_entity_rec.entity_subtype,
      p_name                        => l_entity_name,
      p_description                 => l_entity_rec.description,
      p_data_extract_id             => p_target_data_extract_id,
      p_set_of_books_id             => l_entity_rec.set_of_books_id,
      p_budget_group_id             => l_entity_rec.budget_group_id,
      p_allocation_type             => l_entity_rec.allocation_type,
      p_budget_year_type_id         => l_entity_rec.budget_year_type_id,
      p_balance_type                => l_entity_rec.balance_type,
      p_parameter_autoinc_rule      =>
				   l_entity_rec.parameter_autoinc_rule,
      p_parameter_compound_annually =>
				   l_entity_rec.parameter_compound_annually,
      p_currency_code               => l_entity_rec.currency_code,
      p_fte_constraint              => l_entity_rec.fte_constraint,
      p_constraint_detailed_flag    =>
				   l_entity_rec.constraint_detailed_flag,
/* Budget Revision Rules Enhancement Start */
      p_apply_account_set_flag      => l_entity_rec.apply_account_set_flag,
      p_balance_account_set_flag    => l_entity_rec.balance_account_set_flag,
/* Budget Revision Rules Enhancement End */
      p_attribute1                  => l_entity_rec.attribute1,
      p_attribute2                  => l_entity_rec.attribute2,
      p_attribute3                  => l_entity_rec.attribute3,
      p_attribute4                  => l_entity_rec.attribute4,
      p_attribute5                  => l_entity_rec.attribute5,
      p_attribute6                  => l_entity_rec.attribute6,
      p_attribute7                  => l_entity_rec.attribute7,
      p_attribute8                  => l_entity_rec.attribute8,
      p_attribute9                  => l_entity_rec.attribute9,
      p_attribute10                 => l_entity_rec.attribute10,
      p_context                     => l_entity_rec.context,
      p_effective_start_date        => l_entity_rec.start_date,
      p_effective_end_date          => l_entity_rec.end_date,
      p_last_update_date            => l_last_update_date,
      p_last_updated_by             => l_last_updated_by,
      p_last_update_login           => l_last_update_login,
      p_created_by                  => l_created_by,
      p_creation_date               => l_creation_date
    );

Line: 991

    PSB_ENTITY_ASSIGNMENT_PVT.INSERT_ROW
    (
      p_api_version             => 1.0,
      p_init_msg_list           => null,
      p_commit                  => null,
      p_validation_level        => null,
      p_return_status           => l_return_status,
      p_msg_count               => l_msg_count,
      p_msg_data                => l_msg_data,
      p_rowid                   => l_rowid,
      p_entity_set_id           => p_target_entity_set_id,
      p_entity_id               => l_entity_id,
      p_priority                => l_entity_rec.priority,
      p_severity_level          => l_entity_rec.severity_level,
      p_effective_start_date    => l_entity_rec.effective_start_date,
      p_effective_end_date      => l_entity_rec.effective_end_date,
      p_last_update_date        => l_last_update_date,
      p_last_updated_by         => l_last_updated_by,
      p_last_update_login       => l_last_update_login,
      p_created_by              => l_created_by,
      p_creation_date           => l_creation_date
    );

Line: 1031

      SELECT  pas.name, pas.account_or_position_type, psr.*
      FROM    psb_account_position_sets  pas,
	      psb_set_relations          psr
      WHERE   DECODE(p_entity_type,
			'P', psr.parameter_id,
			'C', psr.constraint_id,
/* Budget Revision Rules Enhancement Start */
			'BRR', psr.rule_id ) = l_entity_rec.entity_id
/* Budget Revision Rules Enhancement End */
      and     pas.account_position_set_id  = psr.account_position_set_id
     )
    LOOP

      IF l_sets_rec.account_or_position_type = 'A' THEN

	debug('Processing Account set ' || l_sets_rec.name);

Line: 1106

	SELECT psb_set_relations_s.nextval INTO l_set_relation_id
	FROM dual;

Line: 1125

	PSB_SET_RELATION_PVT.INSERT_ROW
	(
	  p_api_version              =>  1.0,
	  p_init_msg_list            => null,
	  p_commit                   => null,
	  p_validation_level         => null,
	  p_return_status            => l_return_status,
	  p_msg_count                => l_msg_count,
	  p_msg_data                 => l_msg_data,
	  p_row_id                   => l_rowid,
	  p_Set_Relation_Id          => l_Set_Relation_Id,
	  p_Account_Position_Set_Id  => l_Account_Position_Set_Id,
	  p_Allocation_Rule_Id       => l_sets_rec.Allocation_Rule_Id,
	  p_Budget_Group_Id          => l_sets_rec.Budget_Group_Id,
	  p_Budget_Workflow_Rule_Id  => l_sets_rec.Budget_Workflow_Rule_Id,
	  p_Constraint_Id            => l_Constraint_Id,
	  p_Default_Rule_Id          => l_sets_rec.Default_Rule_Id,
	  p_Parameter_Id             => l_Parameter_Id,
	  p_Position_Set_Group_Id    => l_sets_rec.Position_Set_Group_Id,
/* Budget Revision Rules Enhancement Start */
	  p_Rule_Id                  => l_Rule_Id,
	  p_Apply_Balance_Flag       => l_sets_rec.Apply_Balance_Flag,
/* Budget Revision Rules Enhancement End */
	  p_Effective_Start_Date     => l_sets_rec.Effective_Start_Date,
	  p_Effective_End_Date       => l_sets_rec.Effective_End_Date,
	  p_last_update_date         => l_last_update_date,
	  p_last_updated_by          => l_last_updated_by,
	  p_last_update_login        => l_last_update_login,
	  p_created_by               => l_created_by,
	  p_creation_date            => l_creation_date
	);

Line: 1196

	  SELECT NVL(value_table_flag, 'N') INTO l_value_table_flag
	  FROM   psb_attributes
	  WHERE  attribute_id = l_attribute_id ;

Line: 1347

	SELECT psb_parameter_formulas_s.nextval INTO l_parameter_formula_id
	FROM   dual;

Line: 1352

	PSB_PARAMETER_FORMULAS_PVT.INSERT_ROW
	( p_api_version                 => 1.0,
	  p_init_msg_list               => null,
	  p_commit                      => null,
	  p_validation_level            => null,
	  p_return_status               => l_return_status,
	  p_msg_count                   => l_msg_count,
	  p_msg_data                    => l_msg_data,
	  p_rowid                       => l_rowid,
	  p_parameter_formula_id        => l_parameter_formula_id,
	  p_parameter_id                => l_entity_id,
	  p_step_number                 => l_para_formula_rec.step_number,
		    p_budget_year_type_id               => l_para_formula_rec.budget_year_type_id,
	  p_balance_type                => l_para_formula_rec.balance_type,
	  p_template_id                 => l_para_formula_rec.template_id,
	  p_concatenated_segments       => l_para_formula_rec.concatenated_segments,
	  p_segment1                    => l_para_formula_rec.segment1,
	  p_segment2                    => l_para_formula_rec.segment2,
	  p_segment3                    => l_para_formula_rec.segment3,
	  p_segment4                    => l_para_formula_rec.segment4,
	  p_segment5                    => l_para_formula_rec.segment5,
	  p_segment6                    => l_para_formula_rec.segment6,
	  p_segment7                    => l_para_formula_rec.segment7,
	  p_segment8                    => l_para_formula_rec.segment8,
	  p_segment9                    => l_para_formula_rec.segment9,
	  p_segment10                   => l_para_formula_rec.segment10,
	  p_segment11                   => l_para_formula_rec.segment11,
	  p_segment12                   => l_para_formula_rec.segment12,
	  p_segment13                   => l_para_formula_rec.segment13,
	  p_segment14                   => l_para_formula_rec.segment14,
	  p_segment15                   => l_para_formula_rec.segment15,
	  p_segment16                   => l_para_formula_rec.segment16,
	  p_segment17                   => l_para_formula_rec.segment17,
	  p_segment18                   => l_para_formula_rec.segment18,
	  p_segment19                   => l_para_formula_rec.segment19,
	  p_segment20                   => l_para_formula_rec.segment20,
	  p_segment21                   => l_para_formula_rec.segment21,
	  p_segment22                   => l_para_formula_rec.segment22,
	  p_segment23                   => l_para_formula_rec.segment23,
	  p_segment24                   => l_para_formula_rec.segment24,
	  p_segment25                   => l_para_formula_rec.segment25,
	  p_segment26                   => l_para_formula_rec.segment26,
	  p_segment27                   => l_para_formula_rec.segment27,
	  p_segment28                   => l_para_formula_rec.segment28,
	  p_segment29                   => l_para_formula_rec.segment29,
	  p_segment30                   => l_para_formula_rec.segment30,
	  p_currency_code               => l_para_formula_rec.currency_code,
	  p_amount                      => l_para_formula_rec.amount,
	  p_prefix_operator             => l_para_formula_rec.prefix_operator,
	  p_postfix_operator            => l_para_formula_rec.postfix_operator,
	  p_hiredate_between_FROM       =>
					l_para_formula_rec.hiredate_between_from,
	  p_hiredate_between_to         => l_para_formula_rec.hiredate_between_to,
	  p_adjdate_between_FROM        =>
					l_para_formula_rec.adjdate_between_from,
	  p_adjdate_between_to          => l_para_formula_rec.adjdate_between_to,
	  p_increment_by                => l_para_formula_rec.increment_by,
	  p_increment_type              => l_para_formula_rec.increment_type,
	  p_assignment_type             => l_para_formula_rec.assignment_type,
	  p_attribute_id                => l_para_formula_rec.attribute_id,
	  p_attribute_value             => l_para_formula_rec.attribute_value,
	  p_pay_element_id              => l_target_pay_element_id,
	  p_pay_element_option_id       => l_target_pay_element_option_id,
	  p_grade_step                  => l_para_formula_rec.grade_step,
	  p_element_value               => l_para_formula_rec.element_value,
	  p_element_value_type          => l_para_formula_rec.element_value_type,
	  p_effective_start_date        =>
					 l_para_formula_rec.effective_start_date,
	  p_effective_end_date          => l_para_formula_rec.effective_end_date,
	  p_attribute1                  => l_para_formula_rec.attribute1,
	  p_attribute2                  => l_para_formula_rec.attribute2,
	  p_attribute3                  => l_para_formula_rec.attribute3,
	  p_attribute4                  => l_para_formula_rec.attribute4,
	  p_attribute5                  => l_para_formula_rec.attribute5,
	  p_attribute6                  => l_para_formula_rec.attribute6,
	  p_attribute7                  => l_para_formula_rec.attribute7,
	  p_attribute8                  => l_para_formula_rec.attribute8,
	  p_attribute9                  => l_para_formula_rec.attribute9,
	  p_attribute10                 => l_para_formula_rec.attribute10,
	  p_context                     => l_para_formula_rec.context,
	  p_last_update_date            => l_last_update_date,
	  p_last_updated_by             => l_last_updated_by,
	  p_last_update_login           => l_last_update_login,
	  p_created_by                  => l_created_by,
	  p_creation_date               => l_creation_date
	);

Line: 1594

	SELECT psb_constraint_formulas_s.nextval INTO l_constraint_formula_id
	FROM   dual;

Line: 1600

	PSB_CONSTRAINT_FORMULAS_PVT.INSERT_ROW
	( p_api_version                 => 1.0,
	  p_init_msg_list               => null,
	  p_commit                      => null,
	  p_validation_level            => null,
	  p_return_status               => l_return_status,
	  p_msg_count                   => l_msg_count,
	  p_msg_data                    => l_msg_data,
	  p_rowid                       => l_rowid,
	  p_constraint_formula_id       => l_constraint_formula_id,
	  p_constraint_id               => l_entity_id,
	  p_step_number                 => l_const_formula_rec.step_number,
	  p_budget_year_type_id         => l_const_formula_rec.budget_year_type_id,
	  p_balance_type                => l_const_formula_rec.balance_type,
	  p_currency_code               => l_const_formula_rec.currency_code,
	  p_template_id                 => l_const_formula_rec.template_id,
	  p_segment1                    => l_const_formula_rec.segment1,
	  p_segment2                    => l_const_formula_rec.segment2,
	  p_segment3                    => l_const_formula_rec.segment3,
	  p_segment4                    => l_const_formula_rec.segment4,
	  p_segment5                    => l_const_formula_rec.segment5,
	  p_segment6                    => l_const_formula_rec.segment6,
	  p_segment7                    => l_const_formula_rec.segment7,
	  p_segment8                    => l_const_formula_rec.segment8,
	  p_segment9                    => l_const_formula_rec.segment9,
	  p_segment10                   => l_const_formula_rec.segment10,
	  p_segment11                   => l_const_formula_rec.segment11,
	  p_segment12                   => l_const_formula_rec.segment12,
	  p_segment13                   => l_const_formula_rec.segment13,
	  p_segment14                   => l_const_formula_rec.segment14,
	  p_segment15                   => l_const_formula_rec.segment15,
	  p_segment16                   => l_const_formula_rec.segment16,
	  p_segment17                   => l_const_formula_rec.segment17,
	  p_segment18                   => l_const_formula_rec.segment18,
	  p_segment19                   => l_const_formula_rec.segment19,
	  p_segment20                   => l_const_formula_rec.segment20,
	  p_segment21                   => l_const_formula_rec.segment21,
	  p_segment22                   => l_const_formula_rec.segment22,
	  p_segment23                   => l_const_formula_rec.segment23,
	  p_segment24                   => l_const_formula_rec.segment24,
	  p_segment25                   => l_const_formula_rec.segment25,
	  p_segment26                   => l_const_formula_rec.segment26,
	  p_segment27                   => l_const_formula_rec.segment27,
	  p_segment28                   => l_const_formula_rec.segment28,
	  p_segment29                   => l_const_formula_rec.segment29,
	  p_segment30                   => l_const_formula_rec.segment30,
	  p_amount                      => l_const_formula_rec.amount,
	  p_prefix_operator             => l_const_formula_rec.prefix_operator,
	  p_postfix_operator            => l_const_formula_rec.postfix_operator,
	  p_pay_element_id              => l_target_pay_element_id,
	  p_pay_element_option_id       => l_target_pay_element_option_id,
	  p_allow_modify                => l_const_formula_rec.allow_modify,
	  p_element_value               => l_const_formula_rec.element_value,
	  p_element_value_type          =>
					 l_const_formula_rec.element_value_type,
	  p_effective_start_date        =>
					 l_const_formula_rec.effective_start_date,
	  p_effective_end_date          => l_const_formula_rec.effective_end_date,
	  p_attribute1                  => l_const_formula_rec.attribute1,
	  p_attribute2                  => l_const_formula_rec.attribute2,
	  p_attribute3                  => l_const_formula_rec.attribute3,
	  p_attribute4                  => l_const_formula_rec.attribute4,
	  p_attribute5                  => l_const_formula_rec.attribute5,
	  p_context                     => l_const_formula_rec.context,
	  p_concatenated_segments       =>
					l_const_formula_rec.concatenated_segments,
	  p_last_update_date            => l_last_update_date,
	  p_last_updated_by             => l_last_updated_by,
	  p_last_update_login           => l_last_update_login,
	  p_created_by                  => l_created_by,
	  p_creation_date               => l_creation_date
	);

Line: 1765

  l_last_update_date            DATE;

Line: 1766

  l_last_updated_by             NUMBER;

Line: 1767

  l_last_update_login           NUMBER;

Line: 1783

	SELECT DISTINCT lines.attribute_id, attr_values.attribute_value
	FROM   psb_entity_assignment           assgn,
	       psb_entity                      entity,
	       psb_set_relations               rels,
	       psb_account_position_sets       sets,
	       psb_account_position_set_lines  lines,
	       psb_position_set_line_values    pos_val,
	       psb_attributes                  attrs,
	       psb_attribute_values            attr_values
	WHERE  assgn.entity_set_id           = p_source_entity_set_id
	and    assgn.entity_id               = entity.entity_id
	and    entity.entity_subtype         = 'POSITION'
	and    DECODE(p_entity_type,
			'P', rels.parameter_id,
			'C', rels.constraint_id) = entity.entity_id
	and    sets.account_position_set_id  = rels.account_position_set_id
	and    sets.account_position_set_id  = lines.account_position_set_id
	and    attrs.attribute_id            = lines.attribute_id
	and    attrs.attribute_id            = attr_values.attribute_id
	and    attr_values.data_extract_id   = p_source_data_extract_id
	and    attrs.value_table_flag        = 'Y'
	and    lines.line_sequence_id        = pos_val.line_sequence_id
	and    pos_val.attribute_value_id    = attr_values.attribute_value_id
      )
      UNION
      (
	SELECT DISTINCT formulas.attribute_id, attr_values.attribute_value
	FROM   psb_entity_assignment         assgn,
	       psb_entity                    entity,
	       psb_parameter_formulas        formulas,
	       psb_attributes                attrs,
	       psb_attribute_values          attr_values
	WHERE  assgn.entity_set_id         = p_source_entity_set_id
	and    assgn.entity_id             = entity.entity_id
	and    entity.entity_subtype       = 'POSITION'
	and    formulas.parameter_id       = entity.entity_id
	and    formulas.assignment_type    = 'ATTRIBUTE'
	and    formulas.attribute_id       = attrs.attribute_id
	and    attrs.value_table_flag      = 'Y'
	and    attrs.attribute_id          = attr_values.attribute_id
	and    attr_values.data_extract_id = p_source_data_extract_id
      );

Line: 1827

       SELECT  attr_values.*
	FROM   psb_attributes                attrs,
	       psb_attribute_values          attr_values
	WHERE  attrs.value_table_flag      = 'Y'
	and    attrs.attribute_id          = l_attribute_id
	and    attr_values.attribute_value = l_attribute_value
	and    attr_values.data_extract_id = p_source_data_extract_id;

Line: 1864

  l_last_update_date  := SYSDATE;

Line: 1865

  l_last_updated_by   := FND_GLOBAL.USER_ID;

Line: 1866

  l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1880

    SELECT  count(*) into l_count
    FROM    psb_attributes                attrs,
	    psb_attribute_values          attr_values
    WHERE   attrs.value_table_flag      = 'Y'
    and     attrs.attribute_id          = l_attribute_id
    and     attr_values.attribute_value = l_attribute_value
    and     attr_values.data_extract_id = p_target_data_extract_id;

Line: 1894

      SELECT psb_attribute_values_s.nextval INTO l_attribute_value_id
      FROM   dual;

Line: 1897

      PSB_ATTRIBUTE_VALUES_PVT.INSERT_ROW
      ( p_api_version             =>  1.0,
	p_init_msg_list           => null,
	p_commit                  => null,
	p_validation_level        => null,
	p_return_status           => l_return_status,
	p_msg_count               => l_msg_count,
	p_msg_data                => l_msg_data,
	p_rowid                   => l_rowid,
	p_attribute_value_id      => l_attribute_value_id,
	p_attribute_id            => l_attribute_value_rec.attribute_id,
	p_attribute_value         => l_attribute_value_rec.attribute_value,
	p_hr_value_id             => l_attribute_value_rec.hr_value_id,
	p_description             => l_attribute_value_rec.description,
	p_data_extract_id         => p_target_data_extract_id,
	p_context                 => l_attribute_value_rec.context,
	p_attribute1              => l_attribute_value_rec.attribute1,
	p_attribute2              => l_attribute_value_rec.attribute2,
	p_attribute3              => l_attribute_value_rec.attribute3,
	p_attribute4              => l_attribute_value_rec.attribute4,
	p_attribute5              => l_attribute_value_rec.attribute5,
	p_attribute6              => l_attribute_value_rec.attribute6,
	p_attribute7              => l_attribute_value_rec.attribute7,
	p_attribute8              => l_attribute_value_rec.attribute8,
	p_attribute9              => l_attribute_value_rec.attribute9,
	p_attribute10             => l_attribute_value_rec.attribute10,
	p_attribute11             => l_attribute_value_rec.attribute11,
	p_attribute12             => l_attribute_value_rec.attribute12,
	p_attribute13             => l_attribute_value_rec.attribute13,
	p_attribute14             => l_attribute_value_rec.attribute14,
	p_attribute15             => l_attribute_value_rec.attribute15,
	p_attribute16             => l_attribute_value_rec.attribute16,
	p_attribute17             => l_attribute_value_rec.attribute17,
	p_attribute18             => l_attribute_value_rec.attribute18,
	p_attribute19             => l_attribute_value_rec.attribute19,
	p_attribute20             => l_attribute_value_rec.attribute20,
	p_attribute21             => l_attribute_value_rec.attribute21,
	p_attribute22             => l_attribute_value_rec.attribute22,
	p_attribute23             => l_attribute_value_rec.attribute23,
	p_attribute24             => l_attribute_value_rec.attribute24,
	p_attribute25             => l_attribute_value_rec.attribute25,
	p_attribute26             => l_attribute_value_rec.attribute26,
	p_attribute27             => l_attribute_value_rec.attribute27,
	p_attribute28             => l_attribute_value_rec.attribute28,
	p_attribute29             => l_attribute_value_rec.attribute29,
	p_attribute30             => l_attribute_value_rec.attribute30,
	p_last_update_date        => l_last_update_date,
	p_last_updated_by         => l_last_updated_by,
	p_last_update_login       => l_last_update_login,
	p_created_by              => l_created_by,
	p_creation_date           => l_creation_date
      );

Line: 2045

    SELECT 1
      FROM DUAL
     WHERE EXISTS(
                  SELECT 1
                    FROM PSB_WORKSHEETS
                   WHERE ((parameter_set_id = p_entity_set_id)
                          OR
                          (constraint_set_id = p_entity_set_id)
                          OR
                          (allocrule_set_id = p_entity_set_id))
                 );

Line: 2058

    SELECT 1
      FROM DUAL
     WHERE EXISTS(
                  SELECT 1
                    FROM PSB_BUDGET_REVISIONS
                   WHERE ((parameter_set_id = p_entity_set_id)
                          OR
                          (constraint_set_id = p_entity_set_id))
                  );