APPS.OKL_FE_EO_TERM_OPTIONS_PVT SQL Statements

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

Line: 37

select 1 from okl_fe_eo_terms_all_b
where end_of_term_id= p_end_of_term_id;

Line: 41

select end_of_term_ver_id from okl_fe_eo_term_vers
where end_of_term_id= p_end_of_term_id and version_number= p_version;

Line: 45

SELECT  END_OF_TERM_OBJ_ID,
        OBJECT_VERSION_NUMBER,
        ORGANIZATION_ID,
        INVENTORY_ITEM_ID,
        CATEGORY_SET_ID,
        CATEGORY_ID,
        RESI_CATEGORY_SET_ID,
        END_OF_TERM_VER_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
FROM OKL_FE_EO_TERM_OBJECTS WHERE END_OF_TERM_VER_ID = p_end_of_term_ver_id;

Line: 123

        x_eto_tbl(i).LAST_UPDATED_BY        := eot_objects_tbl.LAST_UPDATED_BY;

Line: 124

        x_eto_tbl(i).LAST_UPDATE_DATE       := eot_objects_tbl.LAST_UPDATE_DATE;

Line: 125

        x_eto_tbl(i).LAST_UPDATE_LOGIN      := eot_objects_tbl.LAST_UPDATE_LOGIN;

Line: 168

select 1 from okl_fe_eo_terms_all_b
where end_of_term_id= p_end_of_term_id;

Line: 172

select end_of_term_ver_id from okl_fe_eo_term_vers
where end_of_term_id= p_end_of_term_id and version_number= p_version;

Line: 176

SELECT  END_OF_TERM_VALUE_ID,
        OBJECT_VERSION_NUMBER,
        EOT_TERM,
        EOT_VALUE,
        END_OF_TERM_VER_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
FROM OKL_FE_EO_TERM_VALUES WHERE end_OF_TERM_VER_ID = p_version_id;

Line: 248

        x_etv_tbl(i).LAST_UPDATED_BY        := eot_values_tbl.LAST_UPDATED_BY;

Line: 249

        x_etv_tbl(i).LAST_UPDATE_DATE       := eot_values_tbl.LAST_UPDATE_DATE;

Line: 250

        x_etv_tbl(i).LAST_UPDATE_LOGIN      := eot_values_tbl.LAST_UPDATE_LOGIN;

Line: 297

SELECT  END_OF_TERM_ID,
        OBJECT_VERSION_NUMBER,
        END_OF_TERM_NAME,
        END_OF_TERM_DESC,
        ORG_ID,
        CURRENCY_CODE,
        EOT_TYPE_CODE,
        PRODUCT_ID,
        CATEGORY_TYPE_CODE,
        ORIG_END_OF_TERM_ID,
        STS_CODE,
        EFFECTIVE_FROM_DATE,
        EFFECTIVE_TO_DATE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
FROM OKL_FE_EO_TERMS_V WHERE END_OF_TERM_ID=p_eot_id;

Line: 334

SELECT  END_OF_TERM_VER_ID,
        OBJECT_VERSION_NUMBER,
        VERSION_NUMBER,
        EFFECTIVE_FROM_DATE,
        EFFECTIVE_TO_DATE,
        STS_CODE,
        END_OF_TERM_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_ID= p_eot_id and version_number=p_eot_version;

Line: 436

SELECT end_of_term_obj_id,
       inventory_item_id ,
       organization_id,
       category_set_id,
       category_id,
       resi_category_set_id
FROM OKL_FE_EO_TERM_OBJECTS
WHERE end_of_term_ver_id = p_version_id;

Line: 447

SELECT  end_of_term_id,
        eot_type_code,
        currency_code,
        category_type_code
FROM OKL_FE_EO_TERM_VERS_V
WHERE end_of_term_ver_id = p_version_id;

Line: 456

SELECT count(*) FROM(
SELECT inventory_item_id ,
       organization_id,
       category_set_id,
       category_id,
       resi_category_set_id
FROM OKL_FE_EO_TERM_OBJECTS
WHERE end_of_term_ver_id = p_version_id
MINUS
SELECT inventory_item_id ,
       organization_id,
       category_set_id,
       category_id,
       resi_category_set_id
FROM OKL_FE_ITEM_RESIDUAL_ALL
WHERE (residual_type_code= 'PERCENT' and
residual_type_code=l_eot_type_code ) OR (residual_type_code = 'AMOUNT' and
residual_type_code=l_eot_type_code and currency_code =l_currency_code)
);

Line: 477

SELECT meaning from fnd_lookups where lookup_type='OKL_SOURCE_TYPES'
and lookup_code=source_code;

Line: 548

SELECT max(expected_start_date) FROM okl_quick_quotes_b WHERE end_of_term_option_id=p_eot_version_id;

Line: 551

SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE end_of_term_option_id=p_eot_version_id;

Line: 554

SELECT max(expected_start_date) FROM okl_quick_quotes_b WHERE rate_card_id in
(select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);

Line: 558

SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE rate_card_id in
(select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);

Line: 563

SELECT effective_from_date, effective_to_date FROM okl_fe_eo_term_vers where end_of_term_id= p_eot_id
AND version_number= p_ver_number-1;

Line: 670

PROCEDURE insert_end_of_term_option(
                            p_api_version      IN  NUMBER,
                            p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                            x_return_status    OUT NOCOPY VARCHAR2,
                            x_msg_count        OUT NOCOPY NUMBER,
                            x_msg_data         OUT NOCOPY VARCHAR2,
                            p_ethv_rec         IN  okl_ethv_rec,
                            p_eve_rec          IN  okl_eve_rec,
                            p_eto_tbl          IN  okl_eto_tbl,
                            p_etv_tbl          IN  okl_etv_tbl,
                            x_ethv_rec         OUT NOCOPY okl_ethv_rec,
                            x_eve_rec          OUT NOCOPY okl_eve_rec,
                            x_eto_tbl          OUT NOCOPY okl_eto_tbl,
                            x_etv_tbl          OUT NOCOPY okl_etv_tbl) AS

    l_api_name      CONSTANT VARCHAR2(40)   := 'insert_end_of_term_option';

Line: 696

      SELECT 'x'
      FROM   okl_fe_eo_terms_v
      WHERE  end_of_term_name = UPPER(p_name);

Line: 755

    okl_eth_pvt.insert_row(
                            p_api_version    => p_api_version,
                            p_init_msg_list  => p_init_msg_list,
                            x_return_status  => l_return_status,
                            x_msg_count      => x_msg_count,
                            x_msg_data       => x_msg_data,
                            p_ethv_rec       => l_ethv_rec,
                            x_ethv_rec       => x_ethv_rec
                            );

Line: 777

    okl_eve_pvt.insert_row(
                            p_api_version   => p_api_version,
                            p_init_msg_list => p_init_msg_list,
                            x_return_status => l_return_status,
                            x_msg_count     => x_msg_count,
                            x_msg_data      => x_msg_data,
                            p_eve_rec       => l_eve_rec,
                            x_eve_rec       => x_eve_rec);

Line: 805

	    -- insert the lines record into the database
	    okl_eto_pvt.insert_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_eto_tbl       => l_eto_tbl,
				    x_eto_tbl       => x_eto_tbl);

Line: 836

		-- insert the values record into the database
		okl_etv_pvt.insert_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_etv_tbl       => l_etv_tbl,
				    x_etv_tbl       => x_etv_tbl);

Line: 883

END insert_end_of_term_option;

Line: 885

PROCEDURE update_end_of_term_option(
                            p_api_version      IN  NUMBER,
                            p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                            x_return_status    OUT NOCOPY VARCHAR2,
                            x_msg_count        OUT NOCOPY NUMBER,
                            x_msg_data         OUT NOCOPY VARCHAR2,
                            p_eve_rec          IN  okl_eve_rec,
                            p_eto_tbl          IN  okl_eto_tbl,
                            p_etv_tbl          IN  okl_etv_tbl,
                            x_eve_rec          OUT NOCOPY okl_eve_rec,
                            x_eto_tbl          OUT NOCOPY okl_eto_tbl,
                            x_etv_tbl          OUT NOCOPY okl_etv_tbl) AS

l_eve_rec   okl_eve_rec := p_eve_rec;

Line: 904

l_api_name      VARCHAR2(40) := 'update_end_of_term_option';

Line: 917

SELECT max(version_number) FROM okl_fe_eo_term_vers
WHERE end_of_term_id=p_eot_id and sts_code='ACTIVE';

Line: 971

            okl_eth_pvt.update_row(
                            p_api_version    => p_api_version,
                            p_init_msg_list  => p_init_msg_list,
                            x_return_status  => l_return_status,
                            x_msg_count      => x_msg_count,
                            x_msg_data       => x_msg_data,
                            p_ethv_rec       => l_ethv_rec,
                            x_ethv_rec       => x_ethv_rec
                            );

Line: 990

        okl_eve_pvt.update_row(
                            p_api_version   => p_api_version,
                            p_init_msg_list => p_init_msg_list,
                            x_return_status => l_return_status,
                            x_msg_count     => x_msg_count,
                            x_msg_data      => x_msg_data,
                            p_eve_rec       => l_eve_rec,
                            x_eve_rec       => x_eve_rec);

Line: 1012

		-- update the lines table

		IF (l_eto_tbl.COUNT >0) then
		    i := l_eto_tbl.FIRST;

Line: 1018

			okl_eto_pvt.update_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_eto_rec       => l_eto_tbl(i),
				    x_eto_rec       => x_eto_tbl(i));

Line: 1037

			okl_eto_pvt.insert_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_eto_rec       => l_eto_tbl(i),
				    x_eto_rec       => x_eto_tbl(i));

Line: 1059

		-- update the values table
		IF (l_etv_tbl.COUNT >0) then

		    i := l_etv_tbl.FIRST;

Line: 1072

			okl_etv_pvt.update_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_etv_rec       => l_etv_tbl(i),
				    x_etv_rec       => x_etv_tbl(i));

Line: 1089

			okl_etv_pvt.insert_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_etv_rec       => l_etv_tbl(i),
				    x_etv_rec       => x_etv_tbl(i));

Line: 1156

            okl_eth_pvt.update_row(
                            p_api_version    => p_api_version,
                            p_init_msg_list  => p_init_msg_list,
                            x_return_status  => l_return_status,
                            x_msg_count      => x_msg_count,
                            x_msg_data       => x_msg_data,
                            p_ethv_rec       => l_ethv_rec,
                            x_ethv_rec       => x_ethv_rec
                            );

Line: 1172

            okl_eve_pvt.update_row(
                            p_api_version   => p_api_version,
                            p_init_msg_list => p_init_msg_list,
                            x_return_status => l_return_status,
                            x_msg_count     => x_msg_count,
                            x_msg_data      => x_msg_data,
                            p_eve_rec       => l_eve_rec,
                            x_eve_rec       => x_eve_rec);

Line: 1199

            okl_eto_pvt.insert_row(
                            p_api_version   => p_api_version,
                            p_init_msg_list => p_init_msg_list,
                            x_return_status => l_return_status,
                            x_msg_count     => x_msg_count,
                            x_msg_data      => x_msg_data,
                            p_eto_rec       => l_eto_tbl(i),
                            x_eto_rec       => x_eto_tbl(i));

Line: 1247

END update_end_of_term_option;

Line: 1309

    okl_eth_pvt.update_row(
                            p_api_version    => p_api_version,
                            p_init_msg_list  => p_init_msg_list,
                            x_return_status  => l_return_status,
                            x_msg_count      => x_msg_count,
                            x_msg_data       => x_msg_data,
                            p_ethv_rec       => l_ethv_rec,
                            x_ethv_rec       => x_ethv_rec
                            );

Line: 1326

    okl_eve_pvt.insert_row(
                            p_api_version   => p_api_version,
                            p_init_msg_list => p_init_msg_list,
                            x_return_status => l_return_status,
                            x_msg_count     => x_msg_count,
                            x_msg_data      => x_msg_data,
                            p_eve_rec       => l_eve_rec,
                            x_eve_rec       => x_eve_rec);

Line: 1356

	    -- insert the lines record into the database
	    okl_eto_pvt.insert_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_eto_tbl       => l_eto_tbl,
				    x_eto_tbl       => x_eto_tbl);

Line: 1387

	    -- insert the values record into the database
	    okl_etv_pvt.insert_row(
				    p_api_version   => p_api_version,
				    p_init_msg_list => p_init_msg_list,
				    x_return_status => l_return_status,
				    x_msg_count     => x_msg_count,
				    x_msg_data      => x_msg_data,
				    p_etv_tbl       => l_etv_tbl,
				    x_etv_tbl       => x_etv_tbl);

