[Home] [Help]
2: /* $Header: IGSHE9BB.pls 120.15 2006/09/21 23:56:26 jbaber noship $ */
3:
4: -- Variables that will be accessed by any or all the procedures
5: -- Extract related records
6: g_he_ext_run_dtls igs_he_ext_run_dtls%ROWTYPE;
7: g_he_ext_run_except igs_he_ext_run_excp%ROWTYPE;
8: g_he_submsn_return igs_he_submsn_return%ROWTYPE;
9: g_he_submsn_header igs_he_submsn_header%ROWTYPE;
10:
556: jbaber 15 Mar 2006 Modified c_fld_defn to use report_null_flag instead of
557: mandatory_flag as per HE365 - Extract Rerun
558: ----------------------------------------------------------------------*/
559: PROCEDURE get_field_defn
560: (p_extract_run_id IN igs_he_ext_run_dtls.extract_run_id%TYPE)
561: IS
562:
563: CURSOR c_ext_dtl IS
564: SELECT a.submission_name,
574: c.offset_days ,
575: c.validation_country,
576: c.apply_to_atmpt_st_dt,
577: c.apply_to_inst_st_dt
578: FROM igs_he_ext_run_dtls a,
579: igs_he_submsn_return b,
580: igs_he_submsn_header c
581: WHERE a.extract_run_id = p_extract_run_id
582: AND a.submission_name = b.submission_name
9189: p_uv_version_number Unit Code Version Number
9190: p_line_number Line Number of the current line being processed
9191: ----------------------------------------------------------------------*/
9192: PROCEDURE process_fields
9193: (p_extract_run_id igs_he_ext_run_dtls.extract_run_id%TYPE,
9194: p_person_id igs_he_ex_rn_dat_ln.person_id%TYPE,
9195: p_course_cd igs_he_ex_rn_dat_ln.course_cd%TYPE,
9196: p_crv_version_number igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
9197: p_student_inst_number igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
9424: p_student_inst_number Student Instance Number
9425: p_line_number Line Number of the current line being processed
9426: ----------------------------------------------------------------------*/
9427: FUNCTION process_comb_stdnt_return
9428: (p_extract_run_id igs_he_ext_run_dtls.extract_run_id%TYPE,
9429: p_person_id igs_he_ex_rn_dat_ln.person_id%TYPE,
9430: p_course_cd igs_he_ex_rn_dat_ln.course_cd%TYPE,
9431: p_crv_version_number igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
9432: p_student_inst_number igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
10337: p_uv_version_number Version Number of the Unit Code
10338: p_line_number Line Number of the current line being processed
10339: ----------------------------------------------------------------------*/
10340: FUNCTION process_module_return
10341: (p_extract_run_id igs_he_ext_run_dtls.extract_run_id%TYPE,
10342: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
10343: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
10344: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
10345: RETURN BOOLEAN
10447: p_person_id Person Id
10448: p_line_number Line Number of the current line being processed
10449: ----------------------------------------------------------------------*/
10450: FUNCTION process_dlhe_return
10451: (p_extract_run_id igs_he_ext_run_dtls.extract_run_id%TYPE,
10452: p_person_id igs_he_ex_rn_dat_ln.person_id%TYPE,
10453: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
10454: RETURN BOOLEAN
10455: IS
10581: Parameters :
10582: p_extract_run_id IN The Extract Run Id
10583: ----------------------------------------------------------------------*/
10584: PROCEDURE process_temp_table
10585: (p_extract_run_id IN igs_he_ext_run_dtls.extract_run_id%TYPE,
10586: p_module_called_from IN VARCHAR2,
10587: p_new_run_flag IN VARCHAR2)
10588: IS
10589: /***************************************************************