DBA Data[Home] [Help]

APPS.XLA_REPORTING_SEQUENCE_PKG dependencies on FUN_SEQ_BATCH

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 608: fun_seq_batch.Batch_exit(p_request_id => l_request_id

604: (p_msg => 'adjustment period, already assigned. End of assign_sequence'
605: ,p_level => C_LEVEL_PROCEDURE
606: ,p_module => l_log_module);
607: END IF;
608: fun_seq_batch.Batch_exit(p_request_id => l_request_id
609: ,x_status => l_gl_seq_status); --Added for bug 8310543
610: RETURN;
611: END IF;
612: END IF;

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

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

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

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

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

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

Line 675: fun_seq_batch.Batch_exit(p_request_id => l_request_id

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

Line 679: fun_seq_batch.Batch_exit(p_request_id => l_request_id

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

Line 748: l_seq_context_value fun_seq_batch.context_value_tbl_type;

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

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

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

Line 830: -- call fun_seq_batch.batch_init

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

Line 833: fun_seq_batch.Batch_init(p_application_id => 602

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

Line 843: fun_seq_batch.Batch_init(p_application_id => 101

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

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

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

Line 902: fun_seq_batch.Batch_exit(p_request_id => l_request_id

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

Line 906: fun_seq_batch.Batch_exit(p_request_id => l_request_id

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