DBA Data[Home] [Help]

APPS.OKL_STREAMS_PVT dependencies on OKL_STRM_ELEMENTS

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 636: FROM OKL_STRM_ELEMENTS sel

632: l_selv_tbl selv_tbl_type;
633:
634: CURSOR sel_csr IS
635: SELECT sel.id
636: FROM OKL_STRM_ELEMENTS sel
637: WHERE sel.stm_id = p_stmv_rec.id;
638: BEGIN
639: FOR sel_rec IN sel_csr
640: LOOP

Line 1329: INSERT INTO OKL_STRM_ELEMENTS_H

1325:
1326: BEGIN
1327:
1328:
1329: INSERT INTO OKL_STRM_ELEMENTS_H
1330: (
1331: MAJOR_VERSION,
1332: ID ,
1333: SE_LINE_NUMBER ,

Line 1385: FROM OKL_STRM_ELEMENTS

1381: --HKPATEL changed for bug 4212626
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