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_POPULATE_BOT_PKG dependencies on HZ_RELATIONSHIPS

Line 307: -- Procedure name: pop_hz_relationships()

303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END pop_hz_role_responsibility;
305:
306: -----------------------------------------------------------------
307: -- Procedure name: pop_hz_relationships()
308: -- Purpose: populates BOT for HZ_RELATIONSHIPS create or update
309: -- Scope: internal
310: -- Called From: V2 API
311: -- Called By: HZ_RELATIONSHIPS create or update APIs

Line 308: -- Purpose: populates BOT for HZ_RELATIONSHIPS create or update

304: END pop_hz_role_responsibility;
305:
306: -----------------------------------------------------------------
307: -- Procedure name: pop_hz_relationships()
308: -- Purpose: populates BOT for HZ_RELATIONSHIPS create or update
309: -- Scope: internal
310: -- Called From: V2 API
311: -- Called By: HZ_RELATIONSHIPS create or update APIs
312: -- Input Parameters:

Line 311: -- Called By: HZ_RELATIONSHIPS create or update APIs

307: -- Procedure name: pop_hz_relationships()
308: -- Purpose: populates BOT for HZ_RELATIONSHIPS create or update
309: -- Scope: internal
310: -- Called From: V2 API
311: -- Called By: HZ_RELATIONSHIPS create or update APIs
312: -- Input Parameters:
313: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
314: -- p_RELATIONSHIP_ID IN NUMBER
315: --

Line 317: -- Following are the allowed PARENT and CHILD BO combinations for HZ_RELATIONSHIPS

313: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
314: -- p_RELATIONSHIP_ID IN NUMBER
315: --
316: -- Note:
317: -- Following are the allowed PARENT and CHILD BO combinations for HZ_RELATIONSHIPS
318: -- This procedure must ensure that the combination is valid before populating BOT
319: --
320: -- PARENT BO: ORG :: CHILD BO:
321: -- PARENT BO: PERSON :: CHILD BO:

Line 324: PROCEDURE pop_hz_relationships(p_operation IN VARCHAR2, p_relationship_id IN NUMBER) IS

320: -- PARENT BO: ORG :: CHILD BO:
321: -- PARENT BO: PERSON :: CHILD BO:
322: -- PARENT BO: ORG_CONTACT :: CHILD BO:
323: -----------------------------------------------------------------
324: PROCEDURE pop_hz_relationships(p_operation IN VARCHAR2, p_relationship_id IN NUMBER) IS
325:
326: CURSOR c_child IS
327: SELECT pp.LAST_UPDATE_DATE lud, pp.subject_id sparent_id, pp.object_id oparent_id,
328: pp.RELATIONSHIP_ID child_id,

Line 331: FROM HZ_RELATIONSHIPS pp

327: SELECT pp.LAST_UPDATE_DATE lud, pp.subject_id sparent_id, pp.object_id oparent_id,
328: pp.RELATIONSHIP_ID child_id,
329: decode(pp.subject_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) sbo_code,
330: decode(pp.object_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) obo_code
331: FROM HZ_RELATIONSHIPS pp
332: WHERE pp.RELATIONSHIP_ID = p_RELATIONSHIP_ID
333: AND subject_type in ('ORGANIZATION','PERSON')
334: AND object_type in ('ORGANIZATION','PERSON');
335:

Line 342: l_debug_prefix VARCHAR2(40) := 'pop_hz_relationships';

338: FROM HZ_ORG_CONTACTS
339: WHERE party_relationship_id = p_relationship_id;
340:
341: -- local variables
342: l_debug_prefix VARCHAR2(40) := 'pop_hz_relationships';
343: l_subj_id NUMBER; -- used to store subject entity identifier
344: l_obj_id NUMBER; -- used to store object entity identifier
345: l_sbo_code VARCHAR2(30); -- used to store subject BO Code
346: l_obo_code VARCHAR2(30); -- used to store object BO Code

Line 347: l_child_id NUMBER; -- used to store HZ_RELATIONSHIPS identifier

343: l_subj_id NUMBER; -- used to store subject entity identifier
344: l_obj_id NUMBER; -- used to store object entity identifier
345: l_sbo_code VARCHAR2(30); -- used to store subject BO Code
346: l_obo_code VARCHAR2(30); -- used to store object BO Code
347: l_child_id NUMBER; -- used to store HZ_RELATIONSHIPS identifier
348: l_lud DATE; -- used to store the child last update date
349: l_oc_id NUMBER;
350: l_child_rec_exists_no NUMBER;
351: l_cen VARCHAR2(30) := 'HZ_RELATIONSHIPS';

Line 351: l_cen VARCHAR2(30) := 'HZ_RELATIONSHIPS';

347: l_child_id NUMBER; -- used to store HZ_RELATIONSHIPS identifier
348: l_lud DATE; -- used to store the child last update date
349: l_oc_id NUMBER;
350: l_child_rec_exists_no NUMBER;
351: l_cen VARCHAR2(30) := 'HZ_RELATIONSHIPS';
352: BEGIN
353: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_relationships+',
354: p_prefix=>l_debug_prefix,
355: p_msg_level=>fnd_log.level_procedure);

Line 353: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_relationships+',

349: l_oc_id NUMBER;
350: l_child_rec_exists_no NUMBER;
351: l_cen VARCHAR2(30) := 'HZ_RELATIONSHIPS';
352: BEGIN
353: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_relationships+',
354: p_prefix=>l_debug_prefix,
355: p_msg_level=>fnd_log.level_procedure);
356:
357: -- validate p_operation

Line 361: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_relationships',

