APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_RELATIONSHIPS

Line 329: FROM HZ_RELATIONSHIPS

325: IS
326: SELECT SUBJECT_ID,
327: SUBJECT_TABLE_NAME,
328: SUBJECT_TYPE
329: FROM HZ_RELATIONSHIPS
330: START WITH OBJECT_ID = p_parent_id
331: AND OBJECT_TABLE_NAME = p_parent_table_name
332: AND OBJECT_TYPE = p_parent_object_type
333: AND DIRECTION_CODE = 'P'

Line 363: FROM HZ_RELATIONSHIPS

359: IS
360: SELECT OBJECT_ID,
361: OBJECT_TABLE_NAME,
362: OBJECT_TYPE
363: FROM HZ_RELATIONSHIPS
364: START WITH SUBJECT_ID = p_child_id
365: AND SUBJECT_TABLE_NAME = p_child_table_name
366: AND SUBJECT_TYPE = p_child_object_type
367: AND DIRECTION_CODE = 'P'

Line 436: SELECT HZ_RELATIONSHIPS_S.NEXTVAL

432: -- If primary key value is passed, check for uniqueness.
433:
434: WHILE l_dummy = 'Y' LOOP
435: BEGIN
436: SELECT HZ_RELATIONSHIPS_S.NEXTVAL
437: INTO l_relationship_id
438: FROM DUAL;
439:
440: SELECT 'Y'

Line 442: FROM HZ_RELATIONSHIPS

438: FROM DUAL;
439:
440: SELECT 'Y'
441: INTO l_dummy
442: FROM HZ_RELATIONSHIPS
443: WHERE RELATIONSHIP_ID = l_relationship_id
444: AND DIRECTIONAL_FLAG = 'F';
445:
446: EXCEPTION

Line 502: FROM HZ_RELATIONSHIPS

498: -- it needs to be done if multiple_parent_allowed is 'N'
499: IF r_rel_type.multiple_parent_allowed = 'N' THEN
500: BEGIN
501: SELECT 1 INTO l_count
502: FROM HZ_RELATIONSHIPS
503: WHERE OBJECT_ID = l_child_id
504: AND OBJECT_TABLE_NAME = l_child_table_name
505: AND OBJECT_TYPE = l_child_object_type
506: AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type

Line 645: HZ_RELATIONSHIPS_PKG.Insert_Row (

641:
642: p_relationship_rec.relationship_id := l_relationship_id;
643:
644: -- Call table-handler to create the forward record.
645: HZ_RELATIONSHIPS_PKG.Insert_Row (
646: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
647: X_SUBJECT_ID => p_relationship_rec.subject_id,
648: X_SUBJECT_TYPE => p_relationship_rec.subject_type,
649: X_SUBJECT_TABLE_NAME => p_relationship_rec.subject_table_name,

Line 738: HZ_RELATIONSHIPS_PKG.Insert_Row (

734: END IF;
735:
736: IF r_rel_type.BACKWARD_REL_CODE is not null THEN
737:
738: HZ_RELATIONSHIPS_PKG.Insert_Row (
739: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
740: X_SUBJECT_ID => p_relationship_rec.object_id,
741: X_SUBJECT_TYPE => p_relationship_rec.object_type,
742: X_SUBJECT_TABLE_NAME => p_relationship_rec.object_table_name,

Line 1139: p_entity_name => 'HZ_RELATIONSHIPS',

1135: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1136:
1137: IF g_rel_mixnmatch_enabled IS NULL THEN
1138: HZ_MIXNM_UTILITY.LoadDataSources(
1139: p_entity_name => 'HZ_RELATIONSHIPS',
1140: p_entity_attr_id => g_rel_entity_attr_id,
1141: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
1142: p_selected_datasources => g_rel_selected_datasources );
1143: END IF;

Line 1146: p_entity_name => 'HZ_RELATIONSHIPS',

1142: p_selected_datasources => g_rel_selected_datasources );
1143: END IF;
1144: */
1145: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
1146: p_entity_name => 'HZ_RELATIONSHIPS',
1147: p_entity_attr_id => g_rel_entity_attr_id,
1148: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
1149: p_selected_datasources => g_rel_selected_datasources,
1150: p_content_source_type => l_rel_rec.content_source_type,

Line 1254: HZ_RELATIONSHIPS_PKG.Select_Row (

1250: ELSE
1251: l_directional_flag := NVL(p_directional_flag, 'F');
1252: END IF;
1253:
1254: HZ_RELATIONSHIPS_PKG.Select_Row (
1255: X_RELATIONSHIP_ID => x_rel_rec.relationship_id,
1256: X_DIRECTIONAL_FLAG => l_directional_flag,
1257: X_SUBJECT_ID => x_rel_rec.subject_id,
1258: X_SUBJECT_TYPE => x_rel_rec.subject_type,