User Tools

Site Tools


hrms-sfis-upgrade:mod_plsql

PLSQL Modified Objects

SchemaObject Name User Description
SYSADMWES_GET_ETHNICITYDAKChanged ethnicity_code to ethnic_grp_cd
SYSADMWES_GET_WESPODAKModified to use new xlat table
SYSADMWES_GET_NAME_PARTSDAKModified to use new xlat table/ GBROWN 3/9/2007 in Function valid_name_type changed to use ps_HCR_NM_TYP_I as cursor
SYSADMWES_GET_XLATDAKModified to use new xlat table
SYSADMWES_ETHNIC_GROUP_CODEDAKModified to use new xlat table
SYSADMWES_GET_ARTS_MATERIALSDAKModified to use new xlat table
SYSADMWES_GET_CREDIT_CATDAKModified to use new field ssr_component
REGGET_SUBJ_CATDAKModified to use new field ssr_component
SYSADMWRG_DROPADD_CREDITSDAKModified to use new field ssr_component
SYSADMWES_GET_EMPLOYEE_STATUSAHModified to use new xlat table
SYSADMWES_GET_EMPL_STAT_EFFDTAHModified to use new xlat table
SYSADMWES_GET_EMPL_STAT_90AHModified to use new xlat table
SYSADMWES_GET_PROGRAMRPLModified to use new xlat table
SYSADMWES_GET_TITLEDLModified to use new position data table(ps_whr_posn_data)to get descr254
SYSADMWES_GET_TITLE_EFFDTDLModified to use new position data table(ps_whr_posn_data)to get descr254
SYSADMWES_GET_TITLE_90BASModified to use new position data table(ps_whr_posn_data)to get descr254
SYSADMWES_GET_DEPTDLModified to use table ps_addresses_sa
SYSADMWES_NAME_EMPLIDGLBFUNCTION modified to use new xlat tables (PSXLATITEM and ps_HCR_NM_TYP_I)
REGCourse_ScheduleGLBPACKAGE Modified to use new xlat table (PSXLATITEM)
SYSADMWES_CRSE_VWGLBVIEW replaced COMPONENT with SSR_COMPONENT, removed AP_BUDGET_PERIOD, removed WROF_BUDGET_PERIOD
SYSADMwes_commDAKreplaced letter_cd with scc_letter_cd, used personal_data as replacement for personal_mc_vw
SYSADMwes_adm_profileDAKreplaced xlattable with psxlatitem and dynamic sql to get ethnic_group
SYSADMOVERSUBSCRIPTIONGLBPACKAGE replaced COMPONENT with SSR_COMPONENT
SYSADMwes_get_title_90AMHreplaced PS_POSITION_DATA with PS_WHR_POSN_DATA
SYSADMWHR_GET_STAFF_FTEAMHreplaces std_hrs_default with std_hours
SYSADMWES_EMERGENCYGLBPROCEDURE Removed @psprod from delete ps_wes_emergency@psprod e
SYSADMWU_DATA.VW_PEOPLE_HRBASremove ORIG_HIRE_DT, access new ps_whr_wess_addrvw
PUBLICPS.PSDBOWNERRPLPublic synonym needs to be created
REGWESMAPS_PAGERPLxlattable change
REGWESMAPS_LOOKUPSRPLxlattable change
REGWESMAPS_DATA_LOADRPLxlattable change
PUBLICPORTFOLIO_AUTHRPLPublic db link needs to be created or copied from prod
REGINSTR_MIN_CLASS_VWRPLReg view component field → ssr_component
ADMIS_WEBCHECKLISTRPLcomponent field → ssr_component
ADMIS_WEBWES_GET_ETHNIC_DTLDAKFUNCTION - fixed to reference ps_divers_ethnic
ADMIS_WEBPREAPPDAKPACKAGE - multiple issues
SYSADMWES_NEW_OR_UPDT_XLIST_CLASSESDAKmodified to deal with all the new fields in CLASS_TBL
SYSADMWES_POST_DEGREESGLBPROCEDURE modified for tables ps_names, ps_addresses, and ps_addresses_sa
SYSADMWRG_MEETS_PREREQGLBFUNCTION removed BULK COLLECT from cursor
REGUTILITIESGLBPACKAGE removed BULK COLLECT from cursor in numerous places of package
SYSADMWES_GET_ETHNICITY_PRIMARYGLBFUNCTION (new) created to return a student's primary ethnicity
SYSADMWES_LOAD_APPLICANTRPLPACKAGE Updated create applicant functionality
SYSADMWES_LOAD_PROSPECTRPLPACKAGE Updated create prospect functionality
SYSADMWAD_PROCESS_QPAY_PREAPPDAKPROCEDURE - PS modified the name of Bank_ACCT_NUM in ADM_APPL_TENDER
SYSADMWAD_UPDATE_COMM_CODESDAK PROCEDURE - Updated LETTER_CD to SCC_LETTER_CD
SYSADMWES_ADRGLB PACKAGE - changed loc_addr from ps_addresses to ps_addresses_sa, commented out section that inserts into ps_pers_data_effdt, modified insert into ps_addresses, added insert into ps_addresses_sa
ATTRACK07UPD_LEAVE_BALBASSTD_HOURS
ATTRACK07UPD_ALL_LEAVE_BALBASSTD_HOURS
ATTRACK07UPD_LEAVE_BAL_1_PERSONBASSTD_HOURS
ATTRACK07LV_ACCRUAL_DAILY_PRCBASSTD_HOURS
WU_DATAVW_PEOPLE_HRBASORIG_HIRE_DT, PS_WHR_WESS_ADDRVW
WU_DATAVW_PEOPLE_HR_POSITIONBAS
WU_DATAVW_PEOPLE_STUDENTBASORIG_HIRE_DT, PS_WHR_WESS_ADDRVW
WU_DATAVW_PEOPLE_HR_PVTBASNEW TO REPLACE SUPPL
SYSADMWES_ROLLOVER_WHR_FRINGEBASNew in production
SYSADMWES_ACCT_CD_TBL_UPDATE_PART1BASReplaces current update
SYSADMWES_ACCT_CD_TBL_UPDATE_PART2BASReplaces current update
SYSADMWRG_PREREQRPLPACKAGE Removed bulk collect in cursor definitions
SYSADMWES_DORM_ADDRESSDAKPROCEDURE - Added ps_addresses_sa to access LOC_ADDR
WU_DATAWES_DEPENDENT_BENEFICIARY_VWAMH VIEW
WU_DATAWHR_PAYROLL_DATA_VWAMHVIEW
OPEN_ENROLLWES_DEPENDENT_BENEFICIARY_VWAMHVIEW
SYSADMWAD_PROCESS_QPAY_PREAPPDAKProcedure - Moved Quickpay Trans_ID from Credit Card Nbr field to firstname field
SYSADMWAD_PASTPRODAKProcedure - Modified structure of Admissions Data Warehouse
SYSADMWES_BATCH_SUMMER_REGGLBPackage - Modified SQL replaced all “INs” with Unions
WES_FINDWPS_WES_DIST_INQ_VWBASACCT_CD tbl chgs
WES_FINDWPS_WES_DIST_STU_VWBASACCT_CD tbl chgs
WES_FINDWPS_WES_DIST_TEM_VWBASACCT_CD tbl chgs
WES_FINDWPS_WES_STU_RPTD_VWBASACCT_CD tbl chgs
WES_FINDWPS_WES_STU_SEC_VWBASACCT_CD tbl chgs
WES_FINDWPS_WES_TEM_RPTD_VWBASACCT_CD tbl chgs
WES_FINDWWES_BUDGET_VWBASACCT_CD tbl chgs
SYSADMWES_PROCESS_CIDDAKPACKAGE - Fixed to deal with new data structure of Crse_offer_tbl
SYSADMWES_STUBILLDAKPACKAGE - Fixed to reference psxlatitem rather than xlattable
REGADVISOR_IASDAKPACKAGE - Comment out the bulk collect in cursor definition
REGFACULTYDAKPACKAGE - Comment out the bulk collect in cursor definition
REGGRADEDAKPACKAGE - Comment out the bulk collect in cursor definition
REGSTUDENTDAKPACKAGE - Comment out the bulk collect in cursor definition
SYSADMNIGHT_JOBSDAKPACKAGE - Comment out the bulk collect in cursor definition
SYSADMWES_UPDATE_ENRL_BINSDAKPROCEDURE - Comment out the bulk collect in cursor definition
SYSADMWES_GET_XLISTINGSDAKFUNCTION - Comment out the bulk collect in cursor definition
SYSADMWES_DROPADDDAKPACKAGE - Comment out the bulk collect in cursor definition
SYSADMWES_PROCESS_CIDDAKPACKAGE - Comment out the bulk collect in cursor definition
SYSADMWAD_CREATE_USA_CITIZENSHIPDAKPROCEDURE - Added 2 more fields for the change in data structure
SYSADMWES_UPDATE_REQ_BINSGLBPROCEDURE - Removed bulk collect from cursor definition
SYSADMwes_delete_address_typeGLBPROCEDURE - in first delete changed to use field ADDRESS_TYPE and included condition for EFFDT ,commented out delete from ps_pers_addr_types - table ps_pers_addr_types no longer exists
hrms-sfis-upgrade/mod_plsql.txt · Last modified: 2007/07/11 20:11 (external edit)