eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POOL_PVT dependencies on OKL_POOL_CONTENTS

Line 120: ,POL_ID OKL_POOL_CONTENTS.POL_ID%TYPE --NUMBER

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
121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search
122: ,STREAMS_FROM_DATE OKL_POOL_CONTENTS.STREAMS_FROM_DATE%TYPE := NULL --DATE
123: ,STREAMS_TO_DATE OKL_POOL_CONTENTS.STREAMS_TO_DATE%TYPE := NULL --DATE
124: ,STREAM_ELEMENT_PAYMENT_FREQ okl_time_units_v.NAME%TYPE := NULL -- VARCHAR2(80)

Line 121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search

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
121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search
122: ,STREAMS_FROM_DATE OKL_POOL_CONTENTS.STREAMS_FROM_DATE%TYPE := NULL --DATE
123: ,STREAMS_TO_DATE OKL_POOL_CONTENTS.STREAMS_TO_DATE%TYPE := NULL --DATE
124: ,STREAM_ELEMENT_PAYMENT_FREQ okl_time_units_v.NAME%TYPE := NULL -- VARCHAR2(80)
125: ,CUST_CRD_CLF_CODE AR_LOOKUPS.LOOKUP_CODE%TYPE := NULL --VARCHAR2(80)

Line 122: ,STREAMS_FROM_DATE OKL_POOL_CONTENTS.STREAMS_FROM_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
121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search
122: ,STREAMS_FROM_DATE OKL_POOL_CONTENTS.STREAMS_FROM_DATE%TYPE := NULL --DATE
123: ,STREAMS_TO_DATE OKL_POOL_CONTENTS.STREAMS_TO_DATE%TYPE := NULL --DATE
124: ,STREAM_ELEMENT_PAYMENT_FREQ okl_time_units_v.NAME%TYPE := NULL -- VARCHAR2(80)
125: ,CUST_CRD_CLF_CODE AR_LOOKUPS.LOOKUP_CODE%TYPE := NULL --VARCHAR2(80)
126: );

Line 123: ,STREAMS_TO_DATE OKL_POOL_CONTENTS.STREAMS_TO_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
121: -- use the following column STREAMS_FROM_DATE, STREAMS_TO_DATE for the okl_pool_contents_uv.STREAMS_FROM_DATE range search
122: ,STREAMS_FROM_DATE OKL_POOL_CONTENTS.STREAMS_FROM_DATE%TYPE := NULL --DATE
123: ,STREAMS_TO_DATE OKL_POOL_CONTENTS.STREAMS_TO_DATE%TYPE := NULL --DATE
124: ,STREAM_ELEMENT_PAYMENT_FREQ okl_time_units_v.NAME%TYPE := NULL -- VARCHAR2(80)
125: ,CUST_CRD_CLF_CODE AR_LOOKUPS.LOOKUP_CODE%TYPE := NULL --VARCHAR2(80)
126: );
127:

Line 134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR

130:
131: TYPE poc_uv_rec_type IS RECORD
132: (
133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM

Line 135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

131: TYPE poc_uv_rec_type IS RECORD
132: (
133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR

132: (
133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR

Line 137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR

133: poc_id NUMBER := OKC_API.G_MISS_NUM
134: ,contract_number OKL_POOL_CONTENTS_UV.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240

Line 139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR

135: ,asset_number OKL_POOL_CONTENTS_UV.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240
142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR
143: );

Line 140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR

136: ,lessee OKL_POOL_CONTENTS_UV.LESSEE%TYPE := OKC_API.G_MISS_CHAR
137: ,stream_type_name OKL_POOL_CONTENTS_UV.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR
138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240
142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR
143: );
144:

Line 142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR

138: ,pool_amount NUMBER := OKC_API.G_MISS_NUM
139: ,sty_subclass_code OKL_POOL_CONTENTS_UV.STY_SUBCLASS_CODE%TYPE := OKC_API.G_MISS_CHAR
140: ,sty_subclass OKL_POOL_CONTENTS_UV.STY_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR
141: -- mvasudev, 09/28/2004, Bug#3909240
142: ,stream_type_purpose OKL_POOL_CONTENTS_UV.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR
143: );
144:
145: TYPE poc_uv_tbl_type IS TABLE OF poc_uv_rec_type
146: INDEX BY BINARY_INTEGER;

Line 395: -- Description : get stream elements amount from pool contents by okl_pool_contents.id

391: ----------------------------------------------------------------------------------
392: -- Start of comments
393: --
394: -- Procedure Name : get_pool_stream_amout
395: -- Description : get stream elements amount from pool contents by okl_pool_contents.id
396: -- Business Rules :
397: -- Parameters :
398: -- Version : 1.0
399: -- End of comments

Line 402: p_poc_id IN okl_pool_contents.id%TYPE

398: -- Version : 1.0
399: -- End of comments
400: ----------------------------------------------------------------------------------
401: FUNCTION get_pool_stream_amout(
402: p_poc_id IN okl_pool_contents.id%TYPE
403: ) RETURN NUMBER;
404: PRAGMA RESTRICT_REFERENCES (get_pool_stream_amout, TRUST);
405: ----------------------------------------------------------------------------------
406: -- Start of comments

Line 688: ,p_poc_id IN okl_pool_contents.id%TYPE

684: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
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: