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.8.12020000.2 2012/07/23 07:02:24 vgopiset ship $
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:
65:

Line 76: (p_location => 'XLA_MULTIPERIOD_RPRTG_PKG.print_logfile');

72: WHEN xla_exceptions_pkg.application_exception THEN
73: RAISE;
74: WHEN OTHERS THEN
75: xla_exceptions_pkg.raise_message
76: (p_location => 'XLA_MULTIPERIOD_RPRTG_PKG.print_logfile');
77: END print_logfile;
78:
79: PROCEDURE build_xml_sql (p_accounting_batch_id IN NUMBER);
80:

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

177: EXCEPTION
178: WHEN OTHERS THEN
179: -- trace mesg
180: xla_exceptions_pkg.raise_message
181: (p_location => 'xla_multiperiod_rprtg_pkg.run_report ');
182: END run_report;
183:
184: FUNCTION get_transaction_id
185: (p_application_id IN NUMBER

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

422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: xla_exceptions_pkg.raise_message
426: (p_location => 'xla_multiperiod_rprtg_pkg.get_transaction_id ');
427:
428: END get_transaction_id;
429:
430: PROCEDURE build_xml_sql (p_accounting_batch_id IN NUMBER) IS

Line 447: xla_multiperiod_rprtg_pkg.C_SUMMARY_QUERY :=

443: ,p_level => C_LEVEL_PROCEDURE
444: ,p_module => l_log_module);
445: END IF;
446:
447: xla_multiperiod_rprtg_pkg.C_SUMMARY_QUERY :=
448: ' SELECT xec.event_class_code EVENT_CLASS_CODE
449: ,xec.name EVENT_CLASS
450: ,xgl.ledger_id LEDGER_ID
451: ,xgl.name LEDGER

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

482: AND lk2.lookup_code = ''B''
483: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
484: AND lk3.lookup_code = ''E'' ';
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||

Line 487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

483: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
484: AND lk3.lookup_code = ''E'' ';
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

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

484: AND lk3.lookup_code = ''E'' ';
485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||

Line 489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

485:
486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

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

486: xla_multiperiod_rprtg_pkg.xah_appl_filter := ' AND xah.application_id = '||
487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:

Line 491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

487: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||

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

488: xla_multiperiod_rprtg_pkg.xae_appl_filter := ' AND xae.application_id = '||
489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);

Line 493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);

489: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
490: xla_multiperiod_rprtg_pkg.ent_appl_filter := ' AND ent.application_id = '||
491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
497:

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

491: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
492: xla_multiperiod_rprtg_pkg.xal_appl_filter := ' AND xal.application_id = '||
493: to_char(xla_multiperiod_rprtg_pkg.p_application_id);
494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
497:
498: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=
499: ' SELECT xgl.name LEDGER

Line 498: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=

494:
495: xla_multiperiod_rprtg_pkg.acct_batch_filter := ' AND xah.accounting_batch_id = '||
496: to_char(p_accounting_batch_id);
497:
498: xla_multiperiod_rprtg_pkg.C_TRANSFER_QUERY :=
499: ' SELECT xgl.name LEDGER
500: ,xgl.ledger_id LEDGER_ID
501: ,lk1.meaning ACTUAL
502: ,lk2.meaning BUDGET

Line 524: xla_multiperiod_rprtg_pkg.C_GENERAL_ERRORS_QUERY :=

520: AND lk2.lookup_code = ''B''
521: AND lk3.lookup_type = ''XLA_BALANCE_TYPE''
522: AND lk3.lookup_code = ''E'' ';
523:
524: xla_multiperiod_rprtg_pkg.C_GENERAL_ERRORS_QUERY :=
525: ' SELECT ERR.MESSAGE_NUMBER ERROR_NO
526: ,ERR.ENCODED_MSG ERROR_MSG
527: ,ERR.AE_LINE_NUM LINE_NUM
528: FROM XLA_ACCOUNTING_ERRORS ERR

Line 533: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=

529: ,XLA_AE_HEADERS XAH
530: WHERE err.ae_header_id = xah.ae_header_id
531: AND err.application_id = xah.application_id ';
532:
533: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=
534: ' SELECT xah.event_id event_id
535: ,xec.name event_class
536: ,xet.name event_type
537: ,xae.event_number event_number

Line 573: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=

569: total_accted_debits
570: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
571: total_accted_credits ';
572:
573: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=
574: ' FROM xla_ae_headers xah
575: ,xla_events xae
576: ,xla_event_types_tl xet
577: ,xla_event_classes_tl xec

Line 589: xla_multiperiod_rprtg_pkg.C_RECOGNITION_WHR_QUERY :=

585: ,fnd_document_sequences seq
586: ,fun_seq_versions seqv2
587: ,fun_seq_versions seqv3 ';
588:
589: xla_multiperiod_rprtg_pkg.C_RECOGNITION_WHR_QUERY :=
590: ' WHERE xec.application_id = xet.application_id
591: AND xec.event_class_code = xet.event_class_code
592: AND xec.language = USERENV(''LANG'')
593: AND ent.application_id = xet.application_id

Line 622: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_COLS_QUERY :=

618: AND xah.accounting_entry_status_code in (''D'',''F'')
619: AND xah.parent_ae_header_id IS NOT NULL
620: AND xah.parent_ae_line_num IS NOT NULL ';
621:
622: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_COLS_QUERY :=
623: ' SELECT xah.event_id event_id
624: ,xec.name event_class
625: ,xet.name event_type
626: ,xae.event_number event_number

Line 662: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=

658: total_accted_debits
659: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
660: total_accted_credits ';
661:
662: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=
663: ' FROM xla_ae_headers xah
664: ,xla_events xae
665: ,xla_event_types_tl xet
666: ,xla_event_classes_tl xec

Line 678: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=

674: ,fnd_document_sequences seq
675: ,fun_seq_versions seqv2
676: ,fun_seq_versions seqv3 ';
677:
678: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=
679: ' WHERE xec.application_id = xet.application_id
680: AND xec.event_class_code = xet.event_class_code
681: AND xec.language = USERENV(''LANG'')
682: AND ent.application_id = xet.application_id

Line 711: xla_multiperiod_rprtg_pkg.C_ERRORS_COLS_QUERY :=

707: AND xah.accounting_entry_status_code in (''D'',''F'')
708: AND xah.parent_ae_header_id IS NOT NULL
709: AND xah.parent_ae_line_num IS NULL ';
710:
711: xla_multiperiod_rprtg_pkg.C_ERRORS_COLS_QUERY :=
712: ' SELECT xah.event_id event_id
713: ,xec.name event_class
714: ,xet.name event_type
715: ,xae.event_number event_number

Line 753: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=

749: total_accted_credits
750: ,err.message_number error_number
751: ,err.encoded_msg error_message ';
752:
753: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=
754: ' FROM xla_ae_headers xah
755: ,xla_events xae
756: ,xla_event_types_tl xet
757: ,xla_event_classes_tl xec

Line 770: xla_multiperiod_rprtg_pkg.C_ERRORS_WHR_QUERY :=

766: ,fun_seq_versions seqv2
767: ,fun_seq_versions seqv3
768: ,xla_accounting_errors err ';
769:
770: xla_multiperiod_rprtg_pkg.C_ERRORS_WHR_QUERY :=
771: ' WHERE xec.application_id = xet.application_id
772: AND xec.event_class_code = xet.event_class_code
773: AND xec.language = USERENV(''LANG'')
774: AND ent.application_id = xet.application_id

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

809: AND xah.accounting_entry_status_code NOT IN (''D'',''F'')
810: AND xah.parent_ae_header_id IS NOT NULL ';
811:
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';

Line 814: ,xla_multiperiod_rprtg_pkg.p_ledger_id

810: AND xah.parent_ae_header_id IS NOT NULL ';
811:
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE

Line 815: ,xla_multiperiod_rprtg_pkg.p_end_date

811:
812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';

Line 816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)

