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 547: FROM HZ_RELATIONSHIPS

543: --When Relationship is created with Inactive status then not validating for Multiple parents.
544: IF r_rel_type.multiple_parent_allowed = 'N' AND NVL(p_relationship_rec.status,'A') <> 'I' THEN
545: BEGIN
546: SELECT 1 INTO l_count
547: FROM HZ_RELATIONSHIPS
548: WHERE OBJECT_ID = l_child_id
549: AND OBJECT_TABLE_NAME = l_child_table_name
550: AND OBJECT_TYPE = l_child_object_type
551: AND RELATIONSHIP_TYPE = p_relationship_rec.relationship_type

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

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

Line 719: HZ_RELATIONSHIPS_PKG.Insert_Row (

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

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

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

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

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

Line 822: HZ_RELATIONSHIPS_PKG.Insert_Row (

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

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

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

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

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

Line 1282: db_actual_content_source hz_relationships.actual_content_source%TYPE;

1278: --Bug 3306941.
1279: l_meaning VARCHAR2(80);
1280:
1281: -- Bug 2197181: added for mix-n-match project.
1282: db_actual_content_source hz_relationships.actual_content_source%TYPE;
1283:
1284: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
1285:
1286: -- Bug 4693719 : Added for local assignment

Line 1287: l_acs hz_relationships.actual_content_source%TYPE;

1283:
1284: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
1285:
1286: -- Bug 4693719 : Added for local assignment
1287: l_acs hz_relationships.actual_content_source%TYPE;
1288:
1289: -- Bug 4873016 : Added to select directional_flag
1290: l_directional_flag hz_relationships.directional_flag%TYPE;
1291:

Line 1290: l_directional_flag hz_relationships.directional_flag%TYPE;

1286: -- Bug 4693719 : Added for local assignment
1287: l_acs hz_relationships.actual_content_source%TYPE;
1288:
1289: -- Bug 4873016 : Added to select directional_flag
1290: l_directional_flag hz_relationships.directional_flag%TYPE;
1291:
1292: BEGIN
1293:
1294: -- Debug info.

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

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

Line 1344: FROM HZ_RELATIONSHIPS

1340: l_direction_code,
1341: l_status,
1342: db_actual_content_source,
1343: l_directional_flag
1344: FROM HZ_RELATIONSHIPS
1345: WHERE RELATIONSHIP_ID = p_relationship_rec.relationship_id
1346: AND SUBJECT_TABLE_NAME = nvl(p_relationship_rec.SUBJECT_TABLE_NAME, SUBJECT_TABLE_NAME)
1347: AND OBJECT_TABLE_NAME = nvl(p_relationship_rec.OBJECT_TABLE_NAME, OBJECT_TABLE_NAME)
1348: AND SUBJECT_ID = nvl(p_relationship_rec.SUBJECT_ID, SUBJECT_ID)

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

1364: )
1365: )
1366: THEN
1367: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1368: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1369: FND_MSG_PUB.ADD;
1370: RAISE FND_API.G_EXC_ERROR;
1371: END IF;
1372:

Line 1418: FROM HZ_RELATIONSHIPS

1414: l_direction_code,
1415: l_status,
1416: db_actual_content_source,
1417: l_directional_flag
1418: FROM HZ_RELATIONSHIPS
1419: WHERE RELATIONSHIP_ID = p_relationship_rec.relationship_id
1420: AND DIRECTIONAL_FLAG = 'F'
1421: FOR UPDATE OF RELATIONSHIP_ID NOWAIT;
1422:

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

1430: )
1431: )
1432: THEN
1433: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1434: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:

Line 1540: FROM HZ_RELATIONSHIPS

1536: THEN
1537: -- code for multiple parent check
1538: BEGIN
1539: SELECT 1 INTO l_count
1540: FROM HZ_RELATIONSHIPS
1541: WHERE OBJECT_ID = l_child_id
1542: AND OBJECT_TABLE_NAME = l_child_table_name
1543: AND OBJECT_TYPE = l_child_object_type
1544: AND RELATIONSHIP_TYPE = l_relationship_type

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

