DBA Data[Home] [Help]

APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on IGS_GE_GEN_003

Line 295: l_replaced_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.replaced_person_number);

291:
292:
293: IF p_sprvsr_dtls_rec.replaced_person_number IS NOT NULL THEN
294:
295: l_replaced_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.replaced_person_number);
296:
297: OPEN c_repl_person_dtls(l_replaced_person_id);
298: FETCH c_repl_person_dtls INTO l_replaced_sequence_number;
299: CLOSE c_repl_person_dtls;

Line 545: l_ca_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.ca_person_number);

541: END IF;
542:
543: IF p_sprvsr_status = 'VALID' THEN
544: -- Check whether ca_person_number is valid or not.
545: l_ca_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.ca_person_number);
546:
547: IF l_ca_person_id IS NULL THEN
548: -- Add exception to stack
549: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');

Line 555: l_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.person_number);

551: p_sprvsr_status := 'INVALID';
552: END IF;
553:
554: -- Check whether ca_person_number is valid or not.
555: l_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.person_number);
556:
557: IF l_person_id IS NULL THEN
558: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');
559: FND_MSG_PUB.Add;

Line 606: l_replaced_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.replaced_person_number);

602:
603: IF p_sprvsr_status = 'VALID' THEN
604:
605: IF p_sprvsr_dtls_rec.replaced_person_number IS NOT NULL THEN
606: l_replaced_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.replaced_person_number);
607: OPEN c_repl_person_dtls(l_replaced_person_id);
608: FETCH c_repl_person_dtls INTO l_replaced_sequence_number;
609: CLOSE c_repl_person_dtls;
610: END IF;