DBA Data[Home] [Help]

APPS.XTR_CASH_FCST dependencies on XTR_CSH_FCST_POP

Line 287: INTO XTR_CSH_FCST_POP.G_calendar_start, XTR_CSH_FCST_POP.G_calendar_end

283: xtr_debug_pkg.debug('>>validate_transaction_calendar');
284: END IF;
285:
286: SELECT min(transaction_date), max(transaction_date)
287: INTO XTR_CSH_FCST_POP.G_calendar_start, XTR_CSH_FCST_POP.G_calendar_end
288: FROM gl_transaction_dates
289: WHERE transaction_calendar_id = G_transaction_calendar_id;
290:
291: IF(XTR_CSH_FCST_POP.G_calendar_start IS NULL OR

Line 291: IF(XTR_CSH_FCST_POP.G_calendar_start IS NULL OR

287: INTO XTR_CSH_FCST_POP.G_calendar_start, XTR_CSH_FCST_POP.G_calendar_end
288: FROM gl_transaction_dates
289: WHERE transaction_calendar_id = G_transaction_calendar_id;
290:
291: IF(XTR_CSH_FCST_POP.G_calendar_start IS NULL OR
292: XTR_CSH_FCST_POP.G_calendar_end IS NULL)THEN
293: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
294: xtr_debug_pkg.debug('Cannot find transaction calendar');
295: END IF;

Line 292: XTR_CSH_FCST_POP.G_calendar_end IS NULL)THEN

288: FROM gl_transaction_dates
289: WHERE transaction_calendar_id = G_transaction_calendar_id;
290:
291: IF(XTR_CSH_FCST_POP.G_calendar_start IS NULL OR
292: XTR_CSH_FCST_POP.G_calendar_end IS NULL)THEN
293: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
294: xtr_debug_pkg.debug('Cannot find transaction calendar');
295: END IF;
296: G_transaction_calendar_id := NULL;

Line 670: XTR_CSH_FCST_POP.populate_aging_buckets;

666: END IF;
667: RAISE;
668: END;
669:
670: XTR_CSH_FCST_POP.populate_aging_buckets;
671:
672: LOOP
673: FETCH f_row_cursor INTO G_rowid, G_forecast_row_id,
674: G_row_number, G_trx_type,

Line 707: XTR_CSH_FCST_POP.Populate_Cells;

703: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
704: xtr_debug_pkg.debug('Calling Pop Cells...for trx : ' || G_trx_type||
705: ' and row_number :' || G_row_number);
706: END IF;
707: XTR_CSH_FCST_POP.Populate_Cells;
708: END LOOP;
709: CLOSE f_row_cursor;
710: END IF;
711: