eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_COM_EBL_SUBJ

Line 7402: FROM igs_uc_com_ebl_subj

7398: ,exam_level
7399: ,title
7400: ,subject_code
7401: ,imported
7402: FROM igs_uc_com_ebl_subj
7403: WHERE subject_id = p_subject;
7404:
7405:
7406: -- For data coming from Marvin INterface

Line 7421: CURSOR c_subjectid ( cp_year Igs_uc_com_ebl_subj.year%TYPE ,

7417: c_map_exam_ebl_rec c_map_exam_ebl%ROWTYPE ;
7418:
7419:
7420: -- For deriving subject ID For data coming from Marvin INterface
7421: CURSOR c_subjectid ( cp_year Igs_uc_com_ebl_subj.year%TYPE ,
7422: cp_sitting Igs_uc_com_ebl_subj.sitting%TYPE ,
7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,
7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,
7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS

Line 7422: cp_sitting Igs_uc_com_ebl_subj.sitting%TYPE ,

7418:
7419:
7420: -- For deriving subject ID For data coming from Marvin INterface
7421: CURSOR c_subjectid ( cp_year Igs_uc_com_ebl_subj.year%TYPE ,
7422: cp_sitting Igs_uc_com_ebl_subj.sitting%TYPE ,
7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,
7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,
7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS
7426: SELECT ebl.subject_id

Line 7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,

7419:
7420: -- For deriving subject ID For data coming from Marvin INterface
7421: CURSOR c_subjectid ( cp_year Igs_uc_com_ebl_subj.year%TYPE ,
7422: cp_sitting Igs_uc_com_ebl_subj.sitting%TYPE ,
7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,
7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,
7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS
7426: SELECT ebl.subject_id
7427: FROM Igs_uc_com_ebl_subj ebl , igs_uc_ref_subj ref

Line 7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,

7420: -- For deriving subject ID For data coming from Marvin INterface
7421: CURSOR c_subjectid ( cp_year Igs_uc_com_ebl_subj.year%TYPE ,
7422: cp_sitting Igs_uc_com_ebl_subj.sitting%TYPE ,
7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,
7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,
7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS
7426: SELECT ebl.subject_id
7427: FROM Igs_uc_com_ebl_subj ebl , igs_uc_ref_subj ref
7428: WHERE ebl.subject_code = ref.subj_code

Line 7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS

7421: CURSOR c_subjectid ( cp_year Igs_uc_com_ebl_subj.year%TYPE ,
7422: cp_sitting Igs_uc_com_ebl_subj.sitting%TYPE ,
7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,
7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,
7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS
7426: SELECT ebl.subject_id
7427: FROM Igs_uc_com_ebl_subj ebl , igs_uc_ref_subj ref
7428: WHERE ebl.subject_code = ref.subj_code
7429: AND ebl.year = cp_year

Line 7427: FROM Igs_uc_com_ebl_subj ebl , igs_uc_ref_subj ref

7423: cp_awarding_body Igs_uc_com_ebl_subj.awarding_body%TYPE ,
7424: cp_exam_level Igs_uc_com_ebl_subj.exam_level%TYPE ,
7425: cp_ebl_subject Igs_uc_com_ebl_subj.subject_code%TYPE ) IS
7426: SELECT ebl.subject_id
7427: FROM Igs_uc_com_ebl_subj ebl , igs_uc_ref_subj ref
7428: WHERE ebl.subject_code = ref.subj_code
7429: AND ebl.year = cp_year
7430: AND ebl.sitting = cp_sitting
7431: AND ebl.awarding_body = cp_awarding_body

Line 7649: --Do the further processing only when the Subject ID is available in IGS_UC_COM_EBL_SUBJ table.

7645: CLOSE c_subjectid ;
7646: END IF ;
7647:
7648:
7649: --Do the further processing only when the Subject ID is available in IGS_UC_COM_EBL_SUBJ table.
7650: IF l_subjectid IS NOT NULL THEN
7651:
7652: /************** II) Derive the 3 result fields eblresult, eblamended and claimedresult ***************/
7653: IF new_ivstarpqr_rec.marvin_type = 'P' THEN