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 182: igs_pe_hz_pty_sites_pkg.insert_row(x_rowid => lv_rowid,

178: -- ssawhney : 2225917
179: ELSIF l_return_status = 'S' THEN
180: p_party_site_ovn := 1;
181: IF p_start_dt IS NOT NULL OR p_end_dt IS NOT NULL THEN
182: igs_pe_hz_pty_sites_pkg.insert_row(x_rowid => lv_rowid,
183: x_party_site_id => p_party_site_id,
184: x_start_date => p_start_dt,
185: x_end_date => p_end_dt );
186: END IF;

Line 201: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,

197: procedure UPDATE_ROW (
198: p_action IN VARCHAR2,
199: p_rowid IN OUT NOCOPY VARCHAR2,
200: p_location_id IN OUT NOCOPY NUMBER,
201: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
202: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
203: p_country IN VARCHAR2,
204: p_address_style IN VARCHAR2,
205: p_addr_line_1 IN VARCHAR2,

Line 202: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,

198: p_action IN VARCHAR2,
199: p_rowid IN OUT NOCOPY VARCHAR2,
200: p_location_id IN OUT NOCOPY NUMBER,
201: p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
202: p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
203: p_country IN VARCHAR2,
204: p_address_style IN VARCHAR2,
205: p_addr_line_1 IN VARCHAR2,
206: p_addr_line_2 IN VARCHAR2,

Line 254: FROM igs_pe_hz_pty_sites WHERE party_site_id = p_party_site_id;

250:
251:
252: CURSOR get_rowid(p_party_site_id NUMBER) IS
253: SELECT ROWID,start_date
254: FROM igs_pe_hz_pty_sites WHERE party_site_id = p_party_site_id;
255:
256: BEGIN
257:
258: -- bug 2203778 : ssawhney, correspondence flag is obsoleted from IGS table and from now

Line 356: igs_pe_hz_pty_sites_pkg.add_row(x_rowid => lv_rowid,

352: FETCH get_rowid INTO lv_rowid,l_start_dt;
353: CLOSE get_rowid;
354:
355: IF p_start_dt IS NOT NULL OR l_start_dt IS NOT NULL THEN
356: igs_pe_hz_pty_sites_pkg.add_row(x_rowid => lv_rowid,
357: x_party_site_id => p_party_site_id,
358: x_start_date => p_start_dt,
359: x_end_date => p_end_dt);
360: