APPS.OKC_PDP_PVT SQL Statements

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

Line: 47

    DELETE FROM OKC_PROCESS_DEF_PARMS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_PROCESS_DEF_PARMS_B B
         WHERE B.ID = T.ID
        );

Line: 54

    UPDATE OKC_PROCESS_DEF_PARMS_TL T SET (
        NAME,
        DESCRIPTION) = (SELECT
                                  B.NAME,
                                  B.DESCRIPTION
                                FROM OKC_PROCESS_DEF_PARMS_TL B
                               WHERE B.ID = T.ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.LANGUAGE
                FROM OKC_PROCESS_DEF_PARMS_TL SUBB, OKC_PROCESS_DEF_PARMS_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.NAME <> SUBT.NAME
                      OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
              ));

Line: 77

    INSERT INTO OKC_PROCESS_DEF_PARMS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        NAME,
        DESCRIPTION,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.NAME,
            B.DESCRIPTION,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKC_PROCESS_DEF_PARMS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKC_PROCESS_DEF_PARMS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 122

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            NAME,
            DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Process_Def_Parms_Tl
     WHERE okc_process_def_parms_tl.id = p_id
       AND okc_process_def_parms_tl.language = p_language;

Line: 153

              l_okc_process_def_parms_tl_rec.LAST_UPDATED_BY,
              l_okc_process_def_parms_tl_rec.LAST_UPDATE_DATE,
              l_okc_process_def_parms_tl_rec.LAST_UPDATE_LOGIN;

Line: 176

    SELECT
            ID,
            PDF_ID,
            NAME,
            DATA_TYPE,
            REQUIRED_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            DEFAULT_VALUE,
            LAST_UPDATE_LOGIN,
            APPLICATION_ID,
            SEEDED_FLAG,
            JTOT_OBJECT_CODE,
            NAME_COLUMN,
            DESCRIPTION_COLUMN
      FROM Okc_Process_Def_Parms_B
     WHERE okc_process_def_parms_b.id = p_id;

Line: 211

              l_pdp_rec.LAST_UPDATED_BY,
              l_pdp_rec.LAST_UPDATE_DATE,
              l_pdp_rec.DEFAULT_VALUE,
              l_pdp_rec.LAST_UPDATE_LOGIN,
              l_pdp_rec.APPLICATION_ID,
              l_pdp_rec.SEEDED_FLAG,
              l_pdp_rec.JTOT_OBJECT_CODE,
              l_pdp_rec.NAME_COLUMN,
              l_pdp_rec.DESCRIPTION_COLUMN;

Line: 240

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            PDF_ID,
            NAME,
            USER_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,
            JTOT_OBJECT_CODE,
            NAME_COLUMN,
            DESCRIPTION_COLUMN
      FROM Okc_Process_Def_Parameters_V
     WHERE okc_process_def_parameters_v.id = p_id;

Line: 284

              l_pdpv_rec.LAST_UPDATED_BY,
              l_pdpv_rec.LAST_UPDATE_DATE,
              l_pdpv_rec.LAST_UPDATE_LOGIN,
              l_pdpv_rec.JTOT_OBJECT_CODE,
              l_pdpv_rec.NAME_COLUMN,
              l_pdpv_rec.DESCRIPTION_COLUMN;

Line: 350

    IF (l_pdpv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_pdpv_rec.last_updated_by := NULL;

Line: 353

    IF (l_pdpv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_pdpv_rec.last_update_date := NULL;

Line: 356

    IF (l_pdpv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_pdpv_rec.last_update_login := NULL;

Line: 440

      SELECT 'x'
       FROM Okc_Process_Defs_V
       WHERE okc_process_defs_v.id = p_id;

Line: 532

      SELECT '1'
      FROM Okc_Process_Defs_V
      WHERE okc_process_defs_v.id = p_pdpv_rec.pdf_id;

Line: 606

          SELECT pdf.USAGE , pdf.pdf_type from okc_process_defs_v pdf
          where pdf.id = p_pdpv_rec.pdf_id ;

Line: 962

    SELECT '1'
    FROM fnd_application
    WHERE application_id = p_application_id;

Line: 1154

    SELECT 'x'
      FROM okc_process_def_parameters_v
     WHERE name = p_pdpv_rec.name
       AND pdf_id = p_pdpv_rec.pdf_id
       AND id <> p_pdpv_rec.id;

Line: 1199

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1200

    p_to.last_update_date := p_from.last_update_date;

Line: 1201

    p_to.last_update_login := p_from.last_update_login;

Line: 1214

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1215

    p_to.last_update_date := p_from.last_update_date;

Line: 1216

    p_to.last_update_login := p_from.last_update_login;

Line: 1231

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1232

    p_to.last_update_date := p_from.last_update_date;

Line: 1234

    p_to.last_update_login := p_from.last_update_login;

Line: 1254

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1255

    p_to.last_update_date := p_from.last_update_date;

Line: 1257

    p_to.last_update_login := p_from.last_update_login;

Line: 1416

  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_okc_process_def_parms_tl_rec  IN OkcProcessDefParmsTlRecType,
    x_okc_process_def_parms_tl_rec  OUT NOCOPY OkcProcessDefParmsTlRecType) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1425

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line: 1430

      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 1469

      INSERT INTO OKC_PROCESS_DEF_PARMS_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          name,
          description,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okc_process_def_parms_tl_rec.id,
          l_okc_process_def_parms_tl_rec.language,
          l_okc_process_def_parms_tl_rec.source_lang,
          l_okc_process_def_parms_tl_rec.sfwt_flag,
          l_okc_process_def_parms_tl_rec.name,
          l_okc_process_def_parms_tl_rec.description,
          l_okc_process_def_parms_tl_rec.created_by,
          l_okc_process_def_parms_tl_rec.creation_date,
          l_okc_process_def_parms_tl_rec.last_updated_by,
          l_okc_process_def_parms_tl_rec.last_update_date,
          l_okc_process_def_parms_tl_rec.last_update_login);

Line: 1528

  END insert_row;

Line: 1532

  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_pdp_rec                      IN pdp_rec_type,
    x_pdp_rec                      OUT NOCOPY pdp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1541

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';

Line: 1577

    INSERT INTO OKC_PROCESS_DEF_PARMS_B(
        id,
        pdf_id,
        name,
        data_type,
        required_yn,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        default_value,
        last_update_login,
        application_id,
        seeded_flag,
        jtot_object_code,
        NAME_COLUMN,
        description_column)
      VALUES (
        l_pdp_rec.id,
        l_pdp_rec.pdf_id,
        l_pdp_rec.name,
        l_pdp_rec.data_type,
        l_pdp_rec.required_yn,
        l_pdp_rec.object_version_number,
        l_pdp_rec.created_by,
        l_pdp_rec.creation_date,
        l_pdp_rec.last_updated_by,
        l_pdp_rec.last_update_date,
        l_pdp_rec.default_value,
        l_pdp_rec.last_update_login,
        l_pdp_rec.application_id,
        l_pdp_rec.seeded_flag,
        l_pdp_rec.jtot_object_code,
        l_pdp_rec.NAME_COLUMN,
        l_pdp_rec.description_column);

Line: 1647

  END insert_row;

Line: 1651

  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_pdpv_rec                     IN pdpv_rec_type,
    x_pdpv_rec                     OUT NOCOPY pdpv_rec_type) IS

    l_id                           NUMBER;

Line: 1662

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

Line: 1680

      l_pdpv_rec.LAST_UPDATE_DATE := l_pdpv_rec.CREATION_DATE;

Line: 1681

      l_pdpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1682

      l_pdpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1717

	  SELECT OKC_PROCESS_DEF_PARMS_S1.nextval INTO l_id FROM dual;

Line: 1758

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_process_def_parms_tl_rec,
      LxOkcProcessDefParmsTlRec
    );

Line: 1772

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pdp_rec,
      lx_pdp_rec
    );

Line: 1820

  END insert_row;

Line: 1824

  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_pdpv_tbl                     IN pdpv_tbl_type,
    x_pdpv_tbl                     OUT NOCOPY pdpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1834

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

Line: 1843

        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_pdpv_rec                     => p_pdpv_tbl(i),
          x_pdpv_rec                     => x_pdpv_tbl(i));

Line: 1886

  END insert_row;

Line: 1904

    SELECT *
      FROM OKC_PROCESS_DEF_PARMS_TL
     WHERE ID = p_okc_process_def_parms_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 1940

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1989

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_PROCESS_DEF_PARMS_B
     WHERE ID = p_pdp_rec.id
       AND OBJECT_VERSION_NUMBER = p_pdp_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1996

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_PROCESS_DEF_PARMS_B
    WHERE ID = p_pdp_rec.id;

Line: 2037

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2046

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2247

  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_okc_process_def_parms_tl_rec  IN OkcProcessDefParmsTlRecType,
    x_okc_process_def_parms_tl_rec  OUT NOCOPY OkcProcessDefParmsTlRecType) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2256

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_update_row';

Line: 2310

      IF (x_okc_process_def_parms_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okc_process_def_parms_tl_rec.last_updated_by := l_okc_process_def_parms_tl_rec.last_updated_by;

Line: 2314

      IF (x_okc_process_def_parms_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okc_process_def_parms_tl_rec.last_update_date := l_okc_process_def_parms_tl_rec.last_update_date;

Line: 2318

      IF (x_okc_process_def_parms_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okc_process_def_parms_tl_rec.last_update_login := l_okc_process_def_parms_tl_rec.last_update_login;

Line: 2364

    UPDATE  OKC_PROCESS_DEF_PARMS_TL
    SET NAME = ldefokcprocessdefparmstlrec.name,
        DESCRIPTION = ldefokcprocessdefparmstlrec.description,
        CREATED_BY = ldefokcprocessdefparmstlrec.created_by,
        CREATION_DATE = ldefokcprocessdefparmstlrec.creation_date,
        LAST_UPDATED_BY = ldefokcprocessdefparmstlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefokcprocessdefparmstlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefokcprocessdefparmstlrec.last_update_login
    WHERE ID = ldefokcprocessdefparmstlrec.id
      AND USERENV('LANG') IN (SOURCE_LANG,LANGUAGE);

Line: 2376

    UPDATE  OKC_PROCESS_DEF_PARMS_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefokcprocessdefparmstlrec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 2414

  END update_row;

Line: 2418

  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_pdp_rec                      IN pdp_rec_type,
    x_pdp_rec                      OUT NOCOPY pdp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2427

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';

Line: 2481

      IF (x_pdp_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pdp_rec.last_updated_by := l_pdp_rec.last_updated_by;

Line: 2485

      IF (x_pdp_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pdp_rec.last_update_date := l_pdp_rec.last_update_date;

Line: 2493

      IF (x_pdp_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pdp_rec.last_update_login := l_pdp_rec.last_update_login;

Line: 2557

    UPDATE  OKC_PROCESS_DEF_PARMS_B
    SET PDF_ID = l_def_pdp_rec.pdf_id,
        NAME = l_def_pdp_rec.name,
        DATA_TYPE = l_def_pdp_rec.data_type,
        REQUIRED_YN = l_def_pdp_rec.required_yn,
        OBJECT_VERSION_NUMBER = l_def_pdp_rec.object_version_number,
        CREATED_BY = l_def_pdp_rec.created_by,
        CREATION_DATE = l_def_pdp_rec.creation_date,
        LAST_UPDATED_BY = l_def_pdp_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pdp_rec.last_update_date,
        DEFAULT_VALUE = l_def_pdp_rec.default_value,
        LAST_UPDATE_LOGIN = l_def_pdp_rec.last_update_login,
        APPLICATION_ID = l_def_pdp_rec.application_id,
        SEEDED_FLAG = l_def_pdp_rec.seeded_flag,
        JTOT_OBJECT_CODE = l_def_pdp_rec.jtot_object_code,
        NAME_COLUMN = l_def_pdp_rec.NAME_COLUMN,
        DESCRIPTION_COLUMN = l_def_pdp_rec.description_column
    WHERE ID = l_def_pdp_rec.id;

Line: 2609

  END update_row;

Line: 2613

  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_pdpv_rec                     IN pdpv_rec_type,
    x_pdpv_rec                     OUT NOCOPY pdpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2623

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

Line: 2639

      l_pdpv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2640

      l_pdpv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2641

      l_pdpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2717

      IF (x_pdpv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_pdpv_rec.last_updated_by := l_pdpv_rec.last_updated_by;

Line: 2721

      IF (x_pdpv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_pdpv_rec.last_update_date := l_pdpv_rec.last_update_date;

Line: 2725

      IF (x_pdpv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_pdpv_rec.last_update_login := l_pdpv_rec.last_update_login;

Line: 2773

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

Line: 2820

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pdp_rec,
      lx_pdp_rec
    );

Line: 2834

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_process_def_parms_tl_rec,
      LxOkcProcessDefParmsTlRec
    );

Line: 2881

  END update_row;

Line: 2885

  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_pdpv_tbl                     IN pdpv_tbl_type,
    x_pdpv_tbl                     OUT NOCOPY pdpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2895

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

Line: 2904

        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_pdpv_rec                     => p_pdpv_tbl(i),
          x_pdpv_rec                     => x_pdpv_tbl(i));

Line: 2947

  END update_row;

Line: 2955

  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_okc_process_def_parms_tl_rec  IN OkcProcessDefParmsTlRecType) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2963

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_row';

Line: 3000

    DELETE FROM OKC_PROCESS_DEF_PARMS_TL
     WHERE ID = l_okc_process_def_parms_tl_rec.id;

Line: 3035

  END delete_row;

Line: 3039

  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_pdp_rec                      IN pdp_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3047

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';

Line: 3061

    DELETE FROM OKC_PROCESS_DEF_PARMS_B
     WHERE ID = l_pdp_rec.id;

Line: 3096

  END delete_row;

Line: 3100

  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_pdpv_rec                     IN pdpv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3109

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

Line: 3130

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

Line: 3145

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_pdp_rec
    );

Line: 3157

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_process_def_parms_tl_rec
    );

Line: 3201

  END delete_row;

Line: 3205

  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_pdpv_tbl                     IN pdpv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3214

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

Line: 3223

        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_pdpv_rec                     => p_pdpv_tbl(i));

Line: 3265

  END delete_row;