[Home] [Help]
81: --
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,
229: -- adding error message to stack as an when a validation fails.
230: --
231: FUNCTION validate_spo_db_cons (
232: p_lgcy_prout_rec IN lgcy_prout_rec_type,
233: p_person_id IN igs_pe_person.person_id%TYPE,
234: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE,
235: p_org_start_dt IN igs_pe_hz_parties.ou_start_dt%TYPE
236:
237: ) RETURN BOOLEAN IS
424: -- the table IGS_PR_STDNT_PR_OU.
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,
890: -- error message to stack as an when it encounters one.
891: --
892: FUNCTION validate_prg_db_cons (
893: p_lgcy_prout_rec IN lgcy_prout_rec_type,
894: p_person_id IN igs_pe_person.person_id%TYPE,
895: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
896: ) RETURN BOOLEAN IS
897: --
898: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
982: -- adding error message to stack as an when it encounters one
983: --
984: FUNCTION validate_uset_db_cons (
985: p_lgcy_prout_rec IN lgcy_prout_rec_type,
986: p_person_id IN igs_pe_person.person_id%TYPE,
987: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
988: ) RETURN BOOLEAN IS
989: --
990: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1047: -- in the table IGS_PR_SDT_PR_UNT_ST
1048: --
1049: FUNCTION validate_unit_set (
1050: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1051: p_person_id IN igs_pe_person.person_id%TYPE,
1052: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE,
1053: p_hold_effect_type IN VARCHAR2
1054: ) RETURN BOOLEAN IS
1055: --
1113: -- adding error message to stack as an when it encounters one
1114: --
1115: FUNCTION validate_unit_db_cons (
1116: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1117: p_person_id IN igs_pe_person.person_id%TYPE,
1118: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
1119: ) RETURN BOOLEAN IS
1120: --
1121: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1232: -- adding error message to stack as an when it encounters one
1233: --
1234: FUNCTION validate_awd_db_cons (
1235: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1236: p_person_id IN igs_pe_person.person_id%TYPE,
1237: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
1238: ) RETURN BOOLEAN IS
1239: --
1240: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1350: -- adding error message to stack as an when it encounters one
1351: --
1352: FUNCTION validate_fnd_db_cons (
1353: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1354: p_person_id IN igs_pe_person.person_id%TYPE,
1355: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
1356: ) RETURN BOOLEAN IS
1357: --
1358: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1405: --
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);