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,
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,
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,
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,