DBA Data[Home] [Help]

APPS.IGS_HE_SPA_LGCY_PUB dependencies on IGS_GE_GEN_003

Line 621: l_person_id := igs_ge_gen_003.get_person_id(p_person_number => p_hesa_spa_stats_rec.person_number);

617: -- If no validation failed then derive the required values
618: IF NOT l_validation_failed THEN
619:
620: -- derive the person Id
621: l_person_id := igs_ge_gen_003.get_person_id(p_person_number => p_hesa_spa_stats_rec.person_number);
622: IF l_person_id IS NULL THEN
623: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_PERSON_NUMBER');
624: FND_MSG_PUB.ADD;
625: x_return_status := FND_API.G_RET_STS_ERROR;

Line 632: l_version_number := igs_ge_gen_003.get_program_version(p_person_id => l_person_id,

628:
629: -- Check whether person ID found then only version number can be derived
630: IF NOT l_validation_failed THEN
631: -- derive the version number of the program attempt
632: l_version_number := igs_ge_gen_003.get_program_version(p_person_id => l_person_id,
633: p_program_cd => p_hesa_spa_stats_rec.program_cd);
634: IF l_version_number IS NULL THEN
635: FND_MESSAGE.SET_NAME ('IGS','IGS_HE_EXT_SPA_DTL_NOT_FOUND');
636: FND_MSG_PUB.ADD;

Line 744: igs_ge_gen_003.get_org_id(),

740: enh_fund_elig_cd,
741: exclude_flag)
742: VALUES (
743: l_hesa_st_spa_id,
744: igs_ge_gen_003.get_org_id(),
745: l_person_id,
746: p_hesa_spa_stats_rec.program_cd,
747: l_version_number,
748: p_hesa_spa_stats_rec.fe_student_marker,