DBA Data[Home] [Help]

APPS.OKL_PRCTIMEOUT_PVT dependencies on OKL_STREAM_INTERFACES

Line 24: FROM OKL_STREAM_INTERFACES

20:
21: CURSOR l_okl_prctimeout_csr
22: IS
23: SELECT ID, DATE_PROCESSED, ORP_CODE,KHR_ID
24: FROM OKL_STREAM_INTERFACES
25: WHERE sis_code IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST, G_SIS_RET_DATA_RECEIVED);
26:
27: l_okl_prctimeout_rec l_okl_prctimeout_csr%ROWTYPE;
28: l_date_processed DATE;

Line 72: okl_stream_interfaces_pub.update_stream_interfaces(

68: lp_sifv_rec.id := l_okl_prctimeout_rec.id;
69: lp_sifv_rec.sis_code := G_SIS_TIME_OUT;
70: lp_sifv_rec.orp_code := l_okl_prctimeout_rec.orp_code;
71:
72: okl_stream_interfaces_pub.update_stream_interfaces(
73: p_api_version => l_api_version,
74: p_init_msg_list => l_init_msg_list ,
75: x_return_status => l_return_status,
76: x_msg_count => l_msg_count,