APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_K_RATE_PARAMS

Line 125: -- Procedure to fetch the day convention from the OKL_K_RATE_PARAMS

121: -- ' | l_days_in_year = ' || x_days_in_year);
122: x_return_status := OKL_API.G_RET_STS_SUCCESS;
123: END get_days_in_year_and_month;
124:
125: -- Procedure to fetch the day convention from the OKL_K_RATE_PARAMS
126: -- if not found reach the SGT assosiated and fetch the day conventions
127: PROCEDURE get_day_convention(
128: p_id IN NUMBER, -- ID of the contract/quote
129: p_source IN VARCHAR2, -- 'ESG'/'ISG' are acceptable values

Line 137: -- Cursor to fetch the day convention from the OKL_K_RATE_PARAMS table ..

133: AS
134: l_api_name VARCHAR2(30) := 'get_day_convention';
135: l_return_status VARCHAR2(1);
136:
137: -- Cursor to fetch the day convention from the OKL_K_RATE_PARAMS table ..
138: CURSOR day_conv_csr( khrId NUMBER) IS
139: SELECT days_in_a_year_code,
140: days_in_a_month_code,
141: DECODE(rate_params.days_in_a_month_code,'30','360',

Line 143: FROM OKL_K_RATE_PARAMS rate_params

139: SELECT days_in_a_year_code,
140: days_in_a_month_code,
141: DECODE(rate_params.days_in_a_month_code,'30','360',
142: rate_params.days_in_a_month_code) esg_days_in_month_code
143: FROM OKL_K_RATE_PARAMS rate_params
144: WHERE khr_id = khrId;
145:
146: -- Cursor to fetch the day convention from the SGT
147: CURSOR get_day_conv_on_sgt_csr( p_khr_id IN VARCHAR2 )

Line 182: -- If there is a record present in the OKL_K_RATE_PARAMS for the corresponding

178: l_days_in_year := t_rec.days_in_a_year_code;
179: l_return_status := G_RET_STS_SUCCESS;
180: END LOOP;
181: -- Bug 4960625: Start
182: -- If there is a record present in the OKL_K_RATE_PARAMS for the corresponding
183: -- Contract, but the Day conventions are null there, then fetch the Day conventions
184: -- from the Stream Generation Template.
185: IF l_days_in_month IS NULL OR
186: l_days_in_year IS NULL

Line 192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from OKL_K_RATE_PARAMS ' || l_return_status );

188: l_return_status := G_RET_STS_ERROR;
189: END IF;
190: -- Bug 4960625: End
191: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || 'Tried fetching the day convention from OKL_K_RATE_PARAMS ' || l_return_status );
193: END IF;
194: IF l_return_status <> G_RET_STS_SUCCESS
195: THEN
196: -- Fetch the day convention from the SGT assosiated to the contract