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

Line 140: FROM HZ_RELATIONSHIPS

136: p_start_date DATE, p_end_date DATE)
137: IS
138: SELECT LEVEL, RELATIONSHIP_ID, SUBJECT_ID, OBJECT_ID, STATUS, START_DATE, END_DATE,
139: SUBJECT_TABLE_NAME, SUBJECT_TYPE
140: FROM HZ_RELATIONSHIPS
141: WHERE RELATIONSHIP_ID <> p_relationship_id
142: START WITH OBJECT_ID = p_parent_id
143: AND OBJECT_TABLE_NAME = p_parent_table_name
144: AND OBJECT_TYPE = p_parent_object_type

Line 429: SELECT HZ_RELATIONSHIPS_S.NEXTVAL

425: l_relationship_id IS NULL
426: THEN
427: WHILE l_dummy = 'Y' LOOP
428: BEGIN
429: SELECT HZ_RELATIONSHIPS_S.NEXTVAL
430: INTO l_relationship_id
431: FROM DUAL;
432:
433: SELECT 'Y'

Line 435: FROM HZ_RELATIONSHIPS

431: FROM DUAL;
432:
433: SELECT 'Y'
434: INTO l_dummy
435: FROM HZ_RELATIONSHIPS
436: WHERE RELATIONSHIP_ID = l_relationship_id
437: AND DIRECTIONAL_FLAG = 'F';
438:
439: EXCEPTION

Line 449: FROM HZ_RELATIONSHIPS

445: ELSE
446: BEGIN
447: SELECT 'Y'
448: INTO l_dummy
449: FROM HZ_RELATIONSHIPS
450: WHERE RELATIONSHIP_ID = l_relationship_id
451: AND DIRECTIONAL_FLAG = 'F';
452:
453: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

Line 545: FROM HZ_RELATIONSHIPS

541: -- it needs to be done if multiple_parent_allowed is 'N'
542: IF r_rel_type.multiple_parent_allowed = 'N' THEN
543: BEGIN
544: SELECT 1 INTO l_count
545: FROM HZ_RELATIONSHIPS
546: WHERE OBJECT_ID = l_child_id
547: AND OBJECT_TABLE_NAME = l_child_table_name
548: AND OBJECT_TYPE = l_child_object_type
549: AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type

Line 711: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)',

707: p_relationship_rec.relationship_id := l_relationship_id;
708:
709: -- Debug info.
710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
711: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)',
712: p_prefix=>l_debug_prefix,
713: p_msg_level=>fnd_log.level_procedure);
714: END IF;
715:

Line 717: HZ_RELATIONSHIPS_PKG.Insert_Row (

713: p_msg_level=>fnd_log.level_procedure);
714: END IF;
715:
716: -- Call table-handler to create the forward record.
717: HZ_RELATIONSHIPS_PKG.Insert_Row (
718: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
719: X_SUBJECT_ID => p_relationship_rec.subject_id,
720: X_SUBJECT_TYPE => p_relationship_rec.subject_type,
721: X_SUBJECT_TABLE_NAME => p_relationship_rec.subject_table_name,

Line 795: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) ' ||

791: );
792:
793: -- Debug info.
794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) ' ||
796: 'x_relationship_id = ' || p_relationship_rec.relationship_id,
797: p_prefix=>l_debug_prefix,
798: p_msg_level=>fnd_log.level_procedure);
799: END IF;

Line 803: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+) ',

799: END IF;
800:
801: -- Debug info.
802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+) ',
804: p_prefix=>l_debug_prefix,
805: p_msg_level=>fnd_log.level_procedure);
806: END IF;
807:

Line 820: HZ_RELATIONSHIPS_PKG.Insert_Row (

816:
817: -- Call table-handler again to create the backward record.
818: -- This is done because for every relationship we want to
819: -- create both forward and backward relationship.
820: HZ_RELATIONSHIPS_PKG.Insert_Row (
821: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
822: X_SUBJECT_ID => p_relationship_rec.object_id,
823: X_SUBJECT_TYPE => p_relationship_rec.object_type,
824: X_SUBJECT_TABLE_NAME => p_relationship_rec.object_table_name,

Line 898: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) ' ||

894: );
895:
896: -- Debug info.
897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
898: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) ' ||
899: 'x_relationship_id = ' || p_relationship_rec.relationship_id,
900: p_prefix=>l_debug_prefix,
901: p_msg_level=>fnd_log.level_procedure);
902: END IF;

Line 1138: l_party_usg_assignment_rec.owner_table_name := 'HZ_RELATIONSHIPS';

1134: END IF;
1135: END IF;
1136: END IF;
1137:
1138: l_party_usg_assignment_rec.owner_table_name := 'HZ_RELATIONSHIPS';
1139: l_party_usg_assignment_rec.owner_table_id := p_relationship_rec.relationship_id;
1140: l_party_usg_assignment_rec.effective_start_date := p_relationship_rec.start_date;
1141: l_party_usg_assignment_rec.effective_end_date := p_relationship_rec.end_date;
1142:

Line 1276: db_actual_content_source hz_relationships.actual_content_source%TYPE;

1272: --Bug 3306941.
1273: l_meaning VARCHAR2(80);
1274:
1275: -- Bug 2197181: added for mix-n-match project.
1276: db_actual_content_source hz_relationships.actual_content_source%TYPE;
1277:
1278: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
1279:
1280: -- Bug 4693719 : Added for local assignment

Line 1281: l_acs hz_relationships.actual_content_source%TYPE;

1277:
1278: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
1279:
1280: -- Bug 4693719 : Added for local assignment
1281: l_acs hz_relationships.actual_content_source%TYPE;
1282:
1283: -- Bug 4873016 : Added to select directional_flag
1284: l_directional_flag hz_relationships.directional_flag%TYPE;
1285:

Line 1284: l_directional_flag hz_relationships.directional_flag%TYPE;

1280: -- Bug 4693719 : Added for local assignment
1281: l_acs hz_relationships.actual_content_source%TYPE;
1282:
1283: -- Bug 4873016 : Added to select directional_flag
1284: l_directional_flag hz_relationships.directional_flag%TYPE;
1285:
1286: BEGIN
1287:
1288: -- Debug info.

