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_SERVICE_INTEGRATION_PVT dependencies on OKC_K_LINES_V

Line 171: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID

167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
170: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
171: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
172: p_supplier_id IN NUMBER, -- OKL_VENDOR
173: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Contract Service TOP Line ID
174: )IS
175:

Line 173: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Contract Service TOP Line ID

169: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
170: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
171: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
172: p_supplier_id IN NUMBER, -- OKL_VENDOR
173: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Contract Service TOP Line ID
174: )IS
175:
176: l_api_name VARCHAR2(35) := 'create_link_service_line';
177: l_proc_name VARCHAR2(35) := 'CREATE_LINK_SERVICE_LINE';

Line 612: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID

608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
611: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
612: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
613: p_supplier_id IN NUMBER,
614: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Contract Service TOP Line ID
615: )IS
616: l_api_name VARCHAR2(35) := 'create_service_line';

Line 614: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Contract Service TOP Line ID

610: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
611: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
612: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
613: p_supplier_id IN NUMBER,
614: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Contract Service TOP Line ID
615: )IS
616: l_api_name VARCHAR2(35) := 'create_service_line';
617: l_proc_name VARCHAR2(35) := 'CREATE_SERVICE_LINE';
618: l_api_version CONSTANT NUMBER := 1;

Line 633: price_negotiated okc_k_lines_v.price_negotiated%type,

629:
630: TYPE srv_okl_rec_type IS RECORD (
631: item_id mtl_system_items.inventory_item_id%type,
632: item_name mtl_system_items.description%type,
633: price_negotiated okc_k_lines_v.price_negotiated%type,
634: fin_line_id okc_k_lines_v.id%type,
635: asset_number okc_k_lines_v.name%type,
636: okl_no_of_item number,
637: srv_no_of_item number

Line 634: fin_line_id okc_k_lines_v.id%type,

630: TYPE srv_okl_rec_type IS RECORD (
631: item_id mtl_system_items.inventory_item_id%type,
632: item_name mtl_system_items.description%type,
633: price_negotiated okc_k_lines_v.price_negotiated%type,
634: fin_line_id okc_k_lines_v.id%type,
635: asset_number okc_k_lines_v.name%type,
636: okl_no_of_item number,
637: srv_no_of_item number
638: );

Line 635: asset_number okc_k_lines_v.name%type,

631: item_id mtl_system_items.inventory_item_id%type,
632: item_name mtl_system_items.description%type,
633: price_negotiated okc_k_lines_v.price_negotiated%type,
634: fin_line_id okc_k_lines_v.id%type,
635: asset_number okc_k_lines_v.name%type,
636: okl_no_of_item number,
637: srv_no_of_item number
638: );
639:

Line 647: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS

643: l_srv_okl_tbl srv_okl_tbl_type;
644:
645: /*
646: CURSOR srv_okl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
647: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS
648: SELECT srv_prod.inventory_item_id item_id,
649: srv_prod.name item_name,
650: srv_line.price_negotiated,
651: okl_fin_line.id fin_line_id,

Line 662: okc_k_lines_v okl_fin_line,

658: okx_customer_products_v srv_prod,
659: okc_k_items okl_item,
660: mtl_system_items_b okl_mtl,
661: okc_k_lines_b okl_item_line,
662: okc_k_lines_v okl_fin_line,
663: okc_line_styles_b okl_style
664: WHERE srv_line.lse_id = srv_style.id
665: AND srv_line.id = srv_item.cle_id
666: AND srv_item.object1_id1 = srv_prod.id1

Line 684: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS

680: */
681:
682:
683: CURSOR srv_amt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
684: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS
685: SELECT nvl(sum(l.price_negotiated),0) tot_amount
686: FROM okc_k_lines_v l,
687: okc_line_styles_v s,
688: okc_k_items_v item,

Line 686: FROM okc_k_lines_v l,

682:
683: CURSOR srv_amt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
684: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS
685: SELECT nvl(sum(l.price_negotiated),0) tot_amount
686: FROM okc_k_lines_v l,
687: okc_line_styles_v s,
688: okc_k_items_v item,
689: okx_install_items_v prod
690: WHERE l.lse_id = s.id

Line 697: okc_k_lines_v line,

693: AND EXISTS (
694: SELECT 'Y'
695: FROM okc_k_items_v item,
696: okx_system_items_v mtl,
697: okc_k_lines_v line,
698: okc_line_styles_v style
699: WHERE item.object1_id1 = mtl.id1
700: AND item.object1_id2 = TO_CHAR(mtl.id2) -- Bug# 2887948
701: AND item.cle_id = line.id

Line 715: CURSOR srv_line_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS

711: AND l.cle_id = nvl(p_srv_line_id,l.cle_id);
712: --AND prod.organization_id = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID');
713:
714:
715: CURSOR srv_line_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
716: SELECT start_date,
717: end_date
718: FROM okc_k_lines_v
719: WHERE id = p_line_id;

Line 718: FROM okc_k_lines_v

714:
715: CURSOR srv_line_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
716: SELECT start_date,
717: end_date
718: FROM okc_k_lines_v
719: WHERE id = p_line_id;
720:
721: CURSOR lease_con_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
722: SELECT start_date,

Line 729: CURSOR item_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS

725: FROM okc_k_headers_v
726: WHERE id = p_chr_id;
727:
728:
729: CURSOR item_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
730: SELECT object1_id1,
731: object1_id2,
732: uom_code
733: FROM okc_k_items_v

Line 737: l_lse_id OKC_K_LINES_V.LSE_ID%TYPE;

733: FROM okc_k_items_v
734: WHERE cle_id = p_cle_id
735: AND jtot_object1_code = 'OKX_SERVICE';
736:
737: l_lse_id OKC_K_LINES_V.LSE_ID%TYPE;
738: l_currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
739: l_srv_amount NUMBER;
740: x_cle_id OKC_K_LINES_V.ID%TYPE;
741:

Line 740: x_cle_id OKC_K_LINES_V.ID%TYPE;

736:
737: l_lse_id OKC_K_LINES_V.LSE_ID%TYPE;
738: l_currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
739: l_srv_amount NUMBER;
740: x_cle_id OKC_K_LINES_V.ID%TYPE;
741:
742: l_srv_st_date OKC_K_LINES_V.START_DATE%TYPE;
743: l_srv_end_date OKC_K_LINES_V.START_DATE%TYPE;
744: l_lease_st_date OKC_K_LINES_V.START_DATE%TYPE;

Line 742: l_srv_st_date OKC_K_LINES_V.START_DATE%TYPE;

738: l_currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE;
739: l_srv_amount NUMBER;
740: x_cle_id OKC_K_LINES_V.ID%TYPE;
741:
742: l_srv_st_date OKC_K_LINES_V.START_DATE%TYPE;
743: l_srv_end_date OKC_K_LINES_V.START_DATE%TYPE;
744: l_lease_st_date OKC_K_LINES_V.START_DATE%TYPE;
745: l_lease_end_date OKC_K_LINES_V.START_DATE%TYPE;
746:

Line 743: l_srv_end_date OKC_K_LINES_V.START_DATE%TYPE;

739: l_srv_amount NUMBER;
740: x_cle_id OKC_K_LINES_V.ID%TYPE;
741:
742: l_srv_st_date OKC_K_LINES_V.START_DATE%TYPE;
743: l_srv_end_date OKC_K_LINES_V.START_DATE%TYPE;
744: l_lease_st_date OKC_K_LINES_V.START_DATE%TYPE;
745: l_lease_end_date OKC_K_LINES_V.START_DATE%TYPE;
746:
747: l_inv_item_id NUMBER;

Line 744: l_lease_st_date OKC_K_LINES_V.START_DATE%TYPE;

740: x_cle_id OKC_K_LINES_V.ID%TYPE;
741:
742: l_srv_st_date OKC_K_LINES_V.START_DATE%TYPE;
743: l_srv_end_date OKC_K_LINES_V.START_DATE%TYPE;
744: l_lease_st_date OKC_K_LINES_V.START_DATE%TYPE;
745: l_lease_end_date OKC_K_LINES_V.START_DATE%TYPE;
746:
747: l_inv_item_id NUMBER;
748: l_inv_org_id NUMBER;

Line 745: l_lease_end_date OKC_K_LINES_V.START_DATE%TYPE;

741:
742: l_srv_st_date OKC_K_LINES_V.START_DATE%TYPE;
743: l_srv_end_date OKC_K_LINES_V.START_DATE%TYPE;
744: l_lease_st_date OKC_K_LINES_V.START_DATE%TYPE;
745: l_lease_end_date OKC_K_LINES_V.START_DATE%TYPE;
746:
747: l_inv_item_id NUMBER;
748: l_inv_org_id NUMBER;
749:

Line 1155: p_okl_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Lease Service Top Line ID

1151: x_msg_count OUT NOCOPY NUMBER,
1152: x_msg_data OUT NOCOPY VARCHAR2,
1153: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
1154: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
1155: p_okl_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Lease Service Top Line ID
1156: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE -- Service Contract - Service TOP Line ID
1157: ) IS
1158:
1159: l_api_name VARCHAR2(35) := 'link_service_line';

Line 1156: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE -- Service Contract - Service TOP Line ID

1152: x_msg_data OUT NOCOPY VARCHAR2,
1153: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
1154: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
1155: p_okl_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Lease Service Top Line ID
1156: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE -- Service Contract - Service TOP Line ID
1157: ) IS
1158:
1159: l_api_name VARCHAR2(35) := 'link_service_line';
1160: l_proc_name VARCHAR2(35) := 'LINK_SERVICE_LINE';

Line 1167: l_oks_service_line_id OKC_K_LINES_V.ID%TYPE;

1163: l_crjv_rec crjv_rec_type;
1164: x_crjv_rec crjv_rec_type;
1165:
1166: l_service_contract_id OKC_K_HEADERS_V.ID%TYPE;
1167: l_oks_service_line_id OKC_K_LINES_V.ID%TYPE;
1168:
1169: BEGIN -- main process begins here
1170: IF (G_DEBUG_ENABLED = 'Y') THEN
1171: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 1378: CURSOR line_link_csr (p_okl_service_line_id OKC_K_LINES_V.ID%TYPE) IS

1374: l_api_name VARCHAR2(35) := 'delete_service_link';
1375: l_proc_name VARCHAR2(35) := 'DELETE_SERVICE_LINK';
1376: l_api_version CONSTANT NUMBER := 1;
1377:
1378: CURSOR line_link_csr (p_okl_service_line_id OKC_K_LINES_V.ID%TYPE) IS
1379: SELECT id
1380: FROM okc_k_rel_objs_v
1381: WHERE cle_id = p_okl_service_line_id
1382: AND rty_code = 'OKLSRV' -- ???

Line 1643: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID

1639: x_msg_count OUT NOCOPY NUMBER,
1640: x_msg_data OUT NOCOPY VARCHAR2,
1641: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
1642: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
1643: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
1644: p_supplier_id IN NUMBER,
1645: p_clev_rec IN clev_rec_type,
1646: p_klev_rec IN klev_rec_type,
1647: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

Line 1647: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

1643: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
1644: p_supplier_id IN NUMBER,
1645: p_clev_rec IN clev_rec_type,
1646: p_klev_rec IN klev_rec_type,
1647: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
1648: ) IS
1649: l_api_name VARCHAR2(35) := 'update_service_link';
1650: l_proc_name VARCHAR2(35) := 'UPDATE_SERVICE_LINK';
1651: l_api_version CONSTANT NUMBER := 1;

Line 1778: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE,

1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_msg_count OUT NOCOPY NUMBER,
1776: x_msg_data OUT NOCOPY VARCHAR2,
1777: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
1778: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE,
1779: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
1780: ) IS
1781: l_api_name VARCHAR2(35) := 'check_service_line_link';
1782: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINE_LINK';

Line 1794: p_line_id OKC_K_LINES_V.ID%TYPE) IS

1790: AND cle_id IS NULL
1791: AND rty_code = 'OKLSRV'; -- ???
1792:
1793: CURSOR line_link_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1794: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1795: SELECT 'Y' answer
1796: FROM okc_k_rel_objs_v
1797: WHERE chr_id = p_chr_id
1798: AND object1_id1 = p_line_id

