APPS.IGF_SP_ASSIGN_PUB dependencies on HZ_PARTIES

Line 23: FUNCTION validate_prsn(p_n_person_id IN hz_parties.party_ID%TYPE) RETURN BOOLEAN

19:
20: g_pkg_name CONSTANT VARCHAR2(30) := 'Igf_Sp_Assign_Pub';
21: g_c_temp VARCHAR2(1);
22:
23: FUNCTION validate_prsn(p_n_person_id IN hz_parties.party_ID%TYPE) RETURN BOOLEAN
24: AS
25: /****************************************************************************
26: Created By: Vinay Chappidi
27: Date Created By: 19-Feb-2003

Line 56: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE)

52: PROCEDURE validate_api_prsn_id(p_c_sys_prsn_id_typ IN igs_pe_person_id_typ.s_person_id_type%TYPE,
53: p_c_usr_alt_prsn_id_typ IN igs_pe_person_id_typ.person_id_type%TYPE,
54: p_c_api_prsn_id IN igs_pe_alt_pers_id.api_person_id%TYPE,
55: p_b_ret_status OUT NOCOPY BOOLEAN,
56: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE)
57: AS
58: /****************************************************************************
59: Created By: Vinay Chappidi
60: Date Created By: 19-Feb-2003

Line 82: l_n_person_id hz_parties.party_id%TYPE;

78: api.api_person_id = cp_c_api_person_id AND
79: pit.s_person_id_type = cp_c_sys_prsn_id_typ AND
80: SYSDATE BETWEEN api.start_dt AND NVL(api.end_dt, SYSDATE);
81:
82: l_n_person_id hz_parties.party_id%TYPE;
83: BEGIN
84: -- check if for the combination of Alternate-Person Id Type, API Person ID if there exists a unique person
85: -- when no person is identified or when there are more than one person identified from above cursor then
86: -- set the return status OUT variable to FALSE and return.

Line 285: PROCEDURE check_create_fa_rec(p_n_person_id hz_parties.party_id%TYPE,

281: END IF;
282: CLOSE c_check_spn_awd;
283: END check_spnsr_awd_rel;
284:
285: PROCEDURE check_create_fa_rec(p_n_person_id hz_parties.party_id%TYPE,
286: p_c_awd_ci_cal_type igs_ca_inst.cal_type%TYPE,
287: p_n_awd_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
288: p_b_ret_status OUT NOCOPY BOOLEAN,
289: p_n_base_id OUT NOCOPY NUMBER)

Line 410: l_n_person_id hz_parties.party_id%TYPE;

406:
407: l_api_name CONSTANT VARCHAR2(30) := 'Create_Stdnt_Spnsr_Rel';
408: l_api_version CONSTANT NUMBER := 1.0;
409:
410: l_n_person_id hz_parties.party_id%TYPE;
411: l_n_fund_id igf_aw_fund_mast.fund_id%TYPE;
412: l_c_sys_alt_prs_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE;
413: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
414: l_n_spr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE;