DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on OKL_STREAMS

Line 112: ,STY_ID okl_streams.STY_ID%TYPE := NULL--NUMBER

108: ,VENDOR_ID1 okx_vendors_v.ID1%TYPE := NULL--NUMBER
109: ,OEC_FROM okl_k_lines.OEC%TYPE := NULL--NUMBER(14,3)
110: ,OEC_TO okl_k_lines.OEC%TYPE := NULL--NUMBER(14,3)
111: ,RESIDUAL_PERCENTAGE okl_k_lines.residual_percentage%TYPE := NULL--NUMBER(5,2)
112: ,STY_ID okl_streams.STY_ID%TYPE := NULL--NUMBER
113: ,STREAM_TYPE_CODE okl_strm_type_v.CODE%TYPE := NULL --VARCHAR2(150)
114: ,STREAM_TYPE_NAME okl_strm_type_v.NAME%TYPE := NULL --VARCHAR2(150)
115: ,STREAM_SAY_CODE okl_streams.SAY_CODE%TYPE := NULL --VARCHAR2(30)
116: ,STREAM_ACTIVE_YN okl_streams.ACTIVE_YN%TYPE := NULL --VARCHAR2(3)

Line 115: ,STREAM_SAY_CODE okl_streams.SAY_CODE%TYPE := NULL --VARCHAR2(30)

111: ,RESIDUAL_PERCENTAGE okl_k_lines.residual_percentage%TYPE := NULL--NUMBER(5,2)
112: ,STY_ID okl_streams.STY_ID%TYPE := NULL--NUMBER
113: ,STREAM_TYPE_CODE okl_strm_type_v.CODE%TYPE := NULL --VARCHAR2(150)
114: ,STREAM_TYPE_NAME okl_strm_type_v.NAME%TYPE := NULL --VARCHAR2(150)
115: ,STREAM_SAY_CODE okl_streams.SAY_CODE%TYPE := NULL --VARCHAR2(30)
116: ,STREAM_ACTIVE_YN okl_streams.ACTIVE_YN%TYPE := NULL --VARCHAR2(3)
117: ,STREAM_ELEMENT_FROM_DATE okl_strm_elements.STREAM_ELEMENT_DATE%TYPE := NULL --DATE
118: ,STREAM_ELEMENT_TO_DATE okl_strm_elements.STREAM_ELEMENT_DATE%TYPE := NULL --DATE
119: ,STREAM_ELEMENT_AMOUNT okl_strm_elements.AMOUNT%TYPE := NULL--NUMBER(14,3)

Line 116: ,STREAM_ACTIVE_YN okl_streams.ACTIVE_YN%TYPE := NULL --VARCHAR2(3)

112: ,STY_ID okl_streams.STY_ID%TYPE := NULL--NUMBER
113: ,STREAM_TYPE_CODE okl_strm_type_v.CODE%TYPE := NULL --VARCHAR2(150)
114: ,STREAM_TYPE_NAME okl_strm_type_v.NAME%TYPE := NULL --VARCHAR2(150)
115: ,STREAM_SAY_CODE okl_streams.SAY_CODE%TYPE := NULL --VARCHAR2(30)
116: ,STREAM_ACTIVE_YN okl_streams.ACTIVE_YN%TYPE := NULL --VARCHAR2(3)
117: ,STREAM_ELEMENT_FROM_DATE okl_strm_elements.STREAM_ELEMENT_DATE%TYPE := NULL --DATE
118: ,STREAM_ELEMENT_TO_DATE okl_strm_elements.STREAM_ELEMENT_DATE%TYPE := NULL --DATE
119: ,STREAM_ELEMENT_AMOUNT okl_strm_elements.AMOUNT%TYPE := NULL--NUMBER(14,3)
120: ,POL_ID OKL_POOL_CONTENTS.POL_ID%TYPE --NUMBER

Line 689: ,p_stm_id IN okl_streams.id%TYPE

685: ,x_return_status OUT NOCOPY VARCHAR2
686: ,x_msg_count OUT NOCOPY NUMBER
687: ,x_msg_data OUT NOCOPY VARCHAR2
688: ,p_poc_id IN okl_pool_contents.id%TYPE
689: ,p_stm_id IN okl_streams.id%TYPE
690: ,x_amount OUT NOCOPY NUMBER
691: );
692:
693: ----------------------------------------------------------------------------------