APPS.CE_BAT_UTILS dependencies on CE_CASHFLOWS

Line 557: type t_cashflow is table of ce_cashflows.cashflow_id%type;

553: p_cashflow_id1 OUT NOCOPY NUMBER,
554: p_cashflow_id2 OUT NOCOPY NUMBER) is
555:
556:
557: type t_cashflow is table of ce_cashflows.cashflow_id%type;
558: type t_objectversion is table of ce_cashflows.object_version_number%type;
559: type t_rowid is table of varchar2(30);
560:
561: l_cashflow t_cashflow;

Line 558: type t_objectversion is table of ce_cashflows.object_version_number%type;

554: p_cashflow_id2 OUT NOCOPY NUMBER) is
555:
556:
557: type t_cashflow is table of ce_cashflows.cashflow_id%type;
558: type t_objectversion is table of ce_cashflows.object_version_number%type;
559: type t_rowid is table of varchar2(30);
560:
561: l_cashflow t_cashflow;
562: l_objectversion t_objectversion;

Line 678: FROM CE_CASHFLOWS

674: --check if its in insert or update mode
675: BEGIN
676: SELECT COUNT(*)
677: INTO p_count
678: FROM CE_CASHFLOWS
679: WHERE TRXN_REFERENCE_NUMBER = p_trxn_reference_number;
680:
681: IF ( p_count <> 0 ) THEN
682: l_mode := 'UPDATE';

Line 696: CE_CASHFLOWS_PKG.insert_row (

692: IF (l_mode = 'INSERT') THEN
693:
694: --insert a source cashflow
695:
696: CE_CASHFLOWS_PKG.insert_row (
697: X_ROWID => l_row_id,
698: X_CASHFLOW_ID => p_cashflow_id1,
699: X_CASHFLOW_LEDGER_ID => p_source_ledger_id,
700: X_CASHFLOW_LEGAL_ENTITY_ID => G_source_le_id,

Line 742: CE_CASHFLOWS_PKG.insert_row (

738:
739: -- insert a destination cashflow
740:
741:
742: CE_CASHFLOWS_PKG.insert_row (
743: X_ROWID => l_row_id,
744: X_CASHFLOW_ID => p_cashflow_id2,
745: X_CASHFLOW_LEDGER_ID => p_dest_ledger_id,
746: X_CASHFLOW_LEGAL_ENTITY_ID => G_dest_le_id,

Line 789: from ce_cashflows

785: ELSIF (l_mode = 'UPDATE') THEN
786: BEGIN
787: select rowid, cashflow_id, object_version_number
788: bulk collect into l_rowid, l_cashflow, l_objectversion
789: from ce_cashflows
790: where trxn_reference_number = p_trxn_reference_number
791: order by cashflow_id;
792: p_cashflow_id1 := l_cashflow(1);
793: p_cashflow_id2 := l_cashflow(2);

Line 796: CE_CASHFLOWS_PKG.update_row (

792: p_cashflow_id1 := l_cashflow(1);
793: p_cashflow_id2 := l_cashflow(2);
794:
795: --update the source cashflow
796: CE_CASHFLOWS_PKG.update_row (
797: X_ROWID => l_rowid(1),
798: X_CASHFLOW_ID => p_cashflow_id1,
799: X_CASHFLOW_LEDGER_ID => p_source_ledger_id,
800: X_CASHFLOW_LEGAL_ENTITY_ID => G_source_le_id,

Line 839: CE_CASHFLOWS_PKG.update_row(

835: X_OBJECT_VERSION_NUMBER => l_objectversion(1)
836: );
837:
838: --update a destination cashflow
839: CE_CASHFLOWS_PKG.update_row(
840: X_ROWID => l_rowid(2),
841: X_CASHFLOW_ID => p_cashflow_id2,
842: X_CASHFLOW_LEDGER_ID => p_dest_ledger_id,
843: X_CASHFLOW_LEGAL_ENTITY_ID => G_dest_le_id,