Line: 1464

SELECT category_type_code,eot_type_code FROM OKL_FE_EO_TERMS_V hdr, OKL_FE_EO_TERM_VERS ver
WHERE hdr.end_of_term_id = ver.end_of_term_id  AND ver.end_of_term_ver_id = p_end_of_term_ver_id;

Line: 1468

SELECT inventory_item_id, organization_id, category_id, category_set_id, resi_category_set_id
FROM OKL_FE_EO_TERM_OBJECTS
WHERE end_of_term_ver_id=p_end_of_term_ver_id;

Line: 1473

select count(*) from
(
select organization_id, inventory_item_id, category_id, category_set_id
from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id1
intersect
select organization_id, inventory_item_id, category_id, category_set_id
from OKL_FE_RESI_CAT_OBJECTS where resi_category_set_id = id2
);

Line: 1560

SELECT  END_OF_TERM_ID,
        VERSION_NUMBER,
        EFFECTIVE_FROM_DATE,
        EFFECTIVE_TO_DATE
FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_VER_ID=p_ver_id;

Line: 1567

SELECT  END_OF_TERM_VER_ID,
        EFFECTIVE_TO_DATE FROM okl_fe_eo_term_vers
WHERE END_OF_TERM_ID=p_eot_id and VERSION_NUMBER = p_version_number;

Line: 1677

    okl_eve_pvt.update_row(
                        p_api_version   => p_api_version,
                        p_init_msg_list => p_init_msg_list,
                        x_return_status => l_return_status,
                        x_msg_count     => x_msg_count,
                        x_msg_data      => x_msg_data,
                        p_eve_rec       => l_prev_eve_rec,
                        x_eve_rec       => x_prev_eve_rec);

Line: 1695

okl_eve_pvt.update_row(
                        p_api_version   => p_api_version,
                        p_init_msg_list => p_init_msg_list,
                        x_return_status => l_return_status,
                        x_msg_count     => x_msg_count,
                        x_msg_data      => x_msg_data,
                        p_eve_rec       => l_eve_rec,
                        x_eve_rec       => x_eve_rec);

Line: 1718

okl_eth_pvt.update_row(
                       p_api_version    => p_api_version,
                       p_init_msg_list  => p_init_msg_list,
                       x_return_status  => l_return_status,
                       x_msg_count      => x_msg_count,
                       x_msg_data       => x_msg_data,
                       p_ethv_rec       => l_ethv_rec,
                       x_ethv_rec       => x_ethv_rec
                       );

Line: 1776

SELECT vers.RATE_SET_VERSION_ID ID,hdr.name NAME,vers.version_number VERSION_NUMBER
FROM OKL_FE_RATE_SET_VERSIONS vers, OKL_LS_RT_FCTR_SETS_V hdr
WHERE  vers.rate_set_id = hdr.id AND vers.end_of_term_ver_id=p_version_id
AND vers.STS_CODE='ACTIVE';

Line: 1873

    SELECT
             RCSV.RESI_CATEGORY_SET_ID ID
           , RCSV.RESI_CAT_NAME        NAME
      FROM
            OKL_FE_RESI_CAT_V RCSV
          , OKL_FE_ITEM_RESIDUAL IRESDV
      WHERE
            IRESDV.CATEGORY_TYPE_CODE   = 'RESCAT'
        AND IRESDV.RESI_CATEGORY_SET_ID = RCSV.RESI_CATEGORY_SET_ID
        AND RCSV.STS_CODE               <> p_rcs_sts_code
        AND IRESDV.item_residual_id     = p_itm_rsdl_id;

Line: 1890

   SELECT  END_OF_TERM_ID
   FROM OKL_FE_EO_TERM_VERS WHERE END_OF_TERM_VER_ID=p_ver_id;

Line: 1894

   SELECT EOT_TYPE_CODE
   FROM OKL_FE_EO_TERMS_V where end_of_term_id= p_eot_id;

Line: 1945

okl_eve_pvt.update_row(   l_api_version
                          ,p_init_msg_list
                          ,l_return_status
                          ,x_msg_count
                          ,x_msg_data
                          ,l_eve_rec
                          ,x_eve_rec);