798: X_CLEARED_BY_FLAG => null,
799: X_REFERENCE_TEXT => null,
800: X_BANK_ACCOUNT_TEXT => null,
801: X_CUSTOMER_TEXT => null,
802: X_CREATED_BY => nvl(fnd_global.user_id, -1),
803: X_CREATION_DATE => sysdate,
804: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
805: X_LAST_UPDATE_DATE => sysdate,
806: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1));
800: X_BANK_ACCOUNT_TEXT => null,
801: X_CUSTOMER_TEXT => null,
802: X_CREATED_BY => nvl(fnd_global.user_id, -1),
803: X_CREATION_DATE => sysdate,
804: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
805: X_LAST_UPDATE_DATE => sysdate,
806: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1));
807:
808: -- insert a destination cashflow
802: X_CREATED_BY => nvl(fnd_global.user_id, -1),
803: X_CREATION_DATE => sysdate,
804: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
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,
841: X_CLEARED_BY_FLAG => null,
842: X_REFERENCE_TEXT => null,
843: X_BANK_ACCOUNT_TEXT => null,
844: X_CUSTOMER_TEXT => null,
845: X_CREATED_BY => nvl(fnd_global.user_id, -1),
846: X_CREATION_DATE => sysdate,
847: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
848: X_LAST_UPDATE_DATE => sysdate,
849: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1));
843: X_BANK_ACCOUNT_TEXT => null,
844: X_CUSTOMER_TEXT => null,
845: X_CREATED_BY => nvl(fnd_global.user_id, -1),
846: X_CREATION_DATE => sysdate,
847: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
848: X_LAST_UPDATE_DATE => sysdate,
849: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1));
850:
851: ELSIF (l_mode = 'UPDATE') THEN
845: X_CREATED_BY => nvl(fnd_global.user_id, -1),
846: X_CREATION_DATE => sysdate,
847: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
848: X_LAST_UPDATE_DATE => sysdate,
849: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1));
850:
851: ELSIF (l_mode = 'UPDATE') THEN
852: BEGIN
853: select rowid, cashflow_id, object_version_number
894: X_CLEARED_BY_FLAG => null,
895: X_REFERENCE_TEXT => null,
896: X_BANK_ACCOUNT_TEXT => null,
897: X_CUSTOMER_TEXT => null,
898: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
899: X_LAST_UPDATE_DATE => sysdate,
900: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
901: X_OBJECT_VERSION_NUMBER => l_objectversion(1));
902:
896: X_BANK_ACCOUNT_TEXT => null,
897: X_CUSTOMER_TEXT => null,
898: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
899: X_LAST_UPDATE_DATE => sysdate,
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(
936: X_CLEARED_BY_FLAG => null,
937: X_REFERENCE_TEXT => null,
938: X_BANK_ACCOUNT_TEXT => null,
939: X_CUSTOMER_TEXT => null,
940: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
941: X_LAST_UPDATE_DATE => sysdate,
942: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
943: X_OBJECT_VERSION_NUMBER => l_objectversion(2));
944: EXCEPTION
938: X_BANK_ACCOUNT_TEXT => null,
939: X_CUSTOMER_TEXT => null,
940: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
941: X_LAST_UPDATE_DATE => sysdate,
942: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
943: X_OBJECT_VERSION_NUMBER => l_objectversion(2));
944: EXCEPTION
945: WHEN OTHERS THEN
946: log('EXCEPTION: l_mode = UPDATE');