APPS.IGS_PR_UPLOAD_EXT_RESULTS dependencies on IGS_CA_INST

Line 21: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

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
25: -- This cursor fetches the interface table records

Line 22: p_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE

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
25: -- This cursor fetches the interface table records
26:

Line 44: cp_alternate_code igs_ca_inst.alternate_code%TYPE

40: WHERE spa.person_id = cp_person_id
41: AND spa.course_cd = cp_course_cd;
42:
43: CURSOR cur_ci_exists (
44: cp_alternate_code igs_ca_inst.alternate_code%TYPE
45: ) IS
46: SELECT ci.cal_type,
47: ci.sequence_number
48: FROM igs_ca_inst ci,

Line 48: FROM igs_ca_inst ci,

44: cp_alternate_code igs_ca_inst.alternate_code%TYPE
45: ) IS
46: SELECT ci.cal_type,
47: ci.sequence_number
48: FROM igs_ca_inst ci,
49: igs_ca_type ct
50: WHERE ci.alternate_code = cp_alternate_code
51: AND ci.cal_type = ct.cal_type
52: AND ct.s_cal_cat = 'LOAD';

Line 342: l_cal_type igs_ca_inst.cal_type%TYPE;

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
346: retcode := 0;

Line 343: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

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
346: retcode := 0;
347: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054