247: p_aging_type VARCHAR2(10);
248: p_period_type VARCHAR2(15);
249: BEGIN
250: -- 14164001: Added debug
251: cep_standard.debug('>>CEFC_VIEW_CONST.set_constants');
252: cep_standard.debug('pn_header_id='||pn_header_id);
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
248: p_period_type VARCHAR2(15);
249: BEGIN
250: -- 14164001: Added debug
251: cep_standard.debug('>>CEFC_VIEW_CONST.set_constants');
252: cep_standard.debug('pn_header_id='||pn_header_id);
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
256: cep_standard.debug('pn_min_col='||pn_min_col);
249: BEGIN
250: -- 14164001: Added debug
251: cep_standard.debug('>>CEFC_VIEW_CONST.set_constants');
252: cep_standard.debug('pn_header_id='||pn_header_id);
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
256: cep_standard.debug('pn_min_col='||pn_min_col);
257: cep_standard.debug('pn_max_col='||pn_max_col);
250: -- 14164001: Added debug
251: cep_standard.debug('>>CEFC_VIEW_CONST.set_constants');
252: cep_standard.debug('pn_header_id='||pn_header_id);
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
256: cep_standard.debug('pn_min_col='||pn_min_col);
257: cep_standard.debug('pn_max_col='||pn_max_col);
258:
251: cep_standard.debug('>>CEFC_VIEW_CONST.set_constants');
252: cep_standard.debug('pn_header_id='||pn_header_id);
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
256: cep_standard.debug('pn_min_col='||pn_min_col);
257: cep_standard.debug('pn_max_col='||pn_max_col);
258:
259: pg_header_id := pn_header_id;
252: cep_standard.debug('pn_header_id='||pn_header_id);
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
256: cep_standard.debug('pn_min_col='||pn_min_col);
257: cep_standard.debug('pn_max_col='||pn_max_col);
258:
259: pg_header_id := pn_header_id;
260: pg_start_date := pn_start_date;
253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);
254: cep_standard.debug('pn_start_period='||pn_start_period);
255: cep_standard.debug('pn_start_date='||pn_start_date);
256: cep_standard.debug('pn_min_col='||pn_min_col);
257: cep_standard.debug('pn_max_col='||pn_max_col);
258:
259: pg_header_id := pn_header_id;
260: pg_start_date := pn_start_date;
261: pg_period_set_name := pn_period_set_name;
298: AND period_type = p_period_type
299: AND start_date <= p_period_start_date;
300:
301: -- 14164001: Added debug
302: cep_standard.debug('p_max_col='||p_max_col);
303: cep_standard.debug('p_min_col='||p_min_col);
304: END IF;
305:
306: pg_min_col := -p_min_col+1;
299: AND start_date <= p_period_start_date;
300:
301: -- 14164001: Added debug
302: cep_standard.debug('p_max_col='||p_max_col);
303: cep_standard.debug('p_min_col='||p_min_col);
304: END IF;
305:
306: pg_min_col := -p_min_col+1;
307: pg_max_col := p_max_col-1;
307: pg_max_col := p_max_col-1;
308: END IF;
309:
310: -- 14164001: Added debug
311: cep_standard.debug('pg_header_id='||pg_header_id);
312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);
313: cep_standard.debug('pg_start_date='||pg_start_date);
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
308: END IF;
309:
310: -- 14164001: Added debug
311: cep_standard.debug('pg_header_id='||pg_header_id);
312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);
313: cep_standard.debug('pg_start_date='||pg_start_date);
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
316: cep_standard.debug('pg_max_col='||pg_max_col);
309:
310: -- 14164001: Added debug
311: cep_standard.debug('pg_header_id='||pg_header_id);
312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);
313: cep_standard.debug('pg_start_date='||pg_start_date);
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
316: cep_standard.debug('pg_max_col='||pg_max_col);
317:
310: -- 14164001: Added debug
311: cep_standard.debug('pg_header_id='||pg_header_id);
312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);
313: cep_standard.debug('pg_start_date='||pg_start_date);
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
316: cep_standard.debug('pg_max_col='||pg_max_col);
317:
318: cep_standard.debug('<
311: cep_standard.debug('pg_header_id='||pg_header_id);
312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);
313: cep_standard.debug('pg_start_date='||pg_start_date);
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
316: cep_standard.debug('pg_max_col='||pg_max_col);
317:
318: cep_standard.debug('<
312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);
313: cep_standard.debug('pg_start_date='||pg_start_date);
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
316: cep_standard.debug('pg_max_col='||pg_max_col);
317:
318: cep_standard.debug('<
320: WHEN OTHERS THEN
314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);
315: cep_standard.debug('pg_min_col='||pg_min_col);
316: cep_standard.debug('pg_max_col='||pg_max_col);
317:
318: cep_standard.debug('<
320: WHEN OTHERS THEN
321: -- 14164001: Added debug
322: cep_standard.debug('CEFC_VIEW_CONST.EXCEPTION');
318: cep_standard.debug('<
320: WHEN OTHERS THEN
321: -- 14164001: Added debug
322: cep_standard.debug('CEFC_VIEW_CONST.EXCEPTION');
323: cep_standard.debug(sqlerrm);
324: RAISE;
325: END set_constants;
326:
319: EXCEPTION
320: WHEN OTHERS THEN
321: -- 14164001: Added debug
322: cep_standard.debug('CEFC_VIEW_CONST.EXCEPTION');
323: cep_standard.debug(sqlerrm);
324: RAISE;
325: END set_constants;
326:
327: END CEFC_VIEW_CONST;