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 634: -- 'HZ_PARTIES'

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

Line 637: p_relationship_rec.subject_table_name = 'HZ_PARTIES'

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

Line 639: p_relationship_rec.object_table_name = 'HZ_PARTIES'

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

Line 666: -- Denormalize flags to HZ_PARTIES:

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

Line 672: -- object_table_name are 'HZ_PARTIES'

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

Line 691: p_relationship_rec.subject_table_name = 'HZ_PARTIES'

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

Line 693: p_relationship_rec.object_table_name = 'HZ_PARTIES'

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

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

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

Line 1076: p_relationship_rec.subject_table_name = 'HZ_PARTIES' AND

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

Line 1077: p_relationship_rec.object_table_name = 'HZ_PARTIES'

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

Line 1642: -- object_table_name are 'HZ_PARTIES'

1638: END IF;
1639: */
1640: -- Denormalization will be done only if content_source_type
1641: -- is 'USER_ENTERED' and both subject_table_name and
1642: -- object_table_name are 'HZ_PARTIES'
1643:
1644: -- Bug 2197181: added for mix-n-match project. Denormalize
1645: -- the three flags when the data source is visible (i.e.
1646: -- selected).

Line 1659: l_subject_table_name = 'HZ_PARTIES'

1655: /*
1656: l_content_source_type = 'USER_ENTERED'
1657: AND
1658: */
1659: l_subject_table_name = 'HZ_PARTIES'
1660: AND
1661: l_object_table_name = 'HZ_PARTIES'
1662: THEN
1663:

Line 1661: l_object_table_name = 'HZ_PARTIES'

1657: AND
1658: */
1659: l_subject_table_name = 'HZ_PARTIES'
1660: AND
1661: l_object_table_name = 'HZ_PARTIES'
1662: THEN
1663:
1664: -- Debug info.
1665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1662: THEN
1663:
1664: -- Debug info.
1665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1666: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
1667: p_prefix =>l_debug_prefix,
1668: p_msg_level=>fnd_log.level_statement);
1669: END IF;
1670:

Line 2035: l_subject_table_name = 'HZ_PARTIES' AND

2031: (l_subject_type = 'PERSON' AND
2032: l_object_type IN ('PERSON', 'ORGANIZATION') OR
2033: l_object_type = 'PERSON' AND
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;

Line 2036: l_object_table_name = 'HZ_PARTIES'

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

Line 2097: | Denormalize flags to hz_parties:

Line 2136: FROM hz_parties

2132:
2133: --check if party record is locked by any one else.
2134: BEGIN
2135: SELECT party_id INTO l_party_id
2136: FROM hz_parties
2137: WHERE party_id = p_party_id
2138: FOR UPDATE NOWAIT;
2139: EXCEPTION WHEN OTHERS THEN
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

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

2137: WHERE party_id = p_party_id
2138: FOR UPDATE NOWAIT;
2139: EXCEPTION WHEN OTHERS THEN
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2141: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
2142: FND_MSG_PUB.ADD;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END;
2145:

Line 2168: UPDATE HZ_PARTIES

2164: THEN
2165: l_competitor_flag := 'Y';
2166: END IF;
2167:
2168: UPDATE HZ_PARTIES
2169: SET COMPETITOR_FLAG = l_competitor_flag
2170: WHERE PARTY_ID = p_party_id;
2171:
2172: ELSIF p_relationship_rec.relationship_code = 'REFERENCE_FOR' THEN

Line 2180: UPDATE HZ_PARTIES

2176: THEN
2177: l_reference_use_flag := 'Y';
2178: END IF;
2179:
2180: UPDATE HZ_PARTIES
2181: SET REFERENCE_USE_FLAG = l_reference_use_flag
2182: WHERE PARTY_ID = p_party_id;
2183:
2184: ELSIF p_relationship_rec.relationship_code = 'PARTNER_OF' THEN

Line 2191: UPDATE HZ_PARTIES

2187: THEN
2188: l_third_party_flag := 'Y';
2189: END IF;
2190:
2191: UPDATE HZ_PARTIES
2192: SET THIRD_PARTY_FLAG = l_third_party_flag
2193: WHERE PARTY_ID = p_party_id;
2194:
2195: END IF;

Line 2254: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

2250: l_generate_party_number VARCHAR2(1);
2251: l_rowid ROWID := NULL;
2252: l_count NUMBER;
2253: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2254: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2255: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2256: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2257: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2258: l_code_assignment_id NUMBER;

Line 2255: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;

2251: l_rowid ROWID := NULL;
2252: l_count NUMBER;
2253: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2254: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2255: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2256: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2257: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2258: l_code_assignment_id NUMBER;
2259: l_msg_count NUMBER;

Line 2256: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;

2252: l_count NUMBER;
2253: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2254: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2255: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2256: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2257: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2258: l_code_assignment_id NUMBER;
2259: l_msg_count NUMBER;
2260: l_msg_data VARCHAR2(2000);

Line 2257: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;

2253: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2254: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2255: l_subject_name HZ_PARTIES.PARTY_NAME%TYPE;
2256: l_object_name HZ_PARTIES.PARTY_NAME%TYPE;
2257: l_customer_key HZ_PARTIES.CUSTOMER_KEY%TYPE;
2258: l_code_assignment_id NUMBER;
2259: l_msg_count NUMBER;
2260: l_msg_data VARCHAR2(2000);
2261: l_dummy VARCHAR2(1);

Line 2283: FROM HZ_PARTIES

2279: THEN
2280: BEGIN
2281: SELECT 'Y'
2282: INTO l_dummy
2283: FROM HZ_PARTIES
2284: WHERE PARTY_ID = l_party_id;
2285:
2286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

Line 2327: FROM HZ_PARTIES

2323:
2324: BEGIN
2325: SELECT 'Y'
2326: INTO l_dummy
2327: FROM HZ_PARTIES
2328: WHERE PARTY_NUMBER = l_party_number;
2329:
2330: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2331: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_number');

Line 2377: FROM HZ_PARTIES

2373:
2374: -- build the party_name for relationship party
2375: SELECT PARTY_NAME
2376: INTO l_subject_name
2377: FROM HZ_PARTIES
2378: WHERE PARTY_ID = p_relationship_rec.subject_id;
2379:
2380: SELECT PARTY_NAME
2381: INTO l_object_name

Line 2382: FROM HZ_PARTIES

2378: WHERE PARTY_ID = p_relationship_rec.subject_id;
2379:
2380: SELECT PARTY_NAME
2381: INTO l_object_name
2382: FROM HZ_PARTIES
2383: WHERE PARTY_ID = p_relationship_rec.object_id;
2384:
2385: l_party_name := SUBSTRB(l_subject_name || '-' ||
2386: l_object_name || '-' ||

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

2392: END IF;
2393:
2394: -- Debug info.
2395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2396: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',
2397: p_prefix=>l_debug_prefix,
2398: p_msg_level=>fnd_log.level_procedure);
2399: END IF;
2400:

Line 2401: HZ_PARTIES_PKG.Insert_Row (

2397: p_prefix=>l_debug_prefix,
2398: p_msg_level=>fnd_log.level_procedure);
2399: END IF;
2400:
2401: HZ_PARTIES_PKG.Insert_Row (
2402: X_PARTY_ID => l_party_rec.party_id,
2403: X_PARTY_NUMBER => l_party_rec.party_number,
2404: X_PARTY_NAME => l_party_name,
2405: X_PARTY_TYPE => p_party_type,

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

2489: x_party_number := l_party_rec.party_number;
2490:
2491: -- Debug info.
2492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2493: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||
2494: 'x_party_id = ' || x_party_id,
2495: p_prefix=>l_debug_prefix,
2496: p_msg_level=>fnd_log.level_procedure);
2497: END IF;

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

2500: l_party_name := SUBSTRB(l_subject_name || '-' ||
2501: l_object_name || '-' ||
2502: x_party_number, 1, 360);
2503:
2504: UPDATE HZ_PARTIES SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
2505:
2506: -- Debug info.
2507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2508: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',

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

2553: ) IS
2554:
2555: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2556: l_rowid ROWID;
2557: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;
2558: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2559: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2560: l_profile_id NUMBER;
2561: l_effective_start_date DATE;

Line 2558: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

2554:
2555: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2556: l_rowid ROWID;
2557: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;
2558: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2559: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2560: l_profile_id NUMBER;
2561: l_effective_start_date DATE;
2562: l_code_assignment_id NUMBER;