Line 2492: p_okl_cov_line_id IN OKC_K_LINES_V.ID%TYPE,

2488: x_return_status OUT NOCOPY VARCHAR2,
2489: x_msg_count OUT NOCOPY NUMBER,
2490: x_msg_data OUT NOCOPY VARCHAR2,
2491: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2492: p_okl_cov_line_id IN OKC_K_LINES_V.ID%TYPE,
2493: p_oks_cov_line_id IN OKC_K_LINES_V.ID%TYPE
2494: ) IS
2495:
2496: l_proc_name VARCHAR2(35) := 'CREATE_COV_LINE_LINK';

Line 2493: p_oks_cov_line_id IN OKC_K_LINES_V.ID%TYPE

2489: x_msg_count OUT NOCOPY NUMBER,
2490: x_msg_data OUT NOCOPY VARCHAR2,
2491: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2492: p_okl_cov_line_id IN OKC_K_LINES_V.ID%TYPE,
2493: p_oks_cov_line_id IN OKC_K_LINES_V.ID%TYPE
2494: ) IS
2495:
2496: l_proc_name VARCHAR2(35) := 'CREATE_COV_LINE_LINK';
2497:

Line 2498: CURSOR cov_link_csr (p_okl_line_id OKC_K_LINES_V.ID%TYPE,

2494: ) IS
2495:
2496: l_proc_name VARCHAR2(35) := 'CREATE_COV_LINE_LINK';
2497:
2498: CURSOR cov_link_csr (p_okl_line_id OKC_K_LINES_V.ID%TYPE,
2499: p_oks_line_id OKC_K_LINES_V.ID%TYPE) IS
2500: SELECT ID
2501: FROM okc_k_rel_objs_v
2502: WHERE cle_id = p_okl_line_id

Line 2499: p_oks_line_id OKC_K_LINES_V.ID%TYPE) IS

2495:
2496: l_proc_name VARCHAR2(35) := 'CREATE_COV_LINE_LINK';
2497:
2498: CURSOR cov_link_csr (p_okl_line_id OKC_K_LINES_V.ID%TYPE,
2499: p_oks_line_id OKC_K_LINES_V.ID%TYPE) IS
2500: SELECT ID
2501: FROM okc_k_rel_objs_v
2502: WHERE cle_id = p_okl_line_id
2503: AND object1_id1 = p_oks_line_id

Line 2620: p_srv_top_id OKC_K_LINES_V.ID%TYPE,

2616: l_api_version CONSTANT NUMBER := 1;
2617:
2618:
2619: CURSOR cov_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2620: p_srv_top_id OKC_K_LINES_V.ID%TYPE,
2621: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS
2622: SELECT 'Y',
2623: item_description,
2624: srv_prod_instance_id

Line 2812: p_srv_top_id OKC_K_LINES_V.ID%TYPE,

2808: l_api_version CONSTANT NUMBER := 1;
2809:
2810:
2811: CURSOR cov_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2812: p_srv_top_id OKC_K_LINES_V.ID%TYPE,
2813: p_asset OKL_LA_COV_ASSET_UV.NAME%TYPE) IS
2814: SELECT 'Y'
2815: FROM okl_la_cov_asset_uv
2816: WHERE chr_id = p_chr_id

Line 3409: p_free_form1_id IN OKC_K_LINES_V.ID%TYPE,

3405: x_return_status OUT NOCOPY VARCHAR2,
3406: x_msg_count OUT NOCOPY NUMBER,
3407: x_msg_data OUT NOCOPY VARCHAR2,
3408: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3409: p_free_form1_id IN OKC_K_LINES_V.ID%TYPE,
3410: p_okl_srv_line_id IN OKC_K_LINES_V.ID%TYPE
3411: ) IS
3412:
3413: l_proc_name VARCHAR2(35) := 'process_serial_item';

Line 3410: p_okl_srv_line_id IN OKC_K_LINES_V.ID%TYPE

