728: X_CLEARED_BY_FLAG => null,
729: X_REFERENCE_TEXT => null,
730: X_BANK_ACCOUNT_TEXT => null,
731: X_CUSTOMER_TEXT => null,
732: X_CREATED_BY => nvl(fnd_global.user_id, -1),
733: X_CREATION_DATE => sysdate,
734: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
735: X_LAST_UPDATE_DATE => sysdate,
736: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1)
730: X_BANK_ACCOUNT_TEXT => null,
731: X_CUSTOMER_TEXT => null,
732: X_CREATED_BY => nvl(fnd_global.user_id, -1),
733: X_CREATION_DATE => sysdate,
734: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
735: X_LAST_UPDATE_DATE => sysdate,
736: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1)
737: ) ;
738:
732: X_CREATED_BY => nvl(fnd_global.user_id, -1),
733: X_CREATION_DATE => sysdate,
734: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
735: X_LAST_UPDATE_DATE => sysdate,
736: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1)
737: ) ;
738:
739: -- insert a destination cashflow
740:
774: X_CLEARED_BY_FLAG => null,
775: X_REFERENCE_TEXT => null,
776: X_BANK_ACCOUNT_TEXT => null,
777: X_CUSTOMER_TEXT => null,
778: X_CREATED_BY => nvl(fnd_global.user_id, -1),
779: X_CREATION_DATE => sysdate,
780: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
781: X_LAST_UPDATE_DATE => sysdate,
782: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1)
776: X_BANK_ACCOUNT_TEXT => null,
777: X_CUSTOMER_TEXT => null,
778: X_CREATED_BY => nvl(fnd_global.user_id, -1),
779: X_CREATION_DATE => sysdate,
780: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
781: X_LAST_UPDATE_DATE => sysdate,
782: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1)
783: ) ;
784:
778: X_CREATED_BY => nvl(fnd_global.user_id, -1),
779: X_CREATION_DATE => sysdate,
780: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
781: X_LAST_UPDATE_DATE => sysdate,
782: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1)
783: ) ;
784:
785: ELSIF (l_mode = 'UPDATE') THEN
786: BEGIN
828: X_CLEARED_BY_FLAG => null,
829: X_REFERENCE_TEXT => null,
830: X_BANK_ACCOUNT_TEXT => null,
831: X_CUSTOMER_TEXT => null,
832: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
833: X_LAST_UPDATE_DATE => sysdate,
834: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
835: X_OBJECT_VERSION_NUMBER => l_objectversion(1)
836: );
830: X_BANK_ACCOUNT_TEXT => null,
831: X_CUSTOMER_TEXT => null,
832: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
833: X_LAST_UPDATE_DATE => sysdate,
834: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
835: X_OBJECT_VERSION_NUMBER => l_objectversion(1)
836: );
837:
838: --update a destination cashflow
871: X_CLEARED_BY_FLAG => null,
872: X_REFERENCE_TEXT => null,
873: X_BANK_ACCOUNT_TEXT => null,
874: X_CUSTOMER_TEXT => null,
875: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
876: X_LAST_UPDATE_DATE => sysdate,
877: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
878: X_OBJECT_VERSION_NUMBER => l_objectversion(2)
879: );
873: X_BANK_ACCOUNT_TEXT => null,
874: X_CUSTOMER_TEXT => null,
875: X_LAST_UPDATED_BY => nvl(fnd_global.user_id, -1),
876: X_LAST_UPDATE_DATE => sysdate,
877: X_LAST_UPDATE_LOGIN => nvl(fnd_global.user_id, -1),
878: X_OBJECT_VERSION_NUMBER => l_objectversion(2)
879: );
880: EXCEPTION
881: WHEN OTHERS THEN