DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ADDR_PKG dependencies on IGS_PE_HZ_PTY_SITES

Line 8: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,

4: procedure INSERT_ROW (
5: p_action IN VARCHAR2,
6: p_rowid IN OUT NOCOPY VARCHAR2,
7: p_location_id IN OUT NOCOPY NUMBER,
8: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
9: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
10: p_country IN VARCHAR2,
11: p_address_style IN VARCHAR2,
12: p_addr_line_1 IN VARCHAR2,

Line 9: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,

5: p_action IN VARCHAR2,
6: p_rowid IN OUT NOCOPY VARCHAR2,
7: p_location_id IN OUT NOCOPY NUMBER,
8: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
9: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
10: p_country IN VARCHAR2,
11: p_address_style IN VARCHAR2,
12: p_addr_line_1 IN VARCHAR2,
13: p_addr_line_2 IN VARCHAR2,

Line 44: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,

40: procedure UPDATE_ROW (
41: p_action IN VARCHAR2,
42: p_rowid IN OUT NOCOPY VARCHAR2,
43: p_location_id IN OUT NOCOPY NUMBER,
44: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
45: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
46: p_country IN VARCHAR2,
47: p_address_style IN VARCHAR2,
48: p_addr_line_1 IN VARCHAR2,

Line 45: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,

41: p_action IN VARCHAR2,
42: p_rowid IN OUT NOCOPY VARCHAR2,
43: p_location_id IN OUT NOCOPY NUMBER,
44: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
45: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
46: p_country IN VARCHAR2,
47: p_address_style IN VARCHAR2,
48: p_addr_line_1 IN VARCHAR2,
49: p_addr_line_2 IN VARCHAR2,