DBA Data[Home] [Help]

APPS.XLA_MULTIPERIOD_RPRTG_PKG dependencies on XLA_MULTIPERIOD_RPRTG_PKG

Line 1: PACKAGE BODY XLA_MULTIPERIOD_RPRTG_PKG AS

1: PACKAGE BODY XLA_MULTIPERIOD_RPRTG_PKG AS
2: -- $Header: xlarpmpa.pkb 120.5 2006/07/27 14:27:21 vkasina noship $
3: /*===========================================================================+
4: | Copyright (c) 2003 Oracle Corporation Belmont, California, USA |
5: | ALL rights reserved. |

Line 11: | xla_multiperiod_rprtg_pkg |

7: | FILENAME |
8: | xlarpmpa.pkb |
9: | |
10: | PACKAGE NAME |
11: | xla_multiperiod_rprtg_pkg |
12: | |
13: | DESCRIPTION |
14: | This package calls XLA_MULTIPERIOD_ACCOUNTING_PKG.complete_ |
15: | journal_entries and generates the XML extract for reporting |

Line 39: := 'xla.plsql.xla_multiperiod_rprtg_pkg';

35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
38: C_DEFAULT_MODULE CONSTANT VARCHAR2(240)
39: := 'xla.plsql.xla_multiperiod_rprtg_pkg';
40:
41: g_log_level NUMBER;
42: g_log_enabled BOOLEAN;
43:

Line 61: (p_location => 'xla_multiperiod_rprtg_pkg.trace');

57: WHEN xla_exceptions_pkg.application_exception THEN
58: RAISE;
59: WHEN OTHERS THEN
60: xla_exceptions_pkg.raise_message
61: (p_location => 'xla_multiperiod_rprtg_pkg.trace');
62: END trace;
63:
64: PROCEDURE build_xml_sql (p_accounting_batch_id IN NUMBER);
65:

Line 166: (p_location => 'xla_multiperiod_rprtg_pkg.run_report ');

162: EXCEPTION
163: WHEN OTHERS THEN
164: -- trace mesg
165: xla_exceptions_pkg.raise_message
166: (p_location => 'xla_multiperiod_rprtg_pkg.run_report ');
167: END run_report;
168:
169: FUNCTION get_transaction_id
170: (p_application_id IN NUMBER

Line 371: (p_location => 'xla_multiperiod_rprtg_pkg.get_transaction_id ');

367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: xla_exceptions_pkg.raise_message
371: (p_location => 'xla_multiperiod_rprtg_pkg.get_transaction_id ');
372:
373: END get_transaction_id;
374:
375: PROCEDURE build_xml_sql (p_accounting_batch_id IN NUMBER) IS

Line 392: xla_multiperiod_rprtg_pkg.C_SUMMARY_QUERY :=

388: ,p_level => C_LEVEL_PROCEDURE
389: ,p_module => l_log_module);
390: END IF;
391:
392: xla_multiperiod_rprtg_pkg.C_SUMMARY_QUERY :=
393: ' SELECT xec.event_class_code EVENT_CLASS_CODE
394: ,xec.name EVENT_CLASS
395: ,xgl.ledger_id LEDGER_ID
396: ,xgl.name LEDGER

Line 431: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||

427: AND lk2.lookup_code = ''B''
428: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
429: AND lk3.lookup_code = ''E'' ';
430:
431: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||

Line 432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

428: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
429: AND lk3.lookup_code = ''E'' ';
430:
431: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

Line 433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||

429: AND lk3.lookup_code = ''E'' ';
430:
431: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||

Line 434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

430:
431: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

Line 435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||

431: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
439:

Line 436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

432: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
439:
440: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||

Line 437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||

433: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
439:
440: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
441: to_char(p_accounting_batch_id);

Line 438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

434: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
435: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
439:
440: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
441: to_char(p_accounting_batch_id);
442:

Line 440: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||

436: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
437: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
438: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
439:
440: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
441: to_char(p_accounting_batch_id);
442:
443: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=
444: ' SELECT xgl.name LEDGER

Line 443: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=

439:
440: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
441: to_char(p_accounting_batch_id);
442:
443: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=
444: ' SELECT xgl.name LEDGER
445: ,xgl.ledger_id LEDGER_ID
446: ,lk1.meaning ACTUAL
447: ,lk2.meaning BUDGET

Line 469: xla_multiperiod_rprtg_pkg.C_GENERAL_ERRORS_QUERY :=

465: AND lk2.lookup_code = ''B''
466: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
467: AND lk3.lookup_code = ''E'' ';
468:
469: xla_multiperiod_rprtg_pkg.C_GENERAL_ERRORS_QUERY :=
470: ' SELECT ERR.MESSAGE_NUMBER ERROR_NO
471: ,ERR.ENCODED_MSG ERROR_MSG
472: ,ERR.AE_LINE_NUM LINE_NUM
473: FROM XLA_ACCOUNTING_ERRORS ERR

Line 478: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=

474: ,XLA_AE_HEADERS XAH
475: WHERE err.ae_header_id = xah.ae_header_id
476: AND err.application_id = xah.application_id ';
477:
478: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=
479: ' SELECT xah.event_id event_id
480: ,xec.name event_class
481: ,xet.name event_type
482: ,xae.event_number event_number

Line 518: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=

514: total_accted_debits
515: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
516: total_accted_credits ';
517:
518: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=
519: ' FROM xla_ae_headers xah
520: ,xla_events xae
521: ,xla_event_types_tl xet
522: ,xla_event_classes_tl xec

Line 534: xla_multiperiod_rprtg_pkg.C_RECOGNITION_WHR_QUERY :=

530: ,fnd_document_sequences seq
531: ,fun_seq_versions seqv2
532: ,fun_seq_versions seqv3 ';
533:
534: xla_multiperiod_rprtg_pkg.C_RECOGNITION_WHR_QUERY :=
535: ' WHERE xec.application_id = xet.application_id
536: AND xec.event_class_code = xet.event_class_code
537: AND xec.language = USERENV(''LANG'')
538: AND ent.application_id = xet.application_id

Line 567: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_COLS_QUERY :=

563: AND xah.accounting_entry_status_code in (''D'',''F'')
564: AND xah.parent_ae_header_id IS NOT NULL
565: AND xah.parent_ae_line_num IS NOT NULL ';
566:
567: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_COLS_QUERY :=
568: ' SELECT xah.event_id event_id
569: ,xec.name event_class
570: ,xet.name event_type
571: ,xae.event_number event_number

Line 607: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=

603: total_accted_debits
604: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
605: total_accted_credits ';
606:
607: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=
608: ' FROM xla_ae_headers xah
609: ,xla_events xae
610: ,xla_event_types_tl xet
611: ,xla_event_classes_tl xec

Line 623: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=

619: ,fnd_document_sequences seq
620: ,fun_seq_versions seqv2
621: ,fun_seq_versions seqv3 ';
622:
623: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=
624: ' WHERE xec.application_id = xet.application_id
625: AND xec.event_class_code = xet.event_class_code
626: AND xec.language = USERENV(''LANG'')
627: AND ent.application_id = xet.application_id

Line 656: xla_multiperiod_rprtg_pkg.C_ERRORS_COLS_QUERY :=

652: AND xah.accounting_entry_status_code in (''D'',''F'')
653: AND xah.parent_ae_header_id IS NOT NULL
654: AND xah.parent_ae_line_num IS NULL ';
655:
656: xla_multiperiod_rprtg_pkg.C_ERRORS_COLS_QUERY :=
657: ' SELECT xah.event_id event_id
658: ,xec.name event_class
659: ,xet.name event_type
660: ,xae.event_number event_number

Line 698: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=

694: total_accted_credits
695: ,err.message_number error_number
696: ,err.encoded_msg error_message ';
697:
698: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=
699: ' FROM xla_ae_headers xah
700: ,xla_events xae
701: ,xla_event_types_tl xet
702: ,xla_event_classes_tl xec

Line 715: xla_multiperiod_rprtg_pkg.C_ERRORS_WHR_QUERY :=

711: ,fun_seq_versions seqv2
712: ,fun_seq_versions seqv3
713: ,xla_accounting_errors err ';
714:
715: xla_multiperiod_rprtg_pkg.C_ERRORS_WHR_QUERY :=
716: ' WHERE xec.application_id = xet.application_id
717: AND xec.event_class_code = xet.event_class_code
718: AND xec.language = USERENV(''LANG'')
719: AND ent.application_id = xet.application_id

Line 757: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id

753: AND xal.ae_line_num(+) = err.ae_line_num
754: AND xah.accounting_entry_status_code NOT IN (''D'',''F'')
755: AND xah.parent_ae_header_id IS NOT NULL ';
756:
757: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
758: ,xla_multiperiod_rprtg_pkg.p_ledger_id
759: ,xla_multiperiod_rprtg_pkg.p_end_date
760: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
761: ||' USERIDS ';

Line 758: ,xla_multiperiod_rprtg_pkg.p_ledger_id

754: AND xah.accounting_entry_status_code NOT IN (''D'',''F'')
755: AND xah.parent_ae_header_id IS NOT NULL ';
756:
757: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
758: ,xla_multiperiod_rprtg_pkg.p_ledger_id
759: ,xla_multiperiod_rprtg_pkg.p_end_date
760: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
761: ||' USERIDS ';
762:

Line 759: ,xla_multiperiod_rprtg_pkg.p_end_date

755: AND xah.parent_ae_header_id IS NOT NULL ';
756:
757: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
758: ,xla_multiperiod_rprtg_pkg.p_ledger_id
759: ,xla_multiperiod_rprtg_pkg.p_end_date
760: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
761: ||' USERIDS ';
762:
763: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 760: ,xla_multiperiod_rprtg_pkg.p_process_category_code)

756:
757: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
758: ,xla_multiperiod_rprtg_pkg.p_ledger_id
759: ,xla_multiperiod_rprtg_pkg.p_end_date
760: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
761: ||' USERIDS ';
762:
763: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
764: trace('build_xml_sql.End'

Line 776: 'xla_multiperiod_rprtg_pkg.build_xml_sql');

772: ,C_LEVEL_PROCEDURE, l_log_module);
773: END IF;
774: xla_exceptions_pkg.raise_message
775: (p_location =>
776: 'xla_multiperiod_rprtg_pkg.build_xml_sql');
777: END build_xml_sql;
778:
779:
780: FUNCTION beforeReport RETURN BOOLEAN IS

Line 827: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id

823: END IF;
824:
825: run_report(p_errbuf => l_errbuf
826: ,p_retcode => C_RETURN_CODE
827: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only

Line 828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id

824:
825: run_report(p_errbuf => l_errbuf
826: ,p_retcode => C_RETURN_CODE
827: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl

Line 829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code

825: run_report(p_errbuf => l_errbuf
826: ,p_retcode => C_RETURN_CODE
827: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl

Line 830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date

826: ,p_retcode => C_RETURN_CODE
827: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name

Line 831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only

827: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code

Line 832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl

828: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1

Line 833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl

829: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2

Line 834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name

830: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3

Line 835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code

831: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1

Line 836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1

832: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2

Line 837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2

833: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
841: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);

Line 838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3

834: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
841: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
842:

Line 839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1

835: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
841: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
842:
843: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2

836: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
841: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
842:
843: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
844: trace('beforeReport.End'

Line 841: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);

837: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
838: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
839: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
840: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
841: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
842:
843: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
844: trace('beforeReport.End'
845: ,C_LEVEL_PROCEDURE, l_log_module);

Line 853: (p_location => 'xla_multiperiod_rprtg_pkg.beforeReport ');

849:
850: EXCEPTION
851: WHEN OTHERS THEN
852: xla_exceptions_pkg.raise_message
853: (p_location => 'xla_multiperiod_rprtg_pkg.beforeReport ');
854:
855: END beforeReport;
856:
857: BEGIN

Line 866: END xla_multiperiod_rprtg_pkg;

862:
863: IF NOT g_log_enabled THEN
864: g_log_level := C_LEVEL_LOG_DISABLED;
865: END IF;
866: END xla_multiperiod_rprtg_pkg;