DBA Data[Home] [Help]

APPS.OKC_OAT_PVT SQL Statements

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

Line: 45

    SELECT
            ID,
            OCE_ID,
            PDP_ID,
            AAE_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            VALUE,
            LAST_UPDATE_LOGIN,
            APPLICATION_ID,
            SEEDED_FLAG
      FROM Okc_Outcome_Arguments
     WHERE okc_outcome_arguments.id = p_id;
Line: 77

              l_oat_rec.LAST_UPDATED_BY,
              l_oat_rec.LAST_UPDATE_DATE,
              l_oat_rec.VALUE,
              l_oat_rec.LAST_UPDATE_LOGIN,
              l_oat_rec.APPLICATION_ID,
              l_oat_rec.SEEDED_FLAG;
Line: 103

    SELECT
            ID,
            PDP_ID,
            OCE_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_Outcome_Arguments_V
     WHERE okc_outcome_arguments_v.id = p_id;
Line: 138

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

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

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

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

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              PDF_ID,
              CNH_ID,
              DNZ_CHR_ID,
              ENABLED_YN,
              COMMENTS,
              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_Outcomes_V
       WHERE okc_outcomes_v.id    = p_id;
Line: 294

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              PDF_ID,
              NAME,
              DATA_TYPE,
              DEFAULT_VALUE,
              REQUIRED_YN,
              DESCRIPTION,
              APPLICATION_ID,
              SEEDED_FLAG,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Process_Def_Parameters_V
       WHERE okc_process_def_parameters_v.id = p_id;
Line: 315

      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: 520

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

      SELECT '1'
      FROM Okc_process_def_parameters_v, okc_process_defs_v
      WHERE okc_process_def_parameters_v.id = p_oatv_rec.pdp_id
      and okc_process_def_parameters_v.pdf_id = okc_process_defs_v.id;
Line: 646

      SELECT '1'
      FROM Okc_outcomes_v
      WHERE okc_outcomes_v.id = p_oatv_rec.oce_id;
Line: 719

      SELECT '1'
      FROM Okc_action_attributes_v
      WHERE okc_action_attributes_v.id = p_oatv_rec.aae_id;
Line: 932

	select data_type
	from okc_process_def_parameters_v
	where id = p_pdp_id;
Line: 937

	select data_type
	from okc_action_attributes_v
	where id = p_aae_id;
Line: 1031

	select data_type
	from okc_process_def_parameters_v
	where id = p_pdp_id;
Line: 1190

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

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

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

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

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

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

  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_oat_rec                      IN oat_rec_type,
    x_oat_rec                      OUT NOCOPY oat_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1377

    l_api_name                     CONSTANT VARCHAR2(30) := 'ARGUMENTS_insert_row';
Line: 1413

    INSERT INTO OKC_OUTCOME_ARGUMENTS(
        id,
        oce_id,
        pdp_id,
        aae_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        value,
        last_update_login,
        application_id,
        seeded_flag)
      VALUES (
        l_oat_rec.id,
        l_oat_rec.oce_id,
        l_oat_rec.pdp_id,
        l_oat_rec.aae_id,
        l_oat_rec.dnz_chr_id,
        l_oat_rec.object_version_number,
        l_oat_rec.created_by,
        l_oat_rec.creation_date,
        l_oat_rec.last_updated_by,
        l_oat_rec.last_update_date,
        l_oat_rec.value,
        l_oat_rec.last_update_login,
        l_oat_rec.application_id,
        l_oat_rec.seeded_flag);
Line: 1477

  END insert_row;
Line: 1481

  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_oatv_rec                     IN oatv_rec_type,
    x_oatv_rec                     OUT NOCOPY oatv_rec_type) IS

    l_id                           NUMBER ;
Line: 1492

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

      l_oatv_rec.LAST_UPDATE_DATE := l_oatv_rec.CREATION_DATE;
Line: 1509

      l_oatv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1510

      l_oatv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1543

	  SELECT OKC_OUTCOME_ARGUMENTS_S1.nextval INTO l_id FROM dual;
Line: 1584

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_oat_rec,
      lx_oat_rec
    );
Line: 1632

  END insert_row;
Line: 1636

  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_oatv_tbl                     IN oatv_tbl_type,
    x_oatv_tbl                     OUT NOCOPY oatv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1646

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

        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_oatv_rec                     => p_oatv_tbl(i),
          x_oatv_rec                     => x_oatv_tbl(i));
Line: 1698

  END insert_row;
Line: 1716

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_OUTCOME_ARGUMENTS
     WHERE ID = p_oat_rec.id
       AND OBJECT_VERSION_NUMBER = p_oat_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1723

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_OUTCOME_ARGUMENTS
    WHERE ID = p_oat_rec.id;
Line: 1764

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

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

  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_oat_rec                      IN oat_rec_type,
    x_oat_rec                      OUT NOCOPY oat_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1969

    l_api_name                     CONSTANT VARCHAR2(30) := 'ARGUMENTS_update_row';
Line: 2023

      IF (x_oat_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_oat_rec.last_updated_by := l_oat_rec.last_updated_by;
Line: 2027

      IF (x_oat_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_oat_rec.last_update_date := l_oat_rec.last_update_date;
Line: 2035

      IF (x_oat_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_oat_rec.last_update_login := l_oat_rec.last_update_login;
Line: 2087

    UPDATE  OKC_OUTCOME_ARGUMENTS
    SET OCE_ID = l_def_oat_rec.oce_id,
        PDP_ID = l_def_oat_rec.pdp_id,
        AAE_ID = l_def_oat_rec.aae_id,
        DNZ_CHR_ID = l_def_oat_rec.dnz_chr_id,
        OBJECT_VERSION_NUMBER = l_def_oat_rec.object_version_number,
        CREATED_BY = l_def_oat_rec.created_by,
        CREATION_DATE = l_def_oat_rec.creation_date,
        LAST_UPDATED_BY = l_def_oat_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_oat_rec.last_update_date,
        VALUE = l_def_oat_rec.value,
        LAST_UPDATE_LOGIN = l_def_oat_rec.last_update_login,
        APPLICATION_ID = l_def_oat_rec.application_id,
        SEEDED_FLAG = l_def_oat_rec.seeded_flag
    WHERE ID = l_def_oat_rec.id;
Line: 2136

  END update_row;
Line: 2140

  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_oatv_rec                     IN oatv_rec_type,
    x_oatv_rec                     OUT NOCOPY oatv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2150

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

      l_oatv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2165

      l_oatv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2166

      l_oatv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2230

      IF (x_oatv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_oatv_rec.last_updated_by := l_oatv_rec.last_updated_by;
Line: 2234

      IF (x_oatv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_oatv_rec.last_update_date := l_oatv_rec.last_update_date;
Line: 2238

      IF (x_oatv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_oatv_rec.last_update_login := l_oatv_rec.last_update_login;
Line: 2271

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

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_oat_rec,
      lx_oat_rec
    );
Line: 2364

  END update_row;
Line: 2368

  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_oatv_tbl                     IN oatv_tbl_type,
    x_oatv_tbl                     OUT NOCOPY oatv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2378

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

        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_oatv_rec                     => p_oatv_tbl(i),
          x_oatv_rec                     => x_oatv_tbl(i));
Line: 2430

  END update_row;
Line: 2438

  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_oat_rec                      IN oat_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2446

    l_api_name                     CONSTANT VARCHAR2(30) := 'ARGUMENTS_delete_row';
Line: 2460

    DELETE FROM OKC_OUTCOME_ARGUMENTS
     WHERE ID = l_oat_rec.id;
Line: 2495

  END delete_row;
Line: 2499

  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_oatv_rec                     IN oatv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2508

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

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_oat_rec
    );
Line: 2584

  END delete_row;
Line: 2588

  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_oatv_tbl                     IN oatv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2597

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

        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_oatv_rec                     => p_oatv_tbl(i));
Line: 2648

  END delete_row;
Line: 2653

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_oatv_tbl oatv_tbl_type) IS
  l_tabsize NUMBER := p_oatv_tbl.COUNT;
Line: 2668

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 2669

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 2670

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 2691

    in_last_updated_by          (j) := p_oatv_tbl(i).last_updated_by;
Line: 2692

    in_last_update_date         (j) := p_oatv_tbl(i).last_update_date;
Line: 2693

    in_last_update_login        (j) := p_oatv_tbl(i).last_update_login;
Line: 2698

    INSERT
      INTO OKC_OUTCOME_ARGUMENTS
      (
        id,
        oce_id,
        pdp_id,
        aae_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        value,
        last_update_login,
        application_id,
        seeded_flag
     )
     VALUES (
        in_id(i),
        in_oce_id(i),
        in_pdp_id(i),
        in_aae_id(i),
        in_dnz_chr_id(i),
        in_object_version_number(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_value(i),
        in_last_update_login(i),
        in_application_id(i),
        in_seeded_flag(i)
     );
Line: 2746

END INSERT_ROW_UPG;
Line: 2760

INSERT INTO okc_outcome_arguments_h
  (
      major_version,
      id,
      oce_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      value,
      last_update_login,
    application_id,
    seeded_flag
)
  SELECT
      p_major_version,
      id,
      oce_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      value,
      last_update_login,
    application_id,
    seeded_flag
  FROM okc_outcome_arguments
 WHERE dnz_chr_id = p_chr_id;
Line: 2826

INSERT INTO okc_outcome_arguments
  (
      id,
      oce_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      value,
      last_update_login,
    application_id,
    seeded_flag
)
  SELECT
      id,
      oce_id,
      pdp_id,
      aae_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      value,
      last_update_login,
    application_id,
    seeded_flag
  FROM okc_outcome_arguments_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;