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_LEASE_QUOTE_SERVICE_PVT dependencies on OKL_LRE_PVT

Line 462: x_deleted_assoc_asset_tbl OUT NOCOPY okl_lre_pvt.lrev_tbl_type,

458: -- PROCEDURE get_deleted_assoc_assets
459: -------------------------------------
460: PROCEDURE get_deleted_assoc_assets (p_service_id IN NUMBER,
461: p_assoc_asset_tbl IN line_relation_tbl_type,
462: x_deleted_assoc_asset_tbl OUT NOCOPY okl_lre_pvt.lrev_tbl_type,
463: x_return_status OUT NOCOPY VARCHAR2) IS
464:
465: l_program_name CONSTANT VARCHAR2(30) := 'get_deleted_assoc_assets';
466: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;

Line 474: l_assoc_asset_tbl okl_lre_pvt.lrev_tbl_type;

470: FROM okl_line_relationships_b
471: WHERE related_line_type = 'SERVICE'
472: AND related_line_id = p_service_id;
473:
474: l_assoc_asset_tbl okl_lre_pvt.lrev_tbl_type;
475: l_delete_flag VARCHAR2(1);
476: i BINARY_INTEGER := 0;
477:
478: BEGIN

Line 541: l_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;

537:
538: l_program_name CONSTANT VARCHAR2(30) := 'create_line_associations';
539: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
540:
541: l_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
542: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
543:
544: l_line_relation_tbl line_relation_tbl_type;
545:

Line 542: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;

538: l_program_name CONSTANT VARCHAR2(30) := 'create_line_associations';
539: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
540:
541: l_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
542: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
543:
544: l_line_relation_tbl line_relation_tbl_type;
545:
546: BEGIN

Line 563: okl_lre_pvt.insert_row (

559: l_assoc_assets_tbl(i).comments := l_line_relation_tbl(i).comments;
560: END IF;
561: END LOOP;
562:
563: okl_lre_pvt.insert_row (
564: p_api_version => G_API_VERSION
565: ,p_init_msg_list => G_FALSE
566: ,x_return_status => x_return_status
567: ,x_msg_count => x_msg_count

Line 615: l_assoc_create_tbl okl_lre_pvt.lrev_tbl_type;

611:
612: l_program_name CONSTANT VARCHAR2(30) := 'update_line_associations';
613: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
614:
615: l_assoc_create_tbl okl_lre_pvt.lrev_tbl_type;
616: l_assoc_update_tbl okl_lre_pvt.lrev_tbl_type;
617: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
618:
619: l_line_relation_tbl line_relation_tbl_type;

Line 616: l_assoc_update_tbl okl_lre_pvt.lrev_tbl_type;

612: l_program_name CONSTANT VARCHAR2(30) := 'update_line_associations';
613: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
614:
615: l_assoc_create_tbl okl_lre_pvt.lrev_tbl_type;
616: l_assoc_update_tbl okl_lre_pvt.lrev_tbl_type;
617: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
618:
619: l_line_relation_tbl line_relation_tbl_type;
620: l_deleted_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;

Line 617: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;

613: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
614:
615: l_assoc_create_tbl okl_lre_pvt.lrev_tbl_type;
616: l_assoc_update_tbl okl_lre_pvt.lrev_tbl_type;
617: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
618:
619: l_line_relation_tbl line_relation_tbl_type;
620: l_deleted_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
621:

Line 620: l_deleted_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;

616: l_assoc_update_tbl okl_lre_pvt.lrev_tbl_type;
617: lx_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
618:
619: l_line_relation_tbl line_relation_tbl_type;
620: l_deleted_assoc_assets_tbl okl_lre_pvt.lrev_tbl_type;
621:
622: BEGIN
623:
624: l_line_relation_tbl := p_assoc_assets_tbl;

Line 640: okl_lre_pvt.delete_row (

636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638:
639: IF l_deleted_assoc_assets_tbl.COUNT > 0 THEN
640: okl_lre_pvt.delete_row (
641: p_api_version => G_API_VERSION
642: ,p_init_msg_list => G_FALSE
643: ,x_return_status => x_return_status
644: ,x_msg_count => x_msg_count

Line 688: okl_lre_pvt.update_row (

684: END IF;
685:
686: IF l_assoc_update_tbl.COUNT > 0 THEN
687:
688: okl_lre_pvt.update_row (
689: p_api_version => G_API_VERSION
690: ,p_init_msg_list => G_FALSE
691: ,x_return_status => x_return_status
692: ,x_msg_count => x_msg_count

Line 708: okl_lre_pvt.insert_row (

704: END IF;
705:
706: IF l_assoc_create_tbl.COUNT > 0 THEN
707:
708: okl_lre_pvt.insert_row (
709: p_api_version => G_API_VERSION
710: ,p_init_msg_list => G_FALSE
711: ,x_return_status => x_return_status
712: ,x_msg_count => x_msg_count

Line 887: okl_lre_pvt.insert_row (

883: CLOSE c_get_new_asset_id;
884: END IF;
885: END LOOP;
886:
887: okl_lre_pvt.insert_row (
888: p_api_version => G_API_VERSION
889: ,p_init_msg_list => G_FALSE
890: ,x_return_status => x_return_status
891: ,x_msg_count => x_msg_count

Line 1685: okl_lre_pvt.update_row (

1681: END IF;
1682: END LOOP;
1683:
1684: IF (l_line_relation_tbl.COUNT > 0) THEN
1685: okl_lre_pvt.update_row (
1686: p_api_version => G_API_VERSION
1687: ,p_init_msg_list => G_FALSE
1688: ,x_return_status => x_return_status
1689: ,x_msg_count => x_msg_count

Line 2262: l_lrev_tbl okl_lre_pvt.lrev_tbl_type;

2258:
2259: l_program_name CONSTANT VARCHAR2(30) := 'delete_service';
2260: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2261:
2262: l_lrev_tbl okl_lre_pvt.lrev_tbl_type;
2263: l_svcv_rec okl_svc_pvt.svcv_rec_type;
2264: i BINARY_INTEGER;
2265:
2266: CURSOR c_sublines IS

Line 2290: okl_lre_pvt.delete_row (

2286: END LOOP;
2287:
2288: IF l_lrev_tbl.COUNT > 0 THEN
2289:
2290: okl_lre_pvt.delete_row (
2291: p_api_version => G_API_VERSION
2292: ,p_init_msg_list => G_FALSE
2293: ,x_return_status => x_return_status
2294: ,x_msg_count => x_msg_count