APPS.IGS_EN_ENROLL_WLST dependencies on IGS_PE_PERSON

Line 6: p_person_id igs_pe_person.person_id%TYPE,

2: /* $Header: IGSEN73B.pls 120.9 2005/12/12 03:32:10 appldev ship $ */
3:
4: /*** Enrolling Persons - Called in loop for Validated filtered student PL/SQL tables **/
5: PROCEDURE Enroll_Persons(p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
6: p_person_id igs_pe_person.person_id%TYPE,
7: p_course_cd igs_en_su_attempt.course_cd%TYPE,
8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,
9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,
10: p_max_quota IN igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,

Line 80: v_person_number igs_pe_person.person_number%TYPE;

76: SELECT party_number
77: FROM hz_parties
78: WHERE party_id=p_person_id;
79:
80: v_person_number igs_pe_person.person_number%TYPE;
81:
82: /** Start of enrol persons **/
83:
84:

Line 467: lv_person_type igs_pe_person_types.person_type_code%TYPE;

463:
464: prraj 08-Apr-2002
465:
466: ******************************************************************/
467: lv_person_type igs_pe_person_types.person_type_code%TYPE;
468:
469: CURSOR c_version_number
470: IS
471: SELECT version_number

Line 479: FROM igs_pe_person_types

475: -- Cursor to get the Person Type Code corresponding to the System Type
476: -- Added as per the bug# 2364461.
477: CURSOR cur_per_typ IS
478: SELECT person_type_code
479: FROM igs_pe_person_types
480: WHERE system_type = 'OTHER';
481: l_cur_per_typ cur_per_typ%ROWTYPE;
482:
483: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 588: lv_person_type igs_pe_person_types.person_type_code%TYPE;

584: Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd to get the academic calendar of the given
585: load calendar rather than current academic calendar for the bug fix: 2381603
586:
587: */
588: lv_person_type igs_pe_person_types.person_type_code%TYPE;
589:
590: -- Cursor to get the Person Type Code corresponding to the System Type
591: -- Added as per the bug# 2364461.
592: CURSOR cur_per_typ IS

Line 594: FROM igs_pe_person_types

590: -- Cursor to get the Person Type Code corresponding to the System Type
591: -- Added as per the bug# 2364461.
592: CURSOR cur_per_typ IS
593: SELECT person_type_code
594: FROM igs_pe_person_types
595: WHERE system_type = 'OTHER';
596: l_cur_per_typ cur_per_typ%ROWTYPE;
597:
598: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 792: v_person_number igs_pe_person.person_number%TYPE;

788: SELECT party_number
789: FROM hz_parties
790: WHERE party_id=p_person_id;
791:
792: v_person_number igs_pe_person.person_number%TYPE;
793: CURSOR c_incl_org_wlst_cp is
794: SELECT asses_chrg_for_wlst_stud
795: FROM IGS_EN_OR_UNIT_WLST
796: WHERE cal_type = p_cal_type AND

Line 1965: lv_person_type igs_pe_person_types.person_type_code%TYPE;

1961: Nishikant 01NOV2002 The call to the function igs_ss_enr_details.get_notification got modified to add two new
1962: parameters p_person_id, p_message.
1963: */
1964:
1965: lv_person_type igs_pe_person_types.person_type_code%TYPE;
1966:
1967: -- Cursor to get the Person Type Code corresponding to the System Type
1968: -- Added as per the bug# 2364461.
1969: CURSOR cur_per_typ IS

Line 1971: FROM igs_pe_person_types

1967: -- Cursor to get the Person Type Code corresponding to the System Type
1968: -- Added as per the bug# 2364461.
1969: CURSOR cur_per_typ IS
1970: SELECT person_type_code
1971: FROM igs_pe_person_types
1972: WHERE system_type = 'OTHER';
1973: l_cur_per_typ cur_per_typ%ROWTYPE;
1974:
1975: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;