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)
555: IS
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)
555: IS
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 746: FROM CE_CASHFLOWS

742: --check if its in insert or update mode
743: BEGIN
744: SELECT COUNT(*)
745: INTO p_count
746: FROM CE_CASHFLOWS
747: WHERE TRXN_REFERENCE_NUMBER = p_trxn_reference_number;
748:
749: IF ( p_count <> 0 ) THEN
750: l_mode := 'UPDATE';

Line 766: CE_CASHFLOWS_PKG.insert_row (

762: IF (l_mode = 'INSERT')
763: THEN
764:
765: --insert a source cashflow
766: CE_CASHFLOWS_PKG.insert_row (
767: X_ROWID => l_row_id,
768: X_CASHFLOW_ID => p_cashflow_id1,
769: X_CASHFLOW_LEDGER_ID => p_source_ledger_id,
770: X_CASHFLOW_LEGAL_ENTITY_ID => G_source_le_id,

Line 809: CE_CASHFLOWS_PKG.insert_row (

805: X_LAST_UPDATE_DATE => sysdate,
806: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1));
807:
808: -- insert a destination cashflow
809: CE_CASHFLOWS_PKG.insert_row (
810: X_ROWID => l_row_id,
811: X_CASHFLOW_ID => p_cashflow_id2,
812: X_CASHFLOW_LEDGER_ID => p_dest_ledger_id,
813: X_CASHFLOW_LEGAL_ENTITY_ID => G_dest_le_id,

Line 855: from ce_cashflows

851: ELSIF (l_mode = 'UPDATE') THEN
852: BEGIN
853: select rowid, cashflow_id, object_version_number
854: bulk collect into l_rowid, l_cashflow, l_objectversion
855: from ce_cashflows
856: where trxn_reference_number = p_trxn_reference_number
857: order by cashflow_id;
858: p_cashflow_id1 := l_cashflow(1);
859: p_cashflow_id2 := l_cashflow(2);

Line 862: CE_CASHFLOWS_PKG.update_row (

858: p_cashflow_id1 := l_cashflow(1);
859: p_cashflow_id2 := l_cashflow(2);
860:
861: --update the source cashflow
862: CE_CASHFLOWS_PKG.update_row (
863: X_ROWID => l_rowid(1),
864: X_CASHFLOW_ID => p_cashflow_id1,
865: X_CASHFLOW_LEDGER_ID => p_source_ledger_id,
866: X_CASHFLOW_LEGAL_ENTITY_ID => G_source_le_id,

Line 904: CE_CASHFLOWS_PKG.update_row(

900: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
901: X_OBJECT_VERSION_NUMBER => l_objectversion(1));
902:
903: --update a destination cashflow
904: CE_CASHFLOWS_PKG.update_row(
905: X_ROWID => l_rowid(2),
906: X_CASHFLOW_ID => p_cashflow_id2,
907: X_CASHFLOW_LEDGER_ID => p_dest_ledger_id,
908: X_CASHFLOW_LEGAL_ENTITY_ID => G_dest_le_id,