Line 1295: /* Bug 4873016 : Select the record from hz_relationships based on

1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;
1294:
1295: /* Bug 4873016 : Select the record from hz_relationships based on
1296: * the values passed by the user to this API. If there is no record
1297: * found, it means that user is trying to update any of the non-updateable
1298: * columns. In this case, we continue to selecte the forward relationship
1299: * record and error will be raised from the validate_relationship call.

Line 1338: FROM HZ_RELATIONSHIPS

1334: l_direction_code,
1335: l_status,
1336: db_actual_content_source,
1337: l_directional_flag
1338: FROM HZ_RELATIONSHIPS
1339: WHERE RELATIONSHIP_ID = p_relationship_rec.relationship_id
1340: AND SUBJECT_TABLE_NAME = nvl(p_relationship_rec.SUBJECT_TABLE_NAME, SUBJECT_TABLE_NAME)
1341: AND OBJECT_TABLE_NAME = nvl(p_relationship_rec.OBJECT_TABLE_NAME, OBJECT_TABLE_NAME)
1342: AND SUBJECT_ID = nvl(p_relationship_rec.SUBJECT_ID, SUBJECT_ID)

Line 1362: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );

1358: )
1359: )
1360: THEN
1361: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1362: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1363: FND_MSG_PUB.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:

Line 1412: FROM HZ_RELATIONSHIPS

1408: l_direction_code,
1409: l_status,
1410: db_actual_content_source,
1411: l_directional_flag
1412: FROM HZ_RELATIONSHIPS
1413: WHERE RELATIONSHIP_ID = p_relationship_rec.relationship_id
1414: AND DIRECTIONAL_FLAG = 'F'
1415: FOR UPDATE OF RELATIONSHIP_ID NOWAIT;
1416:

Line 1428: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );

1424: )
1425: )
1426: THEN
1427: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1428: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1429: FND_MSG_PUB.ADD;
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:

Line 1532: FROM HZ_RELATIONSHIPS

1528: THEN
1529: -- code for multiple parent check
1530: BEGIN
1531: SELECT 1 INTO l_count
1532: FROM HZ_RELATIONSHIPS
1533: WHERE OBJECT_ID = l_child_id
1534: AND OBJECT_TABLE_NAME = l_child_table_name
1535: AND OBJECT_TYPE = l_child_object_type
1536: AND RELATIONSHIP_TYPE = l_relationship_type

Line 1669: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',

1665: END IF;
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',
1670: p_prefix=>l_debug_prefix,
1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;
1673:

Line 1683: HZ_RELATIONSHIPS_PKG.Update_Row (

1679: END IF;
1680:
1681:
1682: --Call to table-handler.
1683: HZ_RELATIONSHIPS_PKG.Update_Row (
1684: X_Rowid => l_rowid,
1685: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1686: -- Bug 4873016 : pass NULL for non updateable columns
1687: /*

Line 1775: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',

1771: );
1772:
1773: -- Debug info.
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',
1776: p_prefix=>l_debug_prefix,
1777: p_msg_level=>fnd_log.level_procedure);
1778: END IF;
1779:

Line 1783: FROM HZ_RELATIONSHIPS

1779:
1780: -- get the reciprocal record information
1781: SELECT ROWID
1782: INTO l_rowid
1783: FROM HZ_RELATIONSHIPS
1784: WHERE RELATIONSHIP_ID = p_relationship_rec.relationship_id
1785: /* Bug 4873016 : query the reciprocal record based on previously
1786: * selected directional flag. If it was 'F' select 'B'
1787: * if it was 'B' select 'F'

Line 1793: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',

1789: AND DIRECTIONAL_FLAG = decode(l_directional_flag, 'F', 'B','B', 'F');
1790:
1791: -- Debug info.
1792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1793: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',
1794: p_prefix=>l_debug_prefix,
1795: p_msg_level=>fnd_log.level_procedure);
1796: END IF;
1797:

Line 1799: HZ_RELATIONSHIPS_PKG.Update_Row (

1795: p_msg_level=>fnd_log.level_procedure);
1796: END IF;
1797:
1798: -- update the reciprocal record
1799: HZ_RELATIONSHIPS_PKG.Update_Row (
1800: X_Rowid => l_rowid,
1801: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1802: X_SUBJECT_ID => NULL,
1803: X_SUBJECT_TYPE => NULL,

Line 1878: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',

1874: );
1875:
1876: -- Debug info.
1877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1878: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',
1879: p_prefix=>l_debug_prefix,
1880: p_msg_level=>fnd_log.level_procedure);
1881: END IF;
1882:

Line 2013: l_party_usg_assignment_rec.owner_table_name := 'HZ_RELATIONSHIPS';

2009: l_subject_type IN ('PERSON', 'ORGANIZATION')) AND
2010: l_subject_table_name = 'HZ_PARTIES' AND
2011: l_object_table_name = 'HZ_PARTIES'
2012: THEN
2013: l_party_usg_assignment_rec.owner_table_name := 'HZ_RELATIONSHIPS';
2014: l_party_usg_assignment_rec.owner_table_id := p_relationship_rec.relationship_id;
2015: l_party_usg_assignment_rec.effective_start_date := p_relationship_rec.start_date;
2016: l_party_usg_assignment_rec.effective_end_date := p_relationship_rec.end_date;
2017:

Line 2540: l_content_source_type HZ_RELATIONSHIPS.CONTENT_SOURCE_TYPE%TYPE;

2536: l_effective_start_date DATE;
2537: l_code_assignment_id NUMBER;
2538: l_sic_code HZ_PARTIES.SIC_CODE%TYPE;
2539: l_sic_code_type HZ_PARTIES.SIC_CODE_TYPE%TYPE;
2540: l_content_source_type HZ_RELATIONSHIPS.CONTENT_SOURCE_TYPE%TYPE;
2541: l_msg_count NUMBER;
2542: l_msg_data VARCHAR2(2000);
2543: l_party_object_version_number NUMBER;
2544: l_debug_prefix VARCHAR2(30);

Line 2965: p_entity_name => 'HZ_RELATIONSHIPS',

2961: /* SSM SST Integration and Extension
2962: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
2963:
2964: HZ_MIXNM_UTILITY.LoadDataSources(
2965: p_entity_name => 'HZ_RELATIONSHIPS',
2966: p_entity_attr_id => g_rel_entity_attr_id,
2967: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
2968: p_selected_datasources => g_rel_selected_datasources );
2969: */

Line 2973: p_entity_name => 'HZ_RELATIONSHIPS',

2969: */
2970: -- END IF;
2971:
2972: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
2973: p_entity_name => 'HZ_RELATIONSHIPS',
2974: p_entity_attr_id => g_rel_entity_attr_id,
2975: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
2976: p_selected_datasources => g_rel_selected_datasources,
2977: p_content_source_type => l_rel_rec.content_source_type,

Line 3011: p_db_object_name => 'HZ_RELATIONSHIPS',

3007: THEN
3008: l_test_security :=
3009: hz_dss_util_pub.test_instance(
3010: p_operation_code => 'INSERT',
3011: p_db_object_name => 'HZ_RELATIONSHIPS',
3012: p_instance_pk1_value => x_relationship_id,
3013: p_instance_pk2_value => 'F',
3014: p_user_name => fnd_global.user_name,
3015: x_return_status => dss_return_status,

Line 3029: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));

3025: -- Bug 3835601: replaced the dss message with a more user friendly message
3026: --
3027: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
3028: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3029: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3030: FND_MSG_PUB.ADD;
3031: RAISE FND_API.G_EXC_ERROR;
3032: end if;
3033: END IF;

Line 3052: HZ_POPULATE_BOT_PKG.pop_hz_relationships(

3048: END IF;
3049:
3050: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3051: -- populate function for integration service
3052: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3053: p_operation => 'I',
3054: p_RELATIONSHIP_ID => x_relationship_id );
3055: END IF;
3056: END IF;

Line 3263: p_db_object_name => 'HZ_RELATIONSHIPS',

3259: THEN
3260: l_test_security :=
3261: hz_dss_util_pub.test_instance(
3262: p_operation_code => 'UPDATE',
3263: p_db_object_name => 'HZ_RELATIONSHIPS',
3264: p_instance_pk1_value => l_rel_rec.relationship_id,
3265: p_instance_pk2_value => 'F',
3266: p_user_name => fnd_global.user_name,
3267: x_return_status => dss_return_status,

Line 3281: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));

3277: -- Bug 3835601: replaced the dss message with a more user friendly message
3278: --
3279: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3281: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;
3284: end if;
3285: END IF;

Line 3297: p_entity_name => 'HZ_RELATIONSHIPS',

3293: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3294: * There is no need to check if the data-source is selected.
3295: -- IF g_rel_mixnmatch_enabled IS NULL THEN
3296: HZ_MIXNM_UTILITY.LoadDataSources(
3297: p_entity_name => 'HZ_RELATIONSHIPS',
3298: p_entity_attr_id => g_rel_entity_attr_id,
3299: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
3300: p_selected_datasources => g_rel_selected_datasources );
3301: -- END IF;

Line 3339: HZ_POPULATE_BOT_PKG.pop_hz_relationships(

3335: END IF;
3336:
3337: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3338: -- populate function for integration service
3339: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3340: p_operation => 'U',
3341: p_RELATIONSHIP_ID => l_rel_rec.relationship_id );
3342: END IF;
3343: END IF;

Line 3536: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',

3532: END IF;
3533:
3534: -- Debug info.
3535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',
3537: p_prefix =>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_statement);
3539: END IF;
3540:

Line 3541: HZ_RELATIONSHIPS_PKG.Select_Row (

3537: p_prefix =>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_statement);
3539: END IF;
3540:
3541: HZ_RELATIONSHIPS_PKG.Select_Row (
3542: X_RELATIONSHIP_ID => x_rel_rec.relationship_id,
3543: X_DIRECTIONAL_FLAG => l_directional_flag,
3544: X_SUBJECT_ID => x_rel_rec.subject_id,
3545: X_SUBJECT_TYPE => x_rel_rec.subject_type,