DBA Data[Home] [Help]

APPS.OKC_FEP_PVT SQL Statements

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

Line: 45

    SELECT
            ID,
            CNL_ID,
            PDP_ID,
            AAE_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            VALUE,
            APPLICATION_ID,
            SEEDED_FLAG,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Function_Expr_Params
     WHERE okc_function_expr_params.id = p_id;
Line: 80

              l_fep_rec.LAST_UPDATED_BY,
              l_fep_rec.LAST_UPDATE_DATE,
              l_fep_rec.LAST_UPDATE_LOGIN;
Line: 103

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CNL_ID,
            PDP_ID,
            AAE_ID,
            DNZ_CHR_ID,
            VALUE,
            APPLICATION_ID,
            SEEDED_FLAG,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Function_Expr_Params_V
     WHERE okc_function_expr_params_v.id = p_id;
Line: 138

              l_fepv_rec.LAST_UPDATED_BY,
              l_fepv_rec.LAST_UPDATE_DATE,
              l_fepv_rec.LAST_UPDATE_LOGIN;
Line: 192

    IF (l_fepv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_fepv_rec.last_updated_by := NULL;
Line: 195

    IF (l_fepv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_fepv_rec.last_update_date := NULL;
Line: 198

    IF (l_fepv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_fepv_rec.last_update_login := NULL;
Line: 258

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              CNH_ID,
              PDF_ID,
              AAE_ID,
              LEFT_CTR_MASTER_ID,
              RIGHT_CTR_MASTER_ID,
              LEFT_COUNTER_ID,
              RIGHT_COUNTER_ID,
              DNZ_CHR_ID,
              SORTSEQ,
              CNL_TYPE,
              DESCRIPTION,
              LEFT_PARENTHESIS,
              RELATIONAL_OPERATOR,
              RIGHT_PARENTHESIS,
              LOGICAL_OPERATOR,
              TOLERANCE,
              START_AT,
              RIGHT_OPERAND,
              APPLICATION_ID,
              SEEDED_FLAG,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Condition_Lines_V
       WHERE okc_condition_lines_v.id = p_id;
Line: 307

      SELECT
              ID,
              AAL_ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              ACN_ID,
              ELEMENT_NAME,
              NAME,
              DESCRIPTION,
              DATA_TYPE,
              LIST_YN,
              VISIBLE_YN,
              DATE_OF_INTEREST_YN,
              FORMAT_MASK,
              MINIMUM_VALUE,
              MAXIMUM_VALUE,
              APPLICATION_ID,
              SEEDED_FLAG,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Action_Attributes_V
       WHERE okc_action_attributes_v.id = p_id;
Line: 350

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              DESCRIPTION,
              SHORT_DESCRIPTION,
              COMMENTS,
              USAGE,
              NAME,
              WF_NAME,
              WF_PROCESS_NAME,
              PROCEDURE_NAME,
              PACKAGE_NAME,
              PDF_TYPE,
              APPLICATION_ID,
              SEEDED_FLAG,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              BEGIN_DATE,
              END_DATE,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Process_Defs_V
       WHERE okc_process_defs_v.id = p_id;
Line: 567

	select '1'
	from fnd_application
	where application_id = p_application_id;
Line: 959

  SELECT 1
  FROM okc_function_expr_params
  WHERE  cnl_id = p_cnl_id
  AND    pdp_id = p_pdp_id
  AND    id <> nvl(p_fepv_rec.id,-99999);
Line: 1046

      SELECT '1'
        FROM Okc_Condition_Lines_V
       WHERE okc_condition_lines_v.id = p_id;
Line: 1053

      SELECT  '1'
        FROM Okc_Action_Attributes_V
       WHERE okc_action_attributes_v.id = p_id;
Line: 1060

      SELECT  '1'
        FROM Okc_Process_Def_Parameters_V
       WHERE okc_process_def_parameters_v.id = p_id;
Line: 1286

    p_to.last_updated_by := p_from.last_updated_by;
Line: 1287

    p_to.last_update_date := p_from.last_update_date;
Line: 1288

    p_to.last_update_login := p_from.last_update_login;
Line: 1306

    p_to.last_updated_by := p_from.last_updated_by;
Line: 1307

    p_to.last_update_date := p_from.last_update_date;
Line: 1308

    p_to.last_update_login := p_from.last_update_login;
Line: 1461

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fep_rec                      IN fep_rec_type,
    x_fep_rec                      OUT NOCOPY fep_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1470

    l_api_name                     CONSTANT VARCHAR2(30) := 'PARAMS_insert_row';
Line: 1506

    INSERT INTO OKC_FUNCTION_EXPR_PARAMS(
        id,
        cnl_id,
        pdp_id,
        aae_id,
        dnz_chr_id,
        object_version_number,
        value,
        application_id,
        seeded_flag,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_fep_rec.id,
        l_fep_rec.cnl_id,
        l_fep_rec.pdp_id,
        l_fep_rec.aae_id,
        l_fep_rec.dnz_chr_id,
        l_fep_rec.object_version_number,
        l_fep_rec.value,
        l_fep_rec.application_id,
        l_fep_rec.seeded_flag,
        l_fep_rec.created_by,
        l_fep_rec.creation_date,
        l_fep_rec.last_updated_by,
        l_fep_rec.last_update_date,
        l_fep_rec.last_update_login);
Line: 1570

  END insert_row;
Line: 1574

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fepv_rec                     IN fepv_rec_type,
    x_fepv_rec                     OUT NOCOPY fepv_rec_type) IS

    l_id                  NUMBER ;
Line: 1585

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1601

      l_fepv_rec.LAST_UPDATE_DATE := l_fepv_rec.CREATION_DATE;
Line: 1602

      l_fepv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1603

      l_fepv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1636

	  SELECT OKC_FUNCTION_EXPR_PARAMS_S1.nextval INTO l_id FROM dual;
Line: 1693

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_fep_rec,
      lx_fep_rec
    );
Line: 1741

  END insert_row;
Line: 1745

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fepv_tbl                     IN fepv_tbl_type,
    x_fepv_tbl                     OUT NOCOPY fepv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1755

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 1764

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_fepv_rec                     => p_fepv_tbl(i),
          x_fepv_rec                     => x_fepv_tbl(i));
