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_PR_UPLOAD_EXT_RESULTS dependencies on HZ_PARTIES

Line 20: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,

16:
17: FUNCTION validate_record (
18: p_stu_acad_stat_int_rec IN igs_pr_stu_acad_stat_int%ROWTYPE,
19: p_error_code OUT NOCOPY igs_pr_stu_acad_stat_int.error_code%TYPE,
20: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
21: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
22: p_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE
23: )
24: RETURN BOOLEAN IS

Line 27: CURSOR cur_hz_parties (

23: )
24: RETURN BOOLEAN IS
25: -- This cursor fetches the interface table records
26:
27: CURSOR cur_hz_parties (
28: cp_person_number igs_pr_stu_acad_stat_int.person_number%TYPE
29: ) IS
30: SELECT hz.party_id
31: FROM hz_parties hz

Line 31: FROM hz_parties hz

27: CURSOR cur_hz_parties (
28: cp_person_number igs_pr_stu_acad_stat_int.person_number%TYPE
29: ) IS
30: SELECT hz.party_id
31: FROM hz_parties hz
32: WHERE hz.party_number = cp_person_number;
33:
34: CURSOR cur_spa_exists (
35: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

Line 94: hz_parties_rec cur_hz_parties%ROWTYPE;

90: FROM igs_pr_sta_type_ele stte
91: WHERE stte.stat_type = cp_stat_type
92: AND stte.s_stat_element = cp_s_stat_element;
93:
94: hz_parties_rec cur_hz_parties%ROWTYPE;
95: spa_exists_rec cur_spa_exists%ROWTYPE;
96: ci_exists_rec cur_ci_exists%ROWTYPE;
97: org_stat_type_rec cur_org_stat_type%ROWTYPE;
98: inst_stat_type_rec cur_inst_stat_type%ROWTYPE;

Line 122: OPEN cur_hz_parties (p_stu_acad_stat_int_rec.person_number);

118: p_error_code := 'IGS_PR_NEGATIVE_STAT_VALUE';
119: RETURN FALSE;
120: END IF;
121:
122: OPEN cur_hz_parties (p_stu_acad_stat_int_rec.person_number);
123: FETCH cur_hz_parties INTO hz_parties_rec;
124:
125: IF (cur_hz_parties%NOTFOUND) THEN
126: p_error_code := 'IGS_PR_PERSON_NOT_FOUND';

Line 123: FETCH cur_hz_parties INTO hz_parties_rec;

119: RETURN FALSE;
120: END IF;
121:
122: OPEN cur_hz_parties (p_stu_acad_stat_int_rec.person_number);
123: FETCH cur_hz_parties INTO hz_parties_rec;
124:
125: IF (cur_hz_parties%NOTFOUND) THEN
126: p_error_code := 'IGS_PR_PERSON_NOT_FOUND';
127: CLOSE cur_hz_parties;

Line 125: IF (cur_hz_parties%NOTFOUND) THEN

121:
122: OPEN cur_hz_parties (p_stu_acad_stat_int_rec.person_number);
123: FETCH cur_hz_parties INTO hz_parties_rec;
124:
125: IF (cur_hz_parties%NOTFOUND) THEN
126: p_error_code := 'IGS_PR_PERSON_NOT_FOUND';
127: CLOSE cur_hz_parties;
128: RETURN FALSE;
129: ELSE

Line 127: CLOSE cur_hz_parties;

123: FETCH cur_hz_parties INTO hz_parties_rec;
124:
125: IF (cur_hz_parties%NOTFOUND) THEN
126: p_error_code := 'IGS_PR_PERSON_NOT_FOUND';
127: CLOSE cur_hz_parties;
128: RETURN FALSE;
129: ELSE
130: p_person_id := hz_parties_rec.party_id;
131: CLOSE cur_hz_parties;

Line 130: p_person_id := hz_parties_rec.party_id;

126: p_error_code := 'IGS_PR_PERSON_NOT_FOUND';
127: CLOSE cur_hz_parties;
128: RETURN FALSE;
129: ELSE
130: p_person_id := hz_parties_rec.party_id;
131: CLOSE cur_hz_parties;
132: END IF;
133:
134: OPEN cur_spa_exists (

Line 131: CLOSE cur_hz_parties;

127: CLOSE cur_hz_parties;
128: RETURN FALSE;
129: ELSE
130: p_person_id := hz_parties_rec.party_id;
131: CLOSE cur_hz_parties;
132: END IF;
133:
134: OPEN cur_spa_exists (
135: hz_parties_rec.party_id,

Line 135: hz_parties_rec.party_id,

131: CLOSE cur_hz_parties;
132: END IF;
133:
134: OPEN cur_spa_exists (
135: hz_parties_rec.party_id,
136: p_stu_acad_stat_int_rec.course_cd
137: );
138: FETCH cur_spa_exists INTO spa_exists_rec;
139:

Line 162: hz_parties_rec.party_id,

158: CLOSE cur_ci_exists;
159: END IF;
160:
161: OPEN cur_org_stat_type (
162: hz_parties_rec.party_id,
163: p_stu_acad_stat_int_rec.course_cd,
164: p_stu_acad_stat_int_rec.stat_type
165: );
166: FETCH cur_org_stat_type INTO org_stat_type_rec;

Line 341: l_person_id hz_parties.party_id%TYPE;

337: stu_acad_stat_int_rec cur_stu_acad_stat_int%ROWTYPE;
338: l_rowid VARCHAR2 (4000) DEFAULT NULL;
339: l_valid_record BOOLEAN DEFAULT FALSE;
340: l_error_code igs_pr_stu_acad_stat_int.error_code%TYPE;
341: l_person_id hz_parties.party_id%TYPE;
342: l_cal_type igs_ca_inst.cal_type%TYPE;
343: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
344: invalid_parameter_combination EXCEPTION;
345: BEGIN

Line 418: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,

414: FUNCTION validate_spa_record (
415: p_person_number IN igs_pr_spa_complete_int.person_number%TYPE,
416: p_course_cd IN igs_pr_spa_complete_int.course_cd%TYPE,
417: p_error_code OUT NOCOPY igs_pr_spa_complete_int.error_code%TYPE,
418: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
419: p_rowid OUT NOCOPY ROWID
420: )
421: RETURN BOOLEAN IS
422:

Line 440: FROM hz_parties hz

436: CURSOR c_parties (
437: cp_person_number igs_pr_spa_complete_int.person_number%TYPE
438: ) IS
439: SELECT hz.party_id
440: FROM hz_parties hz
441: WHERE hz.party_number = cp_person_number;
442:
443: CURSOR c_spa (
444: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

Line 453: l_person_id hz_parties.party_id%TYPE;

449: FROM igs_en_stdnt_ps_att spa
450: WHERE spa.person_id = cp_person_id
451: AND spa.course_cd = cp_course_cd;
452:
453: l_person_id hz_parties.party_id%TYPE;
454: l_rowid ROWID;
455: l_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
456: BEGIN
457: p_error_code := NULL;

Line 504: p_person_id IN hz_parties.party_id%TYPE,

500:
501: -- =========================================================================================
502:
503: FUNCTION validate_susa_record (
504: p_person_id IN hz_parties.party_id%TYPE,
505: p_course_cd IN igs_pr_susa_complete_int.course_cd%TYPE,
506: p_unit_set_cd IN igs_pr_susa_complete_int.unit_set_cd%TYPE,
507: p_error_code OUT NOCOPY igs_pr_susa_complete_int.error_code%TYPE,
508: p_rowid OUT NOCOPY ROWID

Line 864: l_person_id hz_parties.party_id%TYPE;

860: l_susa_rowid ROWID;
861: l_spa_rowid ROWID;
862: l_susa_error_code igs_pr_susa_complete_int.error_code%TYPE;
863: l_spa_error_code igs_pr_spa_complete_int.error_code%TYPE;
864: l_person_id hz_parties.party_id%TYPE;
865: l_errbuf VARCHAR2 (1000);
866: l_retcode NUMBER (1);
867: l_message VARCHAR2 (2000);
868: invalid_parameter_combination EXCEPTION;