APPS.IGF_AP_OSS_INTEGR dependencies on HZ_PARTIES

Line 4: PROCEDURE get_pe_visa_type(p_person_id IN hz_parties.party_id%TYPE,

1: PACKAGE igf_ap_oss_integr AS
2: /* $Header: IGFAP19S.pls 120.0 2005/06/01 14:41:58 appldev noship $ */
3:
4: PROCEDURE get_pe_visa_type(p_person_id IN hz_parties.party_id%TYPE,
5: p_visa_type OUT NOCOPY igs_pe_visa.visa_type%TYPE,
6: p_visa_desc OUT NOCOPY fnd_lookup_values.meaning%TYPE,
7: p_multiple OUT NOCOPY VARCHAR2);
8:

Line 10: PROCEDURE get_pe_active_holds(p_person_id IN hz_parties.party_id%TYPE,

6: p_visa_desc OUT NOCOPY fnd_lookup_values.meaning%TYPE,
7: p_multiple OUT NOCOPY VARCHAR2);
8:
9:
10: PROCEDURE get_pe_active_holds(p_person_id IN hz_parties.party_id%TYPE,
11: p_encumb_type OUT NOCOPY VARCHAR2,
12: p_encumb_desc OUT NOCOPY VARCHAR2,
13: p_multiple OUT NOCOPY VARCHAR2);
14:

Line 16: PROCEDURE get_pe_citizenship_stat(p_person_id IN hz_parties.party_id%TYPE,

12: p_encumb_desc OUT NOCOPY VARCHAR2,
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:

Line 21: PROCEDURE get_pe_mil_service_type(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,
23: p_mil_service_desc OUT NOCOPY igs_lookups_view.meaning%TYPE,
24: p_multiple OUT NOCOPY VARCHAR2);
25:

Line 43: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,

39:
40: --Made the p_adm_appl_number,p_course-cd,p_crv_version_number as IN OUT NOCOPY parameters From IN
41: --as per the FACCR001 DLD
42:
43: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
44: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
45: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
46: p_ad_appl_row_id OUT NOCOPY ROWID,
47: p_ad_prog_appl_row_id OUT NOCOPY ROWID,

Line 57: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,

53: p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%TYPE,
54: p_multiple OUT NOCOPY VARCHAR2 );
55:
56:
57: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
58: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
59: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
60: RETURN ROWID;
61:

Line 62: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,

58: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
59: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
60: RETURN ROWID;
61:
62: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
63: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
64: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
65: RETURN ROWID;
66: