APPS.IGS_EN_VAL_API dependencies on IGS_PE_ALT_PERS_ID

Line 40: p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,

36:
37:
38: -- Validate the payment advice number is unique.
39: FUNCTION enrp_val_api_pan(
40: p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,
41: p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,
42: p_message_name OUT NOCOPY VARCHAR2)
43: RETURN BOOLEAN;
44:

Line 41: p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,

37:
38: -- Validate the payment advice number is unique.
39: FUNCTION enrp_val_api_pan(
40: p_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE ,
41: p_pay_advice_number IGS_PE_ALT_PERS_ID.api_person_id%TYPE ,
42: p_message_name OUT NOCOPY VARCHAR2)
43: RETURN BOOLEAN;
44:
45: -- Check Overlapping period for Person Id Types

Line 47: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

43: RETURN BOOLEAN;
44:
45: -- Check Overlapping period for Person Id Types
46: FUNCTION val_overlap_api(
47: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
48: RETURN BOOLEAN;
49:
50: -- Check Overlapping period for Person Id Types associated with System Person ID type SSN
51: FUNCTION val_ssn_overlap_api(

Line 52: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)

48: RETURN BOOLEAN;
49:
50: -- Check Overlapping period for Person Id Types associated with System Person ID type SSN
51: FUNCTION val_ssn_overlap_api(
52: p_person_id IGS_PE_ALT_PERS_ID_V.PE_PERSON_ID%TYPE)
53: RETURN BOOLEAN;
54:
55: -- To compare the Format mask whether it contains any character other than 9,X and special character.
56: FUNCTION fm_equal(

Line 63: p_api_pers_id IN igs_pe_alt_pers_id.api_person_id%TYPE)

59: RETURN BOOLEAN;
60:
61: -- To unformat the Formatted Alternate Person ID.
62: FUNCTION unformat_api(
63: p_api_pers_id IN igs_pe_alt_pers_id.api_person_id%TYPE)
64: RETURN VARCHAR2;
65:
66: -- wrapper function To compare the Format mask whether it contains any character other than 9,X and special character.
67: -- This function would be called from SS