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.OKL_FE_ADJ_MATRIX_PVT SQL Statements

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

Line: 16


G_EXCEPTION_CANNOT_UPDATE   exception;

Line: 54


SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
WHERE rate_template_id IN
(SELECT  std_rate_tmpl_ver_id FROM okl_fe_std_rt_tmp_vers WHERE adj_mat_version_id=p_version_id);

Line: 60


SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
WHERE rate_template_id in
(SELECT std_rate_tmpl_ver_id from okl_fe_std_rt_tmp_vers where adj_mat_version_id=p_version_id);

Line: 66


SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
WHERE rate_card_id IN
(SELECT  rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);

Line: 72


SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
WHERE rate_card_id IN
(SELECT rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);

Line: 78


SELECT effective_from_date, effective_to_date FROM okl_fe_adj_mat_versions where adj_mat_id= p_adj_mat_id
and version_number= p_ver_number-1;

Line: 82


SELECT max(effective_from_date)
FROM   okl_fe_criteria_set ech
      ,okl_fe_criteria ecl
WHERE  ecl.criteria_set_id = ech.criteria_set_id
AND ech.source_id = p_version_id AND source_object_code = 'PAM';

Line: 315


SELECT  CRITERIA_SET_ID,
        OBJECT_VERSION_NUMBER,
        SOURCE_ID,
        SOURCE_OBJECT_CODE,
        MATCH_CRITERIA_CODE,
        VALIDATION_CODE,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
FROM OKL_FE_CRITERIA_SET WHERE SOURCE_ID= p_source_id AND SOURCE_OBJECT_CODE= p_source_object;

Line: 330


SELECT  CRITERIA_ID,
        OBJECT_VERSION_NUMBER,
        MATCH_CRITERIA_CODE,
        CRITERIA_SET_ID,
        CRIT_CAT_DEF_ID,
        Effective_From_DATE,
        Effective_To_DATE,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN
FROM OKL_FE_CRITERIA WHERE CRITERIA_SET_ID= p_criteria_set_id;

Line: 346


SELECT  CRITERION_VALUE_ID,
        OBJECT_VERSION_NUMBER,
        CRITERIA_ID,
        OPERATOR_CODE,
        CRIT_CAT_VALUE1,
        CRIT_CAT_VALUE2,
        ADJUSTMENT_FACTOR,
        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_CRITERION_VALUES WHERE CRITERIA_ID = p_criteria_id;

Line: 378


SELECT  DATA_TYPE_CODE,
        VALUE_TYPE_CODE
FROM OKL_FE_CRIT_CAT_DEF_V where CRIT_CAT_DEF_ID = criteria_def_id;

Line: 407


        x_ech_rec.LAST_UPDATED_BY       := cat_hdr_rec.LAST_UPDATED_BY;

Line: 408


        x_ech_rec.LAST_UPDATE_DATE      := cat_hdr_rec.LAST_UPDATE_DATE;

Line: 409


        x_ech_rec.LAST_UPDATE_LOGIN     := cat_hdr_rec.LAST_UPDATE_LOGIN;

Line: 453


        x_ecv_tbl(j).LAST_UPDATED_BY:= cat_values_rec.LAST_UPDATED_BY;

Line: 454


        x_ecv_tbl(j).LAST_UPDATE_DATE:= cat_values_rec.LAST_UPDATE_DATE;

Line: 455


        x_ecv_tbl(j).LAST_UPDATE_LOGIN:= cat_values_rec.LAST_UPDATE_LOGIN;

Line: 466


x_ecl_tbl(i).LAST_UPDATED_BY       := cat_lines_rec.LAST_UPDATED_BY;

Line: 467


x_ecl_tbl(i).LAST_UPDATE_DATE      := cat_lines_rec.LAST_UPDATE_DATE;

Line: 468


x_ecl_tbl(i).LAST_UPDATE_LOGIN     := cat_lines_rec.LAST_UPDATE_LOGIN;

Line: 502


SELECT  ADJ_MAT_ID,
        ADJ_MAT_NAME,
        ADJ_MAT_DESC,
        OBJECT_VERSION_NUMBER,
        ORG_ID,
        CURRENCY_CODE,
        ADJ_MAT_TYPE_CODE,
        ORIG_ADJ_MAT_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_ADJ_MAT_V WHERE ADJ_MAT_ID= p_adj_mat_id;

Line: 538


SELECT  ADJ_MAT_VERSION_ID,
        VERSION_NUMBER,
        OBJECT_VERSION_NUMBER,
        ADJ_MAT_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_ADJ_MAT_VERSIONS
WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER= p_version_number;

Line: 610


        x_pamv_rec.LAST_UPDATED_BY := cat_hdr_rec.LAST_UPDATED_BY;

Line: 611


        x_pamv_rec.LAST_UPDATE_DATE := cat_hdr_rec.LAST_UPDATE_DATE;

Line: 612


        x_pamv_rec.LAST_UPDATE_LOGIN := cat_hdr_rec.LAST_UPDATE_LOGIN;

Line: 642


        x_pal_rec.LAST_UPDATED_BY := cat_version_rec.LAST_UPDATED_BY;

Line: 643


        x_pal_rec.LAST_UPDATE_DATE := cat_version_rec.LAST_UPDATE_DATE;

Line: 644


        x_pal_rec.LAST_UPDATE_LOGIN := cat_version_rec.LAST_UPDATE_LOGIN;

Line: 784


SELECT max(version_number) FROM
OKL_FE_ADJ_MAT_VERSIONS WHERE ADJ_MAT_ID=p_adj_mat_id;

