APPS.BSC_CALCULATIONS_PVT SQL Statements

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

Line: 24

PROCEDURE delete_objective_calculation (
  p_indicator            IN    bsc_kpi_calculations.indicator%TYPE,
  p_calculation_id       IN    bsc_kpi_calculations.calculation_id%TYPE,
  x_return_status      OUT   NOCOPY   VARCHAR2,
  x_msg_count          OUT   NOCOPY   NUMBER,
  x_msg_data           OUT   NOCOPY   VARCHAR2
)
IS

BEGIN
  IF (p_indicator IS NOT NULL AND p_calculation_id IS NOT NULL) THEN
    x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 37

    DELETE bsc_kpi_calculations
    WHERE indicator = p_indicator
      AND calculation_id = p_calculation_id;

Line: 47

END delete_objective_calculation;

Line: 52

PROCEDURE insert_objective_calculation (
  p_indicator            IN    bsc_kpi_calculations.indicator%TYPE,
  p_calculation_id       IN    bsc_kpi_calculations.calculation_id%TYPE,
  p_user_level0          IN    bsc_kpi_calculations.user_level0%TYPE,
  p_user_level1          IN    bsc_kpi_calculations.user_level1%TYPE,
  p_user_level1_default  IN    bsc_kpi_calculations.user_level1_default%TYPE,
  p_user_level2          IN    bsc_kpi_calculations.user_level2%TYPE,
  p_user_level2_default  IN    bsc_kpi_calculations.user_level2_default%TYPE,
  p_default_value        IN    bsc_kpi_calculations.default_value%TYPE,
  x_return_status      OUT   NOCOPY   VARCHAR2,
  x_msg_count          OUT   NOCOPY   NUMBER,
  x_msg_data           OUT   NOCOPY   VARCHAR2
)
IS

BEGIN
  IF (p_indicator IS NOT NULL AND p_calculation_id IS NOT NULL) THEN
    x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 71

    INSERT
    INTO bsc_kpi_calculations(INDICATOR,
                              CALCULATION_ID,
                              USER_LEVEL0,
                              USER_LEVEL1,
                              USER_LEVEL1_DEFAULT,
                              USER_LEVEL2,
                              USER_LEVEL2_DEFAULT,
                              DEFAULT_VALUE)
    VALUES(p_indicator,
           p_calculation_id,
           p_user_level0,
           p_user_level1,
           p_user_level1_default,
           p_user_level2,
           p_user_level2_default,
           p_default_value
           );

Line: 95

END insert_objective_calculation;