eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_REPORTING_SEQUENCE_PKG dependencies on FUN_SEQ

Line 444: l_seq_context_value fun_seq_batch.context_value_tbl_type;

440: l_exception exception;
441: l_parameter_list wf_parameter_list_t;
442: l_ledger_id number;
443: l_period_name varchar2(100);
444: l_seq_context_value fun_seq_batch.context_value_tbl_type;
445: l_xla_seq_status varchar2(30);
446: l_gl_seq_status varchar2(30);
447: l_start_date gl_period_statuses.start_date%TYPE;
448: l_end_date gl_period_statuses.end_date%TYPE;

Line 524: (p_msg => 'calling fun_seq_batch.batch_init'

520: END IF;
521:
522: IF (C_LEVEL_EVENT>= g_log_level) THEN
523: trace
524: (p_msg => 'calling fun_seq_batch.batch_init'
525: ,p_level => C_LEVEL_EVENT
526: ,p_module => l_log_module);
527: END IF;
528:

Line 529: -- call fun_seq_batch.batch_init

525: ,p_level => C_LEVEL_EVENT
526: ,p_module => l_log_module);
527: END IF;
528:
529: -- call fun_seq_batch.batch_init
530: -- for xla first
531: l_seq_context_value(1) := p_ledger_id;
532: fun_seq_batch.Batch_init(p_application_id => 602
533: ,p_table_name => 'XLA_AE_HEADERS'

Line 532: fun_seq_batch.Batch_init(p_application_id => 602

528:
529: -- call fun_seq_batch.batch_init
530: -- for xla first
531: l_seq_context_value(1) := p_ledger_id;
532: fun_seq_batch.Batch_init(p_application_id => 602
533: ,p_table_name => 'XLA_AE_HEADERS'
534: ,p_event_code => 'PERIOD_CLOSE'
535: ,p_context_type => 'LEDGER_AND_CURRENCY'
536: ,p_context_value_tbl =>l_seq_context_value

Line 542: fun_seq_batch.Batch_init(p_application_id => 101

538: ,x_status => l_xla_seq_status
539: ,x_seq_context_id => l_xla_seq_context_id);
540:
541: -- for gl
542: fun_seq_batch.Batch_init(p_application_id => 101
543: ,p_table_name => 'GL_JE_HEADERS'
544: ,p_event_code => 'PERIOD_CLOSE'
545: ,p_context_type => 'LEDGER_AND_CURRENCY'
546: ,p_context_value_tbl =>l_seq_context_value

Line 553: (p_msg => 'after calling fun_seq_batch.batch_init'

549: ,x_seq_context_id => l_gl_seq_context_id);
550:
551: IF (C_LEVEL_EVENT>= g_log_level) THEN
552: trace
553: (p_msg => 'after calling fun_seq_batch.batch_init'
554: ,p_level => C_LEVEL_EVENT
555: ,p_module => l_log_module);
556: END IF;
557:

Line 576: FROM FUN_SEQ_CONTEXTS

572: -- l_sort_date will have value 'GL_DATE', 'REFERENCE_DATE' or 'COMPLETION_DATE'
573: IF(l_gl_seq_status = 'SUCCESS') THEN
574: SELECT nvl(SORT_OPTION, DATE_TYPE)
575: INTO l_sort_date
576: FROM FUN_SEQ_CONTEXTS
577: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
578: ELSE
579: SELECT nvl(SORT_OPTION, DATE_TYPE)
580: INTO l_sort_date

Line 581: FROM FUN_SEQ_CONTEXTS

577: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
578: ELSE
579: SELECT nvl(SORT_OPTION, DATE_TYPE)
580: INTO l_sort_date
581: FROM FUN_SEQ_CONTEXTS
582: WHERE SEQ_CONTEXT_ID = l_xla_seq_context_id;
583: END IF;
584:
585: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

Line 655: (p_msg => 'before calling fun_seq_batch.populate_acct_seq_info'

651: ,p_sort_date => l_sort_date);
652:
653: IF (C_LEVEL_EVENT>= g_log_level) THEN
654: trace
655: (p_msg => 'before calling fun_seq_batch.populate_acct_seq_info'
656: ,p_level => C_LEVEL_EVENT
657: ,p_module => l_log_module);
658: END IF;
659:

Line 660: fun_seq_batch.populate_acct_seq_info(p_calling_program => 'REPORTING'

656: ,p_level => C_LEVEL_EVENT
657: ,p_module => l_log_module);
658: END IF;
659:
660: fun_seq_batch.populate_acct_seq_info(p_calling_program => 'REPORTING'
661: ,p_request_id => l_request_id);
662:
663: IF (C_LEVEL_EVENT>= g_log_level) THEN
664: trace

Line 665: (p_msg => 'after calling fun_seq_batch.populate_acct_seq_info'

661: ,p_request_id => l_request_id);
662:
663: IF (C_LEVEL_EVENT>= g_log_level) THEN
664: trace
665: (p_msg => 'after calling fun_seq_batch.populate_acct_seq_info'
666: ,p_level => C_LEVEL_EVENT
667: ,p_module => l_log_module);
668: END IF;
669:

Line 673: fun_seq_batch.Batch_exit(p_request_id => l_request_id

669:
670: update_entries_from_gt;
671:
672: IF (l_xla_seq_status = 'SUCCESS') THEN
673: fun_seq_batch.Batch_exit(p_request_id => l_request_id
674: ,x_status => l_xla_seq_status);
675: END IF;
676: IF (l_gl_seq_status = 'SUCCESS') THEN
677: fun_seq_batch.Batch_exit(p_request_id => l_request_id

Line 677: fun_seq_batch.Batch_exit(p_request_id => l_request_id

673: fun_seq_batch.Batch_exit(p_request_id => l_request_id
674: ,x_status => l_xla_seq_status);
675: END IF;
676: IF (l_gl_seq_status = 'SUCCESS') THEN
677: fun_seq_batch.Batch_exit(p_request_id => l_request_id
678: ,x_status => l_gl_seq_status);
679: END IF;
680: END IF;
681: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 746: l_seq_context_value fun_seq_batch.context_value_tbl_type;

742: , p_retcode OUT NOCOPY NUMBER) is
743: l_log_module VARCHAR2(240);
744: l_ledger_id number;
745: l_period_name varchar2(100);
746: l_seq_context_value fun_seq_batch.context_value_tbl_type;
747: l_xla_seq_status varchar2(30);
748: l_gl_seq_status varchar2(30);
749: l_start_date gl_period_statuses.start_date%TYPE;
750: l_end_date gl_period_statuses.end_date%TYPE;

Line 824: (p_msg => 'calling fun_seq_batch.batch_init'

820: END IF;
821:
822: IF (C_LEVEL_EVENT>= g_log_level) THEN
823: trace
824: (p_msg => 'calling fun_seq_batch.batch_init'
825: ,p_level => C_LEVEL_EVENT
826: ,p_module => l_log_module);
827: END IF;
828: -- call fun_seq_batch.batch_init

Line 828: -- call fun_seq_batch.batch_init

824: (p_msg => 'calling fun_seq_batch.batch_init'
825: ,p_level => C_LEVEL_EVENT
826: ,p_module => l_log_module);
827: END IF;
828: -- call fun_seq_batch.batch_init
829: -- for xla first
830: l_seq_context_value(1) := p_ledger_id;
831: fun_seq_batch.Batch_init(p_application_id => 602
832: ,p_table_name => 'XLA_AE_HEADERS'

Line 831: fun_seq_batch.Batch_init(p_application_id => 602

827: END IF;
828: -- call fun_seq_batch.batch_init
829: -- for xla first
830: l_seq_context_value(1) := p_ledger_id;
831: fun_seq_batch.Batch_init(p_application_id => 602
832: ,p_table_name => 'XLA_AE_HEADERS'
833: ,p_event_code => 'PERIOD_CLOSE'
834: ,p_context_type => 'LEDGER_AND_CURRENCY'
835: ,p_context_value_tbl =>l_seq_context_value

Line 841: fun_seq_batch.Batch_init(p_application_id => 101

837: ,x_status => l_xla_seq_status
838: ,x_seq_context_id => l_xla_seq_context_id);
839:
840: -- for gl
841: fun_seq_batch.Batch_init(p_application_id => 101
842: ,p_table_name => 'GL_JE_HEADERS'
843: ,p_event_code => 'PERIOD_CLOSE'
844: ,p_context_type => 'LEDGER_AND_CURRENCY'
845: ,p_context_value_tbl =>l_seq_context_value

Line 852: (p_msg => 'after calling fun_seq_batch.batch_init'

848: ,x_seq_context_id => l_gl_seq_context_id);
849:
850: IF (C_LEVEL_EVENT>= g_log_level) THEN
851: trace
852: (p_msg => 'after calling fun_seq_batch.batch_init'
853: ,p_level => C_LEVEL_EVENT
854: ,p_module => l_log_module);
855: END IF;
856:

Line 876: FROM FUN_SEQ_CONTEXTS

872: -- l_sort_date will have value 'GL_DATE', 'REFERENCE_DATE' or 'COMPLETION_DATE'
873: IF(l_gl_seq_status = 'SUCCESS') THEN
874: SELECT nvl(SORT_OPTION, DATE_TYPE)
875: INTO l_sort_date
876: FROM FUN_SEQ_CONTEXTS
877: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
878: ELSE
879: SELECT nvl(SORT_OPTION, DATE_TYPE)
880: INTO l_sort_date

Line 881: FROM FUN_SEQ_CONTEXTS

877: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
878: ELSE
879: SELECT nvl(SORT_OPTION, DATE_TYPE)
880: INTO l_sort_date
881: FROM FUN_SEQ_CONTEXTS
882: WHERE SEQ_CONTEXT_ID = l_xla_seq_context_id;
883: END IF;
884:
885: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

Line 900: fun_seq_batch.Batch_exit(p_request_id => l_request_id

896: , p_start_date => l_start_date
897: , p_end_date => l_end_date
898: , p_sort_date => l_sort_date);
899: IF (l_xla_seq_status = 'SUCCESS') THEN
900: fun_seq_batch.Batch_exit(p_request_id => l_request_id
901: ,x_status => l_xla_seq_status);
902: END IF;
903: IF (l_gl_seq_status = 'SUCCESS') THEN
904: fun_seq_batch.Batch_exit(p_request_id => l_request_id

Line 904: fun_seq_batch.Batch_exit(p_request_id => l_request_id

900: fun_seq_batch.Batch_exit(p_request_id => l_request_id
901: ,x_status => l_xla_seq_status);
902: END IF;
903: IF (l_gl_seq_status = 'SUCCESS') THEN
904: fun_seq_batch.Batch_exit(p_request_id => l_request_id
905: ,x_status => l_gl_seq_status);
906: END IF;
907: END IF;
908:

Line 1142: fun_seq.reset(p_seq_version_id => l_seq_ver_id

1138: LOOP
1139: FETCH c_reset_cursor into l_seq_value, l_seq_ver_id;
1140: EXIT WHEN c_reset_cursor%NOTFOUND;
1141:
1142: fun_seq.reset(p_seq_version_id => l_seq_ver_id
1143: ,p_sequence_number => l_seq_value -1 );
1144: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
1145: trace
1146: (p_msg => 'ver_id:'||to_char(l_seq_ver_id) || ' ver value:'||