APPS.IGF_AP_OSS_INTEGR dependencies on HZ_PARTIES

Line 36: PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,

32:
33: (reverse chronological order - newest change first)
34: ******************************************************************/
35:
36: PROCEDURE get_pe_mil_service_type(p_person_id IN hz_parties.party_id%TYPE,
37: p_mil_service_type OUT NOCOPY igs_lookups_view.lookup_code%TYPE,
38: p_mil_service_desc OUT NOCOPY igs_lookups_view.meaning%TYPE,
39: p_multiple OUT NOCOPY VARCHAR2)
40: IS

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

79: END get_pe_mil_service_type;
80:
81:
82:
83: PROCEDURE get_pe_active_holds(p_person_id IN hz_parties.party_id%TYPE,
84: p_encumb_type OUT NOCOPY VARCHAR2,
85: p_encumb_desc OUT NOCOPY VARCHAR2,
86: p_multiple OUT NOCOPY VARCHAR2)
87: IS

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

131: END get_pe_active_holds;
132:
133:
134:
135: PROCEDURE get_pe_visa_type(p_person_id IN hz_parties.party_id%TYPE,
136: p_visa_type OUT NOCOPY igs_pe_visa.visa_type%TYPE,
137: p_visa_desc OUT NOCOPY fnd_lookup_values.meaning%TYPE,
138: p_multiple OUT NOCOPY VARCHAR2)
139: IS

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

178: END get_pe_visa_type;
179:
180:
181:
182: PROCEDURE get_pe_citizenship_stat(p_person_id IN hz_parties.party_id%TYPE,
183: p_citizenship_stat OUT NOCOPY igs_Lookups_view.lookup_code%TYPE,
184: p_citizenship_desc OUT NOCOPY igs_lookups_view.meaning%TYPE)
185: IS
186:

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

324:
325:
326:
327:
328: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
329: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
330: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
331: p_ad_appl_row_id OUT NOCOPY ROWID,
332: p_ad_prog_appl_row_id OUT NOCOPY ROWID,

Line 372: lv_person_id hz_parties.party_id%TYPE;

368: lv_cal_type igs_ca_inst.cal_type%TYPE DEFAULT NULL;
369: lv_sequence_number igs_ca_inst.sequence_number%TYPE DEFAULT NULL;
370: lv_alt_code igs_ca_inst.alternate_code%TYPE DEFAULT NULL;
371:
372: lv_person_id hz_parties.party_id%TYPE;
373: lv_appl_sel_order VARCHAR2(30);
374:
375: --Bug No:2154941 Desc : Disbursement Build Jul 2002
376: --Added the NVL clauses for check against the Application Number,Course Code and Version Number

Line 379: CURSOR c_get_adm_appl_details(p_person_id hz_parties.party_id%TYPE,

375: --Bug No:2154941 Desc : Disbursement Build Jul 2002
376: --Added the NVL clauses for check against the Application Number,Course Code and Version Number
377: --as per the FACCR001 DLD
378:
379: CURSOR c_get_adm_appl_details(p_person_id hz_parties.party_id%TYPE,
380: c_cal_type igs_ca_inst_all.cal_type%TYPE ,
381: c_sequence_number igs_ca_inst_all.sequence_number%TYPE,
382: p_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
383: p_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

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

481: CLOSE c_get_adm_appl;
482:
483: END get_adm_appl_details;
484:
485: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
486: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
487: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
488: RETURN ROWID
489: IS

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

530:
531:
532:
533:
534: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
535: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
536: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
537: RETURN ROWID
538: IS