Line 2559: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

2555: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE := p_relationship_rec.party_rec;
2556: l_rowid ROWID;
2557: l_party_name HZ_PARTIES.PARTY_NAME%TYPE := FND_API.G_MISS_CHAR;
2558: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2559: l_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2560: l_profile_id NUMBER;
2561: l_effective_start_date DATE;
2562: l_code_assignment_id NUMBER;
2563: l_sic_code HZ_PARTIES.SIC_CODE%TYPE;

Line 2563: l_sic_code HZ_PARTIES.SIC_CODE%TYPE;

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

Line 2564: l_sic_code_type HZ_PARTIES.SIC_CODE_TYPE%TYPE;

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

Line 2571: db_created_by_module HZ_PARTIES.CREATED_BY_MODULE%TYPE;

2567: l_msg_data VARCHAR2(2000);
2568: l_party_object_version_number NUMBER;
2569: l_debug_prefix VARCHAR2(30);
2570:
2571: db_created_by_module HZ_PARTIES.CREATED_BY_MODULE%TYPE;
2572:
2573: BEGIN
2574:
2575: -- Debug info.

Line 2590: FROM HZ_PARTIES

2586: CREATED_BY_MODULE
2587: INTO l_party_object_version_number,
2588: l_rowid,
2589: db_created_by_module
2590: FROM HZ_PARTIES
2591: WHERE PARTY_ID = l_party_rec.party_id
2592: FOR UPDATE OF PARTY_ID NOWAIT;
2593:
2594: -- lock the current record. if the record is locked by some one else,

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

2605: )
2606: )
2607: THEN
2608: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2609: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
2610: FND_MSG_PUB.ADD;
2611: RAISE FND_API.G_EXC_ERROR;
2612: END IF;
2613:

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

2634: END IF;
2635:
2636: -- Debug info.
2637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2638: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',
2639: p_prefix=>l_debug_prefix,
2640: p_msg_level=>fnd_log.level_procedure);
2641: END IF;
2642:

Line 2644: HZ_PARTIES_PKG.Update_Row (

2640: p_msg_level=>fnd_log.level_procedure);
2641: END IF;
2642:
2643: -- call table handler to update the record
2644: HZ_PARTIES_PKG.Update_Row (
2645: X_Rowid => l_rowid,
2646: X_PARTY_ID => l_party_rec.party_id,
2647: X_PARTY_NUMBER => NULL,
2648: X_PARTY_NAME => NULL,

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

2731: );
2732:
2733: -- Debug info.
2734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2735: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',
2736: p_prefix=>l_debug_prefix,
2737: p_msg_level=>fnd_log.level_procedure);
2738: END IF;
2739:

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

3026: -- Bug 3818648: do dss check in party context only. check dss
3027: -- profile before call test_instance.
3028: --
3029: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3030: (l_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3031: l_rel_rec.object_table_name = 'HZ_PARTIES')
3032: THEN
3033: l_test_security :=
3034: hz_dss_util_pub.test_instance(

Line 3031: l_rel_rec.object_table_name = 'HZ_PARTIES')

3027: -- profile before call test_instance.
3028: --
3029: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3030: (l_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3031: l_rel_rec.object_table_name = 'HZ_PARTIES')
3032: THEN
3033: l_test_security :=
3034: hz_dss_util_pub.test_instance(
3035: p_operation_code => 'INSERT',

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

3278: -- Bug 3818648: do dss check in party context only. check dss
3279: -- profile before call test_instance.
3280: --
3281: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3282: (l_old_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3283: l_old_rel_rec.object_table_name = 'HZ_PARTIES')
3284: THEN
3285: l_test_security :=
3286: hz_dss_util_pub.test_instance(

Line 3283: l_old_rel_rec.object_table_name = 'HZ_PARTIES')

3279: -- profile before call test_instance.
3280: --
3281: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' AND
3282: (l_old_rel_rec.subject_table_name = 'HZ_PARTIES' OR
3283: l_old_rel_rec.object_table_name = 'HZ_PARTIES')
3284: THEN
3285: l_test_security :=
3286: hz_dss_util_pub.test_instance(
3287: p_operation_code => 'UPDATE',