[Home] [Help]
84: p_lgcy_prout_rec IN OUT NOCOPY lgcy_prout_rec_type,
85: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
86: p_prg_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
87: p_prg_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
88: p_outcome_sequence_number OUT NOCOPY igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,
89: p_hold_effect_type OUT NOCOPY igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE,
90: p_org_start_dt OUT NOCOPY igs_pe_hz_parties.ou_start_dt%TYPE,
91: x_return_value OUT NOCOPY BOOLEAN
92: ) IS
92: ) IS
93: --
94: CURSOR cur_sequence_number IS
95: SELECT sequence_number
96: FROM igs_pr_stdnt_pr_ou_all
97: WHERE person_id = p_person_id
98: AND progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type
99: AND course_cd = p_lgcy_prout_rec.program_cd
100: AND prg_cal_type = p_prg_cal_type
167: -- Derive the Outcome Sequence Number.
168: -- Check for the existance of Student Progression Outcome in OSS which
169: -- matches with the record in interface table. If the record exists then
170: -- assign p_outcome_sequence_number with
171: -- igs_pr_stdnt_pr_ou_all.sequence_number else assign the new sequence value
172: -- from igs_pr_spo_seq_num_s sequence.
173: --
174: OPEN cur_sequence_number;
175: FETCH cur_sequence_number INTO p_outcome_sequence_number;
427: p_lgcy_prout_rec IN lgcy_prout_rec_type,
428: p_person_id IN igs_pe_person.person_id%TYPE,
429: p_prg_cal_type IN igs_ca_inst.cal_type%TYPE,
430: p_prg_sequence_number IN igs_ca_inst.sequence_number%TYPE,
431: p_outcome_sequence_number IN igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,
432: p_hold_effect_type IN VARCHAR2,
433: p_decision_ou_start_dt IN igs_pe_hz_parties.ou_start_dt%TYPE
434: ) RETURN BOOLEAN IS
435: --
1408: -- Local params
1409: l_person_id igs_pe_person.person_id%TYPE;
1410: l_prg_cal_type igs_ca_inst.cal_type%TYPE;
1411: l_prg_sequence_number igs_ca_inst.sequence_number%TYPE;
1412: l_outcome_sequence_number igs_pr_stdnt_pr_ou_all.sequence_number%TYPE;
1413: l_hold_effect_type VARCHAR2(2000);
1414: l_org_start_dt igs_pe_hz_parties.ou_start_dt%TYPE;
1415: l_return_value VARCHAR2(1);
1416: l_return_boolean_value BOOLEAN;