[Home] [Help]
80: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
81: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;
87: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
88: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
81: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;
87: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
88: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
89:
82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;
87: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
88: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
89:
90: --vdamerla bug 5474844
908:
909:
910:
911:
912: Okl_Sel_Pvt.insert_row(
913: p_api_version,
914: p_init_msg_list,
915: x_return_status,
916: x_msg_count,
1045: l_selv_rec.source_id := cur_sec_strm.khr_id;
1046: l_selv_rec.source_table := 'OKL_K_HEADERS';
1047: END IF;
1048:
1049: Okl_Sel_Pvt.insert_row(
1050: p_api_version,
1051: p_init_msg_list,
1052: x_return_status,
1053: x_msg_count,
1196: l_selv_rec.source_id := cur_sec_strm.khr_id;
1197: l_selv_rec.source_table := 'OKL_K_HEADERS';
1198: END IF;
1199:
1200: Okl_Sel_Pvt.insert_row(
1201: p_api_version,
1202: p_init_msg_list,
1203: x_return_status,
1204: x_msg_count,
1606: CLOSE c_AR_source_sel;
1607: l_selv_rec.source_table := cns_AR_source_table;
1608: end if;
1609:
1610: Okl_Sel_Pvt.insert_row(
1611: p_api_version,
1612: p_init_msg_list,
1613: x_return_status,
1614: x_msg_count,
1753: --@IMPORTANT@ Uncomment out this code once lsm_id is added to okl_strm_elements
1754: --l_selv_rec.lsm_id := cur_sec_strm.cnsld_strm_id;
1755: l_selv_rec.sel_id := l_sel_id;
1756:
1757: Okl_Sel_Pvt.insert_row(
1758: p_api_version,
1759: p_init_msg_list,
1760: x_return_status,
1761: x_msg_count,
1907: l_selv_rec.source_id := cur_sec_strm.khr_id;
1908: l_selv_rec.source_table := 'OKL_K_HEADERS';
1909: END IF;
1910:
1911: Okl_Sel_Pvt.insert_row(
1912: p_api_version,
1913: p_init_msg_list,
1914: x_return_status,
1915: x_msg_count,