eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_RGR_PVT SQL Statements

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

Line: 8


  g_insert_mode boolean := FALSE;

Line: 40


    SELECT 'x'
    FROM   okc_rg_def_rules
    WHERE  rgd_code  = p_rgrv_rec.RGD_CODE
    AND    rdf_code  = p_rgrv_rec.RDF_CODE;

Line: 126


      SELECT 'x'
        FROM FND_LOOKUP_VALUES rgdv
       WHERE rgdv.LOOKUP_CODE = p_rgrv_rec.rgd_code
         AND rgdv.lookup_type = 'OKC_RULE_GROUP_DEF';

Line: 229


      SELECT 'x'
        FROM FND_LOOKUP_VALUES rdfv
       WHERE rdfv.LOOKUP_CODE = p_rgrv_rec.rdf_code
         AND rdfv.lookup_type = 'OKC_RULE_DEF';

Line: 236


      SELECT 'x'
        FROM okc_rule_defs_b rdfv
       WHERE rdfv.RULE_CODE = p_rgrv_rec.rdf_code;

Line: 614


      SELECT 'x'
        FROM FND_LOOKUP_VALUES rgdv
       WHERE rgdv.LOOKUP_CODE = p_rgrv_rec.access_level
         AND rgdv.lookup_type = 'OKC_SEED_ACCESS_LEVEL_SU';

Line: 784


    IF g_insert_mode THEN
      validate_uniqueness(
        x_return_status => l_return_status,
        p_rgrv_rec      => p_rgrv_rec);

Line: 881


    SELECT
            RGD_CODE,
            RDF_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            OPTIONAL_YN,
            LAST_UPDATE_LOGIN,
            MIN_CARDINALITY,
            MAX_CARDINALITY,
            PRICING_RELATED_YN,
            ACCESS_LEVEL
      FROM Okc_Rg_Def_Rules
     WHERE okc_rg_def_rules.rgd_code = p_rgd_code
       AND okc_rg_def_rules.rdf_code = p_rdf_code;

Line: 917


              l_rgr_rec.LAST_UPDATED_BY,
              l_rgr_rec.LAST_UPDATE_DATE,
              l_rgr_rec.OPTIONAL_YN,
              l_rgr_rec.LAST_UPDATE_LOGIN,
              l_rgr_rec.MIN_CARDINALITY,
              l_rgr_rec.MAX_CARDINALITY,
              l_rgr_rec.PRICING_RELATED_YN,
              l_rgr_rec.ACCESS_LEVEL;

Line: 955


    SELECT
            RGD_CODE,
            RDF_CODE,
            OBJECT_VERSION_NUMBER,
            OPTIONAL_YN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            MIN_CARDINALITY,
            MAX_CARDINALITY,
            PRICING_RELATED_YN,
            ACCESS_LEVEL
      FROM Okc_Rg_Def_Rules_V
     WHERE okc_rg_def_rules_v.rgd_code = p_rgd_code
       AND okc_rg_def_rules_v.rdf_code = p_rdf_code;

Line: 992


              l_rgrv_rec.LAST_UPDATED_BY,
              l_rgrv_rec.LAST_UPDATE_DATE,
              l_rgrv_rec.LAST_UPDATE_LOGIN,
              l_rgrv_rec.MIN_CARDINALITY,
              l_rgrv_rec.MAX_CARDINALITY,
              l_rgrv_rec.PRICING_RELATED_YN,
              l_rgrv_rec.ACCESS_LEVEL;

Line: 1053


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

Line: 1056


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

Line: 1059


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

Line: 1151


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1152


    p_to.last_update_date := p_from.last_update_date;

Line: 1154


    p_to.last_update_login := p_from.last_update_login;

Line: 1172


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1173


    p_to.last_update_date := p_from.last_update_date;

Line: 1175


    p_to.last_update_login := p_from.last_update_login;

Line: 1395


  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_rgr_rec                      IN rgr_rec_type,
    x_rgr_rec                      OUT NOCOPY rgr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1404


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

Line: 1426


       okc_debug.log('5500: Entered insert_row', 2);

Line: 1429


    g_insert_mode := TRUE;

Line: 1449


    INSERT INTO OKC_RG_DEF_RULES(
        rgd_code,
        rdf_code,
        object_version_number,
	   application_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        optional_yn,
        last_update_login,
        min_cardinality,
        max_cardinality,
        pricing_related_yn,
        access_level)
      VALUES (
        l_rgr_rec.rgd_code,
        l_rgr_rec.rdf_code,
        l_rgr_rec.object_version_number,
	   fnd_global.resp_appl_id,
        l_rgr_rec.created_by,
        l_rgr_rec.creation_date,
        l_rgr_rec.last_updated_by,
        l_rgr_rec.last_update_date,
        l_rgr_rec.optional_yn,
        l_rgr_rec.last_update_login,
        l_rgr_rec.min_cardinality,
        l_rgr_rec.max_cardinality,
        l_rgr_rec.pricing_related_yn,
        l_rgr_rec.access_level);

Line: 1484


       okc_debug.log('5600: Leaving insert_row', 2);

Line: 1492


       okc_debug.log('5700: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1508


       okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1524


       okc_debug.log('5900: Exiting insert_row:OTHERS Exception', 2);

Line: 1538


  END insert_row;

Line: 1542


  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_rgrv_rec                     IN rgrv_rec_type,
    x_rgrv_rec                     OUT NOCOPY rgrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1552


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

Line: 1569


      l_rgrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1570


      l_rgrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1571


      l_rgrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1594


       okc_debug.log('6200: Entered insert_row', 2);

Line: 1597


    g_insert_mode := TRUE;

Line: 1643


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rgr_rec,
      lx_rgr_rec
    );

Line: 1662


       okc_debug.log('6300: Leaving insert_row', 2);

Line: 1670


       okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1686


       okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1702


       okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);

Line: 1716


  END insert_row;

Line: 1720


  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_rgrv_tbl                     IN rgrv_tbl_type,
    x_rgrv_tbl                     OUT NOCOPY rgrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1730


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

Line: 1737


       okc_debug.log('6700: Entered insert_row', 2);

Line: 1745


        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_rgrv_rec                     => p_rgrv_tbl(i),
          x_rgrv_rec                     => x_rgrv_tbl(i));

Line: 1759


       okc_debug.log('6800: Leaving insert_row', 2);

Line: 1767


       okc_debug.log('6900: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1783


       okc_debug.log('7000: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1799


       okc_debug.log('7100: Exiting insert_row:OTHERS Exception', 2);

Line: 1813


  END insert_row;

Line: 1831


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RG_DEF_RULES
     WHERE RGD_CODE = p_rgr_rec.rgd_code
       AND RDF_CODE = p_rgr_rec.rdf_code
       AND OBJECT_VERSION_NUMBER = p_rgr_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1839


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_RG_DEF_RULES
    WHERE RGD_CODE = p_rgr_rec.rgd_code
       AND RDF_CODE = p_rgr_rec.rdf_code;

Line: 1905


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1914


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2188


  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_rgr_rec                      IN rgr_rec_type,
    x_rgr_rec                      OUT NOCOPY rgr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2197


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

Line: 2245


      IF (x_rgr_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rgr_rec.last_updated_by := l_rgr_rec.last_updated_by;

Line: 2249


      IF (x_rgr_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rgr_rec.last_update_date := l_rgr_rec.last_update_date;

Line: 2257


      IF (x_rgr_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rgr_rec.last_update_login := l_rgr_rec.last_update_login;

Line: 2304


       okc_debug.log('9200: Entered update_row', 2);

Line: 2307


    g_insert_mode := FALSE;

Line: 2333


    UPDATE  OKC_RG_DEF_RULES
    SET OBJECT_VERSION_NUMBER = l_def_rgr_rec.object_version_number,
        CREATED_BY = l_def_rgr_rec.created_by,
        CREATION_DATE = l_def_rgr_rec.creation_date,
        LAST_UPDATED_BY = l_def_rgr_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_rgr_rec.last_update_date,
        OPTIONAL_YN = l_def_rgr_rec.optional_yn,
        LAST_UPDATE_LOGIN = l_def_rgr_rec.last_update_login,
        MIN_CARDINALITY = l_def_rgr_rec.min_cardinality,
        MAX_CARDINALITY = l_def_rgr_rec.max_cardinality,
        PRICING_RELATED_YN = l_def_rgr_rec.pricing_related_yn,
        ACCESS_LEVEL = l_def_rgr_rec.access_level
    WHERE RGD_CODE = l_def_rgr_rec.rgd_code
      AND RDF_CODE = l_def_rgr_rec.rdf_code;

Line: 2352


       okc_debug.log('9300: Leaving update_row', 2);

Line: 2360


       okc_debug.log('9400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2376


       okc_debug.log('9500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2392


       okc_debug.log('9600: Exiting update_row:OTHERS Exception', 2);

Line: 2406


  END update_row;

Line: 2410


  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_rgrv_rec                     IN rgrv_rec_type,
    x_rgrv_rec                     OUT NOCOPY rgrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2420


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

Line: 2435


      l_rgrv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2436


      l_rgrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2437


      l_rgrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2488


      IF (x_rgrv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_rgrv_rec.last_updated_by := l_rgrv_rec.last_updated_by;

Line: 2492


      IF (x_rgrv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_rgrv_rec.last_update_date := l_rgrv_rec.last_update_date;

Line: 2496


      IF (x_rgrv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_rgrv_rec.last_update_login := l_rgrv_rec.last_update_login;

Line: 2542


    g_insert_mode := FALSE;

Line: 2594


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_rgr_rec,
      lx_rgr_rec
    );

Line: 2612


       okc_debug.log('10100: Leaving update_row', 2);

Line: 2620


       okc_debug.log('10200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2636


       okc_debug.log('10300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2652


       okc_debug.log('10400: Exiting update_row:OTHERS Exception', 2);

Line: 2666


  END update_row;

Line: 2670


  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_rgrv_tbl                     IN rgrv_tbl_type,
    x_rgrv_tbl                     OUT NOCOPY rgrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2680


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

Line: 2687


       okc_debug.log('10500: Entered update_row', 2);

Line: 2695


        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_rgrv_rec                     => p_rgrv_tbl(i),
          x_rgrv_rec                     => x_rgrv_tbl(i));

Line: 2709


       okc_debug.log('10600: Leaving update_row', 2);

Line: 2717


       okc_debug.log('10700: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2733


       okc_debug.log('10800: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2749


       okc_debug.log('10900: Exiting update_row:OTHERS Exception', 2);

Line: 2763


  END update_row;

Line: 2771


  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_rgr_rec                      IN rgr_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2779


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

Line: 2787


       okc_debug.log('11000: Entered delete_row', 2);

Line: 2799


    DELETE FROM OKC_RG_DEF_RULES
     WHERE RGD_CODE = l_rgr_rec.rgd_code AND
     RDF_CODE = l_rgr_rec.rdf_code;

Line: 2806


       okc_debug.log('11100: Leaving delete_row', 2);

Line: 2814


       okc_debug.log('11200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2830


       okc_debug.log('11300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2846


       okc_debug.log('11400: Exiting delete_row:OTHERS Exception', 2);

Line: 2860


  END delete_row;

Line: 2864


  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_rgrv_rec                     IN rgrv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2873


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

Line: 2881


       okc_debug.log('11500: Entered delete_row', 2);

Line: 2903


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

Line: 2918


       okc_debug.log('11600: Leaving delete_row', 2);

Line: 2926


       okc_debug.log('11700: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2942


       okc_debug.log('11800: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2958


       okc_debug.log('11900: Exiting delete_row:OTHERS Exception', 2);

Line: 2972


  END delete_row;

Line: 2976


  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_rgrv_tbl                     IN rgrv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2985


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

Line: 2992


       okc_debug.log('12000: Entered delete_row', 2);

Line: 3000


        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_rgrv_rec                     => p_rgrv_tbl(i));

Line: 3013


       okc_debug.log('12100: Leaving delete_row', 2);

Line: 3021


       okc_debug.log('12200: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3037


       okc_debug.log('12300: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3053


       okc_debug.log('12400: Exiting delete_row:OTHERS Exception', 2);

Line: 3067


  END delete_row;