APPS.XTR_REVAL_PROCESS_P dependencies on XTR_REVALUATION_RATES

Line 6: /* based on time and input into XTR_REVALUATION_RATES table */

2: /* $Header: xtrrevlb.pls 120.59.12010000.4 2010/02/05 10:34:04 nipant ship $ */
3: -------------------------------------------------------------------------------------------------------
4: /***************************************************************/
5: /* This procedure get rates information from xtr_market_prices */
6: /* based on time and input into XTR_REVALUATION_RATES table */
7: /* Also it generates a batch ID for the new period */
8: /***************************************************************/
9: PROCEDURE GET_ALL_REVAL_RATES(l_company IN VARCHAR2,
10: l_start_date IN DATE,

Line 198: insert into XTR_REVALUATION_RATES

194: open NUM;
195: fetch NUM INTO p_UNIQUE_REF_NUM;
196: close NUM;
197:
198: insert into XTR_REVALUATION_RATES
199: (batch_id,unique_ref_num,company_code,period_from,period_to,reval_type,
200: currencya,bid,ask,entered_on,
201: entered_by,rate_date,volatility_or_rate,day_mth,day_count_basis,currencyb,period_ref1,
202: period_ref2,number_of_days,created_on,created_by)

Line 277: insert into XTR_REVALUATION_RATES

273: open NUM;
274: fetch NUM INTO p_UNIQUE_REF_NUM;
275: close NUM;
276:
277: insert into XTR_REVALUATION_RATES
278: (batch_id,unique_ref_num,company_code,period_from,period_to,reval_type,
279: currencya,bid,ask,entered_on,
280: entered_by,rate_date,volatility_or_rate,day_mth,day_count_basis,currencyb,period_ref1,
281: period_ref2,number_of_days,created_on,created_by)

Line 305: insert into XTR_REVALUATION_RATES

301: open NUM;
302: fetch NUM INTO p_UNIQUE_REF_NUM;
303: close NUM;
304:
305: insert into XTR_REVALUATION_RATES
306: (batch_id,unique_ref_num,company_code,period_from,period_to,reval_type,
307: currencya,bid, ask,entered_on,
308: entered_by,rate_date,volatility_or_rate,day_mth,day_count_basis,currencyb,period_ref1,
309: period_ref2,number_of_days,created_on,created_by)