[Home] [Help]
202: fun_seq.get_assign_context_info(
203: p_context_type => 'LEDGER_AND_CURRENCY',
204: p_context_value => p_ledgers_tbl(i),
205: p_application_id => 101,
206: p_table_name => 'GL_JE_HEADERS',
207: p_event_code => 'POSTING',
208: p_request_id => NULL, -- Don't use cache. Not locked yet.
209: x_seq_context_id => l_seq_context_id,
210: x_control_date_type => l_date_type,
623: l_je_source_tbl,
624: l_je_category_tbl,
625: l_gl_date_tbl
626: FROM fun_seq_batch_gt bg,
627: gl_je_headers jh
628: WHERE bg.source_id = jh.je_header_id;
629: --
630: -- Loop for journal entries in fun_seq_batch_gt
631: --
665: fun_seq.get_assigned_sequence_info(
666: p_context_type => 'LEDGER_AND_CURRENCY',
667: p_context_value => l_ledger_id_tbl(i),
668: p_application_Id => 101,
669: p_table_name => 'GL_JE_HEADERS',
670: p_event_code => 'POSTING',
671: p_control_attribute_rec => l_ctrl_attr_rec,
672: p_control_date_tbl => l_ctrl_date_tbl,
673: p_request_id => -1, -- Use Cache
702: -- Meaning of each Status
703: -- [No action is required]
704: -- NO_ASSIGN_CONTEXT
705: -- NO_ASSIGNMENT
706: -- [Update GL_JE_HEADERS with the information in FUN_SEQ_BATCH_GT
707: -- DO_NOT_SEQUENCE
708: -- SEQ_VER_FOUND
709: -- [Critical Error]
710: -- ENFORCE_NO_ASSIGNMENT
817: INTO l_source_id_tbl,
818: l_seq_ver_id_tbl,
819: l_assign_id_tbl
820: FROM fun_seq_batch_gt bg,
821: gl_je_headers jh
822: WHERE jh.je_header_id =bg.source_id and
823: bg.status_code = 'SEQ_VER_FOUND'
824: ORDER BY bg.seq_version_id,
825: bg.assignment_id,
1578: --
1579: SELECT ae_header_id,
1580: application_id,
1581: DECODE(application_id,602,'XLA_AE_HEADERS',
1582: 101,'GL_JE_HEADERS',
1583: null),
1584: ledger_id,
1585: je_source_name,
1586: je_category_name,