APPS.IGS_AD_IMP_002 dependencies on IGS_AD_ADDR_INT_ALL

Line 39: PROCEDURE CREATE_ADDRESS(p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,

35: P_ADDR_TYPE IN VARCHAR2,
36: P_PERSON_ID_TYPE IN VARCHAR2,
37: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE);
38:
39: PROCEDURE CREATE_ADDRESS(p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
40: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
41: P_STATUS OUT NOCOPY VARCHAR2,
42: P_ERROR_CODE OUT NOCOPY VARCHAR2);
43:

Line 55: PROCEDURE UPDATE_ADDRESS(P_ADDR_REC IN IGS_AD_ADDR_INT_ALL%ROWTYPE,

51: || pkpatel 22-JUN-2001 Bug no.2466466
52: || Added the parameter p_party_site_id
53: || (reverse chronological order - newest change first)
54: */
55: PROCEDURE UPDATE_ADDRESS(P_ADDR_REC IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
56: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
57: p_location_id IN hz_party_sites.location_id%TYPE,
58: p_party_site_id IN hz_party_sites.party_site_id%TYPE);
59:

Line 60: PROCEDURE VALIDATE_ADDRESS( P_ADDR_REC IN IGS_AD_ADDR_INT_ALL%ROWTYPE,

56: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
57: p_location_id IN hz_party_sites.location_id%TYPE,
58: p_party_site_id IN hz_party_sites.party_site_id%TYPE);
59:
60: PROCEDURE VALIDATE_ADDRESS( P_ADDR_REC IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
61: P_PERSON_ID IN igs_pe_person_base_v.PERSON_ID%TYPE,
62: p_status OUT NOCOPY VARCHAR2,
63: p_error_code OUT NOCOPY VARCHAR2);
64: