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_PARTIES

Line 632: -- 'HZ_PARTIES'

628:
629: -- the PARTY_RELATIONSHIP type party will be created if
630: -- the relationship type has create_party_flag = 'Y' and
631: -- both the subject_table_name and object_table_name are
632: -- 'HZ_PARTIES'
633: IF r_rel_type.create_party_flag = 'Y'
634: AND
635: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
636: AND

Line 635: p_relationship_rec.subject_table_name = 'HZ_PARTIES'

631: -- both the subject_table_name and object_table_name are
632: -- 'HZ_PARTIES'
633: IF r_rel_type.create_party_flag = 'Y'
634: AND
635: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
636: AND
637: p_relationship_rec.object_table_name = 'HZ_PARTIES'
638: THEN
639:

Line 637: p_relationship_rec.object_table_name = 'HZ_PARTIES'

633: IF r_rel_type.create_party_flag = 'Y'
634: AND
635: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
636: AND
637: p_relationship_rec.object_table_name = 'HZ_PARTIES'
638: THEN
639:
640: -- Debug info.
641: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 664: -- Denormalize flags to HZ_PARTIES:

660: ELSE
661: x_created_party := 'N';
662: END IF;
663:
664: -- Denormalize flags to HZ_PARTIES:
665: -- COMPETITOR_FLAG
666: -- REFERENCE_USE_FLAG
667: -- THIRD_PARTY_FLAG
668: -- Denormalization will be done only if content_source_type

Line 670: -- object_table_name are 'HZ_PARTIES'

666: -- REFERENCE_USE_FLAG
667: -- THIRD_PARTY_FLAG
668: -- Denormalization will be done only if content_source_type
669: -- is 'USER_ENTERED' and both subject_table_name and
670: -- object_table_name are 'HZ_PARTIES'
671:
672: -- Bug 2197181: added for mix-n-match project. Denormalize
673: -- the three flags when the data source is visible (i.e.
674: -- selected).

Line 689: p_relationship_rec.subject_table_name = 'HZ_PARTIES'

685: OR
686: p_relationship_rec.content_source_type IS NULL
687: )
688: */
689: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
690: AND
691: p_relationship_rec.object_table_name = 'HZ_PARTIES'
692: THEN
693:

Line 691: p_relationship_rec.object_table_name = 'HZ_PARTIES'

687: )
688: */
689: p_relationship_rec.subject_table_name = 'HZ_PARTIES'
690: AND
691: p_relationship_rec.object_table_name = 'HZ_PARTIES'
692: THEN
693:
694: -- Debug info.
695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 696: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',

692: THEN
693:
694: -- Debug info.
695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;
700:

Line 1074: p_relationship_rec.subject_table_name = 'HZ_PARTIES' AND

1070: IF (p_relationship_rec.subject_type = 'PERSON' AND
1071: p_relationship_rec.object_type IN ('PERSON', 'ORGANIZATION') OR
1072: p_relationship_rec.object_type = 'PERSON' AND
1073: p_relationship_rec.subject_type IN ('PERSON', 'ORGANIZATION')) AND
1074: p_relationship_rec.subject_table_name = 'HZ_PARTIES' AND
1075: p_relationship_rec.object_table_name = 'HZ_PARTIES'
1076: THEN
1077: IF (p_contact_party_id IS NOT NULL AND
1078: p_contact_party_id <> FND_API.G_MISS_NUM AND

Line 1075: p_relationship_rec.object_table_name = 'HZ_PARTIES'

1071: p_relationship_rec.object_type IN ('PERSON', 'ORGANIZATION') OR
1072: p_relationship_rec.object_type = 'PERSON' AND
1073: p_relationship_rec.subject_type IN ('PERSON', 'ORGANIZATION')) AND
1074: p_relationship_rec.subject_table_name = 'HZ_PARTIES' AND
1075: p_relationship_rec.object_table_name = 'HZ_PARTIES'
1076: THEN
1077: IF (p_contact_party_id IS NOT NULL AND
1078: p_contact_party_id <> FND_API.G_MISS_NUM AND
1079: (p_contact_party_usage_code IS NULL OR

Line 1634: -- object_table_name are 'HZ_PARTIES'

1630: END IF;
1631: */
1632: -- Denormalization will be done only if content_source_type
1633: -- is 'USER_ENTERED' and both subject_table_name and
1634: -- object_table_name are 'HZ_PARTIES'
1635:
1636: -- Bug 2197181: added for mix-n-match project. Denormalize
1637: -- the three flags when the data source is visible (i.e.
1638: -- selected).

Line 1651: l_subject_table_name = 'HZ_PARTIES'

1647: /*
1648: l_content_source_type = 'USER_ENTERED'
1649: AND
1650: */
1651: l_subject_table_name = 'HZ_PARTIES'
1652: AND
1653: l_object_table_name = 'HZ_PARTIES'
1654: THEN
1655:

Line 1653: l_object_table_name = 'HZ_PARTIES'

1649: AND
1650: */
1651: l_subject_table_name = 'HZ_PARTIES'
1652: AND
1653: l_object_table_name = 'HZ_PARTIES'
1654: THEN
1655:
1656: -- Debug info.
1657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1658: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',

1654: THEN
1655:
1656: -- Debug info.
1657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1658: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
1659: p_prefix =>l_debug_prefix,
1660: p_msg_level=>fnd_log.level_statement);
1661: END IF;
1662:

Line 2010: l_subject_table_name = 'HZ_PARTIES' AND

2006: (l_subject_type = 'PERSON' AND
2007: l_object_type IN ('PERSON', 'ORGANIZATION') OR
2008: l_object_type = 'PERSON' AND
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;

Line 2011: l_object_table_name = 'HZ_PARTIES'

2007: l_object_type IN ('PERSON', 'ORGANIZATION') OR
2008: l_object_type = 'PERSON' AND
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;

Line 2072: | Denormalize flags to hz_parties:

Line 2111: FROM hz_parties

2107:
2108: --check if party record is locked by any one else.
2109: BEGIN
2110: SELECT party_id INTO l_party_id
2111: FROM hz_parties
2112: WHERE party_id = p_party_id
2113: FOR UPDATE NOWAIT;
2114: EXCEPTION WHEN OTHERS THEN
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

Line 2116: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');

2112: WHERE party_id = p_party_id
2113: FOR UPDATE NOWAIT;
2114: EXCEPTION WHEN OTHERS THEN
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2116: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
2117: FND_MSG_PUB.ADD;
2118: RAISE FND_API.G_EXC_ERROR;
2119: END;
2120:

Line 2143: UPDATE HZ_PARTIES

2139: THEN
2140: l_competitor_flag := 'Y';
2141: END IF;
2142:
2143: UPDATE HZ_PARTIES
2144: SET COMPETITOR_FLAG = l_competitor_flag
2145: WHERE PARTY_ID = p_party_id;
2146:
2147: ELSIF p_relationship_rec.relationship_code = 'REFERENCE_FOR' THEN

Line 2155: UPDATE HZ_PARTIES

2151: THEN
2152: l_reference_use_flag := 'Y';
2153: END IF;
2154:
2155: UPDATE HZ_PARTIES
2156: SET REFERENCE_USE_FLAG = l_reference_use_flag
2157: WHERE PARTY_ID = p_party_id;
2158:
2159: ELSIF p_relationship_rec.relationship_code = 'PARTNER_OF' THEN

Line 2166: UPDATE HZ_PARTIES

2162: THEN
2163: l_third_party_flag := 'Y';
2164: END IF;
2165:
2166: UPDATE HZ_PARTIES
2167: SET THIRD_PARTY_FLAG = l_third_party_flag
2168: WHERE PARTY_ID = p_party_id;
2169:
2170: END IF;

Line 2229: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

2225: l_generate_party_number VARCHAR2(1);
2226: l_rowid ROWID := NULL;
2227: l_count NUMBER;
2228: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2229: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2230: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2231: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2232: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2233: l_code_assignment_id NUMBER;

Line 2230: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;

2226: l_rowid ROWID := NULL;
2227: l_count NUMBER;
2228: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2229: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2230: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2231: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2232: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2233: l_code_assignment_id NUMBER;
2234: l_msg_count NUMBER;

Line 2231: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;

2227: l_count NUMBER;
2228: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2229: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2230: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2231: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2232: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2233: l_code_assignment_id NUMBER;
2234: l_msg_count NUMBER;
2235: l_msg_data VARCHAR2(2000);

Line 2232: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;

2228: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2229: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2230: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2231: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2232: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2233: l_code_assignment_id NUMBER;
2234: l_msg_count NUMBER;
2235: l_msg_data VARCHAR2(2000);
2236: l_dummy VARCHAR2(1);

Line 2258: FROM HZ_PARTIES

2254: THEN
2255: BEGIN
2256: SELECT 'Y'
2257: INTO l_dummy
2258: FROM HZ_PARTIES
2259: WHERE PARTY_ID = l_party_id;
2260:
2261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2262: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

Line 2302: FROM HZ_PARTIES

2298:
2299: BEGIN
2300: SELECT 'Y'
2301: INTO l_dummy
2302: FROM HZ_PARTIES
2303: WHERE PARTY_NUMBER = l_party_number;
2304:
2305: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2306: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_number');

Line 2352: FROM HZ_PARTIES

2348:
2349: -- build the party_name for relationship party
2350: SELECT PARTY_NAME
2351: INTO l_subject_name
2352: FROM HZ_PARTIES
2353: WHERE PARTY_ID = p_relationship_rec.subject_id;
2354:
2355: SELECT PARTY_NAME
2356: INTO l_object_name

Line 2357: FROM HZ_PARTIES

2353: WHERE PARTY_ID = p_relationship_rec.subject_id;
2354:
2355: SELECT PARTY_NAME
2356: INTO l_object_name
2357: FROM HZ_PARTIES
2358: WHERE PARTY_ID = p_relationship_rec.object_id;
2359:
2360: l_party_name := SUBSTRB(l_subject_name || '-' ||
2361: l_object_name || '-' ||

Line 2371: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',

2367: END IF;
2368:
2369: -- Debug info.
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:

Line 2376: HZ_PARTIES_PKG.Insert_Row (

2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:
2376: HZ_PARTIES_PKG.Insert_Row (
2377: X_PARTY_ID => l_party_rec.party_id,
2378: X_PARTY_NUMBER => l_party_rec.party_number,
2379: X_PARTY_NAME => l_party_name,
2380: X_PARTY_TYPE => p_party_type,

Line 2468: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||

2464: x_party_number := l_party_rec.party_number;
2465:
2466: -- Debug info.
2467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2468: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||
2469: 'x_party_id = ' || x_party_id,
2470: p_prefix=>l_debug_prefix,
2471: p_msg_level=>fnd_log.level_procedure);
2472: END IF;

Line 2479: UPDATE HZ_PARTIES SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;

2475: l_party_name := SUBSTRB(l_subject_name || '-' ||
2476: l_object_name || '-' ||
2477: x_party_number, 1, 360);
2478:
2479: UPDATE HZ_PARTIES SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
2480:
2481: -- Debug info.
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',

Line 2532: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;

2528: ) IS
2529:
2530: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2531: l_rowid ROWID;
2532: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;
2533: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2534: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2535: l_profile_id NUMBER;
2536: l_effective_start_date DATE;

Line 2533: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

2529:
2530: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2531: l_rowid ROWID;
2532: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;
2533: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2534: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2535: l_profile_id NUMBER;
2536: l_effective_start_date DATE;
2537: l_code_assignment_id NUMBER;

Line 2534: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

2530: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2531: l_rowid ROWID;
2532: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;
2533: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2534: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2535: l_profile_id NUMBER;
2536: l_effective_start_date DATE;
2537: l_code_assignment_id NUMBER;
2538: l_sic_code HZ_PARTIES.SIC_CODE%TYPE;

Line 2538: l_sic_code HZ_PARTIES.SIC_CODE%TYPE;

2534: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2535: l_profile_id NUMBER;
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);

Line 2539: l_sic_code_type HZ_PARTIES.SIC_CODE_TYPE%TYPE;

2535: l_profile_id NUMBER;
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;

Line 2546: db_created_by_module HZ_PARTIES.CREATED_BY_MODULE%TYPE;

2542: l_msg_data VARCHAR2(2000);
2543: l_party_object_version_number NUMBER;
2544: l_debug_prefix VARCHAR2(30);
2545:
2546: db_created_by_module HZ_PARTIES.CREATED_BY_MODULE%TYPE;
2547:
2548: BEGIN
2549:
2550: -- Debug info.

Line 2565: FROM HZ_PARTIES

2561: CREATED_BY_MODULE
2562: INTO l_party_object_version_number,
2563: l_rowid,
2564: db_created_by_module
2565: FROM HZ_PARTIES
2566: WHERE PARTY_ID = l_party_rec.party_id
2567: FOR UPDATE OF PARTY_ID NOWAIT;
2568:
2569: -- lock the current record. if the record is locked by some one else,

Line 2584: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

2580: )
2581: )
2582: THEN
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2584: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;
2588:

Line 2613: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',

2609: END IF;
2610:
2611: -- Debug info.
2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2613: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',
2614: p_prefix=>l_debug_prefix,
2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;
2617:

Line 2619: HZ_PARTIES_PKG.Update_Row (

2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;
2617:
2618: -- call table handler to update the record
2619: HZ_PARTIES_PKG.Update_Row (
2620: X_Rowid => l_rowid,
2621: X_PARTY_ID => l_party_rec.party_id,
2622: X_PARTY_NUMBER => NULL,
2623: X_PARTY_NAME => NULL,

Line 2710: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',

2706: );
2707:
2708: -- Debug info.
2709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2710: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',
2711: p_prefix=>l_debug_prefix,
2712: p_msg_level=>fnd_log.level_procedure);
2713: END IF;
2714:

Line 3005: (l_rel_rec.subject_table_name = 'HZ_PARTIES' OR

3001: -- Bug 3818648: do dss check in party context only. check dss
3002: -- profile before call test_instance.
3003: --
3004: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3005: (l_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3006: l_rel_rec.object_table_name = 'HZ_PARTIES')
3007: THEN
3008: l_test_security :=
3009: hz_dss_util_pub.test_instance(

Line 3006: l_rel_rec.object_table_name = 'HZ_PARTIES')

3002: -- profile before call test_instance.
3003: --
3004: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3005: (l_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3006: l_rel_rec.object_table_name = 'HZ_PARTIES')
3007: THEN
3008: l_test_security :=
3009: hz_dss_util_pub.test_instance(
3010: p_operation_code => 'INSERT',

Line 3257: (l_old_rel_rec.subject_table_name = 'HZ_PARTIES' OR

3253: -- Bug 3818648: do dss check in party context only. check dss
3254: -- profile before call test_instance.
3255: --
3256: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3257: (l_old_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3258: l_old_rel_rec.object_table_name = 'HZ_PARTIES')
3259: THEN
3260: l_test_security :=
3261: hz_dss_util_pub.test_instance(

Line 3258: l_old_rel_rec.object_table_name = 'HZ_PARTIES')

3254: -- profile before call test_instance.
3255: --
3256: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3257: (l_old_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3258: l_old_rel_rec.object_table_name = 'HZ_PARTIES')
3259: THEN
3260: l_test_security :=
3261: hz_dss_util_pub.test_instance(
3262: p_operation_code => 'UPDATE',