APPS.OKC_RUL_PVT SQL Statements

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

Line: 39

SELECT descriptive_flex_context_code
      ,end_user_column_name
      ,flex_value_set_id
      ,required_flag
      ,application_column_name
      ,seq_no
      ,form_left_prompt
FROM   okc_ddf_contextcode_tmp
WHERE  descriptive_flex_context_code = p_context_code
ORDER BY seq_no;

Line: 51

SELECT descriptive_flex_context_code
      ,dummy_col
      ,seq_no
      ,form_left_prompt
FROM   okc_obj_ddf_ctxcode_tmp
WHERE descriptive_flex_context_code = p_context_code
ORDER BY seq_no;

Line: 114

      SELECT 'x'
        FROM OKC_RULE_GROUPS_B rgpv
       WHERE rgpv.ID = p_rulv_rec.RGP_ID;

Line: 340

      SELECT 'x'
        FROM OKC_K_HEADERS_B chrv
       WHERE chrv.ID = p_rulv_rec.DNZ_CHR_ID;

Line: 526

      SELECT 'x'
        FROM FND_DESCR_FLEX_CONTEXTS_VL dfc
--       WHERE dfc.application_id = 510 -- Application id for Contracts    -- /striping/
       WHERE dfc.application_id = appl_id -- Application id for Contracts
--	    AND dfc.descriptive_flexfield_name    = G_DESCRIPTIVE_FLEXFIELD_NAME   -- /striping/
	    AND dfc.descriptive_flexfield_name    = dff_name
         AND dfc.descriptive_flex_context_code = p_rulv_rec.rule_information_category;

Line: 535

      SELECT 'x'
        FROM OKC_RULE_GROUPS_B rgpv,
             OKC_RG_DEF_RULES  rgrv
       WHERE rgrv.RGD_CODE = rgpv.RGD_CODE
         AND rgpv.ID       = p_rulv_rec.rgp_id
         AND rgrv.RDF_CODE = p_rulv_rec.rule_information_category;

Line: 802

      SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,
             UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG,
             NUMBER_PRECISION
        FROM FND_FLEX_VALUE_SETS fvs
       WHERE fvs.FLEX_VALUE_SET_ID = l_flex_value_set_id;

Line: 810

      SELECT application_table_name, id_column_name, id_column_type,
             ADDITIONAL_WHERE_CLAUSE
        FROM FND_FLEX_VALIDATION_TABLES fvt
       WHERE fvt.flex_value_set_id = l_flex_value_set_id;

Line: 818

    SELECT /*+ first_rows */ 'x'
      FROM FND_FLEX_VALUES fvl
     WHERE fvl.flex_value_set_id = l_flex_value_set_id
       AND rownum < 2 ;

Line: 824

    SELECT /*+ first_rows */ 'x'
      FROM FND_FLEX_VALUES fvl
     WHERE fvl.flex_value_set_id = l_flex_value_set_id
       AND fvl.flex_value        = l_rule_information
       AND rownum < 2 ;

Line: 833

      SELECT END_USER_COLUMN_NAME, FLEX_VALUE_SET_ID, REQUIRED_FLAG
        FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu
        WHERE dfcu.descriptive_flexfield_name = 'OKC Rule Developer DF'
        AND dfcu.descriptive_flex_context_code = p_rule_cat
        AND dfcu.application_column_name       =  p_attribute
	AND dfcu.application_id =510;

Line: 1046

            sql_stmt := 'SELECT ''x'' ' ||
                        '  FROM ' || l_fvt_rec.application_table_name ||
                        ' WHERE ' || l_fvt_rec.id_column_name ||  ' = :col_val ' ||
                        ' AND rownum < 2 ' ||
                        l_where_clause;

Line: 1192

      sql_stmt := 'SELECT ''x'' ' ||
                  ' FROM FND_DESCR_FLEX_COLUMN_USAGES dfcu ' ||
--                  ' WHERE dfcu.descriptive_flexfield_name = ' ||   -- /striping/
                  ' WHERE dfcu.descriptive_flexfield_name = :dff_name ' ||
--                  ''''||G_DESCRIPTIVE_FLEXFIELD_NAME||'''' ||     -- /striping/
                  '   AND dfcu.descriptive_flex_context_code = :rule_cat ' ||
                  '   AND dfcu.end_user_column_name       =  :attribute' ||
--			'   AND dfcu.APPLICATION_ID=510';   -- /striping/

Line: 1274

      SELECT decode(where_clause,'','','and '||where_clause) where_clause,
             from_table
        FROM JTF_OBJECTS_B jtot
       WHERE jtot.object_code = jtot_object_code;

Line: 1404

        sql_stmt := 'SELECT ''x'' ' ||
                    '  FROM ' || l_from_table ||
                    ' WHERE ID1 = :col_val ' ||
                    '   AND ID2 = :col_val2 '||
                    '   AND rownum < 2 '|| l_where_clause;

Line: 1617

      SELECT decode(where_clause,'','','and '||where_clause) where_clause,
             from_table
        FROM JTF_OBJECTS_B jtot
       WHERE jtot.object_code = l_jtot_object_code;

Line: 1672

        sql_stmt := 'SELECT name ' ||
                    '  FROM ' || l_from_table ||
                    ' WHERE ID1 = :col_val ' ||
                    '   AND ID2 = :col_val2 ' || l_where_clause;

Line: 1714

      SELECT VALIDATION_TYPE, FORMAT_TYPE, MAXIMUM_SIZE,
             UPPERCASE_ONLY_FLAG, NUMERIC_MODE_ENABLED_FLAG,
             NUMBER_PRECISION
        FROM FND_FLEX_VALUE_SETS fvs
       WHERE fvs.FLEX_VALUE_SET_ID = l_flex_value_set_id;

Line: 1722

      SELECT application_table_name, id_column_name, id_column_type,
             ADDITIONAL_WHERE_CLAUSE, value_column_name
        FROM FND_FLEX_VALIDATION_TABLES fvt
       WHERE fvt.flex_value_set_id = l_flex_value_set_id;

Line: 1820

            sql_stmt := 'SELECT ' ||l_fvt_rec.value_column_name||
                        '  FROM ' || l_fvt_rec.application_table_name ||
                        ' WHERE ' || l_fvt_rec.id_column_name ||  ' = :col_val ' ||
                        l_where_clause;

Line: 1929

    DELETE FROM OKC_RULES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_RULES_B B
         WHERE B.ID = T.ID
        );

Line: 1938

    UPDATE OKC_RULES_TL T SET (
        COMMENTS,
        TEXT) = (SELECT
                                  B.COMMENTS,
                                  B.TEXT
                                FROM OKC_RULES_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_RULES_TL SUBB, OKC_RULES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.COMMENTS <> SUBT.COMMENTS
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
                      OR ((SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NOT NULL) AND
                          (DBMS_LOB.COMPARE(SUBB.TEXT,SUBT.TEXT) <> 0))
              ));

Line: 1963

    INSERT INTO OKC_RULES_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        COMMENTS,
        TEXT,
        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.COMMENTS,
            B.TEXT,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKC_RULES_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKC_RULES_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 1996

    DELETE FROM OKC_RULES_TLH T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_RULES_BH B
         WHERE B.ID = T.ID
         AND B.MAJOR_VERSION = T.MAJOR_VERSION
        );

Line: 2004

    UPDATE OKC_RULES_TLH T SET (
        COMMENTS,
        TEXT) = (SELECT
                                  B.COMMENTS,
                                  B.TEXT
                                FROM OKC_RULES_TLH B
                               WHERE B.ID = T.ID
                                 AND B.MAJOR_VERSION = T.MAJOR_VERSION
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.MAJOR_VERSION,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.MAJOR_VERSION,
                  SUBT.LANGUAGE
                FROM OKC_RULES_TLH SUBB, OKC_RULES_TLH SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.COMMENTS <> SUBT.COMMENTS
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
                      OR ((SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NOT NULL) AND
                          (DBMS_LOB.COMPARE(SUBB.TEXT,SUBT.TEXT) <> 0))
              ));

Line: 2032

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

Line: 2080

    SELECT
            ID,
            RGP_ID,
            OBJECT1_ID1,
            OBJECT2_ID1,
            OBJECT3_ID1,
            OBJECT1_ID2,
            OBJECT2_ID2,
            OBJECT3_ID2,
            JTOT_OBJECT1_CODE,
            JTOT_OBJECT2_CODE,
            JTOT_OBJECT3_CODE,
            DNZ_CHR_ID,
            STD_TEMPLATE_YN,
            WARN_YN,
            PRIORITY,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            RULE_INFORMATION_CATEGORY,
            RULE_INFORMATION1,
            RULE_INFORMATION2,
            RULE_INFORMATION3,
            RULE_INFORMATION4,
            RULE_INFORMATION5,
            RULE_INFORMATION6,
            RULE_INFORMATION7,
            RULE_INFORMATION8,
            RULE_INFORMATION9,
            RULE_INFORMATION10,
            RULE_INFORMATION11,
            RULE_INFORMATION12,
            RULE_INFORMATION13,
            RULE_INFORMATION14,
            RULE_INFORMATION15,
            TEMPLATE_YN,
            ans_set_jtot_object_code,
            ans_set_jtot_object_id1,
            ans_set_jtot_object_id2,
            DISPLAY_SEQUENCE,
--Bug 3055393
            comments
      FROM Okc_Rules_B
     WHERE okc_rules_b.id       = p_id;

Line: 2172

              l_rul_rec.LAST_UPDATED_BY,
              l_rul_rec.LAST_UPDATE_DATE,
              l_rul_rec.LAST_UPDATE_LOGIN,
              l_rul_rec.ATTRIBUTE_CATEGORY,
              l_rul_rec.ATTRIBUTE1,
              l_rul_rec.ATTRIBUTE2,
              l_rul_rec.ATTRIBUTE3,
              l_rul_rec.ATTRIBUTE4,
              l_rul_rec.ATTRIBUTE5,
              l_rul_rec.ATTRIBUTE6,
              l_rul_rec.ATTRIBUTE7,
              l_rul_rec.ATTRIBUTE8,
              l_rul_rec.ATTRIBUTE9,
              l_rul_rec.ATTRIBUTE10,
              l_rul_rec.ATTRIBUTE11,
              l_rul_rec.ATTRIBUTE12,
              l_rul_rec.ATTRIBUTE13,
              l_rul_rec.ATTRIBUTE14,
              l_rul_rec.ATTRIBUTE15,
              l_rul_rec.RULE_INFORMATION_CATEGORY,
              l_rul_rec.RULE_INFORMATION1,
              l_rul_rec.RULE_INFORMATION2,
              l_rul_rec.RULE_INFORMATION3,
              l_rul_rec.RULE_INFORMATION4,
              l_rul_rec.RULE_INFORMATION5,
              l_rul_rec.RULE_INFORMATION6,
              l_rul_rec.RULE_INFORMATION7,
              l_rul_rec.RULE_INFORMATION8,
              l_rul_rec.RULE_INFORMATION9,
              l_rul_rec.RULE_INFORMATION10,
              l_rul_rec.RULE_INFORMATION11,
              l_rul_rec.RULE_INFORMATION12,
              l_rul_rec.RULE_INFORMATION13,
              l_rul_rec.RULE_INFORMATION14,
              l_rul_rec.RULE_INFORMATION15,
              l_rul_rec.TEMPLATE_YN,
              l_rul_rec.ans_set_jtot_object_code,
              l_rul_rec.ans_set_jtot_object_id1,
              l_rul_rec.ans_set_jtot_object_id2,
              l_rul_rec.DISPLAY_SEQUENCE,
--Bug 3055393
              l_rul_rec.comments ;

Line: 2239

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            COMMENTS,
            TEXT,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Rules_Tl
     WHERE okc_rules_tl.id      = p_id
       AND okc_rules_tl.language = p_language;

Line: 2273

              l_okc_rules_tl_rec.LAST_UPDATED_BY,
              l_okc_rules_tl_rec.LAST_UPDATE_DATE,
              l_okc_rules_tl_rec.LAST_UPDATE_LOGIN;

Line: 2301

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
--Bug 3055393            SFWT_FLAG,
            OBJECT1_ID1,
            OBJECT2_ID1,
            OBJECT3_ID1,
            OBJECT1_ID2,
            OBJECT2_ID2,
            OBJECT3_ID2,
            JTOT_OBJECT1_CODE,
            JTOT_OBJECT2_CODE,
            JTOT_OBJECT3_CODE,
            DNZ_CHR_ID,
            RGP_ID,
            PRIORITY,
            STD_TEMPLATE_YN,
            COMMENTS,
            WARN_YN,
            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,
--Bug 3055393            TEXT,
            RULE_INFORMATION_CATEGORY,
            RULE_INFORMATION1,
            RULE_INFORMATION2,
            RULE_INFORMATION3,
            RULE_INFORMATION4,
            RULE_INFORMATION5,
            RULE_INFORMATION6,
            RULE_INFORMATION7,
            RULE_INFORMATION8,
            RULE_INFORMATION9,
            RULE_INFORMATION10,
            RULE_INFORMATION11,
            RULE_INFORMATION12,
            RULE_INFORMATION13,
            RULE_INFORMATION14,
            RULE_INFORMATION15,
            TEMPLATE_YN,
            ans_set_jtot_object_code,
            ans_set_jtot_object_id1,
            ans_set_jtot_object_id2,
            DISPLAY_SEQUENCE
      FROM Okc_Rules_V
     WHERE okc_rules_v.id       = p_id;

Line: 2411

              l_rulv_rec.LAST_UPDATED_BY,
              l_rulv_rec.LAST_UPDATE_DATE,
              l_rulv_rec.LAST_UPDATE_LOGIN,
--Bug 3055393              l_rulv_rec.TEXT,
              l_rulv_rec.RULE_INFORMATION_CATEGORY,
              l_rulv_rec.RULE_INFORMATION1,
              l_rulv_rec.RULE_INFORMATION2,
              l_rulv_rec.RULE_INFORMATION3,
              l_rulv_rec.RULE_INFORMATION4,
              l_rulv_rec.RULE_INFORMATION5,
              l_rulv_rec.RULE_INFORMATION6,
              l_rulv_rec.RULE_INFORMATION7,
              l_rulv_rec.RULE_INFORMATION8,
              l_rulv_rec.RULE_INFORMATION9,
              l_rulv_rec.RULE_INFORMATION10,
              l_rulv_rec.RULE_INFORMATION11,
              l_rulv_rec.RULE_INFORMATION12,
              l_rulv_rec.RULE_INFORMATION13,
              l_rulv_rec.RULE_INFORMATION14,
              l_rulv_rec.RULE_INFORMATION15,
              l_rulv_rec.TEMPLATE_YN,
              l_rulv_rec.ans_set_jtot_object_code,
              l_rulv_rec.ans_set_jtot_object_id1,
              l_rulv_rec.ans_set_jtot_object_id2,
              l_rulv_rec.DISPLAY_SEQUENCE ;

Line: 2570

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

Line: 2573

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

Line: 2576

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

Line: 2751

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2752

    p_to.last_update_date := p_from.last_update_date;

Line: 2753

    p_to.last_update_login := p_from.last_update_login;

Line: 2828

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2829

    p_to.last_update_date := p_from.last_update_date;

Line: 2830

    p_to.last_update_login := p_from.last_update_login;

Line: 2892

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2893

    p_to.last_update_date := p_from.last_update_date;

