REQUESTCENTER_TEST38 — Procedure, funzioni, package, trigger

Generato da catalogo (snapshot 2026-07-21). Dipendenze proc→tabella: TASK-SPDEP-001 (schemi piccoli).

PROCEDURE (345)

Elenco troncato: 200 di 345 (TASK-DB-002 per l'elenco completo).

• ADDCALLTYPE
• ADDCOMPTOMOINTERVENT
• ADDCOMPTOMOREQUEST
• ADDCUSTOMLISTITEM
• ADDFILEEXTENSIONALLOWED
• ADDFILETOINTERVENT
• ADDFILETOREQUEST
• ADDFILETYPE
• ADDINTERVENTACTOR
• ADDINTERVENTTOREQUEST
• ADDLOGDATETOUSER
• ADDMAINTACTIVITYTOREQUEST
• ADDMAINTACTTOREQUEST
• ADDMOTOINTERVENT
• ADDMOTOREQUEST
• ADDREGISTRATIONTOINTERVENT
• ADDREQUESTAPPROVAL
• ADDREQUESTCATEGORY
• ADDREQUESTCOMPLAINT
• ADDREQUESTCONTACT
• ADDREQUESTCS
• ADDREQUESTCSREASON
• ADDREQUESTFROMTYPE
• ADDREQUESTTYPOLOGY
• ADDREQUESTURGE
• ADDROLE
• ADDSIGNTOINTERVENT
• ADDSIGNTOREQUEST
• ADDTENANTTOENTITY
• ADDTENANTTOENTITYBYGUID
• ADDTENANTTOENTITYBYSTR
• ADDUSER
• ADDUSERREGISTRY
• ADDUSERROLE
• CHECKUSERINUSE
• DELETEAPPROVALBYREQUEST
• DELETECALLTYPE
• DELETECOMPTOMOINTERVENT
• DELETECOMPTOMOREQUEST
• DELETECUSTOMLISTITEM
• DELETEFILEEXTENSIONALLOWED
• DELETEFILETOINTERVENT
• DELETEFILETOREQUEST
• DELETEFILETYPE
• DELETEINTERVENTACTOR
• DELETEINTERVENTTOREQUEST
• DELETEMAINTACTIVITYTOREQUEST
• DELETEMAINTACTTOREQUEST
• DELETEMOTOINTERVENT
• DELETEMOTOREQUEST
• DELETEREQUEST
• DELETEREQUESTAPPROVAL
• DELETEREQUESTCATEGORY
• DELETEREQUESTCONTACT
• DELETEREQUESTCS
• DELETEREQUESTCSREASON
• DELETEREQUESTFROMTYPE
• DELETEREQUESTTYPOLOGY
• DELETEROLE
• DELETESIGNTOINTERVENT
• DELETESIGNTOREQUEST
• DELETETENANTALLBYENTITY
• DELETETENANTALLBYENTITYBYGUID
• DELETETENANTALLBYENTITYBYSTR
• DELETETENANTBYENTITY
• DELETETENANTBYENTITYBYGUID
• DELETETENANTBYENTITYBYSTR
• DELETEUSER
• DELETEUSERREGISTRY
• DELETEUSERROLE
• DELTEMPORARYPROTOCOL
• DISABLEUSER
• DISABLEUSERALLROLES
• DISABLEUSERROLE
• ENABLEUSER
• ENABLEUSERROLE
• GETADMINREQUESTLISTBYP
• GETADMINREQUESTLISTBYPL
• GETADMINREQUESTLISTCHILDS
• GETADMINREQUESTLISTLBYP
• GETADMINREQUESTLISTSTATE
• GETADMINREQUESTLISTSTATE2
• GETADMINREQUESTLISTSTATEL
• GETADMINWFELEMENTS
• GETADMINWFELEMENTSL
• GETALERTSIDUSED
• GETAPPROVALISUSED
• GETAPPROVALLISTBYREQUEST
• GETCALLTYPE
• GETCALLTYPELIST
• GETCDRIDUSED
• GETCHILDREQUESTLIST
• GETCHILDREQUESTLISTBYPCTYPE
• GETCHILDREQUESTLISTBYPCTYPEL
• GETCHILDREQUESTLISTL
• GETCHILDWFELEMENTS
• GETCHILDWFELEMENTSBYPCTYPE
• GETCHILDWFELEMENTSBYPCTYPEL
• GETCHILDWFELEMENTSL
• GETCLOSEDREQUESTINTERVENTLIST
• GETCLOSEDREQUESTINTERVENTLISTL
• GETCLOSEDREQUESTINTVLISTBYLST
• GETCOMPANIESIDUSED
• GETCONTACTSIDUSED
• GETCONTRACTSIDUSED
• GETCSISUSED
• GETCUSTOMITEM
• GETCUSTOMITEMLIST
• GETCUSTOMITEMLISTLIST
• GETCUSTOMSTRINGFIELDVALUES
• GETDEFERABILITY
• GETDEFERABILITYLIST
• GETFILEALLOWEDEXTENSION
• GETFILEALLOWEDEXTLIST
• GETFILETYPE
• GETFILETYPEEXTENSIONLIST
• GETFILETYPEFORWFACTIVITY
• GETFILETYPEFORWFSTATE
• GETFILETYPELIST
• GETIDUSERFROMLOGINID
• GETINTERVENT
• GETINTERVENTACTORLIST
• GETINTERVENTCOMPONENT
• GETINTERVENTCOMPONENTLIST
• GETINTERVENTFILELIST
• GETINTERVENTLIST
• GETINTERVENTLISTBYFILTER
• GETINTERVENTLISTBYFILTERL
• GETINTERVENTLISTBYIDREQUESTLST
• GETINTERVENTLISTCOMPANY
• GETINTERVENTLISTCONTRACT
• GETINTERVENTLISTMAINTENANCE
• GETINTERVENTLISTMANAGEMENT
• GETINTERVENTMO
• GETINTERVENTMOCOMPLIST
• GETINTERVENTMOLIST
• GETINTERVENTSIGNLIST
• GETINTERVENTSIGNLISTBYREQUEST
• GETINTERVENTTYPE
• GETINTERVENTTYPELIST
• GETINTVCOMPONENTSIDUSED
• GETLOGINIDSUSED
• GETMAINTAINISUSED
• GETMANAGEMENTSIDUSED
• GETMOSIDUSED
• GETNEWPROTOCOL
• GETOPENERREQUESTLISTSTATE
• GETOPENERREQUESTLISTSTATEL
• GETOPENERSIDUSED
• GETOPENERWFELEMENTS
• GETOPENERWFELEMENTSL
• GETPROTSRCREQUESTINTVLIST
• GETPROTSRCREQUESTINTVLISTL
• GETREFERREQUESTLISTSTATE
• GETREFERREQUESTLISTSTATEL
• GETREFERRERISUSED
• GETREFERWFELEMENTS
• GETREFERWFELEMENTSL
• GETREQUEST
• GETREQUESTANOMALIES
• GETREQUESTANOMALIESL
• GETREQUESTAPPROVAL
• GETREQUESTAPPROVALHISTORYLIST
• GETREQUESTAPPROVALLIST
• GETREQUESTBYPROTOCOL
• GETREQUESTCATEGORY
• GETREQUESTCATEGORYLIST
• GETREQUESTCOMPBYCATEGORYLIST
• GETREQUESTCOMPLAINT
• GETREQUESTCOMPLAINTLIST
• GETREQUESTCOMPONENT
• GETREQUESTCOMPONENTLIST
• GETREQUESTCOMPONENTSIDUSED
• GETREQUESTCS
• GETREQUESTCSLIST
• GETREQUESTCSLISTBYIDREQUEST
• GETREQUESTCSREASON
• GETREQUESTCSREASONLIST
• GETREQUESTCUSTOMITEMLIST
• GETREQUESTCUSTOMITEMLISTBYCL
• GETREQUESTCUSTOMITEMLISTBYCLI
• GETREQUESTERREQUESTLISTSTATE
• GETREQUESTERREQUESTLISTSTATEL
• GETREQUESTERSIDUSED
• GETREQUESTERWFELEMENTS
• GETREQUESTERWFELEMENTSL
• GETREQUESTFILELIST
• GETREQUESTFILELISTBYLIST
• GETREQUESTFILES
• GETREQUESTFROMTYPE
• GETREQUESTFROMTYPELIST
• GETREQUESTIDLISTCUSTOMITEMLIST
• GETREQUESTIDSBYFILTER
• GETREQUESTIDSBYFILTERL
• GETREQUESTINTERVENTACTORLIST
• GETREQUESTINTERVENTCOMPLIST
• GETREQUESTINTERVENTFILELIST
• GETREQUESTINTERVENTLIST
• GETREQUESTINTERVENTLISTBYGUID
• GETREQUESTINTERVENTLISTCOMP

FUNCTION (2)

• GETROLEFILTERSTRING
• TESTREPORTBODY

PACKAGE (5)

• DATAANALYSIS
• DATAANALYSIS_T2
• GESTREQUEST
• GESTREQUEST_T2
• WORKDAYS

PACKAGE BODY (5)

• DATAANALYSIS
• DATAANALYSIS_T2
• GESTREQUEST
• GESTREQUEST_T2
• WORKDAYS

TRIGGER (28)

• CALLTYPE
• CUSTOMLISTITEM
• DEFERABILITY
• DR$INTERVENTDS_INDEXTC
• DR$REQUESTDS_INDEXTC
• FILEEXTENSIONALLOWED
• FILETYPE
• FLOWTYPE
• INTERVENTTYPE
• PRICECATEGORY
• PRICETYPE
• REQUESTAPPROVAL
• REQUESTAPPROVALHISTORY
• REQUESTCATEGORY
• REQUESTCHARGES
• REQUESTCOMPLAINT
• REQUESTCONTACT
• REQUESTFROMTYPE
• REQUESTINTERVENT
• REQUESTINTERVENTFILES
• REQUESTREGISTRY
• REQUESTREGISTRYFILES
• REQUESTTYPE
• REQUESTTYPOLOGY
• REQUESTURGE
• ROLE
• USERREGISTRY
• USERS

VIEW (28)

• BI_REPORTCENTER_TICKETS
• CUT_RPT_ELEMENTACTIVITY
• CUT_RPT_ELEMENTPROTOCOL
• CUT_RPT_ELEMENTSTATE
• CUT_RPT_TICKET
• EXTENDED_BIS
• PBI_RC_PIVOT_SOURCE
• RC_CONTRACTS
• RC_DWH_CUSTOMFIELDS
• RC_DWH_DEM
• RC_PIVOT_SOURCE
• RC_PIVOT_SOURCE_ADB
• RC_PIVOT_SOURCE_EXTENDED
• RC_REQUESTFILES_V
• RC_TICKETS
• RPT_REQCHARGES
• VCLASSIFICATION
• VICH_PERMANENZA_STATI
• VIEWREQUESTTOTALS
• VIEWREQUESTTOTALS2
• VIEWUSERROLE
• VIEWUSERS
• VIEW_PIVOT_TICKETSLA
• VIEW_PIVOT_TICKETSLA_GSE
• VIEW_PIVOT_TICKETSLA_ICH
• VREQUESTS
• _REQUESTCATEGORY
• __REQUESTCATEGORY

SEQUENCE (33)

• CALLTYPE_0
• CUSTOMLISTITEM_0
• DBOBJECTID_SEQUENCE
• DEFERABILITY_0
• DUMP_TICKETESITI_0
• DUMP_TICKETLISTHISTORY_0
• DUMP_TICKETLIST_0
• FILEEXTENSIONALLOWED_0
• FILETYPE_0
• FLOWTYPE_0
• INTERVENTTYPE_0
• ISEQ$$_887281
• ISEQ$$_887297
• ISEQ$$_905381
• PRICECATEGORY_0
• PRICETYPE_0
• REQUESTAPPROVALHISTORY_0
• REQUESTAPPROVAL_0
• REQUESTCATEGORY_0
• REQUESTCHARGES_0
• REQUESTCOMPLAINT_0
• REQUESTCONTACT_0
• REQUESTFROMTYPE_0
• REQUESTINTERVENTFILES_0
• REQUESTINTERVENT_0
• REQUESTREGISTRYFILES_0
• REQUESTREGISTRY_0
• REQUESTTYPE_0
• REQUESTTYPOLOGY_0
• REQUESTURGE_0
• ROLE_0
• USERREGISTRY_0
• USERS_0

TYPE (5)

• MYDATETABLE
• MYINTTABLE
• MYRAWTABLE
• MYSTRINGTABLE
• T_STRARRAY