Line: 1807

  END insert_row;
Line: 1825

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_FUNCTION_EXPR_PARAMS
     WHERE ID = p_fep_rec.id
       AND OBJECT_VERSION_NUMBER = p_fep_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1832

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_FUNCTION_EXPR_PARAMS
    WHERE ID = p_fep_rec.id;
Line: 1873

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1882

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2069

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fep_rec                      IN fep_rec_type,
    x_fep_rec                      OUT NOCOPY fep_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2078

    l_api_name                     CONSTANT VARCHAR2(30) := 'PARAMS_update_row';
Line: 2144

      IF (x_fep_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_fep_rec.last_updated_by := l_fep_rec.last_updated_by;
Line: 2148

      IF (x_fep_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_fep_rec.last_update_date := l_fep_rec.last_update_date;
Line: 2152

      IF (x_fep_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_fep_rec.last_update_login := l_fep_rec.last_update_login;
Line: 2196

    UPDATE  OKC_FUNCTION_EXPR_PARAMS
    SET CNL_ID = l_def_fep_rec.cnl_id,
        PDP_ID = l_def_fep_rec.pdp_id,
        AAE_ID = l_def_fep_rec.aae_id,
        DNZ_CHR_ID = l_def_fep_rec.dnz_chr_id,
        OBJECT_VERSION_NUMBER = l_def_fep_rec.object_version_number,
        VALUE = l_def_fep_rec.value,
        APPLICATION_ID = l_def_fep_rec.application_id,
        SEEDED_FLAG = l_def_fep_rec.seeded_flag,
        CREATED_BY = l_def_fep_rec.created_by,
        CREATION_DATE = l_def_fep_rec.creation_date,
        LAST_UPDATED_BY = l_def_fep_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_fep_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_fep_rec.last_update_login
    WHERE ID = l_def_fep_rec.id;
Line: 2245

  END update_row;
Line: 2249

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fepv_rec                     IN fepv_rec_type,
    x_fepv_rec                     OUT NOCOPY fepv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2259

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 2273

      l_fepv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2274

      l_fepv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2275

      l_fepv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2339

      IF (x_fepv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_fepv_rec.last_updated_by := l_fepv_rec.last_updated_by;
Line: 2343

      IF (x_fepv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_fepv_rec.last_update_date := l_fepv_rec.last_update_date;
Line: 2347

      IF (x_fepv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_fepv_rec.last_update_login := l_fepv_rec.last_update_login;
Line: 2380

    IF  l_fepv_rec.last_updated_by <> 1 THEN
    IF  l_fepv_rec.seeded_flag = 'Y' THEN
	   OKC_API.set_message(p_app_name => G_APP_NAME,
					   p_msg_name => 'OKC_NOT_DELETE_SEEDED');
Line: 2426

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_fep_rec,
      lx_fep_rec
    );
Line: 2473

  END update_row;
Line: 2477

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fepv_tbl                     IN fepv_tbl_type,
    x_fepv_tbl                     OUT NOCOPY fepv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2487

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 2496

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_fepv_rec                     => p_fepv_tbl(i),
          x_fepv_rec                     => x_fepv_tbl(i));
Line: 2539

  END update_row;
Line: 2547

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fep_rec                      IN fep_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2555

    l_api_name                     CONSTANT VARCHAR2(30) := 'PARAMS_delete_row';
Line: 2569

    DELETE FROM OKC_FUNCTION_EXPR_PARAMS
     WHERE ID = l_fep_rec.id;
Line: 2604

  END delete_row;
Line: 2608

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fepv_rec                     IN fepv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2617

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 2635

    IF  l_fepv_rec.last_updated_by <> 1 THEN
    IF  l_fepv_rec.seeded_flag = 'Y' THEN
	   OKC_API.set_message(p_app_name => G_APP_NAME,
					   p_msg_name => 'OKC_NOT_DELETE_SEEDED');
Line: 2649

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_fep_rec
    );
Line: 2693

  END delete_row;
Line: 2697

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_fepv_tbl                     IN fepv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2706

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 2715

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_fepv_rec                     => p_fepv_tbl(i));
Line: 2757

  END delete_row;
Line: 2771

INSERT INTO okc_function_expr_params_h
  (
      major_version,
      id,
      cnl_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      value,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      APPLICATION_ID,
      SEEDED_FLAG
)
  SELECT
      p_major_version,
      id,
      cnl_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      value,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      APPLICATION_ID,
      SEEDED_FLAG
  FROM okc_function_expr_params
WHERE dnz_chr_id = p_chr_id;
Line: 2837

INSERT INTO okc_function_expr_params
  (
      id,
      cnl_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      value,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      APPLICATION_ID,
      SEEDED_FLAG
)
  SELECT
      id,
      cnl_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      value,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      APPLICATION_ID,
      SEEDED_FLAG
  FROM okc_function_expr_params_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;