357: -- validate p_operation
358: IF p_operation IN ('I','U') THEN
359: NULL;
360: ELSE
361: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_relationships',
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;

Line 398: 'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,

394: INSERT INTO HZ_BUS_OBJ_TRACKING
395: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
396: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
397: ) VALUES (
398: 'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,
399: l_lud, l_lud, 'HZ_PARTIES', l_subj_id, l_sbo_code);
400:
401: -- for object
402: INSERT INTO HZ_BUS_OBJ_TRACKING

Line 406: 'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,

402: INSERT INTO HZ_BUS_OBJ_TRACKING
403: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
404: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
405: ) VALUES (
406: 'N', p_operation, l_child_id, 'HZ_RELATIONSHIPS', NULL,
407: l_lud, l_lud, 'HZ_PARTIES', l_obj_id, l_obo_code);
408:
409: -- if record not existing for customer account contact, insert into hz_bus_obj_tracking
410: pop_parent_record(p_child_id => l_subj_id,

Line 439: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_relationships-',

435: END IF;
436: END ; -- anonymous block end
437: END LOOP;
438:
439: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_relationships-',
440: p_prefix=>l_debug_prefix,
441: p_msg_level=>fnd_log.level_procedure);
442: EXCEPTION
443: WHEN OTHERS THEN

Line 448: END pop_hz_relationships;

444: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
445: p_prefix=>l_debug_prefix,
446: p_msg_level=>fnd_log.level_procedure);
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END pop_hz_relationships;
449:
450: -----------------------------------------------------------------
451: -- Procedure name: pop_hz_person_profiles()
452: -- Purpose: populates BOT for HZ_PERSON_PROFILES create or update

Line 783: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

779: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
780:
781: CURSOR get_org_contact(l_party_id NUMBER) IS
782: SELECT oc.org_contact_id
783: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
784: WHERE oc.party_relationship_id = pr.relationship_id
785: AND pr.party_id = l_party_id
786: AND pr.subject_type = 'PERSON'
787: AND pr.object_type = 'ORGANIZATION'

Line 905: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

901: AND p.party_type in ('ORGANIZATION','PERSON','PARTY_RELATIONSHIP');
902:
903: CURSOR get_org_contact(l_party_id NUMBER) IS
904: SELECT oc.org_contact_id
905: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
906: WHERE oc.party_relationship_id = pr.relationship_id
907: AND pr.party_id = l_party_id
908: AND pr.subject_type = 'PERSON'
909: AND pr.object_type = 'ORGANIZATION'

Line 1128: FROM HZ_ORG_CONTACT_ROLES ocr, HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

1124: -- cursor statement to select the info from child table
1125: CURSOR C_child IS
1126: SELECT ocr.LAST_UPDATE_DATE lud, ocr.ORG_CONTACT_ID parent_id,
1127: ocr.ORG_CONTACT_ROLE_ID child_id, pr.object_id object_id
1128: FROM HZ_ORG_CONTACT_ROLES ocr, HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
1129: WHERE ORG_CONTACT_ROLE_ID = P_ORG_CONTACT_ROLE_ID
1130: AND ocr.org_contact_id = oc.org_contact_id
1131: AND oc.party_relationship_id = pr.relationship_id
1132: AND pr.object_type = 'ORGANIZATION'

Line 1235: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr

1231: -- cursor statement to select the info from child table
1232: CURSOR C_child IS
1233: SELECT oc.LAST_UPDATE_DATE lud, oc.ORG_CONTACT_ID child_id,
1234: pr.object_id parent_id, pr.subject_id person_id, pr.relationship_id rel_id
1235: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS pr
1236: WHERE oc.ORG_CONTACT_ID = P_ORG_CONTACT_ID
1237: AND oc.party_relationship_id = pr.relationship_id
1238: AND pr.object_type = 'ORGANIZATION'
1239: AND pr.subject_type = 'PERSON'

Line 1320: p_centity_name => 'HZ_RELATIONSHIPS',

1316:
1317: -- populate relationship as child
1318: pop_parent_record(p_child_id => l_rel_id,
1319: p_lud => l_lud,
1320: p_centity_name => 'HZ_RELATIONSHIPS',
1321: p_cbo_code => NULL,
1322: p_parent_id => l_child_id,
1323: p_pentity_name => 'HZ_ORG_CONTACTS',
1324: p_pbo_code => 'ORG_CONTACT');

Line 3038: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc

3034: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3035:
3036: CURSOR c_oc(p_parent_id NUMBER) IS
3037: SELECT oc.org_contact_id
3038: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc
3039: WHERE r.relationship_id = oc.party_relationship_id
3040: AND r.subject_type = 'PERSON'
3041: AND r.object_type = 'ORGANIZATION'
3042: AND r.party_id = p_parent_id

Line 3218: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc

3214: AND party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
3215:
3216: CURSOR c_oc(p_parent_id NUMBER) IS
3217: SELECT oc.org_contact_id
3218: FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc
3219: WHERE r.relationship_id = oc.party_relationship_id
3220: AND r.subject_type = 'PERSON'
3221: AND r.object_type = 'ORGANIZATION'
3222: AND r.party_id = p_parent_id

Line 4024: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r

4020: AND p.party_type in ('ORGANIZATION', 'PERSON', 'PARTY_RELATIONSHIP');
4021:
4022: CURSOR get_oc(l_party_id NUMBER) IS
4023: SELECT 1
4024: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
4025: WHERE p.party_id = l_party_id
4026: AND p.party_id = r.party_id
4027: AND r.subject_type = 'PERSON'
4028: AND r.object_type = 'ORGANIZATION'