function addJobTitles() { $tableName = 'HS_HR_JOB_TITLE'; $this->jobId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'JOBTIT_CODE', 'JOB'); $arrRecordsList[0] = "'" . $this->getJobId() . "'"; $arrRecordsList[1] = "'" . $this->getJobName() . "'"; $arrRecordsList[2] = "'" . $this->getJobDesc() . "'"; $arrRecordsList[3] = "'" . $this->getJobComm() . "'"; $arrRecordsList[4] = "'" . $this->getJobSalGrd() . "'"; $arrRecordsList[5] = isset($this->jobSpecId) ? $this->jobSpecId : 'null'; $arrFieldList[0] = 'JOBTIT_CODE'; $arrFieldList[1] = 'JOBTIT_NAME'; $arrFieldList[2] = 'JOBTIT_DESC'; $arrFieldList[3] = 'JOBTIT_COMM'; $arrFieldList[4] = 'SAL_GRD_CODE'; $arrFieldList[5] = self::DB_FIELD_JOBSPEC_ID; $sql_builder = new SQLQBuilder(); $sql_builder->table_name = $tableName; $sql_builder->flg_insert = 'true'; $sql_builder->arr_insert = $arrRecordsList; $sql_builder->arr_insertfield = $arrFieldList; $sqlQString = $sql_builder->addNewRecordFeature2(); $dbConnection = new DMLFunctions(); $message2 = $dbConnection->executeQuery($sqlQString); $jobTitleEmpStat = new JobTitEmpStat(); $jobTitleEmpStat->setEmpStatId(EmploymentStatus::EMPLOYMENT_STATUS_ID_TERMINATED); $jobTitleEmpStat->setJobTitId($this->getJobId()); $jobTitleEmpStat->addJobTitEmpStat(); return $message2; }