1673: END IF;
1674:
1675: -- Debug info.
1676: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1677: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',
1678: p_prefix=>l_debug_prefix,
1679: p_msg_level=>fnd_log.level_procedure);
1680: END IF;
1681:

Line 1691: HZ_RELATIONSHIPS_PKG.Update_Row (

1687: END IF;
1688:
1689:
1690: --Call to table-handler.
1691: HZ_RELATIONSHIPS_PKG.Update_Row (
1692: X_Rowid => l_rowid,
1693: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1694: -- Bug 4873016 : pass NULL for non updateable columns
1695: /*

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

1779: );
1780:
1781: -- Debug info.
1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',
1784: p_prefix=>l_debug_prefix,
1785: p_msg_level=>fnd_log.level_procedure);
1786: END IF;
1787:

Line 1791: FROM HZ_RELATIONSHIPS

1787:
1788: -- get the reciprocal record information
1789: SELECT ROWID
1790: INTO l_rowid
1791: FROM HZ_RELATIONSHIPS
1792: WHERE RELATIONSHIP_ID = p_relationship_rec.relationship_id
1793: /* Bug 4873016 : query the reciprocal record based on previously
1794: * selected directional flag. If it was 'F' select 'B'
1795: * if it was 'B' select 'F'

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

1797: AND DIRECTIONAL_FLAG = decode(l_directional_flag, 'F', 'B','B', 'F');
1798:
1799: -- Debug info.
1800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1801: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',
1802: p_prefix=>l_debug_prefix,
1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;
1805:

Line 1807: HZ_RELATIONSHIPS_PKG.Update_Row (

1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;
1805:
1806: -- update the reciprocal record
1807: HZ_RELATIONSHIPS_PKG.Update_Row (
1808: X_Rowid => l_rowid,
1809: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1810: X_SUBJECT_ID => NULL,
1811: X_SUBJECT_TYPE => NULL,

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

1882: );
1883:
1884: -- Debug info.
1885: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1886: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',
1887: p_prefix=>l_debug_prefix,
1888: p_msg_level=>fnd_log.level_procedure);
1889: END IF;
1890:

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

2034: l_subject_type IN ('PERSON', 'ORGANIZATION')) AND
2035: l_subject_table_name = 'HZ_PARTIES' AND
2036: l_object_table_name = 'HZ_PARTIES'
2037: THEN
2038: l_party_usg_assignment_rec.owner_table_name := 'HZ_RELATIONSHIPS';
2039: l_party_usg_assignment_rec.owner_table_id := p_relationship_rec.relationship_id;
2040: l_party_usg_assignment_rec.effective_start_date := p_relationship_rec.start_date;
2041: l_party_usg_assignment_rec.effective_end_date := p_relationship_rec.end_date;
2042:

Line 2565: l_content_source_type HZ_RELATIONSHIPS.CONTENT_SOURCE_TYPE%TYPE;

2561: l_effective_start_date DATE;
2562: l_code_assignment_id NUMBER;
2563: l_sic_code HZ_PARTIES.SIC_CODE%TYPE;
2564: l_sic_code_type HZ_PARTIES.SIC_CODE_TYPE%TYPE;
2565: l_content_source_type HZ_RELATIONSHIPS.CONTENT_SOURCE_TYPE%TYPE;
2566: l_msg_count NUMBER;
2567: l_msg_data VARCHAR2(2000);
2568: l_party_object_version_number NUMBER;
2569: l_debug_prefix VARCHAR2(30);

Line 2990: p_entity_name => 'HZ_RELATIONSHIPS',

2986: /* SSM SST Integration and Extension
2987: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
2988:
2989: HZ_MIXNM_UTILITY.LoadDataSources(
2990: p_entity_name => 'HZ_RELATIONSHIPS',
2991: p_entity_attr_id => g_rel_entity_attr_id,
2992: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
2993: p_selected_datasources => g_rel_selected_datasources );
2994: */

Line 2998: p_entity_name => 'HZ_RELATIONSHIPS',

2994: */
2995: -- END IF;
2996:
2997: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (
2998: p_entity_name => 'HZ_RELATIONSHIPS',
2999: p_entity_attr_id => g_rel_entity_attr_id,
3000: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
3001: p_selected_datasources => g_rel_selected_datasources,
3002: p_content_source_type => l_rel_rec.content_source_type,

Line 3036: p_db_object_name => 'HZ_RELATIONSHIPS',

3032: THEN
3033: l_test_security :=
3034: hz_dss_util_pub.test_instance(
3035: p_operation_code => 'INSERT',
3036: p_db_object_name => 'HZ_RELATIONSHIPS',
3037: p_instance_pk1_value => x_relationship_id,
3038: p_instance_pk2_value => 'F',
3039: p_user_name => fnd_global.user_name,
3040: x_return_status => dss_return_status,

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

3050: -- Bug 3835601: replaced the dss message with a more user friendly message
3051: --
3052: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
3053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3054: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3055: FND_MSG_PUB.ADD;
3056: RAISE FND_API.G_EXC_ERROR;
3057: end if;
3058: END IF;

Line 3077: HZ_POPULATE_BOT_PKG.pop_hz_relationships(

3073: END IF;
3074:
3075: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3076: -- populate function for integration service
3077: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3078: p_operation => 'I',
3079: p_RELATIONSHIP_ID => x_relationship_id );
3080: END IF;
3081: END IF;

Line 3288: p_db_object_name => 'HZ_RELATIONSHIPS',

3284: THEN
3285: l_test_security :=
3286: hz_dss_util_pub.test_instance(
3287: p_operation_code => 'UPDATE',
3288: p_db_object_name => 'HZ_RELATIONSHIPS',
3289: p_instance_pk1_value => l_rel_rec.relationship_id,
3290: p_instance_pk2_value => 'F',
3291: p_user_name => fnd_global.user_name,
3292: x_return_status => dss_return_status,

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

3302: -- Bug 3835601: replaced the dss message with a more user friendly message
3303: --
3304: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3306: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3307: FND_MSG_PUB.ADD;
3308: RAISE FND_API.G_EXC_ERROR;
3309: end if;
3310: END IF;

Line 3322: p_entity_name => 'HZ_RELATIONSHIPS',

3318: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.
3319: * There is no need to check if the data-source is selected.
3320: -- IF g_rel_mixnmatch_enabled IS NULL THEN
3321: HZ_MIXNM_UTILITY.LoadDataSources(
3322: p_entity_name => 'HZ_RELATIONSHIPS',
3323: p_entity_attr_id => g_rel_entity_attr_id,
3324: p_mixnmatch_enabled => g_rel_mixnmatch_enabled,
3325: p_selected_datasources => g_rel_selected_datasources );
3326: -- END IF;

Line 3364: HZ_POPULATE_BOT_PKG.pop_hz_relationships(

3360: END IF;
3361:
3362: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3363: -- populate function for integration service
3364: HZ_POPULATE_BOT_PKG.pop_hz_relationships(
3365: p_operation => 'U',
3366: p_RELATIONSHIP_ID => l_rel_rec.relationship_id );
3367: END IF;
3368: END IF;

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

3557: END IF;
3558:
3559: -- Debug info.
3560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3561: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',
3562: p_prefix =>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_statement);
3564: END IF;
3565:

Line 3566: HZ_RELATIONSHIPS_PKG.Select_Row (

3562: p_prefix =>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_statement);
3564: END IF;
3565:
3566: HZ_RELATIONSHIPS_PKG.Select_Row (
3567: X_RELATIONSHIP_ID => x_rel_rec.relationship_id,
3568: X_DIRECTIONAL_FLAG => l_directional_flag,
3569: X_SUBJECT_ID => x_rel_rec.subject_id,
3570: X_SUBJECT_TYPE => x_rel_rec.subject_type,