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.HZ_ACCT_CREATE_PKG dependencies on HZ_PARTIES

Line 108: FROM HZ_PARTIES

104: SELECT ROWID,
105: OBJECT_VERSION_NUMBER,
106: LAST_UPDATE_DATE,
107: NULL
108: FROM HZ_PARTIES
109: WHERE PARTY_ID = p_col_id;
110:
111: l_last_update_date DATE;
112: BEGIN

Line 166: FROM hz_parties

162: IS
163: CURSOR cu_party_update
164: IS
165: SELECT party_id
166: FROM hz_parties
167: WHERE party_id = p_party_id
168: FOR UPDATE OF party_id NOWAIT;
169: l_lock NUMBER;
170: BEGIN

Line 175: UPDATE hz_parties

171: OPEN cu_party_update;
172: FETCH cu_party_update INTO l_lock;
173: IF cu_party_update%FOUND THEN
174: IF p_flag_name = 'REFERENCE_FOR' THEN
175: UPDATE hz_parties
176: SET REFERENCE_USE_FLAG = p_flag_value
177: WHERE party_id = p_party_id;
178: ELSIF p_flag_name = 'PARTNER_OF' THEN
179: UPDATE hz_parties

Line 179: UPDATE hz_parties

175: UPDATE hz_parties
176: SET REFERENCE_USE_FLAG = p_flag_value
177: WHERE party_id = p_party_id;
178: ELSIF p_flag_name = 'PARTNER_OF' THEN
179: UPDATE hz_parties
180: SET THIRD_PARTY_FLAG = p_flag_value
181: WHERE party_id = p_party_id;
182: ELSIF p_flag_name = 'COMPETITOR_OF' THEN
183: UPDATE hz_parties

Line 183: UPDATE hz_parties

179: UPDATE hz_parties
180: SET THIRD_PARTY_FLAG = p_flag_value
181: WHERE party_id = p_party_id;
182: ELSIF p_flag_name = 'COMPETITOR_OF' THEN
183: UPDATE hz_parties
184: SET COMPETITOR_FLAG = p_flag_value
185: WHERE party_id = p_party_id;
186: END IF;
187: ELSE

Line 189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');

185: WHERE party_id = p_party_id;
186: END IF;
187: ELSE
188: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');
190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;

Line 224: and subject_table_name = 'HZ_PARTIES'

220: end_date
221: from hz_relationships
222: where subject_id = c_party_id
223: and relationship_code = 'REFERENCE_FOR'
224: and subject_table_name = 'HZ_PARTIES'
225: and object_table_name = 'HZ_PARTIES'
226: and directional_flag = 'F';
227:
228: cursor C_PARTNER_OF is

Line 225: and object_table_name = 'HZ_PARTIES'

221: from hz_relationships
222: where subject_id = c_party_id
223: and relationship_code = 'REFERENCE_FOR'
224: and subject_table_name = 'HZ_PARTIES'
225: and object_table_name = 'HZ_PARTIES'
226: and directional_flag = 'F';
227:
228: cursor C_PARTNER_OF is
229: select relationship_id ,

Line 234: and subject_table_name = 'HZ_PARTIES'

230: end_date
231: from hz_relationships
232: where subject_id = c_party_id
233: and relationship_code = 'PARTNER_OF'
234: and subject_table_name = 'HZ_PARTIES'
235: and object_table_name = 'HZ_PARTIES'
236: and directional_flag = 'F';
237:
238: cursor C_COMPETITOR_OF is

Line 235: and object_table_name = 'HZ_PARTIES'

231: from hz_relationships
232: where subject_id = c_party_id
233: and relationship_code = 'PARTNER_OF'
234: and subject_table_name = 'HZ_PARTIES'
235: and object_table_name = 'HZ_PARTIES'
236: and directional_flag = 'F';
237:
238: cursor C_COMPETITOR_OF is
239: select relationship_id,

Line 244: and subject_table_name = 'HZ_PARTIES'

240: end_date
241: from hz_relationships
242: where subject_id = c_party_id
243: and relationship_code = 'COMPETITOR_OF'
244: and subject_table_name = 'HZ_PARTIES'
245: and object_table_name = 'HZ_PARTIES'
246: and directional_flag = 'F';
247:
248: l_party_rel_object_version NUMBER;

Line 245: and object_table_name = 'HZ_PARTIES'

241: from hz_relationships
242: where subject_id = c_party_id
243: and relationship_code = 'COMPETITOR_OF'
244: and subject_table_name = 'HZ_PARTIES'
245: and object_table_name = 'HZ_PARTIES'
246: and directional_flag = 'F';
247:
248: l_party_rel_object_version NUMBER;
249: l_party_object_version NUMBER;

Line 295: prel_rec.subject_table_name:= 'HZ_PARTIES';

291: FETCH cu_rel_type INTO l_rel_type, l_create_party;
292: CLOSE cu_rel_type;
293:
294: prel_rec.subject_id := c_party_id;
295: prel_rec.subject_table_name:= 'HZ_PARTIES';
296: prel_rec.subject_type := c_party_type;
297: prel_rec.object_id := i_internal_party_id;
298: prel_rec.object_table_name := 'HZ_PARTIES';
299: prel_rec.object_type := i_internal_party_type;

Line 298: prel_rec.object_table_name := 'HZ_PARTIES';

294: prel_rec.subject_id := c_party_id;
295: prel_rec.subject_table_name:= 'HZ_PARTIES';
296: prel_rec.subject_type := c_party_type;
297: prel_rec.object_id := i_internal_party_id;
298: prel_rec.object_table_name := 'HZ_PARTIES';
299: prel_rec.object_type := i_internal_party_type;
300: prel_rec.start_date := SYSDATE;
301: prel_rec.end_date := NULL;
302: prel_rec.relationship_type := l_rel_type;

Line 327: AND subject_table_name = 'HZ_PARTIES'

323: INTO x_party_rel_last_update_date ,
324: l_party_rel_object_version
325: FROM hz_relationships
326: WHERE relationship_id = x_party_rel_id
327: AND subject_table_name = 'HZ_PARTIES'
328: AND object_table_name = 'HZ_PARTIES'
329: AND directional_flag = 'F';
330:
331: SELECT last_update_date,

Line 328: AND object_table_name = 'HZ_PARTIES'

324: l_party_rel_object_version
325: FROM hz_relationships
326: WHERE relationship_id = x_party_rel_id
327: AND subject_table_name = 'HZ_PARTIES'
328: AND object_table_name = 'HZ_PARTIES'
329: AND directional_flag = 'F';
330:
331: SELECT last_update_date,
332: object_version_number

Line 335: FROM hz_parties

331: SELECT last_update_date,
332: object_version_number
333: INTO x_party_last_update_date,
334: l_party_object_version
335: FROM hz_parties
336: WHERE party_id = c_party_id;
337:
338: prel_rec.relationship_id := x_party_rel_id;
339: prel_rec.subject_id := c_party_id;

Line 340: prel_rec.subject_table_name:= 'HZ_PARTIES';

336: WHERE party_id = c_party_id;
337:
338: prel_rec.relationship_id := x_party_rel_id;
339: prel_rec.subject_id := c_party_id;
340: prel_rec.subject_table_name:= 'HZ_PARTIES';
341: prel_rec.subject_type := c_party_type;
342: prel_rec.object_id := i_internal_party_id;
343: prel_rec.object_table_name := 'HZ_PARTIES';
344: prel_rec.object_type := i_internal_party_type;

Line 343: prel_rec.object_table_name := 'HZ_PARTIES';

339: prel_rec.subject_id := c_party_id;
340: prel_rec.subject_table_name:= 'HZ_PARTIES';
341: prel_rec.subject_type := c_party_type;
342: prel_rec.object_id := i_internal_party_id;
343: prel_rec.object_table_name := 'HZ_PARTIES';
344: prel_rec.object_type := i_internal_party_type;
345: prel_rec.end_date := TO_DATE('31124712','DDMMYYYY');
346: prel_rec.relationship_type := l_rel_type;
347: prel_rec.relationship_code := p_rel_code;

Line 382: AND subject_table_name = 'HZ_PARTIES'

378: INTO x_party_rel_last_update_date ,
379: l_party_rel_object_version
380: FROM hz_relationships
381: WHERE relationship_id = x_party_rel_id
382: AND subject_table_name = 'HZ_PARTIES'
383: AND object_table_name = 'HZ_PARTIES'
384: AND directional_flag = 'F';
385:
386: SELECT last_update_date,

Line 383: AND object_table_name = 'HZ_PARTIES'

379: l_party_rel_object_version
380: FROM hz_relationships
381: WHERE relationship_id = x_party_rel_id
382: AND subject_table_name = 'HZ_PARTIES'
383: AND object_table_name = 'HZ_PARTIES'
384: AND directional_flag = 'F';
385:
386: SELECT last_update_date,
387: object_version_number

Line 390: FROM hz_parties

386: SELECT last_update_date,
387: object_version_number
388: INTO x_party_last_update_date,
389: l_party_object_version
390: FROM hz_parties
391: WHERE party_id = c_party_id;
392:
393: prel_rec.relationship_id := x_party_rel_id;
394: prel_rec.subject_id := c_party_id;

Line 395: prel_rec.subject_table_name:= 'HZ_PARTIES';

391: WHERE party_id = c_party_id;
392:
393: prel_rec.relationship_id := x_party_rel_id;
394: prel_rec.subject_id := c_party_id;
395: prel_rec.subject_table_name:= 'HZ_PARTIES';
396: prel_rec.subject_type := c_party_type;
397: prel_rec.object_id := i_internal_party_id;
398: prel_rec.object_table_name := 'HZ_PARTIES';
399: prel_rec.object_type := i_internal_party_type;

Line 398: prel_rec.object_table_name := 'HZ_PARTIES';

394: prel_rec.subject_id := c_party_id;
395: prel_rec.subject_table_name:= 'HZ_PARTIES';
396: prel_rec.subject_type := c_party_type;
397: prel_rec.object_id := i_internal_party_id;
398: prel_rec.object_table_name := 'HZ_PARTIES';
399: prel_rec.object_type := i_internal_party_type;
400: prel_rec.end_date := SYSDATE;
401: prel_rec.relationship_type := l_rel_type;
402: prel_rec.relationship_code := p_rel_code;

Line 448: FROM hz_parties

444: IS
445:
446: CURSOR cu_internal_type IS
447: SELECT party_type
448: FROM hz_parties
449: WHERE party_id = i_internal_party_id;
450: l_internal_party_type VARCHAR2(30);
451:
452: BEGIN

Line 2091: and subject_table_name = 'HZ_PARTIES'

2087: select relationship_id
2088: from hz_relationships
2089: where subject_id = c_party_id
2090: and relationship_code = 'REFERENCE_FOR'
2091: and subject_table_name = 'HZ_PARTIES'
2092: and object_table_name = 'HZ_PARTIES'
2093: and directional_flag = 'F';
2094:
2095: cursor C_PARTNER_OF is

Line 2092: and object_table_name = 'HZ_PARTIES'

2088: from hz_relationships
2089: where subject_id = c_party_id
2090: and relationship_code = 'REFERENCE_FOR'
2091: and subject_table_name = 'HZ_PARTIES'
2092: and object_table_name = 'HZ_PARTIES'
2093: and directional_flag = 'F';
2094:
2095: cursor C_PARTNER_OF is
2096: select relationship_id

Line 2100: and subject_table_name = 'HZ_PARTIES'

2096: select relationship_id
2097: from hz_relationships
2098: where subject_id = c_party_id
2099: and relationship_code = 'PARTNER_OF'
2100: and subject_table_name = 'HZ_PARTIES'
2101: and object_table_name = 'HZ_PARTIES'
2102: and directional_flag = 'F';
2103:
2104: cursor C_COMPETITOR_OF is

Line 2101: and object_table_name = 'HZ_PARTIES'

2097: from hz_relationships
2098: where subject_id = c_party_id
2099: and relationship_code = 'PARTNER_OF'
2100: and subject_table_name = 'HZ_PARTIES'
2101: and object_table_name = 'HZ_PARTIES'
2102: and directional_flag = 'F';
2103:
2104: cursor C_COMPETITOR_OF is
2105: select relationship_id

Line 2109: and subject_table_name = 'HZ_PARTIES'

2105: select relationship_id
2106: from hz_relationships
2107: where subject_id = c_party_id
2108: and relationship_code = 'COMPETITOR_OF'
2109: and subject_table_name = 'HZ_PARTIES'
2110: and object_table_name = 'HZ_PARTIES'
2111: and directional_flag = 'F';
2112:
2113: i_pr_party_relationship_id NUMBER;

Line 2110: and object_table_name = 'HZ_PARTIES'

2106: from hz_relationships
2107: where subject_id = c_party_id
2108: and relationship_code = 'COMPETITOR_OF'
2109: and subject_table_name = 'HZ_PARTIES'
2110: and object_table_name = 'HZ_PARTIES'
2111: and directional_flag = 'F';
2112:
2113: i_pr_party_relationship_id NUMBER;
2114: i_pr_party_id NUMBER;

Line 2538: FROM hz_parties

2534: AND content_source_type = 'USER_ENTERED'
2535: AND organization_profile_id = o_organization_profile_id;
2536:
2537: SELECT last_update_date INTO x_pt_last_update_date
2538: FROM hz_parties
2539: WHERE party_id = c_party_id;
2540:
2541: ELSIF (x_account_type = 'PERSON') THEN
2542:

Line 2590: FROM hz_parties

2586: AND person_profile_id = o_person_profile_id;
2587:
2588: SELECT last_update_date
2589: INTO x_pt_last_update_date
2590: FROM hz_parties
2591: WHERE party_id = c_party_id;
2592:
2593: END IF;
2594:

Line 3101: from hz_parties

3097: select 1
3098: into dummy
3099: from dual
3100: where not exists ( select 1
3101: from hz_parties
3102: where party_number = p_party_number
3103: and ( ( p_rowid is null ) or (rowid <> p_rowid))
3104: );
3105: