APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_SERVICE_INTEGRATION_PUB

Line 467: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

463: ) IS
464:
465: x_msg_count NUMBER;
466: x_msg_data VARCHAR2(256);
467: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
468: x_service_contract_id NUMBER;
469:
470: i NUMBER;
471:

Line 489: Okl_Service_Integration_Pub.get_service_link_line (

485:
486: -- initialize return status
487: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
488:
489: Okl_Service_Integration_Pub.get_service_link_line (
490: p_api_version => 1.0,
491: p_init_msg_list => Okl_Api.G_FALSE,
492: x_return_status => x_return_status,
493: x_msg_count => x_msg_count,

Line 618: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

614: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
615:
616: x_msg_count NUMBER;
617: x_msg_data VARCHAR2(256);
618: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
619: x_service_contract_id NUMBER;
620:
621: l_svclne l_svclne_csr%ROWTYPE;
622:

Line 631: Okl_Service_Integration_Pub.get_service_link_line (

627:
628: -- initialize return status
629: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
630:
631: Okl_Service_Integration_Pub.get_service_link_line (
632: p_api_version => 1.0,
633: p_init_msg_list => Okl_Api.G_FALSE,
634: x_return_status => x_return_status,
635: x_msg_count => x_msg_count,

Line 708: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

704: ) IS
705:
706: x_msg_count NUMBER;
707: x_msg_data VARCHAR2(256);
708: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
709: x_service_contract_id NUMBER;
710:
711: CURSOR srv_csr (p_serv_top_line_id NUMBER) IS
712: SELECT item_id inventory_item_id,

Line 735: Okl_Service_Integration_Pub.get_service_link_line (

731:
732: -- initialize return status
733: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
734:
735: Okl_Service_Integration_Pub.get_service_link_line (
736: p_api_version => 1.0,
737: p_init_msg_list => Okl_Api.G_FALSE,
738: x_return_status => x_return_status,
739: x_msg_count => x_msg_count,

Line 890: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;

886: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
887:
888: x_msg_count NUMBER;
889: x_msg_data VARCHAR2(256);
890: x_link_line_tbl Okl_Service_Integration_Pub.LINK_LINE_TBL_TYPE;
891: x_service_contract_id NUMBER;
892:
893: CURSOR srv_amt_csr (p_serv_top_line_id NUMBER) IS
894: SELECT item_id inventory_item_id,

Line 914: Okl_Service_Integration_Pub.get_service_link_line (

910:
911: -- initialize return status
912: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
913:
914: Okl_Service_Integration_Pub.get_service_link_line (
915: p_api_version => 1.0,
916: p_init_msg_list => Okl_Api.G_FALSE,
917: x_return_status => x_return_status,
918: x_msg_count => x_msg_count,