3406: x_msg_count OUT NOCOPY NUMBER,
3407: x_msg_data OUT NOCOPY VARCHAR2,
3408: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3409: p_free_form1_id IN OKC_K_LINES_V.ID%TYPE,
3410: p_okl_srv_line_id IN OKC_K_LINES_V.ID%TYPE
3411: ) IS
3412:
3413: l_proc_name VARCHAR2(35) := 'process_serial_item';
3414:

Line 3551: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

3547: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
3548: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
3549: p_supplier_id IN NUMBER, -- OKL_VENDOR
3550: p_sty_id IN OKL_K_LINES.STY_ID%TYPE DEFAULT NULL, -- Bug 4011710
3551: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
3552: ) IS
3553:
3554: l_api_name VARCHAR2(35) := 'create_service_from_oks';
3555: l_proc_name VARCHAR2(35) := 'CREATE_SERVICE_FROM_OKS';

Line 3578: CURSOR oks_cov_csr(p_oks_serv_id OKC_K_LINES_V.ID%TYPE) IS

3574: SELECT DISTINCT cle_id
3575: FROM okl_la_link_service_uv9
3576: WHERE chr_id = p_oks_chr_id;
3577:
3578: CURSOR oks_cov_csr(p_oks_serv_id OKC_K_LINES_V.ID%TYPE) IS
3579: SELECT line.id,
3580: line.price_negotiated
3581: FROM okc_k_lines_b line,
3582: okc_line_styles_v style

Line 3592: CURSOR okl_asset_csr (p_oks_cov_line_id OKC_K_LINES_V.ID%TYPE,

3588: WHERE TO_CHAR(line.id) = rel.object1_id1
3589: AND jtot_object1_code = 'OKL_COV_PROD'
3590: AND rty_code = 'OKLSRV'); -- to pickup only non-linked lines
3591:
3592: CURSOR okl_asset_csr (p_oks_cov_line_id OKC_K_LINES_V.ID%TYPE,
3593: p_okl_serv_line_id OKC_K_LINES_V.ID%TYPE) IS
3594: SELECT name,
3595: id1,
3596: id2 --,

Line 3593: p_okl_serv_line_id OKC_K_LINES_V.ID%TYPE) IS

3589: AND jtot_object1_code = 'OKL_COV_PROD'
3590: AND rty_code = 'OKLSRV'); -- to pickup only non-linked lines
3591:
3592: CURSOR okl_asset_csr (p_oks_cov_line_id OKC_K_LINES_V.ID%TYPE,
3593: p_okl_serv_line_id OKC_K_LINES_V.ID%TYPE) IS
3594: SELECT name,
3595: id1,
3596: id2 --,
3597: --lease_item_qty,

Line 3614: CURSOR check_serial_csr (p_okl_service_id OKC_K_LINES_V.ID%TYPE) IS

3610: AND line.id = cov_item.cle_id
3611: AND line.id = cov_asset.serv_top_line_id
3612: AND line.sts_code <> 'ABANDONED');
3613:
3614: CURSOR check_serial_csr (p_okl_service_id OKC_K_LINES_V.ID%TYPE) IS
3615: SELECT distinct id1
3616: FROM okl_la_cov_asset_uv
3617: WHERE serv_top_line_id = p_okl_service_id
3618: AND serial_number_control_code <> 1; -- serial item

Line 4347: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

4343: AND kitem.jtot_object1_code = 'OKX_COVASST'
4344: AND rel.chr_id = p_chr_id;
4345:
4346: CURSOR inst_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
4347: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
4348: SELECT kitem.id,
4349: kitem.object1_id1,
4350: kitem.cle_id
4351: FROM okc_k_lines_b form2,

Line 4554: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

4550: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
4551: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
4552: p_supplier_id IN NUMBER, -- OKL_VENDOR
4553: p_sty_id IN OKL_K_LINES.STY_ID%TYPE DEFAULT NULL, -- Bug 4011710
4554: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
4555: ) IS
4556:
4557: l_api_name VARCHAR2(35) := 'relink_service_contract';
4558: l_proc_name VARCHAR2(35) := 'RELINK_SERVICE_CONTRACT';