Oracle Web Application Programming for PL/SQL Developers

Solutions Specification for classes_list

Description: Call this procedure from 'Classes List' menu item in the classes left nav bar. Load into 'classes_main' frame. List all of the courses in a table. Display the following columns:

  1. Course No
  2. Course
  3. Sections

Each class section should be hyperlinked to 'classes location', passing the section_id for the section selected.

Sample Screen

classes_list.gif

Sample Code

 CREATE OR REPLACE PROCEDURE classes_list  AS 
    v_fname           INSTRUCTOR.first_name%TYPE          DEFAULT NULL;
    v_lname           INSTRUCTOR.last_name%TYPE           DEFAULT NULL;
    v_instructor_id   INSTRUCTOR.instructor_id%TYPE       DEFAULT NULL;
    v_course_no       COURSE.course_no%TYPE               DEFAULT NULL;

 BEGIN NULL;

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

-- FILE           : classes_list.sql
-- CREATED BY     : Solomon Morse
-- CREATED BY DATE: January 12, 2003
-- URL            : classes_list

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


htp.p('

<HTML>
<HEAD>
<TITLE>University Maintenance Website</TITLE>
</HEAD>
 
<BODY BGCOLOR="#99CCCC">
<P ALIGN="CENTER">
<STRONG>
<EM>
<FONT SIZE="+2" COLOR="BLUE">Class List </FONT></EM></STRONG></P>
    
<FONT FACE="ARIAL">
<HR>
    
<FORM ACTION="classes_location" METHOD="POST" NAME="classlistform">
<TABLE ALIGN="CENTER" BORDER="2" CELLPADDING="10" CELLSPACING="5" BGCOLOR="WHITE">

  <TR>
    <TD ALIGN="CENTER" COLSPAN="3"><FONT COLOR="BLUE"><B>Course List - (click on a section to change location)</B></FONT></TD>
  </TR>

  <TR>
    <TD ALIGN="CENTER"><FONT COLOR="BLACK">Course No</FONT></TD>
    <TD ALIGN="CENTER"><FONT COLOR="BLACK">Course</FONT></TD>
    <TD ALIGN="CENTER"><FONT COLOR="MAROON"><B><I>Sections</I></B></FONT></TD>
  </TR>
  
');
 FOR c IN (SELECT course_no,
                    description
             FROM course
             ORDER BY course_no
   ) LOOP

htp.p(' <TR>
    <TD ALIGN="CENTER">'||c.course_no||'</TD>');
htp.p('<TD ALIGN="CENTER">'||c.description||'</TD>');
htp.p('<TD ALIGN="CENTER">');
 FOR s IN (SELECT section_no,
                      section_id
               FROM section
               WHERE course_no=c.course_no
               ORDER BY section_no
     ) LOOP
  
htp.p(' <A HREF="classes_location?p_section_id='||s.section_id||'" LINK="maroon">'||s.section_no||'</A>');


     END LOOP;
  
htp.p(' </TD>
  </TR>  
  
');

   END LOOP;

htp.p(' </TABLE>
   
</P>
</FORM>
</FONT>
<HR>
  
</BODY>
</HTML>

');
 END;
/

Select a Sample Application Code Unit

  1. main_frame (15.2)
  2. top_menu (13.3) / (15.2)
  3. splash (13.1)
  4. student_main_frame (6.3)
  5. students_left_nav (6.3)
  6. search_student (12.4)
  7. get_student (12.4)
  8. student_list (12.4)
  9. student_personal_info (12.4)
  10. student_zipcode (18.5)
  11. update_student (18.5)
  12. instruct (Package Spec and Body)
    • grade_calc (9.2)
    • v_font (9.4)
    • c_instruct_list (9.4)
    • inst_tbl_type (9.4)
    • instruct_table (9.4)
    • [PL/SQL block to load instruct_table] (9.4)
    • instruct_personal_info (11.3)
    • instructor_list_info (11.3)
    • showzip (11.3)
    • instructors_frame (11.1)
    • instructors_left_nav (11.1)
    • update_instructor (11.2)
    • instructor_list_class (11.3)
    • instruct_classes (11.3)
    • student_list (11.2)
  13. classes_main_frame (6.3)
  14. classes_left_nav (6, Building App)
  15. classes_list (6, Building App)
  16. classes_location (13.4)
  17. classes_location_update (13.4)
  18. set_cookie (15.2)
  19. get_cookie (15.2)
  20. cookie_exists (15.2)
  21. visitor_name (15.2)
  22. process_visitor_name (15.2)
  23. student_list_update (not in book)

Main Solutions Page