[Home] [Help]
2307: WHERE sca.person_id = p_person_id AND
2308: sca.course_cd = p_course_cd;
2309:
2310: CURSOR c_person(cp_party_id Number) IS
2311: SELECT PARTY_NUMBER FROM HZ_PARTIES
2312: WHERE PARTY_ID = cp_party_id;
2313:
2314: lv_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2315:
2310: CURSOR c_person(cp_party_id Number) IS
2311: SELECT PARTY_NUMBER FROM HZ_PARTIES
2312: WHERE PARTY_ID = cp_party_id;
2313:
2314: lv_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2315:
2316: BEGIN
2317: -- Set the default message number
2318: --kdande; 19-Jul-2002; Bug# 2462120; Nullified the message name since it was defaulted to 0.
2483: || Change History :
2484: || Who When What
2485: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
2486: || kdande 17-Dec-2002 Bug# 2543601. Changed the query for c_pe
2487: || cursor to use hz_parties instead of igs_pe_person
2488: || nalkumar 19-NOV-2002 Bug NO: 2658550. Modified this function as per the FA110 PR Enh.
2489: || pkpatel 7-OCT-2002 Bug No: 2600842
2490: || Added the parameter x_auth_resp_id in the call to igs_pe_pers_encumb_pkg
2491: || (reverse chronological order - newest change first)
2570: att.attendance_type (+)= spo.restricted_attendance_type;
2571: v_spo_rec c_spo%ROWTYPE;
2572: CURSOR c_pe IS
2573: SELECT p.party_id person_id
2574: FROM hz_parties p,
2575: fnd_user u
2576: WHERE u.user_id = FND_GLOBAL.USER_ID
2577: AND u.person_party_id = p.party_id
2578: AND SUBSTR (igs_en_gen_003.get_staff_ind (p.party_id), 1, 1) = 'Y';