USP_DATAFORMTEMPLATE_ADD_ADDOPPORTUNITIESPROCESS_PRELOAD
The load procedure used by the edit dataform template "Add Opportunities Process Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROSPECTPLANRECORDTYPEID | uniqueidentifier | INOUT | |
| @TRANSACTIONCURRENCYID | uniqueidentifier | INOUT | Currency |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ADDOPPORTUNITIESPROCESS_PRELOAD
(
@PROSPECTPLANRECORDTYPEID uniqueidentifier = null output,
@TRANSACTIONCURRENCYID uniqueidentifier = null output,
@CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;
select @PROSPECTPLANRECORDTYPEID = ID
from dbo.RECORDTYPE
where NAME = 'Prospect Plan';
select @TRANSACTIONCURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID)
return 0;