13: p_multiple OUT NOCOPY VARCHAR2);
14:
15:
16: PROCEDURE get_pe_citizenship_stat(p_person_id IN hz_parties.party_id%TYPE,
17: p_citizenship_stat OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
18: p_citizenship_desc OUT NOCOPY igs_lookups_view.meaning%TYPE);
19:
20:
21: PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,
14:
15:
16: PROCEDURE get_pe_citizenship_stat(p_person_id IN hz_parties.party_id%TYPE,
17: p_citizenship_stat OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
18: p_citizenship_desc OUT NOCOPY igs_lookups_view.meaning%TYPE);
19:
20:
21: PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,
22: p_mil_service_type OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
18: p_citizenship_desc OUT NOCOPY igs_lookups_view.meaning%TYPE);
19:
20:
21: PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,
22: p_mil_service_type OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
23: p_mil_service_desc OUT NOCOPY igs_lookups_view.meaning%TYPE,
24: p_multiple OUT NOCOPY VARCHAR2);
25:
26:
19:
20:
21: PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,
22: p_mil_service_type OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
23: p_mil_service_desc OUT NOCOPY igs_lookups_view.meaning%TYPE,
24: p_multiple OUT NOCOPY VARCHAR2);
25:
26:
27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,