DBA Data[Home] [Help]

APPS.CEFC_VIEW_CONST dependencies on CEP_STANDARD

Line 251: cep_standard.debug('>>CEFC_VIEW_CONST.set_constants');

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);

Line 252: cep_standard.debug('pn_header_id='||pn_header_id);

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);

Line 253: cep_standard.debug('pn_period_set_name='||pn_period_set_name);

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);

Line 254: cep_standard.debug('pn_start_period='||pn_start_period);

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:

Line 255: cep_standard.debug('pn_start_date='||pn_start_date);

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;

Line 256: cep_standard.debug('pn_min_col='||pn_min_col);

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;

Line 257: cep_standard.debug('pn_max_col='||pn_max_col);

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;

Line 302: cep_standard.debug('p_max_col='||p_max_col);

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;

Line 303: cep_standard.debug('p_min_col='||p_min_col);

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;

Line 311: cep_standard.debug('pg_header_id='||pg_header_id);

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);

Line 312: cep_standard.debug('pg_period_set_name='||pg_period_set_name);

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);

Line 313: cep_standard.debug('pg_start_date='||pg_start_date);

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:

Line 314: cep_standard.debug('pg_start_period_name='||pg_start_period_name);

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('<

Line 315: cep_standard.debug('pg_min_col='||pg_min_col);

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('< 319: EXCEPTION

Line 316: cep_standard.debug('pg_max_col='||pg_max_col);

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('< 319: EXCEPTION
320: WHEN OTHERS THEN

Line 318: cep_standard.debug('<

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('< 319: EXCEPTION
320: WHEN OTHERS THEN
321: -- 14164001: Added debug
322: cep_standard.debug('CEFC_VIEW_CONST.EXCEPTION');

Line 322: cep_standard.debug('CEFC_VIEW_CONST.EXCEPTION');

318: cep_standard.debug('< 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:

Line 323: cep_standard.debug(sqlerrm);

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;