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_CVM_PVT SQL Statements

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

Line: 40


  		select 'x'
  		from OKC_K_HEADERS_ALL_B -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b
  		where ID = p_cvmv_rec.chr_id;

Line: 113


    SELECT
            CHR_ID,
            MAJOR_VERSION,
            MINOR_VERSION,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_K_Vers_Numbers
     WHERE okc_k_vers_numbers.chr_id = p_chr_id;

Line: 138


              l_cvm_rec.LAST_UPDATED_BY,
              l_cvm_rec.LAST_UPDATE_DATE,
              l_cvm_rec.LAST_UPDATE_LOGIN;

Line: 161


    SELECT
            CHR_ID,
            OBJECT_VERSION_NUMBER,
            MAJOR_VERSION,
            MINOR_VERSION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_K_Vers_Numbers_V
     WHERE okc_k_vers_numbers_v.chr_id = p_chr_id;

Line: 186


              l_cvmv_rec.LAST_UPDATED_BY,
              l_cvmv_rec.LAST_UPDATE_DATE,
              l_cvmv_rec.LAST_UPDATE_LOGIN;

Line: 228


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

Line: 231


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

Line: 234


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

Line: 283


    p_to.last_updated_by := p_from.last_updated_by;

Line: 284


    p_to.last_update_date := p_from.last_update_date;

Line: 285


    p_to.last_update_login := p_from.last_update_login;

Line: 298


    p_to.last_updated_by := p_from.last_updated_by;

Line: 299


    p_to.last_update_date := p_from.last_update_date;

Line: 300


    p_to.last_update_login := p_from.last_update_login;

Line: 313


    p_to.last_updated_by := p_from.last_updated_by;

Line: 314


    p_to.last_update_date := p_from.last_update_date;

Line: 315


    p_to.last_update_login := p_from.last_update_login;

Line: 324


  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_k_vers_numbers_h_rec     IN okc_k_vers_numbers_h_rec_type,
    x_okc_k_vers_numbers_h_rec     OUT NOCOPY okc_k_vers_numbers_h_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 333


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

Line: 369


    INSERT INTO OKC_K_VERS_NUMBERS_H(
        chr_id,
        major_version,
        minor_version,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okc_k_vers_numbers_h_rec.chr_id,
        l_okc_k_vers_numbers_h_rec.major_version,
        l_okc_k_vers_numbers_h_rec.minor_version,
        l_okc_k_vers_numbers_h_rec.object_version_number,
        l_okc_k_vers_numbers_h_rec.created_by,
        l_okc_k_vers_numbers_h_rec.creation_date,
        l_okc_k_vers_numbers_h_rec.last_updated_by,
        l_okc_k_vers_numbers_h_rec.last_update_date,
        l_okc_k_vers_numbers_h_rec.last_update_login);

Line: 432


  END insert_row;

Line: 436


  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_cvm_rec                      IN cvm_rec_type,
    x_cvm_rec                      OUT NOCOPY cvm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 445


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

Line: 483


    INSERT INTO OKC_K_VERS_NUMBERS(
        chr_id,
        major_version,
        minor_version,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_cvm_rec.chr_id,
        l_cvm_rec.major_version,
        l_cvm_rec.minor_version,
        l_cvm_rec.object_version_number,
        l_cvm_rec.created_by,
        l_cvm_rec.creation_date,
        l_cvm_rec.last_updated_by,
        l_cvm_rec.last_update_date,
        l_cvm_rec.last_update_login);

Line: 537


  END insert_row;

Line: 541


  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_cvmv_rec                     IN cvmv_rec_type,
    x_cvmv_rec                     OUT NOCOPY cvmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 551


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

Line: 567


      l_cvmv_rec.LAST_UPDATE_DATE := l_cvmv_rec.CREATION_DATE;

Line: 568


      l_cvmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 569


      l_cvmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 631


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cvm_rec,
      lx_cvm_rec
    );

Line: 679


  END insert_row;

Line: 697


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_VERS_NUMBERS
     WHERE CHR_ID = p_cvm_rec.chr_id
       AND OBJECT_VERSION_NUMBER IN (p_cvm_rec.object_version_number,
							  OKC_API.G_MISS_NUM)
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 705


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_VERS_NUMBERS
    WHERE CHR_ID = p_cvm_rec.chr_id;

Line: 746


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 755


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 954


  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_cvm_rec                      IN cvm_rec_type,
    x_cvm_rec                      OUT NOCOPY cvm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 963


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

Line: 1015


      IF (x_cvm_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cvm_rec.last_updated_by := l_cvm_rec.last_updated_by;

Line: 1019


      IF (x_cvm_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cvm_rec.last_update_date := l_cvm_rec.last_update_date;

Line: 1023


      IF (x_cvm_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cvm_rec.last_update_login := l_cvm_rec.last_update_login;

Line: 1082


    UPDATE  OKC_K_VERS_NUMBERS
    SET MAJOR_VERSION = l_def_cvm_rec.major_version,
        MINOR_VERSION = l_def_cvm_rec.minor_version,
        OBJECT_VERSION_NUMBER = l_def_cvm_rec.object_version_number,
        CREATED_BY = l_def_cvm_rec.created_by,
        CREATION_DATE = l_def_cvm_rec.creation_date,
        LAST_UPDATED_BY = l_def_cvm_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cvm_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cvm_rec.last_update_login
    WHERE CHR_ID = l_def_cvm_rec.chr_id;

Line: 1094


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_vers_numbers_h_rec,
      lx_okc_k_vers_numbers_h_rec
    );

Line: 1140


  END update_row;

Line: 1144


  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_cvmv_rec                     IN cvmv_rec_type,
    x_cvmv_rec                     OUT NOCOPY cvmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1154


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

Line: 1168


      l_cvmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1169


      l_cvmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1170


      l_cvmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1214


      IF (x_cvmv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cvmv_rec.last_updated_by := l_cvmv_rec.last_updated_by;

Line: 1218


      IF (x_cvmv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cvmv_rec.last_update_date := l_cvmv_rec.last_update_date;

Line: 1222


      IF (x_cvmv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cvmv_rec.last_update_login := l_cvmv_rec.last_update_login;

Line: 1307


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cvm_rec,
      lx_cvm_rec
    );

Line: 1354


  END update_row;

Line: 1362


  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_cvm_rec                      IN cvm_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1370


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

Line: 1392


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_vers_numbers_h_rec,
      lx_okc_k_vers_numbers_h_rec
    );

Line: 1405


    DELETE FROM OKC_K_VERS_NUMBERS
     WHERE CHR_ID = l_cvm_rec.chr_id;

Line: 1440


  END delete_row;

Line: 1444


  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_cvmv_rec                     IN cvmv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1453


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

Line: 1477


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

Line: 1521


  END delete_row;

Line: 1532


    OKC_CVM_PVT.insert_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_cvmv_rec,
    		x_cvmv_rec);

Line: 1544


  PROCEDURE update_contract_version(
    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_cvmv_rec                     IN cvmv_rec_type,
    x_cvmv_rec                     OUT NOCOPY cvmv_rec_type) IS

	v_trans_id VARCHAR2(100);

Line: 1558


   	     okc_debug.log('1000: Entered update_contract_version, g_defer_min_vers_upd='||g_defer_min_vers_upd, 2);

Line: 1577


	-- update the contract version number

	IF v_trans_id IS NOT NULL AND v_trans_id <> g_trans_id THEN
	   -- save current transaction id
	   g_trans_id := v_trans_id;

Line: 1584


	   -- Major version update is not allowed

	   -- update contract version number
	   OKC_CVM_PVT.update_row(
    			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			l_cvmv_rec,
    			x_cvmv_rec);

Line: 1605


  END update_contract_version;

Line: 1621


		SELECT major_version
		FROM OKC_K_VERS_NUMBERS_V
		WHERE chr_id = p_chr_id;

Line: 1645


       OKC_CVM_PVT.update_row(
    			p_api_version,
    			p_init_msg_list,
    			x_return_status,
    			x_msg_count,
    			x_msg_data,
    			l_cvmv_rec,
    			x_cvmv_rec);

Line: 1661


  PROCEDURE delete_contract_version(
    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_cvmv_rec                     IN cvmv_rec_type) IS
  BEGIN

    OKC_CVM_PVT.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_cvmv_rec);

Line: 1678


  END delete_contract_version;

Line: 1688


  PROCEDURE defer_minor_version_update
  (
   p_defer IN VARCHAR2 DEFAULT FND_API.G_FALSE
  )
  IS
  BEGIN

        IF (l_debug = 'Y') THEN
            okc_debug.Set_Indentation('OKC_CVM_PVT');

Line: 1697


            okc_debug.log('8000: Entered defer_minor_version_update, p_defer='||p_defer||' ,g_defer_min_vers_upd='||g_defer_min_vers_upd, 2);

Line: 1707


            okc_debug.log('8100: Leaving defer_minor_version_update,  ,g_defer_min_vers_upd='||g_defer_min_vers_upd, 2);

Line: 1711


  END defer_minor_version_update;

Line: 1713


  FUNCTION Update_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
	l_api_version                 NUMBER := 1;

Line: 1725


        okc_debug.log('9000: Entered Update_Minor_Version(p_chr_id), p_chr_id='||p_chr_id, 2);

Line: 1734


	OKC_CVM_PVT.update_contract_version(
		p_api_version    => l_api_version,
		p_init_msg_list  => l_init_msg_list,
		x_return_status  => x_return_status,
		x_msg_count      => x_msg_count,
		x_msg_data       => x_msg_data,
		p_cvmv_rec       => l_cvmv_rec,
		x_cvmv_rec       => x_out_rec);

Line: 1744


        okc_debug.log('9100: Leaving Update_Minor_Version(p_chr_id), x_return_status='||x_return_status, 2);

Line: 1763


            okc_debug.log('9200: Leaving Update_Minor_Version(p_chr_id):other_error: x_return_status='||x_return_status, 2);

Line: 1769


  END Update_Minor_Version;