Chapter 13 Code Snippets
========================

p. 425, Step 3:

import oracle.jbo.domain.Number;

-------------------------------------------

p. 426, Step 4, top of page:

public Number audit(Number salaryThreshold, Number reportsThreshold)
{
  int managersFired = 0;
  return new Number(managersFired);
}


Step 3:

import oracle.jbo.domain.Number;


Step 4, near bottom of page:

public Number auditManagers(Number salaryThreshold, Number reportsThreshold)
{
  return getAllManagers().audit(salaryThreshold, reportsThreshold);
}

-------------------------------------------

p. 431, Step 3, near bottom of page:

RowSetIterator secondaryIterator = createRowSetIterator(null);


Step 5, bottom of page:

ManagersViewRowImpl currentMgr;
while (secondaryIterator.hasNext())
{
  currentMgr =
    (ManagersViewRowImpl) secondaryIterator.next();
  managersFired++;
}

-------------------------------------------

p. 432, Step 6, near top of page:

secondaryIterator.closeRowSetIterator();

-------------------------------------------

p. 433, Step 2:

ViewCriteria mgrCriteria = createViewCriteria();


Step 4:

ViewCriteriaRow manRow = mgrCriteria.createViewCriteriaRow();
manRow.setAttribute("Salary", "> " + salaryThreshold);
manRow.setAttribute("NumReports", "< " + reportsThreshold);
mgrCriteria.addElement(manRow);


Step 6:

applyViewCriteria(mgrCriteria);
executeQuery();


Step 7:

applyViewCriteria(null);
executeQuery();

-------------------------------------------

p. 434, Step 3, near bottom of page:

RowIterator reportsIter;
EmployeesViewRowImpl currentRpt;


Step 6, bottom of page:

reportsIter = currentMgr.getReportsView();

-------------------------------------------

p. 435, Step 7:

while (reportsIter.hasNext())
{
  currentRpt = (EmployeesViewRowImpl) reportsIter.next();
}
Bulleted step:

currentRpt.setManagerId(new Number(100));


Step 1, middle of page:

currentMgr.remove();

-------------------------------------------

p. 439, Step 3, top of page:

public void addReportsToPastJobs()
{
  createViewLink(
    "ReportsToPastJobs",
    "hrapp.model.datamodel.EmpPastJobsLink",
    getManagerReports(),
    getReportPastJobs() );
}


Step 1, middle of page:

public void removeReportsToPastJobs()
{
  ViewLink linkForRemoval =
    this.findViewLink("ReportsToPastJobs");
  linkForRemoval.remove();
}


-------------------------------------------