8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_API_TYPE CONSTANT VARCHAR2(4) := '_PUB';
10:
11: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
12: subtype stmv_rec_type IS OKL_STREAMS_PUB.stmv_rec_type;
13: subtype selv_rec_type IS OKL_STREAMS_PUB.selv_rec_type;
14: subtype selv_tbl_type IS OKL_STREAMS_PUB.selv_tbl_type;
15: subtype khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
16: subtype chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
9: G_API_TYPE CONSTANT VARCHAR2(4) := '_PUB';
10:
11: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
12: subtype stmv_rec_type IS OKL_STREAMS_PUB.stmv_rec_type;
13: subtype selv_rec_type IS OKL_STREAMS_PUB.selv_rec_type;
14: subtype selv_tbl_type IS OKL_STREAMS_PUB.selv_tbl_type;
15: subtype khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
16: subtype chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
17:
10:
11: -- subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
12: subtype stmv_rec_type IS OKL_STREAMS_PUB.stmv_rec_type;
13: subtype selv_rec_type IS OKL_STREAMS_PUB.selv_rec_type;
14: subtype selv_tbl_type IS OKL_STREAMS_PUB.selv_tbl_type;
15: subtype khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
16: subtype chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
17:
18:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
230: p_stream_status IN OKL_STREAMS.SAY_CODE%TYPE
231: ) IS
232:
233: l_api_name VARCHAR2(35) := 'sync_rebook_stream';
234: l_proc_name VARCHAR2(35) := 'SYNC_REBOOK_STREAM';