APPS.FUN_SEQ_BATCH dependencies on FUN_SEQ_BATCH_GT

Line 611: -- Bulk Collect Journal Entry Information from fun_seq_batch_gt

607: l_ctrl_date_tbl(1).date_type := 'GL_DATE';
608: -- gl date is populated within the loop
609:
610: --
611: -- Bulk Collect Journal Entry Information from fun_seq_batch_gt
612: --
613: SELECT jh.ledger_id,
614: bg.source_id,
615: jh.actual_flag,

Line 626: FROM fun_seq_batch_gt bg,

622: l_actual_flag_tbl,
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

Line 630: -- Loop for journal entries in fun_seq_batch_gt

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: --
632: FOR i IN l_je_header_id_tbl.FIRST .. l_je_header_id_tbl.LAST LOOP
633: l_debug_je_header_id := l_je_header_id_tbl(i);
634: --

Line 706: -- [Update GL_JE_HEADERS with the information in FUN_SEQ_BATCH_GT

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

Line 717: -- Bulk Update fun_seq_batch_gt

713: RAISE no_assigned_seq_info;
714: END IF;
715: END LOOP;
716: --
717: -- Bulk Update fun_seq_batch_gt
718: --
719: IF l_assign_id_tbl.COUNT > 0 THEN
720: FORALL i IN l_assign_id_tbl.FIRST .. l_assign_id_tbl.LAST
721: UPDATE fun_seq_batch_gt

Line 721: UPDATE fun_seq_batch_gt

717: -- Bulk Update fun_seq_batch_gt
718: --
719: IF l_assign_id_tbl.COUNT > 0 THEN
720: FORALL i IN l_assign_id_tbl.FIRST .. l_assign_id_tbl.LAST
721: UPDATE fun_seq_batch_gt
722: SET assignment_id = l_assign_id_tbl(i),
723: seq_version_id = l_seq_ver_id_tbl(i),
724: status_code = l_error_code_tbl(i)
725: WHERE source_id = l_je_header_id_tbl(i);

Line 820: FROM fun_seq_batch_gt bg,

816: BULK COLLECT
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,

Line 835: FROM fun_seq_batch_gt

831: BULK COLLECT
832: INTO l_source_id_tbl,
833: l_seq_ver_id_tbl,
834: l_assign_id_tbl
835: FROM fun_seq_batch_gt
836: WHERE status_code = 'SEQ_VER_FOUND'
837: ORDER BY seq_version_id,
838: assignment_id;
839: END IF;

Line 851: -- Bulk Update fun_seq_batch_gt

847: p_assign_id_tbl => l_assign_id_tbl,
848: x_seq_value_tbl => l_seq_value_tbl,
849: x_seq_date_tbl => l_seq_date_tbl); -- Not used here
850: --
851: -- Bulk Update fun_seq_batch_gt
852: --
853: IF l_source_id_tbl.COUNT > 0 THEN
854: FORALL i IN l_source_id_tbl.FIRST..l_source_id_tbl.LAST
855: UPDATE fun_seq_batch_gt gt

Line 855: UPDATE fun_seq_batch_gt gt

851: -- Bulk Update fun_seq_batch_gt
852: --
853: IF l_source_id_tbl.COUNT > 0 THEN
854: FORALL i IN l_source_id_tbl.FIRST..l_source_id_tbl.LAST
855: UPDATE fun_seq_batch_gt gt
856: SET gt.seq_version_id = l_seq_ver_id_tbl(i),
857: gt.assignment_id = l_assign_id_tbl(i),
858: gt.seq_value = l_seq_value_tbl(i)
859: WHERE gt.source_id = l_source_id_tbl(i);