Line: 2894

    p_to.last_update_login := p_from.last_update_login;

Line: 2920

    p_to.last_updated_by := p_from.last_updated_by;

Line: 2921

    p_to.last_update_date := p_from.last_update_date;

Line: 2922

    p_to.last_update_login := p_from.last_update_login;

Line: 3118

  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_rul_rec                      IN rul_rec_type,
    x_rul_rec                      OUT NOCOPY rul_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3127

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

Line: 3132

   l_proc varchar2(72) := g_package||'insert_row';

Line: 3170

    INSERT INTO OKC_RULES_B(
        id,
        rgp_id,
        object1_id1,
        object2_id1,
        object3_id1,
        object1_id2,
        object2_id2,
        object3_id2,
        jtot_object1_code,
        jtot_object2_code,
        jtot_object3_code,
        dnz_chr_id,
        std_template_yn,
        warn_yn,
        priority,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        rule_information_category,
        rule_information1,
        rule_information2,
        rule_information3,
        rule_information4,
        rule_information5,
        rule_information6,
        rule_information7,
        rule_information8,
        rule_information9,
        rule_information10,
        rule_information11,
        rule_information12,
        rule_information13,
        rule_information14,
        rule_information15,
        template_yn,
        ans_set_jtot_object_code,
        ans_set_jtot_object_id1,
        ans_set_jtot_object_id2,
        display_sequence,
--Bug 3055393
        comments)
      VALUES (
        l_rul_rec.id,
        l_rul_rec.rgp_id,
        l_rul_rec.object1_id1,
        l_rul_rec.object2_id1,
        l_rul_rec.object3_id1,
        l_rul_rec.object1_id2,
        l_rul_rec.object2_id2,
        l_rul_rec.object3_id2,
        l_rul_rec.jtot_object1_code,
        l_rul_rec.jtot_object2_code,
        l_rul_rec.jtot_object3_code,
        l_rul_rec.dnz_chr_id,
        l_rul_rec.std_template_yn,
        l_rul_rec.warn_yn,
        l_rul_rec.priority,
        l_rul_rec.object_version_number,
        l_rul_rec.created_by,
        l_rul_rec.creation_date,
        l_rul_rec.last_updated_by,
        l_rul_rec.last_update_date,
        l_rul_rec.last_update_login,
        l_rul_rec.attribute_category,
        l_rul_rec.attribute1,
        l_rul_rec.attribute2,
        l_rul_rec.attribute3,
        l_rul_rec.attribute4,
        l_rul_rec.attribute5,
        l_rul_rec.attribute6,
        l_rul_rec.attribute7,
        l_rul_rec.attribute8,
        l_rul_rec.attribute9,
        l_rul_rec.attribute10,
        l_rul_rec.attribute11,
        l_rul_rec.attribute12,
        l_rul_rec.attribute13,
        l_rul_rec.attribute14,
        l_rul_rec.attribute15,
        l_rul_rec.rule_information_category,
        l_rul_rec.rule_information1,
        l_rul_rec.rule_information2,
        l_rul_rec.rule_information3,
        l_rul_rec.rule_information4,
        l_rul_rec.rule_information5,
        l_rul_rec.rule_information6,
        l_rul_rec.rule_information7,
        l_rul_rec.rule_information8,
        l_rul_rec.rule_information9,
        l_rul_rec.rule_information10,
        l_rul_rec.rule_information11,
        l_rul_rec.rule_information12,
        l_rul_rec.rule_information13,
        l_rul_rec.rule_information14,
        l_rul_rec.rule_information15,
        l_rul_rec.template_yn,
        l_rul_rec.ans_set_jtot_object_code,
        l_rul_rec.ans_set_jtot_object_id1,
        l_rul_rec.ans_set_jtot_object_id2,
        l_rul_rec.display_sequence,
--Bug 3055393
        l_rul_rec.comments);

Line: 3336

  END insert_row;

Line: 3341

  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_rules_tl_rec             IN okc_rules_tl_rec_type,
    x_okc_rules_tl_rec             OUT NOCOPY okc_rules_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3350

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

Line: 3355

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

Line: 3359

   l_proc varchar2(72) := g_package||'insert_row';

Line: 3401

      INSERT INTO OKC_RULES_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          comments,
          text,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okc_rules_tl_rec.id,
          l_okc_rules_tl_rec.language,
          l_okc_rules_tl_rec.source_lang,
          l_okc_rules_tl_rec.sfwt_flag,
          l_okc_rules_tl_rec.comments,
          l_okc_rules_tl_rec.text,
          l_okc_rules_tl_rec.created_by,
          l_okc_rules_tl_rec.creation_date,
          l_okc_rules_tl_rec.last_updated_by,
          l_okc_rules_tl_rec.last_update_date,
          l_okc_rules_tl_rec.last_update_login);

Line: 3470

  END insert_row;

Line: 3475

  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_rulv_rec                     IN rulv_rec_type,
    x_rulv_rec                     OUT NOCOPY rulv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3485

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

Line: 3494

   l_proc varchar2(72) := g_package||'insert_row';

Line: 3506

      l_rulv_rec.LAST_UPDATE_DATE := l_rulv_rec.creation_date;

Line: 3507

      l_rulv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3508

      l_rulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3589

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rul_rec,
      lx_rul_rec
    );

Line: 3604

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rules_tl_rec,
      lx_okc_rules_tl_rec
    );

Line: 3663

  END insert_row;

Line: 3667

  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_rulv_tbl                     IN rulv_tbl_type,
    x_rulv_tbl                     OUT NOCOPY rulv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3677

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

Line: 3681

   l_proc varchar2(72) := g_package||'insert_row';

Line: 3693

        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_rulv_rec                     => p_rulv_tbl(i),
          x_rulv_rec                     => x_rulv_tbl(i));

Line: 3746

  END insert_row;

Line: 3764

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RULES_B
     WHERE ID = p_rul_rec.id
       AND OBJECT_VERSION_NUMBER = p_rul_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 3771

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RULES_B
    WHERE ID = p_rul_rec.id;

Line: 3782

   l_proc varchar2(72) := g_package||'insert_row';

Line: 3819

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3828

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3888

    SELECT *
      FROM OKC_RULES_TL
     WHERE ID = p_okc_rules_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 3900

   l_proc varchar2(72) := g_package||'insert_row';

Line: 3931

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 3995

   l_proc varchar2(72) := g_package||'insert_row';

Line: 4107

   l_proc varchar2(72) := g_package||'insert_row';

Line: 4179

  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_rul_rec                      IN rul_rec_type,
    x_rul_rec                      OUT NOCOPY rul_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4188

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

Line: 4194

   l_proc varchar2(72) := g_package||'update_row';

Line: 4292

      IF (x_rul_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rul_rec.last_updated_by := l_rul_rec.last_updated_by;

Line: 4296

      IF (x_rul_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rul_rec.last_update_date := l_rul_rec.last_update_date;

Line: 4300

      IF (x_rul_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rul_rec.last_update_login := l_rul_rec.last_update_login;

Line: 4506

    UPDATE  OKC_RULES_B
    SET RGP_ID = l_def_rul_rec.rgp_id,
        OBJECT1_ID1 = l_def_rul_rec.object1_id1,
        OBJECT2_ID1 = l_def_rul_rec.object2_id1,
        OBJECT3_ID1 = l_def_rul_rec.object3_id1,
        OBJECT1_ID2 = l_def_rul_rec.object1_id2,
        OBJECT2_ID2 = l_def_rul_rec.object2_id2,
        OBJECT3_ID2 = l_def_rul_rec.object3_id2,
        JTOT_OBJECT1_CODE = l_def_rul_rec.jtot_object1_code,
        JTOT_OBJECT2_CODE = l_def_rul_rec.jtot_object2_code,
        JTOT_OBJECT3_CODE = l_def_rul_rec.jtot_object3_code,
        DNZ_CHR_ID = l_def_rul_rec.dnz_chr_id,
        STD_TEMPLATE_YN = l_def_rul_rec.std_template_yn,
        WARN_YN = l_def_rul_rec.warn_yn,
        PRIORITY = l_def_rul_rec.priority,
        OBJECT_VERSION_NUMBER = l_def_rul_rec.object_version_number,
        CREATED_BY = l_def_rul_rec.created_by,
        CREATION_DATE = l_def_rul_rec.creation_date,
        LAST_UPDATED_BY = l_def_rul_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rul_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_rul_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_rul_rec.attribute_category,
        ATTRIBUTE1 = l_def_rul_rec.attribute1,
        ATTRIBUTE2 = l_def_rul_rec.attribute2,
        ATTRIBUTE3 = l_def_rul_rec.attribute3,
        ATTRIBUTE4 = l_def_rul_rec.attribute4,
        ATTRIBUTE5 = l_def_rul_rec.attribute5,
        ATTRIBUTE6 = l_def_rul_rec.attribute6,
        ATTRIBUTE7 = l_def_rul_rec.attribute7,
        ATTRIBUTE8 = l_def_rul_rec.attribute8,
        ATTRIBUTE9 = l_def_rul_rec.attribute9,
        ATTRIBUTE10 = l_def_rul_rec.attribute10,
        ATTRIBUTE11 = l_def_rul_rec.attribute11,
        ATTRIBUTE12 = l_def_rul_rec.attribute12,
        ATTRIBUTE13 = l_def_rul_rec.attribute13,
        ATTRIBUTE14 = l_def_rul_rec.attribute14,
        ATTRIBUTE15 = l_def_rul_rec.attribute15,
        RULE_INFORMATION_CATEGORY = l_def_rul_rec.rule_information_category,
        RULE_INFORMATION1 = l_def_rul_rec.rule_information1,
        RULE_INFORMATION2 = l_def_rul_rec.rule_information2,
        RULE_INFORMATION3 = l_def_rul_rec.rule_information3,
        RULE_INFORMATION4 = l_def_rul_rec.rule_information4,
        RULE_INFORMATION5 = l_def_rul_rec.rule_information5,
        RULE_INFORMATION6 = l_def_rul_rec.rule_information6,
        RULE_INFORMATION7 = l_def_rul_rec.rule_information7,
        RULE_INFORMATION8 = l_def_rul_rec.rule_information8,
        RULE_INFORMATION9 = l_def_rul_rec.rule_information9,
        RULE_INFORMATION10 = l_def_rul_rec.rule_information10,
        RULE_INFORMATION11 = l_def_rul_rec.rule_information11,
        RULE_INFORMATION12 = l_def_rul_rec.rule_information12,
        RULE_INFORMATION13 = l_def_rul_rec.rule_information13,
        RULE_INFORMATION14 = l_def_rul_rec.rule_information14,
        RULE_INFORMATION15 = l_def_rul_rec.rule_information15,
        TEMPLATE_YN = l_def_rul_rec.template_yn,
        ans_set_jtot_object_code = l_def_rul_rec.ans_set_jtot_object_code,
        ans_set_jtot_object_id1 = l_def_rul_rec.ans_set_jtot_object_id1,
        ans_set_jtot_object_id2 = l_def_rul_rec.ans_set_jtot_object_id2,
        DISPLAY_SEQUENCE = l_def_rul_rec.display_sequence,
--Bug 3055393
        comments = l_def_rul_rec.comments
    WHERE ID = l_def_rul_rec.id;

Line: 4611

  END update_row;

Line: 4616

  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_rules_tl_rec             IN okc_rules_tl_rec_type,
    x_okc_rules_tl_rec             OUT NOCOPY okc_rules_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4625

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

Line: 4631

   l_proc varchar2(72) := g_package||'update_row';

Line: 4682

      IF (x_okc_rules_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okc_rules_tl_rec.last_updated_by := l_okc_rules_tl_rec.last_updated_by;

Line: 4686

      IF (x_okc_rules_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okc_rules_tl_rec.last_update_date := l_okc_rules_tl_rec.last_update_date;

Line: 4690

      IF (x_okc_rules_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okc_rules_tl_rec.last_update_login := l_okc_rules_tl_rec.last_update_login;

Line: 4740

    UPDATE  OKC_RULES_TL
    SET COMMENTS = l_def_okc_rules_tl_rec.comments,
        TEXT = l_def_okc_rules_tl_rec.text,
        CREATED_BY = l_def_okc_rules_tl_rec.created_by,
        CREATION_DATE = l_def_okc_rules_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_rules_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_rules_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_rules_tl_rec.last_update_login
    WHERE ID = l_def_okc_rules_tl_rec.id
      AND SOURCE_LANG = USERENV('LANG');

Line: 4751

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

Line: 4799

  END update_row;

Line: 4804

  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_rulv_rec                     IN rulv_rec_type,
    x_rulv_rec                     OUT NOCOPY rulv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4814

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

Line: 4823

   l_proc varchar2(72) := g_package||'update_row';

Line: 4833

      l_rulv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 4834

      l_rulv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4835

      l_rulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 5001

      IF (x_rulv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rulv_rec.last_updated_by := l_rulv_rec.last_updated_by;

Line: 5005

      IF (x_rulv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rulv_rec.last_update_date := l_rulv_rec.last_update_date;

Line: 5009

      IF (x_rulv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rulv_rec.last_update_login := l_rulv_rec.last_update_login;

Line: 5184

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_rules_tl_rec,
      lx_okc_rules_tl_rec
    );

Line: 5199

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rul_rec,
      lx_rul_rec
    );

Line: 5256

  END update_row;

Line: 5260

  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_rulv_tbl                     IN rulv_tbl_type,
    x_rulv_tbl                     OUT NOCOPY rulv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5270

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

Line: 5274

   l_proc varchar2(72) := g_package||'update_row';

Line: 5286

        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_rulv_rec                     => p_rulv_tbl(i),
          x_rulv_rec                     => x_rulv_tbl(i));

Line: 5339

  END update_row;

Line: 5347

  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_rul_rec                      IN rul_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5355

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

Line: 5360

   l_proc varchar2(72) := g_package||'delete_row';

Line: 5376

    DELETE FROM OKC_RULES_B
     WHERE ID = l_rul_rec.id;

Line: 5421

  END delete_row;

Line: 5426

  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_rules_tl_rec             IN okc_rules_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5434

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

Line: 5439

   l_proc varchar2(72) := g_package||'delete_row';

Line: 5478

    DELETE FROM OKC_RULES_TL
     WHERE ID = l_okc_rules_tl_rec.id;

Line: 5523

  END delete_row;

Line: 5528

  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_rulv_rec                     IN rulv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5537

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

Line: 5543

   l_proc varchar2(72) := g_package||'delete_row';

Line: 5571

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

Line: 5584

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

Line: 5638

  END delete_row;

Line: 5642

  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_rulv_tbl                     IN rulv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 5651

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

Line: 5655

   l_proc varchar2(72) := g_package||'delete_row';

Line: 5667

        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_rulv_rec                     => p_rulv_tbl(i));

Line: 5719

  END delete_row;

Line: 5724

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_rulv_tbl rulv_tbl_type) IS
  l_tabsize NUMBER := p_rulv_tbl.COUNT;

Line: 5764

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 5765

  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 5766

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 5792

   l_proc varchar2(72) := g_package||'INSERT_ROW_UPG';

Line: 5838

    in_last_updated_by          (j) := p_rulv_tbl(i).last_updated_by;

Line: 5839

    in_last_update_date         (j) := p_rulv_tbl(i).last_update_date;

Line: 5840

    in_last_update_login        (j) := p_rulv_tbl(i).last_update_login;

Line: 5867

    INSERT
      INTO OKC_RULES_B
      (
        id,
        rgp_id,
        object1_id1,
        object2_id1,
        object3_id1,
        object1_id2,
        object2_id2,
        object3_id2,
        jtot_object1_code,
        jtot_object2_code,
        jtot_object3_code,
        dnz_chr_id,
        std_template_yn,
        warn_yn,
        priority,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        rule_information_category,
        rule_information1,
        rule_information2,
        rule_information3,
        rule_information4,
        rule_information5,
        rule_information6,
        rule_information7,
        rule_information8,
        rule_information9,
        rule_information10,
        rule_information11,
        rule_information12,
        rule_information13,
        rule_information14,
        rule_information15,
        template_yn,
        ans_set_jtot_object_code,
        ans_set_jtot_object_id1,
        ans_set_jtot_object_id2,
        display_sequence,
--Bug 3055393
        comments
     )
     VALUES (
        in_id(i),
        in_rgp_id(i),
        in_object1_id1(i),
        in_object2_id1(i),
        in_object3_id1(i),
        in_object1_id2(i),
        in_object2_id2(i),
        in_object3_id2(i),
        in_jtot_object1_code(i),
        in_jtot_object2_code(i),
        in_jtot_object3_code(i),
        in_dnz_chr_id(i),
        in_std_template_yn(i),
        in_warn_yn(i),
        in_priority(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_last_update_login(i),
        in_attribute_category(i),
        in_attribute1(i),
        in_attribute2(i),
        in_attribute3(i),
        in_attribute4(i),
        in_attribute5(i),
        in_attribute6(i),
        in_attribute7(i),
        in_attribute8(i),
        in_attribute9(i),
        in_attribute10(i),
        in_attribute11(i),
        in_attribute12(i),
        in_attribute13(i),
        in_attribute14(i),
        in_attribute15(i),
        in_rule_information_category(i),
        in_rule_information1(i),
        in_rule_information2(i),
        in_rule_information3(i),
        in_rule_information4(i),
        in_rule_information5(i),
        in_rule_information6(i),
        in_rule_information7(i),
        in_rule_information8(i),
        in_rule_information9(i),
        in_rule_information10(i),
        in_rule_information11(i),
        in_rule_information12(i),
        in_rule_information13(i),
        in_rule_information14(i),
        in_rule_information15(i),
        in_template_yn(i),
        in_ans_set_jtot_object_code(i),
        in_ans_set_jtot_object_id1(i),
        in_ans_set_jtot_object_id2(i),
        in_display_sequence(i),
--Bug 3055393
        in_comments(i)
     );

Line: 5996

      INSERT INTO OKC_RULES_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        comments,
        --text,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        in_id(i),
        OKC_UTIL.g_language_code(lang_i),
        l_source_lang,
        in_sfwt_flag(i),
        in_comments(i),
        --in_text(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_last_update_login(i)
      );

Line: 6038

END INSERT_ROW_UPG;

Line: 6059

INSERT INTO okc_rules_bh
  (
      major_version,
      id,
      rgp_id,
      object1_id1,
      object2_id1,
      object3_id1,
      object1_id2,
      object2_id2,
      object3_id2,
      jtot_object1_code,
      jtot_object2_code,
      jtot_object3_code,
      dnz_chr_id,
      std_template_yn,
      warn_yn,
      priority,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      rule_information_category,
      rule_information1,
      rule_information2,
      rule_information3,
      rule_information4,
      rule_information5,
      rule_information6,
      rule_information7,
      rule_information8,
      rule_information9,
      rule_information10,
      rule_information11,
      rule_information12,
      rule_information13,
      rule_information14,
      rule_information15,
      template_yn,
      ans_set_jtot_object_code,
      ans_set_jtot_object_id1,
      ans_set_jtot_object_id2,
      display_sequence,
--Bug 3055393
      comments
)
  SELECT
      p_major_version,
      id,
      rgp_id,
      object1_id1,
      object2_id1,
      object3_id1,
      object1_id2,
      object2_id2,
      object3_id2,
      jtot_object1_code,
      jtot_object2_code,
      jtot_object3_code,
      dnz_chr_id,
      std_template_yn,
      warn_yn,
      priority,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      rule_information_category,
      rule_information1,
      rule_information2,
      rule_information3,
      rule_information4,
      rule_information5,
      rule_information6,
      rule_information7,
      rule_information8,
      rule_information9,
      rule_information10,
      rule_information11,
      rule_information12,
      rule_information13,
      rule_information14,
      rule_information15,
      template_yn,
      ans_set_jtot_object_code,
      ans_set_jtot_object_id1,
      ans_set_jtot_object_id2,
      display_sequence,
--Bug 3055393
      comments
  FROM okc_rules_b
 WHERE dnz_chr_id = p_chr_id;

Line: 6192

INSERT INTO okc_rules_tlh
  (
      major_version,
      id,
      language,
      source_lang,
      sfwt_flag,
      comments,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      id,
      language,
      source_lang,
      sfwt_flag,
      comments,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_rules_tl
 WHERE id  in (select id
			  from okc_rules_b
			 where dnz_chr_id = p_chr_id);

Line: 6265

INSERT INTO okc_rules_tl
  (
      id,
      language,
      source_lang,
      sfwt_flag,
      comments,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      id,
      language,
      source_lang,
      sfwt_flag,
      comments,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_rules_tlh
WHERE id in (SELECT id
			FROM okc_rules_bh
		    WHERE dnz_chr_id = p_chr_id)
  AND major_version = p_major_version;

Line: 6301

INSERT INTO okc_rules_b
(
      id,
      rgp_id,
      object1_id1,
      object2_id1,
      object3_id1,
      object1_id2,
      object2_id2,
      object3_id2,
      jtot_object1_code,
      jtot_object2_code,
      jtot_object3_code,
      dnz_chr_id,
      std_template_yn,
      warn_yn,
      priority,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      rule_information_category,
      rule_information1,
      rule_information2,
      rule_information3,
      rule_information4,
      rule_information5,
      rule_information6,
      rule_information7,
      rule_information8,
      rule_information9,
      rule_information10,
      rule_information11,
      rule_information12,
      rule_information13,
      rule_information14,
      rule_information15,
      template_yn,
      ans_set_jtot_object_code,
      ans_set_jtot_object_id1,
      ans_set_jtot_object_id2,
      display_sequence,
      comments
)
  SELECT
      id,
      rgp_id,
      object1_id1,
      object2_id1,
      object3_id1,
      object1_id2,
      object2_id2,
      object3_id2,
      jtot_object1_code,
      jtot_object2_code,
      jtot_object3_code,
      dnz_chr_id,
      std_template_yn,
      warn_yn,
      priority,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      rule_information_category,
      rule_information1,
      rule_information2,
      rule_information3,
      rule_information4,
      rule_information5,
      rule_information6,
      rule_information7,
      rule_information8,
      rule_information9,
      rule_information10,
      rule_information11,
      rule_information12,
      rule_information13,
      rule_information14,
      rule_information15,
      template_yn,
      ans_set_jtot_object_code,
      ans_set_jtot_object_id1,
      ans_set_jtot_object_id2,
      display_sequence,
--Bug 3055393
      comments
  FROM okc_rules_bh
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;

Line: 6460

SELECT 'Y'
FROM   okc_ddf_contextcode_tmp
WHERE  descriptive_flex_context_code = p_context_code;

Line: 6483

   INSERT INTO okc_ddf_contextcode_tmp
   (descriptive_flex_context_code, end_user_column_name, flex_value_set_id,
   required_flag, application_column_name, seq_no, form_left_prompt)
   SELECT
      descriptive_flex_context_code,
      end_user_column_name,
      flex_value_set_id,
      required_flag,
      application_column_name,
      SUBSTR(application_column_name,17,2) seq_no,
      form_left_prompt
   FROM fnd_descr_flex_col_usage_vl dfcu
--   WHERE dfcu.descriptive_flexfield_name = l_desc_ff_name    -- /striping/
   WHERE dfcu.descriptive_flexfield_name = p_dff_name
      AND application_column_name like l_app_col_name
--      AND dfcu.application_id =510                           -- /striping/
      AND dfcu.application_id = p_appl_id
      AND dfcu.descriptive_flex_context_code IN
        (
           SELECT /*+ NO_UNNEST */ rdf_code
             FROM OKC_K_HEADERS_B K ,
                  okc_subclass_rg_defs  B,
			   okc_rg_def_rules  A
            WHERE A.rgd_code = B.rgd_code
              AND B.scs_code = K.scs_code
              AND k.id = p_rulv_rec.dnz_chr_id
        )
      AND NOT EXISTS
	      (SELECT 1 FROM okc_ddf_contextcode_tmp
		   WHERE descriptive_flex_context_code =
				   dfcu.descriptive_flex_context_code
          AND  application_column_name       =
               dfcu.application_column_name);

Line: 6539

SELECT 'Y'
FROM   okc_obj_ddf_ctxcode_tmp
WHERE  descriptive_flex_context_code = p_context_code;

Line: 6568

   INSERT INTO okc_obj_ddf_ctxcode_tmp
      (descriptive_flex_context_code, dummy_col, seq_no, form_left_prompt)
   SELECT
      descriptive_flex_context_code ,
      'x',
      SUBSTR(application_column_name,12,1) seq_no ,
      form_left_prompt
   FROM fnd_descr_flex_col_usage_vl dfcu
--   WHERE dfcu.descriptive_flexfield_name = l_desc_ff_name    -- /striping/
   WHERE dfcu.descriptive_flexfield_name = p_dff_name
     AND application_column_name like l_app_col_name
--     AND dfcu.application_id =510                            -- /striping/
     AND dfcu.application_id = p_appl_id
     AND dfcu.descriptive_flex_context_code IN
       (
           SELECT /*+ NO_UNNEST */ rdf_code
             FROM OKC_K_HEADERS_B K ,
                  okc_subclass_rg_defs  B,
			   okc_rg_def_rules  A
            WHERE A.rgd_code = B.rgd_code
              AND B.scs_code = K.scs_code
              AND k.id = p_rulv_rec.dnz_chr_id
        )
      AND NOT EXISTS
	      (SELECT 1 FROM okc_obj_ddf_ctxcode_tmp
		   WHERE descriptive_flex_context_code =
				   dfcu.descriptive_flex_context_code
           AND seq_no = SUBSTR(application_column_name,12,1));