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_HE_EXTRACT2_PKG dependencies on IGS_HE_EX_RN_DAT_LN

Line 690: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,

686: --else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value
687: --of course in context and assign it to field
688: ----------------------------------------------------------------------*/
689: PROCEDURE process_comb_fields
690: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
691: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
692: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
693: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
694: p_field_number IN NUMBER,

Line 691: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,

687: --of course in context and assign it to field
688: ----------------------------------------------------------------------*/
689: PROCEDURE process_comb_fields
690: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
691: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
692: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
693: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
694: p_field_number IN NUMBER,
695: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

Line 692: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,

688: ----------------------------------------------------------------------*/
689: PROCEDURE process_comb_fields
690: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
691: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
692: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
693: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
694: p_field_number IN NUMBER,
695: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
696:

Line 693: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,

689: PROCEDURE process_comb_fields
690: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
691: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
692: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
693: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
694: p_field_number IN NUMBER,
695: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
696:
697: IS

Line 4619: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,

4615: --else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value
4616: --of course in context and assign it to field
4617: ----------------------------------------------------------------------*/
4618: PROCEDURE process_stdnt_fields
4619: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
4620: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
4621: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
4622: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
4623: p_field_number IN NUMBER,

Line 4620: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,

4616: --of course in context and assign it to field
4617: ----------------------------------------------------------------------*/
4618: PROCEDURE process_stdnt_fields
4619: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
4620: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
4621: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
4622: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
4623: p_field_number IN NUMBER,
4624: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

Line 4621: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,

4617: ----------------------------------------------------------------------*/
4618: PROCEDURE process_stdnt_fields
4619: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
4620: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
4621: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
4622: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
4623: p_field_number IN NUMBER,
4624: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
4625:

Line 4622: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,

4618: PROCEDURE process_stdnt_fields
4619: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
4620: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
4621: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
4622: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
4623: p_field_number IN NUMBER,
4624: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
4625:
4626: IS

