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_STD_RATE_TMPL_PVT dependencies on STANDARD

Line 359: -- procedure to give the details of the Standard Rate Template given the Standard

355: ,x_msg_data
356: ,'_PVT');
357: END get_eligibility_criteria;
358:
359: -- procedure to give the details of the Standard Rate Template given the Standard
360: -- Rate Template id and the version number
361:
362: PROCEDURE get_version(p_api_version IN NUMBER
363: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

Line 452: -- procedure to give the details of the latest version of Standard Rate Template

448: ,x_msg_data
449: ,'_PVT');
450: END get_version;
451:
452: -- procedure to give the details of the latest version of Standard Rate Template
453: -- given the Standard Rate Template id
454:
455: PROCEDURE get_version(p_api_version IN NUMBER
456: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

Line 453: -- given the Standard Rate Template id

449: ,'_PVT');
450: END get_version;
451:
452: -- procedure to give the details of the latest version of Standard Rate Template
453: -- given the Standard Rate Template id
454:
455: PROCEDURE get_version(p_api_version IN NUMBER
456: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
457: ,x_return_status OUT NOCOPY VARCHAR2

Line 553: --procedure to create a Standard Rate Template with the associated Eligibility Criteria

549: ,x_msg_data
550: ,'_PVT');
551: END get_version;
552:
553: --procedure to create a Standard Rate Template with the associated Eligibility Criteria
554:
555: PROCEDURE insert_srt(p_api_version IN NUMBER
556: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
557: ,x_return_status OUT NOCOPY VARCHAR2

Line 718: -- procedure to update a particular version of the Standard Rate Template

714: ,x_msg_data
715: ,'_PVT');
716: END insert_srt;
717:
718: -- procedure to update a particular version of the Standard Rate Template
719:
720: PROCEDURE update_srt(p_api_version IN NUMBER
721: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
722: ,x_return_status OUT NOCOPY VARCHAR2

Line 936: -- procedure to create a new version of the Standard Rate Template

932: ,x_msg_data
933: ,'_PVT');
934: END update_srt;
935:
936: -- procedure to create a new version of the Standard Rate Template
937:
938: PROCEDURE create_version(p_api_version IN NUMBER
939: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
940: ,x_return_status OUT NOCOPY VARCHAR2

Line 1459: -- procedure to set the default Standard Rate Template

1455: ,x_msg_data
1456: ,'_PVT');
1457: END handle_approval;
1458:
1459: -- procedure to set the default Standard Rate Template
1460:
1461: PROCEDURE update_default(p_api_version IN NUMBER
1462: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1463: ,x_return_status OUT NOCOPY VARCHAR2

Line 1498: -- change the default yn flag of this Standard Rate Template to N

1494: OPEN default_yn_csr;
1495: FETCH default_yn_csr INTO l_srt_id ;
1496: CLOSE default_yn_csr;
1497:
1498: -- change the default yn flag of this Standard Rate Template to N
1499:
1500: IF (l_srt_id IS NOT NULL) THEN
1501: l_srtv_rec.std_rate_tmpl_id := l_srt_id;
1502: l_srtv_rec.default_yn := 'N';

Line 1580: -- cursor to calculate the LRS objects which are referncing this Standard Rate Template

1576: ,x_msg_data OUT NOCOPY VARCHAR2
1577: ,p_version_id IN NUMBER
1578: ,x_obj_tbl OUT NOCOPY invalid_object_tbl) AS
1579:
1580: -- cursor to calculate the LRS objects which are referncing this Standard Rate Template
1581:
1582: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1583: SELECT vers.rate_set_version_id id
1584: ,hdr.name name

Line 1670: -- cursor to fetch the maximum start date of lease quotes referencing Standard Rate Template

1666: l_start_date l_start_date_type;
1667: l_max_start_date DATE;
1668: i NUMBER;
1669:
1670: -- cursor to fetch the maximum start date of lease quotes referencing Standard Rate Template
1671:
1672: CURSOR srt_lq_csr(p_version_id IN NUMBER) IS
1673: SELECT MAX(lq.expected_start_date) start_date
1674: FROM okl_lease_quotes_b lq

Line 1679: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template

1675: ,okl_fe_std_rt_tmp_vers srt
1676: WHERE srt.std_rate_tmpl_ver_id = p_version_id
1677: AND lq.rate_template_id = srt.std_rate_tmpl_ver_id;
1678:
1679: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template
1680:
1681: CURSOR srt_qq_csr(p_version_id IN NUMBER) IS
1682: SELECT MAX(qq.expected_start_date) start_date
1683: FROM okl_quick_quotes_b qq

Line 1858: -- cursor to calculate the LRS objects which are referncing this Standard Rate Template

1854: ,std_rate_tmpl_id
1855: FROM okl_fe_std_rt_tmp_vers
1856: WHERE std_rate_tmpl_ver_id = p_srt_version_id;
1857:
1858: -- cursor to calculate the LRS objects which are referncing this Standard Rate Template
1859:
1860: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1861: SELECT vers.rate_set_version_id id
1862: ,hdr.name name