APPS.IGS_PR_UPLOAD_EXT_RESULTS dependencies on IGS_PR_STU_ACAD_STAT_INT

Line 18: p_stu_acad_stat_int_rec IN igs_pr_stu_acad_stat_int%ROWTYPE,

14: || for the Degree Comnpletion Import.
15: ****************************************************************************************************************/
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

Line 19: p_error_code OUT NOCOPY igs_pr_stu_acad_stat_int.error_code%TYPE,

15: ****************************************************************************************************************/
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: )

Line 28: cp_person_number igs_pr_stu_acad_stat_int.person_number%TYPE

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
32: WHERE hz.party_number = cp_person_number;

Line 330: cp_batch_id igs_pr_stu_acad_stat_int.batch_id%TYPE

326: ||swaghmar 16-Jan-2006 Bug# 4951054 Added check for disabling UI's
327: ****************************************************************************************************************/
328:
329: CURSOR cur_stu_acad_stat_int (
330: cp_batch_id igs_pr_stu_acad_stat_int.batch_id%TYPE
331: ) IS
332: SELECT sasi.*
333: FROM igs_pr_stu_acad_stat_int sasi
334: WHERE sasi.batch_id = cp_batch_id

Line 333: FROM igs_pr_stu_acad_stat_int sasi

329: CURSOR cur_stu_acad_stat_int (
330: cp_batch_id igs_pr_stu_acad_stat_int.batch_id%TYPE
331: ) IS
332: SELECT sasi.*
333: FROM igs_pr_stu_acad_stat_int sasi
334: WHERE sasi.batch_id = cp_batch_id
335: FOR UPDATE;
336:
337: stu_acad_stat_int_rec cur_stu_acad_stat_int%ROWTYPE;

Line 340: l_error_code igs_pr_stu_acad_stat_int.error_code%TYPE;

336:
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;

Line 380: DELETE FROM igs_pr_stu_acad_stat_int

376: x_mode => 'R'
377: );
378:
379: IF l_rowid IS NOT NULL THEN
380: DELETE FROM igs_pr_stu_acad_stat_int
381: WHERE CURRENT OF cur_stu_acad_stat_int;
382: END IF;
383: ELSE
384: UPDATE igs_pr_stu_acad_stat_int

Line 384: UPDATE igs_pr_stu_acad_stat_int

380: DELETE FROM igs_pr_stu_acad_stat_int
381: WHERE CURRENT OF cur_stu_acad_stat_int;
382: END IF;
383: ELSE
384: UPDATE igs_pr_stu_acad_stat_int
385: SET error_code = l_error_code
386: WHERE CURRENT OF cur_stu_acad_stat_int;
387: END IF;
388: END LOOP;