Line 8225: (p_unit_cd IN igs_he_ex_rn_dat_ln.unit_cd%TYPE,

8221: p_field_number Field Number currently being processed.
8222: p_value Calculated Value of the field.
8223: ----------------------------------------------------------------------*/
8224: PROCEDURE process_module_fields
8225: (p_unit_cd IN igs_he_ex_rn_dat_ln.unit_cd%TYPE,
8226: p_uv_version_number IN igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
8227: p_field_number IN igs_he_ex_rn_dat_fd.field_number%TYPE,
8228: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
8229: IS

Line 8226: p_uv_version_number IN igs_he_ex_rn_dat_ln.uv_version_number%TYPE,

8222: p_value Calculated Value of the field.
8223: ----------------------------------------------------------------------*/
8224: PROCEDURE process_module_fields
8225: (p_unit_cd IN igs_he_ex_rn_dat_ln.unit_cd%TYPE,
8226: p_uv_version_number IN igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
8227: p_field_number IN igs_he_ex_rn_dat_fd.field_number%TYPE,
8228: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
8229: IS
8230: /***************************************************************

Line 8597: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,

8593: p_value Calculated Value of the field.
8594:
8595: ----------------------------------------------------------------------*/
8596: PROCEDURE process_dlhe_fields
8597: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
8598: p_field_number IN NUMBER,
8599: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
8600:
8601: IS

Line 9194: p_person_id igs_he_ex_rn_dat_ln.person_id%TYPE,

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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,

Line 9195: p_course_cd igs_he_ex_rn_dat_ln.course_cd%TYPE,

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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,

Line 9196: p_crv_version_number igs_he_ex_rn_dat_ln.crv_version_number%TYPE,

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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
9200: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)

Line 9197: p_student_inst_number igs_he_ex_rn_dat_ln.student_inst_number%TYPE,

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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
9200: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9201: IS

Line 9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
9200: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9201: IS
9202: /***************************************************************

Line 9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
9200: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9201: IS
9202: /***************************************************************
9203: Created By : Bidisha S

Line 9200: p_line_number igs_he_ex_rn_dat_ln.line_number%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,
9198: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,
9199: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
9200: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9201: IS
9202: /***************************************************************
9203: Created By : Bidisha S
9204: Date Created By : 28-Jan-02

Line 9429: p_person_id igs_he_ex_rn_dat_ln.person_id%TYPE,

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,
9433: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)

Line 9430: p_course_cd igs_he_ex_rn_dat_ln.course_cd%TYPE,

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,
9433: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9434: RETURN BOOLEAN

Line 9431: p_crv_version_number igs_he_ex_rn_dat_ln.crv_version_number%TYPE,

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,
9433: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9434: RETURN BOOLEAN
9435: /***************************************************************

Line 9432: p_student_inst_number igs_he_ex_rn_dat_ln.student_inst_number%TYPE,

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,
9433: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9434: RETURN BOOLEAN
9435: /***************************************************************
9436: Created By :

Line 9433: p_line_number igs_he_ex_rn_dat_ln.line_number%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,
9433: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)
9434: RETURN BOOLEAN
9435: /***************************************************************
9436: Created By :
9437: Date Created By :

Line 10342: p_unit_cd igs_he_ex_rn_dat_ln.unit_cd%TYPE,

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
10346: IS

Line 10343: p_uv_version_number igs_he_ex_rn_dat_ln.uv_version_number%TYPE,

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
10346: IS
10347: --smaddali modified the order of columns because they donot match that of the Fetch statement bug 2417454

Line 10344: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)

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
10346: IS
10347: --smaddali modified the order of columns because they donot match that of the Fetch statement bug 2417454
10348: CURSOR c_moddtl IS

Line 10452: p_person_id igs_he_ex_rn_dat_ln.person_id%TYPE,

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
10456: /***************************************************************

Line 10453: p_line_number igs_he_ex_rn_dat_ln.line_number%TYPE)

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
10456: /***************************************************************
10457: Created By : smaddali

Line 10614: l_line_number igs_he_ex_rn_dat_ln.line_number%TYPE;

10610: line_number
10611: FROM igs_he_ext_run_interim
10612: WHERE extract_run_id = p_extract_run_id;
10613:
10614: l_line_number igs_he_ex_rn_dat_ln.line_number%TYPE;
10615: l_he_ex_rn_dat_ln igs_he_ex_rn_dat_ln%ROWTYPE;
10616: l_rowid VARCHAR2(30);
10617: l_message VARCHAR2(2000);
10618:

Line 10615: l_he_ex_rn_dat_ln igs_he_ex_rn_dat_ln%ROWTYPE;

10611: FROM igs_he_ext_run_interim
10612: WHERE extract_run_id = p_extract_run_id;
10613:
10614: l_line_number igs_he_ex_rn_dat_ln.line_number%TYPE;
10615: l_he_ex_rn_dat_ln igs_he_ex_rn_dat_ln%ROWTYPE;
10616: l_rowid VARCHAR2(30);
10617: l_message VARCHAR2(2000);
10618:
10619:

Line 10658: FROM igs_he_ex_rn_dat_ln

10654: THEN
10655:
10656: SELECT MAX(line_number)
10657: INTO l_line_number
10658: FROM igs_he_ex_rn_dat_ln
10659: WHERE extract_run_id = p_extract_run_id;
10660:
10661: l_line_number := Nvl(l_line_number,0) + 1;
10662:

Line 10726: Igs_He_Ex_Rn_Dat_Ln_Pkg.Insert_Row

10722: ELSE
10723: l_he_ex_rn_dat_ln.recalculate_flag := 'N';
10724: END IF;
10725:
10726: Igs_He_Ex_Rn_Dat_Ln_Pkg.Insert_Row
10727: (X_rowid => l_rowid,
10728: X_rn_dat_ln_id => l_he_ex_rn_dat_ln.rn_dat_ln_id,
10729: X_person_id => l_he_ex_rn_dat_ln.person_id,
10730: X_course_cd => l_he_ex_rn_dat_ln.course_cd,

Line 10756: UPDATE igs_he_ex_rn_dat_ln

10752: -- Update timestamp of recalulated record
10753: -- to allow filtering on date when creating the extract file.
10754: -- Also update recalculate flag for any records that were picked up from
10755: -- person or program criteria.
10756: UPDATE igs_he_ex_rn_dat_ln
10757: SET last_update_date = sysdate,
10758: recalculate_flag = 'Y'
10759: WHERE extract_run_id = p_extract_run_id
10760: AND line_number = l_he_ex_rn_dat_ln.line_number;