APPS.OKL_CS_LEASE_RENEWAL_PVT dependencies on OKL_STREAM_INTERFACES

Line 62: FROM okl_stream_interfaces

58:
59: CURSOR c_supertrump_csr (a_id IN NUMBER)
60: IS
61: SELECT sis_code
62: FROM okl_stream_interfaces
63: WHERE ID=a_id;
64:
65: l_status_code VARCHAR2(80);
66: l_object1_id1 VARCHAR2(40);

Line 78: IF l_object1_code = 'OKL_STREAM_INTERFACES' THEN

74: CLOSE c_cs_Status_csr;
75:
76: IF l_status_code='SUBMITTED_CALCULATION' THEN
77: --Still not processed, Check for the status in Streams table.
78: IF l_object1_code = 'OKL_STREAM_INTERFACES' THEN
79: open c_supertrump_csr(l_object1_id1);
80: FETCH c_supertrump_csr INTO l_sis_code;
81: CLOSE c_supertrump_csr;
82: END IF;

Line 1055: l_trqv_tbl(1).jtot_object1_code := 'OKL_STREAM_INTERFACES';

1051: END IF;
1052:
1053: l_trqv_tbl(1).id := x_trqv_tbl(1).id;
1054: l_trqv_tbl(1).object_version_number := l_object_version_number;
1055: l_trqv_tbl(1).jtot_object1_code := 'OKL_STREAM_INTERFACES';
1056: l_trqv_tbl(1).object1_id1 := l_trans_id;
1057:
1058: --Call update here.
1059: okl_trx_requests_pub.update_trx_requests(