[Home] [Help]
82: --
83: PROCEDURE derive_pr_stnd_lvl_data (
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,
83: PROCEDURE derive_pr_stnd_lvl_data (
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
425: --
426: FUNCTION validate_stdnt_prg_otcm (
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
426: FUNCTION validate_stdnt_prg_otcm (
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
1406: l_api_name CONSTANT VARCHAR2(30) := 'create_outcome';
1407: l_api_version CONSTANT NUMBER := 1.0;
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;
1407: l_api_version CONSTANT NUMBER := 1.0;
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);