APPS.OKL_STREAMS_PVT dependencies on OKL_STREAMS

Line 1: PACKAGE BODY Okl_Streams_Pvt AS

1: PACKAGE BODY Okl_Streams_Pvt AS
2: /* $Header: OKLCSTMB.pls 120.3 2005/07/05 05:25:47 mansrini noship $ */
3:
4: PROCEDURE create_streams(
5: p_api_version IN NUMBER

Line 127: -- assuming that stm_id in the okl_strm_elements table is referring to id in the okl_streams table

123: -- populate the foreign keys for the detail
124: if(l_selv_tbl.count > 0) then
125: i:=l_selv_tbl.FIRST;
126: loop
127: -- assuming that stm_id in the okl_strm_elements table is referring to id in the okl_streams table
128: l_selv_tbl(i).stm_id:=x_stmv_tbl(i).id;
129: exit when(i=l_selv_tbl.last);
130: i :=l_selv_tbl.next(i);
131: end loop;

Line 1224: INSERT INTO OKL_STREAMS_H

1220:
1221: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1222:
1223:
1224: INSERT INTO OKL_STREAMS_H
1225: (
1226: major_version,
1227: ID,
1228: TRANSACTION_NUMBER,

Line 1290: FROM OKL_STREAMS

1286: --HKPATEL changed for bug 4212626
1287: TRX_ID,
1288: LINK_HIST_STREAM_ID
1289:
1290: FROM OKL_STREAMS
1291: WHERE
1292: say_code = 'CURR' and
1293: khr_id = p_khr_id;
1294:

Line 1386: WHERE stm_id in (Select id from OKL_STREAMS where khr_id = p_khr_id and say_code ='CURR');

1382: BILL_ADJ_FLAG,
1383: ACCRUAL_ADJ_FLAG
1384:
1385: FROM OKL_STRM_ELEMENTS
1386: WHERE stm_id in (Select id from OKL_STREAMS where khr_id = p_khr_id and say_code ='CURR');
1387:
1388: EXCEPTION
1389: -- other appropriate handlers
1390: WHEN OTHERS THEN

Line 1422: from OKL_STREAMS_H

1418: where id = l_khr_id;
1419:
1420: Cursor l_strm_csr(l_khr_id NUMBER, l_major_version NUMBER) Is
1421: select 'x'
1422: from OKL_STREAMS_H
1423: where khr_id = l_khr_id and major_version = l_major_version ;
1424:
1425: l_strm_val varchar2(1);
1426: l_cntrct_val varchar2(1);

Line 1511: END Okl_Streams_Pvt;

1507:
1508:
1509: END version_stream;
1510:
1511: END Okl_Streams_Pvt;