Line: 884


PROCEDURE INSERT_ADJ_MAT(
                        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_pamv_rec      IN  okl_pamv_rec,
                        p_pal_rec       IN  okl_pal_rec,
                        x_pamv_rec      OUT NOCOPY okl_pamv_rec,
                        x_pal_rec       OUT NOCOPY okl_pal_rec
                        ) IS

l_pamv_rec      okl_pamv_rec := p_pamv_rec;

Line: 899


l_api_name      VARCHAR2(40):='INSERT_ADJ_MAT';

Line: 905


      SELECT 'x'
      FROM   okl_fe_adj_mat_v
      WHERE  adj_mat_name = p_name;

Line: 945


okl_pam_pvt.insert_row(   l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,x_msg_count
                         ,x_msg_data
                         ,l_pamv_rec
                         ,x_pamv_rec);

Line: 965


okl_pal_pvt.insert_row(   l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,x_msg_count
                         ,x_msg_data
                         ,l_pal_rec
                         ,x_pal_rec);

Line: 1016


END INSERT_ADJ_MAT;

Line: 1019


PROCEDURE UPDATE_ADJ_MAT(
                        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_pal_rec       IN  okl_pal_rec,
                        x_pal_rec       OUT NOCOPY okl_pal_rec
                        ) IS

l_pamv_rec      okl_pamv_rec;

Line: 1033


l_api_name      VARCHAR2(40):='UPDATE_ADJ_MAT';

Line: 1048


SELECT effective_from_date, effective_to_date
FROM okl_fe_adj_mat_versions
WHERE adj_mat_id= l_adj_mat_id AND version_number=l_version_number -1;

Line: 1053


SELECT max(effective_from_date)
FROM   okl_fe_criteria_set ech
      ,okl_fe_criteria ecl
WHERE  ecl.criteria_set_id = ech.criteria_set_id
AND ech.source_id = p_version_id AND source_object_code = 'PAM';

Line: 1098


    okl_pam_pvt.update_row(l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,x_msg_count
                         ,x_msg_data
                         ,l_pamv_rec
                         ,x_pamv_rec);

Line: 1211


    okl_pal_pvt.update_row(   l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,x_msg_count
                             ,x_msg_data
                             ,l_pal_rec
                             ,x_pal_rec);

Line: 1228


    okl_pal_pvt.update_row(   l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,x_msg_count
                             ,x_msg_data
                             ,l_pal_rec
                             ,x_pal_rec);

Line: 1299


END UPDATE_ADJ_MAT;

Line: 1316


l_api_name      VARCHAR2(40):='UPDATE_ADJ_MAT';

Line: 1344


okl_pam_pvt.update_row(l_api_version
                      ,l_init_msg_list
                      ,l_return_status
                      ,x_msg_count
                      ,x_msg_data
                      ,l_pamv_rec
                      ,x_pamv_rec);

Line: 1366


okl_pal_pvt.insert_row(   l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,x_msg_count
                         ,x_msg_data
                         ,l_pal_rec
                         ,x_pal_rec);

Line: 1447


l_api_name      VARCHAR2(40):='UPDATE_ADJ_MAT';

Line: 1472


okl_pal_pvt.update_row(   l_api_version
                          ,p_init_msg_list
                          ,l_return_status
                          ,x_msg_count
                          ,x_msg_data
                          ,l_pal_rec
                          ,x_pal_rec);

Line: 1565


SELECT ADJ_MAT_ID,
       VERSION_NUMBER,
       EFFECTIVE_FROM_DATE,
       EFFECTIVE_TO_DATE
       FROM okl_fe_adj_mat_versions
WHERE ADJ_MAT_VERSION_ID = p_version_id;

Line: 1573


SELECT  ADJ_MAT_VERSION_ID,
        EFFECTIVE_TO_DATE FROM okl_fe_adj_mat_versions
WHERE ADJ_MAT_ID=p_adj_mat_id and VERSION_NUMBER = p_version_number;

Line: 1578


SELECT max(VERSION_NUMBER) FROM OKL_FE_ADJ_MAT_VERSIONS
WHERE ADJ_MAT_ID = p_adj_mat_id;

Line: 1583


select max(effective_from_date) from okl_fe_std_rt_tmp_vers
where adj_mat_version_id=p_version_id;

Line: 1702


            okl_pal_pvt.update_row(   l_api_version
                             ,p_init_msg_list
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data
                             ,l_pal_rec
                             ,x_pal_rec);

Line: 1783


    okl_pal_pvt.update_row(   l_api_version
                             ,p_init_msg_list
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data
                             ,l_pal_rec
                             ,x_pal_rec);

Line: 1797


    okl_pam_pvt.update_row(   l_api_version
                             ,p_init_msg_list
                             ,x_return_status
                             ,x_msg_count
                             ,x_msg_data
                             ,l_pamv_rec
                             ,x_pamv_rec);

Line: 1872


SELECT vers.std_rate_tmpl_ver_id ID,hdr.template_name NAME ,vers.version_number VERSION_NUMBER
FROM okl_fe_std_rt_tmp_vers vers, okl_fe_std_rt_tmp_v hdr
WHERE vers.std_rate_tmpl_id = hdr.std_rate_tmpl_id AND vers.adj_mat_version_id=p_version_id
AND vers.STS_CODE='ACTIVE';

Line: 1880


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.adj_mat_version_id=p_version_id
AND vers.STS_CODE='ACTIVE';

Line: 1887


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.std_rate_tmpl_ver_id = p_version_id
AND vers.sts_code = 'ACTIVE';