APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SERVICE_INTEGRATION_PUB

Line 447: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

443: ) IS
444:
445: x_msg_count NUMBER;
446: x_msg_data VARCHAR2(256);
447: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
448: x_service_contract_id NUMBER;
449:
450: i NUMBER;
451:

Line 469: Okl_Service_Integration_Pub.get_service_link_line (

465:
466: -- initialize return status
467: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
468:
469: Okl_Service_Integration_Pub.get_service_link_line (
470: p_api_version => 1.0,
471: p_init_msg_list => Okl_Api.G_FALSE,
472: x_return_status => x_return_status,
473: x_msg_count => x_msg_count,

Line 598: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

594: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
595:
596: x_msg_count NUMBER;
597: x_msg_data VARCHAR2(256);
598: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
599: x_service_contract_id NUMBER;
600:
601: l_svclne l_svclne_csr%ROWTYPE;
602:

Line 611: Okl_Service_Integration_Pub.get_service_link_line (

607:
608: -- initialize return status
609: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
610:
611: Okl_Service_Integration_Pub.get_service_link_line (
612: p_api_version => 1.0,
613: p_init_msg_list => Okl_Api.G_FALSE,
614: x_return_status => x_return_status,
615: x_msg_count => x_msg_count,

Line 688: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

684: ) IS
685:
686: x_msg_count NUMBER;
687: x_msg_data VARCHAR2(256);
688: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
689: x_service_contract_id NUMBER;
690:
691: CURSOR srv_csr (p_serv_top_line_id NUMBER) IS
692: SELECT item_id inventory_item_id,

Line 715: Okl_Service_Integration_Pub.get_service_link_line (

711:
712: -- initialize return status
713: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
714:
715: Okl_Service_Integration_Pub.get_service_link_line (
716: p_api_version => 1.0,
717: p_init_msg_list => Okl_Api.G_FALSE,
718: x_return_status => x_return_status,
719: x_msg_count => x_msg_count,

Line 870: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

866: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
867:
868: x_msg_count NUMBER;
869: x_msg_data VARCHAR2(256);
870: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
871: x_service_contract_id NUMBER;
872:
873: CURSOR srv_amt_csr (p_serv_top_line_id NUMBER) IS
874: SELECT item_id inventory_item_id,

Line 894: Okl_Service_Integration_Pub.get_service_link_line (

890:
891: -- initialize return status
892: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
893:
894: Okl_Service_Integration_Pub.get_service_link_line (
895: p_api_version => 1.0,
896: p_init_msg_list => Okl_Api.G_FALSE,
897: x_return_status => x_return_status,
898: x_msg_count => x_msg_count,