DBA Data[Home] [Help]

APPS.CE_CP_PRIORDAY dependencies on STANDARD

Line 27: cep_standard.debug('>>CE_CP_PRIORDAY.set_parameters -------');

23: p_debug_path VARCHAR2,
24: p_debug_file VARCHAR2) IS
25: BEGIN
26: IF l_debug in ('Y', 'C') THEN
27: cep_standard.debug('>>CE_CP_PRIORDAY.set_parameters -------');
28: END IF;
29: CE_CP_PRIORDAY.G_worksheet_header_id := p_worksheet_header_id;
30: IF (p_as_of_date is null) THEN
31: CE_CP_PRIORDAY.G_purge_flag := 'Y';

Line 42: cep_standard.debug('G_worksheet_header_id = ' ||

38: CE_CP_PRIORDAY.G_display_debug := p_display_debug;
39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;
40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);

Line 44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);

40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:

Line 45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);

41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:
49: END set_parameters;

Line 46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);

42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:
49: END set_parameters;
50:

Line 47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);

43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:
49: END set_parameters;
50:
51: PROCEDURE calculate_summary IS

Line 87: cep_standard.debug('>>CE_CP_PRIORDAY.calculate_summary -------');

83:
84: BEGIN
85:
86: IF l_debug in ('Y', 'C') THEN
87: cep_standard.debug('>>CE_CP_PRIORDAY.calculate_summary -------');
88: END IF;
89:
90: /* purge prior-day data */
91: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN

Line 386: cep_standard.debug('l_ws_id = ' || l_ws_id);

382: LOOP
383: FETCH ws_cursor INTO l_ws_id;
384: EXIT WHEN ws_cursor%NOTFOUND OR ws_cursor%NOTFOUND IS NULL;
385:
386: cep_standard.debug('l_ws_id = ' || l_ws_id);
387:
388: /* purge overdue data */
389: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN
390: DELETE CE_CP_PRIORDAY_BALANCES

Line 405: cep_standard.debug('>>l_bank_account_id = ' || l_bank_account_id);

401: FETCH wsba_cursor INTO l_bank_account_id, l_currency_code,
402: l_statement_date;
403: EXIT WHEN wsba_cursor%NOTFOUND OR wsba_cursor%NOTFOUND IS NULL;
404:
405: cep_standard.debug('>>l_bank_account_id = ' || l_bank_account_id);
406: cep_standard.debug('>>l_currency_code = ' || l_currency_code);
407: cep_standard.debug('>>l_statement_date = ' || to_char(l_statement_date,
408: 'YYYY/MM/DD'));
409:

Line 406: cep_standard.debug('>>l_currency_code = ' || l_currency_code);

402: l_statement_date;
403: EXIT WHEN wsba_cursor%NOTFOUND OR wsba_cursor%NOTFOUND IS NULL;
404:
405: cep_standard.debug('>>l_bank_account_id = ' || l_bank_account_id);
406: cep_standard.debug('>>l_currency_code = ' || l_currency_code);
407: cep_standard.debug('>>l_statement_date = ' || to_char(l_statement_date,
408: 'YYYY/MM/DD'));
409:
410: tmp_balance := 0;

Line 407: cep_standard.debug('>>l_statement_date = ' || to_char(l_statement_date,

403: EXIT WHEN wsba_cursor%NOTFOUND OR wsba_cursor%NOTFOUND IS NULL;
404:
405: cep_standard.debug('>>l_bank_account_id = ' || l_bank_account_id);
406: cep_standard.debug('>>l_currency_code = ' || l_currency_code);
407: cep_standard.debug('>>l_statement_date = ' || to_char(l_statement_date,
408: 'YYYY/MM/DD'));
409:
410: tmp_balance := 0;
411:

Line 756: cep_standard.init_security;

752: p_debug_path VARCHAR2,
753: p_debug_file VARCHAR2) IS
754: BEGIN
755:
756: cep_standard.init_security;
757: IF l_debug in ('Y', 'C') THEN
758: cep_standard.enable_debug(p_debug_path, p_debug_file);
759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');

Line 758: cep_standard.enable_debug(p_debug_path, p_debug_file);

754: BEGIN
755:
756: cep_standard.init_security;
757: IF l_debug in ('Y', 'C') THEN
758: cep_standard.enable_debug(p_debug_path, p_debug_file);
759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);

Line 759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||

755:
756: cep_standard.init_security;
757: IF l_debug in ('Y', 'C') THEN
758: cep_standard.enable_debug(p_debug_path, p_debug_file);
759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);

Line 761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);

757: IF l_debug in ('Y', 'C') THEN
758: cep_standard.enable_debug(p_debug_path, p_debug_file);
759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);
764: cep_standard.debug('p_debug_path: '||p_debug_path);
765: cep_standard.debug('p_debug_file: '||p_debug_file);

Line 762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);

758: cep_standard.enable_debug(p_debug_path, p_debug_file);
759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);
764: cep_standard.debug('p_debug_path: '||p_debug_path);
765: cep_standard.debug('p_debug_file: '||p_debug_file);
766: END IF;

Line 763: cep_standard.debug('p_display_debug: '||p_display_debug);

759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);
764: cep_standard.debug('p_debug_path: '||p_debug_path);
765: cep_standard.debug('p_debug_file: '||p_debug_file);
766: END IF;
767:

Line 764: cep_standard.debug('p_debug_path: '||p_debug_path);

760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);
764: cep_standard.debug('p_debug_path: '||p_debug_path);
765: cep_standard.debug('p_debug_file: '||p_debug_file);
766: END IF;
767:
768: set_parameters(p_worksheet_header_id, p_as_of_date, p_display_debug,

Line 765: cep_standard.debug('p_debug_file: '||p_debug_file);

761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);
764: cep_standard.debug('p_debug_path: '||p_debug_path);
765: cep_standard.debug('p_debug_file: '||p_debug_file);
766: END IF;
767:
768: set_parameters(p_worksheet_header_id, p_as_of_date, p_display_debug,
769: p_debug_path, p_debug_file);

Line 774: cep_standard.debug('<

770:
771: calculate_summary;
772:
773: IF l_debug in ('Y', 'C') THEN
774: cep_standard.debug('< 775: END IF;
776:
777: END gen_prior_day;
778: