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.

[Home] [Help]

APPS.IGS_EN_WLST_GEN_PROC dependencies on HZ_PARTIES

Line 464: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS

460: cur_sua_rec c_stud_unit_attempt%ROWTYPE;
461:
462:
463: -- Cursor to select person number based on the person_id
464: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
465: SELECT party_number
466: FROM hz_parties
467: WHERE party_id = cp_person_id;
468:

Line 466: FROM hz_parties

462:
463: -- Cursor to select person number based on the person_id
464: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE) IS
465: SELECT party_number
466: FROM hz_parties
467: WHERE party_id = cp_person_id;
468:
469: -- Cursor to select user name of the student based on the person_id
470: CURSOR c_student(cp_person_id hz_parties.party_id%TYPE) IS

Line 470: CURSOR c_student(cp_person_id hz_parties.party_id%TYPE) IS

466: FROM hz_parties
467: WHERE party_id = cp_person_id;
468:
469: -- Cursor to select user name of the student based on the person_id
470: CURSOR c_student(cp_person_id hz_parties.party_id%TYPE) IS
471: SELECT user_name
472: FROM fnd_user
473: WHERE person_party_id = cp_person_id;
474:

Line 490: l_person_number_wlst hz_parties.party_number%TYPE;

486: TYPE t_stud_waitlist IS TABLE OF t_stud_wait_rec INDEX BY BINARY_INTEGER;
487:
488: stud_waitlist_table t_stud_waitlist;
489:
490: l_person_number_wlst hz_parties.party_number%TYPE;
491: l_person_number_sua hz_parties.party_number%TYPE;
492: l_student_user_name fnd_user.user_name%TYPE;
493:
494: waitlist_pos NUMBER;

Line 491: l_person_number_sua hz_parties.party_number%TYPE;

487:
488: stud_waitlist_table t_stud_waitlist;
489:
490: l_person_number_wlst hz_parties.party_number%TYPE;
491: l_person_number_sua hz_parties.party_number%TYPE;
492: l_student_user_name fnd_user.user_name%TYPE;
493:
494: waitlist_pos NUMBER;
495: counter NUMBER;

Line 1631: CURSOR c_person_num (cp_person_id hz_parties.party_id%TYPE) IS

1627: IS
1628:
1629:
1630: -- cursor to get the Person Number corresponding to the person_id
1631: CURSOR c_person_num (cp_person_id hz_parties.party_id%TYPE) IS
1632: SELECT party_number
1633: FROM hz_parties
1634: WHERE party_id = cp_person_id;
1635:

Line 1633: FROM hz_parties

1629:
1630: -- cursor to get the Person Number corresponding to the person_id
1631: CURSOR c_person_num (cp_person_id hz_parties.party_id%TYPE) IS
1632: SELECT party_number
1633: FROM hz_parties
1634: WHERE party_id = cp_person_id;
1635:
1636: -- cursor to get the calendar description
1637: CURSOR c_cal_desc (pc_cal_type igs_ca_inst.cal_type%TYPE, pc_seq_num igs_ca_inst.sequence_number%TYPE) IS

Line 1643: l_party_id hz_parties.party_id%TYPE;

1639: FROM igs_ca_inst
1640: WHERE cal_type=pc_cal_type
1641: AND sequence_number=pc_seq_num;
1642:
1643: l_party_id hz_parties.party_id%TYPE;
1644: l_cal_type igs_ca_inst.cal_type%TYPE;
1645: l_seq_num igs_ca_inst.sequence_number%TYPE;
1646: l_party_number hz_parties.party_number%TYPE;
1647: l_description igs_ca_inst.description%TYPE;

Line 1646: l_party_number hz_parties.party_number%TYPE;

1642:
1643: l_party_id hz_parties.party_id%TYPE;
1644: l_cal_type igs_ca_inst.cal_type%TYPE;
1645: l_seq_num igs_ca_inst.sequence_number%TYPE;
1646: l_party_number hz_parties.party_number%TYPE;
1647: l_description igs_ca_inst.description%TYPE;
1648:
1649: BEGIN
1650: