APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_GE_GEN_003

Line 393: p_person_id := IGS_GE_GEN_003.get_person_id(p_lgcy_adstunt_rec.person_number );

389: l_return_status VARCHAR2(1000);
390:
391: BEGIN
392: p_s_adv_stnd_type := 'UNIT'; -- initialise
393: p_person_id := IGS_GE_GEN_003.get_person_id(p_lgcy_adstunt_rec.person_number );
394: mydebug('Got person ID as ' || p_person_id);
395: IF p_person_id IS NULL THEN
396: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
397: FND_MSG_PUB.ADD;

Line 407: mydebug('Calling IGS_GE_GEN_003.get_calendar_instance ' || p_cal_type || p_lgcy_adstunt_rec.load_cal_alt_code);

403: FND_MSG_PUB.ADD;
404: RETURN FALSE;
405: END IF;
406:
407: mydebug('Calling IGS_GE_GEN_003.get_calendar_instance ' || p_cal_type || p_lgcy_adstunt_rec.load_cal_alt_code);
408: igs_ge_gen_003.get_calendar_instance(p_alternate_cd => p_lgcy_adstunt_rec.load_cal_alt_code ,
409: p_s_cal_category=>'''LOAD''',
410: p_cal_type => p_cal_type,
411: p_ci_sequence_number => p_seq_number ,

Line 408: igs_ge_gen_003.get_calendar_instance(p_alternate_cd => p_lgcy_adstunt_rec.load_cal_alt_code ,

404: RETURN FALSE;
405: END IF;
406:
407: mydebug('Calling IGS_GE_GEN_003.get_calendar_instance ' || p_cal_type || p_lgcy_adstunt_rec.load_cal_alt_code);
408: igs_ge_gen_003.get_calendar_instance(p_alternate_cd => p_lgcy_adstunt_rec.load_cal_alt_code ,
409: p_s_cal_category=>'''LOAD''',
410: p_cal_type => p_cal_type,
411: p_ci_sequence_number => p_seq_number ,
412: p_start_dt => l_start_dt ,

Line 423: p_auth_pers_id := igs_ge_gen_003.get_person_id(p_lgcy_adstunt_rec.authorising_person_number );

419: FND_MSG_PUB.ADD;
420: RETURN FALSE;
421: END IF;
422:
423: p_auth_pers_id := igs_ge_gen_003.get_person_id(p_lgcy_adstunt_rec.authorising_person_number );
424:
425: mydebug('Got p_auth_pers_id as ' || p_auth_pers_id);
426: OPEN c_unit_details_id(p_lgcy_adstunt_rec.PREV_UNIT_CD ,p_lgcy_adstunt_rec.prev_term ,
427: p_lgcy_adstunt_rec.start_date , p_lgcy_adstunt_rec.end_date ,

Line 459: p_as_version_number := igs_ge_gen_003.get_program_version( p_person_id => p_person_id , p_program_cd => p_lgcy_adstunt_rec.program_cd );

455: IF l_n_rec_count = 0 OR l_count >=2 THEN
456: p_tst_rslt_dtls_id := NULL;
457: END IF;
458: -- Get the program version number
459: p_as_version_number := igs_ge_gen_003.get_program_version( p_person_id => p_person_id , p_program_cd => p_lgcy_adstunt_rec.program_cd );
460: mydebug('Got p_as_version_number as ' || p_as_version_number);
461:
462: -- Default p_lgcy_adstunt_rec.achievable_credit_points
463: IF p_lgcy_adstunt_rec.achievable_credit_points IS NULL THEN

Line 1711: igs_ge_gen_003.get_org_id()

1707: p_lgcy_adstunt_rec.total_exmptn_approved ,
1708: p_lgcy_adstunt_rec.total_exmptn_granted,
1709: p_lgcy_adstunt_rec.total_exmptn_perc_grntd,
1710: p_lgcy_adstunt_rec.exemption_institution_cd ,
1711: igs_ge_gen_003.get_org_id()
1712: );
1713: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
1714: mydebug('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION');
1715: IF NOT IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION(

Line 1831: igs_ge_gen_003.get_org_id(),

1827: p_lgcy_adstunt_rec.revoked_dt,
1828: p_lgcy_adstunt_rec.comments,
1829: /* p_lgcy_adstunt_rec.credit_percentage, */
1830: upper(p_lgcy_adstunt_rec.s_adv_stnd_recognition_type),
1831: igs_ge_gen_003.get_org_id(),
1832: l_request_id,
1833: l_program_application_id,
1834: l_program_id,
1835: l_program_update_date,

Line 1937: igs_ge_gen_003.get_org_id(),

1933: SYSDATE,
1934: p_lgcy_adstunt_rec.basis_program_type ,
1935: p_lgcy_adstunt_rec.basis_year,
1936: p_lgcy_adstunt_rec.basis_completion_ind,
1937: igs_ge_gen_003.get_org_id(),
1938: l_av_stnd_unit_lvl_id
1939: );
1940: ELSE -- validate_unit_basis
1941: x_return_status := FND_API.G_RET_STS_ERROR;