eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_PERSON_ADDR_PKG dependencies on HZ_PARTY_SITES

Line 34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,

30: p_party_id IN NUMBER,
31: p_party_site_id IN OUT NOCOPY NUMBER,
32: p_party_type IN VARCHAR2,
33: p_last_update_date IN OUT NOCOPY DATE,
34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE
37: ) AS
38:

Line 35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,

31: p_party_site_id IN OUT NOCOPY NUMBER,
32: p_party_type IN VARCHAR2,
33: p_last_update_date IN OUT NOCOPY DATE,
34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE
37: ) AS
38:
39: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;

Line 36: p_status IN hz_party_sites.status%TYPE

32: p_party_type IN VARCHAR2,
33: p_last_update_date IN OUT NOCOPY DATE,
34: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE
37: ) AS
38:
39: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
40: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;

Line 60: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;

56: CURSOR c_party_site_number IS
57: SELECT hz_party_site_number_s.NEXTVAL
58: FROM dual;
59:
60: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
61: l_hz_gen_party_site VARCHAR2(10);
62: BEGIN
63:
64: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN

Line 135: -- this flag will be replaced by hz_party_sites

131: RETURN;
132: ELSIF l_return_status = 'S' THEN
133: p_location_ovn := 1;
134: -- bug 2203778 : ssawhney, correspondence flag is obsoleted from IGS table and from now
135: -- this flag will be replaced by hz_party_sites
136:
137: P_PARTY_SITE_REC_INSERT.PARTY_ID := p_party_id;
138: P_PARTY_SITE_REC_INSERT.LOCATION_ID := p_location_id;
139: P_PARTY_SITE_REC_INSERT.IDENTIFYING_ADDRESS_FLAG := p_correspondence ;

Line 227: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,

223: p_party_id IN NUMBER,
224: p_party_site_id IN OUT NOCOPY NUMBER,
225: p_party_type IN VARCHAR2,
226: p_last_update_date IN OUT NOCOPY DATE,
227: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
228: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
229: p_status IN hz_party_sites.status%TYPE
230: )
231: AS

Line 228: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,

224: p_party_site_id IN OUT NOCOPY NUMBER,
225: p_party_type IN VARCHAR2,
226: p_last_update_date IN OUT NOCOPY DATE,
227: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
228: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
229: p_status IN hz_party_sites.status%TYPE
230: )
231: AS
232: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;

Line 229: p_status IN hz_party_sites.status%TYPE

225: p_party_type IN VARCHAR2,
226: p_last_update_date IN OUT NOCOPY DATE,
227: p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
228: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
229: p_status IN hz_party_sites.status%TYPE
230: )
231: AS
232: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
233: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;

Line 235: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;

231: AS
232: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
233: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;
234: l_contact_person VARCHAR2(40) := NULL;
235: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
236: l_msg_count NUMBER(15);
237: l_loc_id NUMBER(15);
238: lv_rowid VARCHAR2(25);
239: p_location_rec_update HZ_LOCATION_V2PUB.location_rec_type;

Line 259: -- this flag will be replaced by hz_party_sites

255:
256: BEGIN
257:
258: -- bug 2203778 : ssawhney, correspondence flag is obsoleted from IGS table and from now
259: -- this flag will be replaced by hz_party_sites
260:
261: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN
262: IF p_start_dt > p_end_dt THEN
263: FND_MESSAGE.SET_NAME('IGS','IGS_PE_FROM_DT_GRT_TO_DATE');