812: IF p_report = 'D' THEN
813: xla_multiperiod_rprtg_pkg.p_trx_identifiers := get_transaction_id(xla_multiperiod_rprtg_pkg.p_application_id
814: ,xla_multiperiod_rprtg_pkg.p_ledger_id
815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';
820: END IF;

Line 819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';

815: ,xla_multiperiod_rprtg_pkg.p_end_date
816: ,xla_multiperiod_rprtg_pkg.p_process_category_code)
817: ||' USERIDS ';
818: ELSE
819: xla_multiperiod_rprtg_pkg.p_trx_identifiers := ',CASE WHEN 1<1 THEN NULL END USERIDS ';
820: END IF;
821:
822: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
823: trace('build_xml_sql.End'

Line 835: 'xla_multiperiod_rprtg_pkg.build_xml_sql');

831: ,C_LEVEL_PROCEDURE, l_log_module);
832: END IF;
833: xla_exceptions_pkg.raise_message
834: (p_location =>
835: 'xla_multiperiod_rprtg_pkg.build_xml_sql');
836: END build_xml_sql;
837:
838:
839: FUNCTION beforeReport RETURN BOOLEAN IS

Line 886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id

882: END IF;
883:
884: run_report(p_errbuf => l_errbuf
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only

Line 887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id

883:
884: run_report(p_errbuf => l_errbuf
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl

Line 888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code

884: run_report(p_errbuf => l_errbuf
885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl

Line 889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date

885: ,p_retcode => C_RETURN_CODE
886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name

Line 890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only

886: ,p_application_id => xla_multiperiod_rprtg_pkg.p_application_id
887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code

Line 891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl

887: ,p_ledger_id => xla_multiperiod_rprtg_pkg.p_ledger_id
888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1

Line 892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl

888: ,p_process_category_code => xla_multiperiod_rprtg_pkg.p_process_category_code
889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2

Line 893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name

889: ,p_end_date => xla_multiperiod_rprtg_pkg.p_end_date
890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3

Line 894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code

890: ,p_errors_only_flag => xla_multiperiod_rprtg_pkg.p_errors_only
891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1

Line 895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1

891: ,p_transfer_to_gl_flag => xla_multiperiod_rprtg_pkg.p_transfer_to_gl
892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2

Line 896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2

892: ,p_post_in_gl_flag => xla_multiperiod_rprtg_pkg.p_post_in_gl
893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);

Line 897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3

893: ,p_gl_batch_name => xla_multiperiod_rprtg_pkg.p_gl_batch_name
894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:

Line 898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1

894: ,p_valuation_method_code => xla_multiperiod_rprtg_pkg.p_valuation_method_code
895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2

895: ,p_security_int_1 => xla_multiperiod_rprtg_pkg.p_security_int_1
896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
903: trace('C_RETURN_CODE = '||C_RETURN_CODE,C_LEVEL_STATEMENT ,l_log_module);

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

896: ,p_security_int_2 => xla_multiperiod_rprtg_pkg.p_security_int_2
897: ,p_security_int_3 => xla_multiperiod_rprtg_pkg.p_security_int_3
898: ,p_security_char_1 => xla_multiperiod_rprtg_pkg.p_security_char_1
899: ,p_security_char_2 => xla_multiperiod_rprtg_pkg.p_security_char_2
900: ,p_security_char_3 => xla_multiperiod_rprtg_pkg.p_security_char_3);
901:
902: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
903: trace('C_RETURN_CODE = '||C_RETURN_CODE,C_LEVEL_STATEMENT ,l_log_module);
904: trace('beforeReport.End'

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

909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: xla_exceptions_pkg.raise_message
913: (p_location => 'xla_multiperiod_rprtg_pkg.beforeReport ');
914:
915: END beforeReport;
916:
917: FUNCTION AfterReport RETURN BOOLEAN IS

Line 951: (p_location => 'xla_multiperiod_rprtg_pkg.AfterReport');

947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: xla_exceptions_pkg.raise_message
951: (p_location => 'xla_multiperiod_rprtg_pkg.AfterReport');
952:
953: END afterReport;
954:
955: BEGIN

Line 964: END xla_multiperiod_rprtg_pkg;

960:
961: IF NOT g_log_enabled THEN
962: g_log_level := C_LEVEL_LOG_DISABLED;
963: END IF;
964: END xla_multiperiod_rprtg_pkg;