APPS.IGF_SP_ASSIGN_PUB dependencies on IGS_PE_PERSON_ID_TYP

Line 52: PROCEDURE validate_api_prsn_id(p_c_sys_prsn_id_typ IN igs_pe_person_id_typ.s_person_id_type%TYPE,

48: RETURN FALSE;
49: END IF;
50: END validate_prsn;
51:
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)

Line 53: p_c_usr_alt_prsn_id_typ IN igs_pe_person_id_typ.person_id_type%TYPE,

49: END IF;
50: END validate_prsn;
51:
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

Line 69: CURSOR cur_get_person_id(cp_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE,

65: Change History
66: Who When What
67: ******************************************************************************/
68:
69: CURSOR cur_get_person_id(cp_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE,
70: cp_c_usr_alt_prs_id_type igs_pe_person_id_typ.person_id_type%TYPE,
71: cp_c_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE)
72: IS
73: SELECT api.pe_person_id

Line 70: cp_c_usr_alt_prs_id_type igs_pe_person_id_typ.person_id_type%TYPE,

66: Who When What
67: ******************************************************************************/
68:
69: CURSOR cur_get_person_id(cp_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE,
70: cp_c_usr_alt_prs_id_type igs_pe_person_id_typ.person_id_type%TYPE,
71: cp_c_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE)
72: IS
73: SELECT api.pe_person_id
74: FROM igs_pe_person_id_typ pit,

Line 74: FROM igs_pe_person_id_typ pit,

70: cp_c_usr_alt_prs_id_type igs_pe_person_id_typ.person_id_type%TYPE,
71: cp_c_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE)
72: IS
73: SELECT api.pe_person_id
74: FROM igs_pe_person_id_typ pit,
75: igs_pe_alt_pers_id api
76: WHERE api.person_id_type = pit.person_id_type AND
77: api.person_id_type = cp_c_usr_alt_prs_id_type AND
78: api.api_person_id = cp_c_api_person_id AND

Line 412: l_c_sys_alt_prs_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE;

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;
415:
416: l_c_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;