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_MAP_PARTY_PUB dependencies on HZ_ORGANIZATION_PROFILES

Line 1011: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

1007: system.ad_apps_private.get_apps_schema_name(
1008: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
1009:
1010: --Add policy functions
1011: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1012: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1013:
1014: /* SSM SST Integration and Extension
1015: * Policy functions will not be added to non-profile entities as the concept of

Line 1298: -- isMixNMatchEnabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES', l_mixnmatch_global_id);

1294: if l_user_data_creation_rule_id is not null then
1295: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',null);
1296: end if;
1297:
1298: -- isMixNMatchEnabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES', l_mixnmatch_global_id);
1299: -- arp_util.debug('isMixNMatchEnabled=' || isMixNMatchEnabled);
1300:
1301: arp_util.debug('HZ_MAP_PARTY_PUB.MAP (+) ');
1302:

Line 1443: FROM hz_organization_profiles

1439: --DUNS might have changed over time.
1440:
1441: BEGIN
1442: SELECT 'Y' INTO l_exist
1443: FROM hz_organization_profiles
1444: -- Bug 4956756 : use DUNS_NUMBER_C
1445: WHERE DUNS_NUMBER_C = lpad(to_char(l_interface_rec.DUNS_NUMBER), 9, '0')
1446: AND actual_content_source = l_interface_rec.content_source_type
1447: AND (SYSDATE BETWEEN effective_start_date

Line 1497: FROM hz_organization_profiles

1493: BEGIN
1494:
1495: SELECT displayed_duns_party_id
1496: INTO l_displayed_duns_party_id
1497: FROM hz_organization_profiles
1498: WHERE party_id = l_original_party_id
1499: AND actual_content_source = l_interface_rec.content_source_type
1500: AND (SYSDATE BETWEEN effective_start_date
1501: AND NVL(effective_end_date, to_date('12/31/4712','MM/DD/YYYY')));

Line 1511: FROM hz_organization_profiles

1507:
1508: IF l_displayed_duns_party_id IS NOT NULL THEN
1509:
1510: SELECT duns_number_c INTO l_duns_number
1511: FROM hz_organization_profiles
1512: WHERE party_id = l_displayed_duns_party_id
1513: AND actual_content_source = l_interface_rec.content_source_type
1514: AND (SYSDATE BETWEEN effective_start_date
1515: AND NVL(effective_end_date, to_date('12/31/4712','MM/DD/YYYY')));

Line 1552: FROM hz_organization_profiles

1548: --as there may be multiple such parties.
1549:
1550: SELECT party_id
1551: INTO l_displayed_duns_party_id
1552: FROM hz_organization_profiles
1553: -- Bug 4956756 : use DUNS_NUMBER_C
1554: WHERE DUNS_NUMBER_C = lpad(to_char(l_interface_rec.DUNS_NUMBER), 9, '0')
1555: AND actual_content_source = l_interface_rec.content_source_type
1556: AND ( SYSDATE BETWEEN effective_start_date

Line 1560: FROM hz_organization_profiles

1556: AND ( SYSDATE BETWEEN effective_start_date
1557: AND NVL(effective_end_date, to_date('12/31/4712','MM/DD/YYYY')))
1558: AND last_update_date = (
1559: SELECT max(last_update_date)
1560: FROM hz_organization_profiles
1561: -- Bug 4956756 : use DUNS_NUMBER_C
1562: WHERE DUNS_NUMBER_C = lpad(to_char(l_interface_rec.DUNS_NUMBER), 9, '0')
1563: AND actual_content_source = l_interface_rec.content_source_type
1564: AND (SYSDATE BETWEEN effective_start_date

Line 1870: FROM -- hz_organization_profiles org_pro,

1866: hosr.start_date_active,
1867: hosr.orig_system,
1868: hosr.orig_system_reference,
1869: hosr.owner_table_name
1870: FROM -- hz_organization_profiles org_pro,
1871: hz_orig_sys_references hosr
1872: WHERE -- nvl(org_pro.party_id, '-999') = hosr.owner_table_id AND
1873: hosr.orig_system = 'DNB'
1874: AND hosr.owner_table_name = 'HZ_PARTIES'

Line 2084: --hz_organization_profiles org_pro,

2080: hosr.orig_system_reference,
2081: hosr.owner_table_name,
2082: hosr.owner_table_id
2083: FROM
2084: --hz_organization_profiles org_pro,
2085: hz_orig_sys_references hosr
2086: WHERE
2087: --nvl(org_pro.party_id, '-999') = hosr.owner_table_id AND
2088: hosr.orig_system = 'DNB'

Line 3275: FROM hz_organization_profiles

3271:
3272: BEGIN
3273:
3274: SELECT 'Y' INTO l_ue_exist
3275: FROM hz_organization_profiles
3276: WHERE party_id = p_organization_rec.party_rec.party_id
3277: AND actual_content_source = HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
3278: AND effective_end_date is null
3279: AND ROWNUM = 1;

Line 3289: FROM hz_organization_profiles

3285:
3286: BEGIN
3287:
3288: SELECT 'Y' INTO l_exist
3289: FROM hz_organization_profiles
3290: WHERE party_id = p_organization_rec.party_rec.party_id
3291: AND actual_content_source = p_organization_rec.ACTUAL_CONTENT_SOURCE
3292: AND effective_end_date is null
3293: AND ROWNUM = 1;

Line 3364: UPDATE hz_organization_profiles

3360: IF l_ue_exist = 'N' THEN
3361:
3362: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG: party does not exist: update DNB and USER_ENTERED displayed_duns_party_id');
3363:
3364: UPDATE hz_organization_profiles
3365: SET displayed_duns_party_id = p_organization_rec.party_rec.party_id
3366: WHERE party_id = p_organization_rec.party_rec.party_id AND
3367: effective_end_date is null;
3368: ELSE

Line 3370: UPDATE hz_organization_profiles

3366: WHERE party_id = p_organization_rec.party_rec.party_id AND
3367: effective_end_date is null;
3368: ELSE
3369: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG: party does not exist: update DNB displayed_duns_party_id');
3370: UPDATE hz_organization_profiles
3371: SET displayed_duns_party_id = p_organization_rec.party_rec.party_id
3372: WHERE party_id = p_organization_rec.party_rec.party_id AND
3373: actual_content_source = p_organization_rec.ACTUAL_CONTENT_SOURCE AND
3374: effective_end_date is null;

Line 4016: l_duns_number_c hz_organization_profiles.duns_number_c%type;

4012: -- Bug 2882305 : Local variable to store address1
4013:
4014: l_address1 VARCHAR2(240);
4015: --4227564
4016: l_duns_number_c hz_organization_profiles.duns_number_c%type;
4017: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
4018: l_count NUMBER;
4019: l_orig_sys_ref_id NUMBER;
4020: BEGIN

Line 4307: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;

4303: l_mosr_mapping_exist VARCHAR2(1);
4304: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
4305: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
4306: l_count NUMBER;
4307: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;
4308:
4309: CURSOR check_party_site_mosr_mapping (p_orig_system IN VARCHAR2,
4310: p_orig_system_ref IN VARCHAR2,
4311: p_owner_table_name IN VARCHAR2)

Line 4438: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;

4434: l_contact_point_id NUMBER;
4435: l_create BOOLEAN := FALSE;
4436: l_count NUMBER;
4437: l_orig_system_reference hz_orig_sys_references.orig_system_reference%TYPE;
4438: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;
4439: --4227564
4440: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
4441: l_orig_sys_ref_id NUMBER;
4442:

Line 6100: FROM hz_organization_profiles org, hz_orig_sys_references ssm

6096: -- to find active profile for related party.
6097:
6098: CURSOR c1 IS
6099: SELECT org.party_id
6100: FROM hz_organization_profiles org, hz_orig_sys_references ssm
6101: WHERE org.duns_number_c = lpad(to_char(p_related_duns_rec.DUNS_NUMBER),9,'0')
6102: AND org.actual_content_source = p_related_duns_rec.content_source_type
6103: AND org.effective_end_date is NULL
6104: AND org.party_id = ssm.owner_table_id

Line 6179: FROM hz_organization_profiles

6175: x_conform_party_id := l_party_rel_rec.subject_id ;
6176: ELSE
6177:
6178: SELECT COUNT(*) INTO l_count
6179: FROM hz_organization_profiles
6180: WHERE duns_number_c = lpad(to_char(p_related_duns_rec.DUNS_NUMBER),9,'0')
6181: AND actual_content_source = p_related_duns_rec.content_source_type
6182: AND (SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, to_date('12/31/4712','MM/DD/YYYY')));
6183:

Line 6238: UPDATE hz_organization_profiles

6234: --
6235:
6236: --arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG: party does not exist: update displayed_duns_party_id');
6237:
6238: UPDATE hz_organization_profiles
6239: SET displayed_duns_party_id = l_organization_rec.party_rec.party_id
6240: WHERE organization_profile_id = l_organization_profile_id;
6241:
6242: -- party_id = l_organization_rec.party_rec.party_id AND

Line 6416: l_old_duns_number hz_organization_profiles.duns_number_c%TYPE;

6412:
6413: l_old_rel_ids l_old_rel_id_table;
6414: l_old_sub_ids l_old_sub_id_table;
6415:
6416: l_old_duns_number hz_organization_profiles.duns_number_c%TYPE;
6417: l_new_duns_number hz_organization_profiles.duns_number_c%TYPE;
6418: l_old_subject_id NUMBER;
6419:
6420: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

Line 6417: l_new_duns_number hz_organization_profiles.duns_number_c%TYPE;

6413: l_old_rel_ids l_old_rel_id_table;
6414: l_old_sub_ids l_old_sub_id_table;
6415:
6416: l_old_duns_number hz_organization_profiles.duns_number_c%TYPE;
6417: l_new_duns_number hz_organization_profiles.duns_number_c%TYPE;
6418: l_old_subject_id NUMBER;
6419:
6420: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
6421: l_create_rel BOOLEAN := TRUE;

Line 6527: FROM hz_organization_profiles o

6523: l_old_subject_id := l_old_sub_ids(i);
6524:
6525: --Find the old duns number
6526: SELECT duns_number_c INTO l_old_duns_number
6527: FROM hz_organization_profiles o
6528: WHERE o.party_id = l_old_subject_id
6529: AND o.effective_end_date IS NULL
6530: AND o.actual_content_source = p_party_rel_rec.actual_content_source;
6531:

Line 6534: FROM hz_organization_profiles o

6530: AND o.actual_content_source = p_party_rel_rec.actual_content_source;
6531:
6532: --Find the new duns number
6533: SELECT duns_number_c INTO l_new_duns_number
6534: FROM hz_organization_profiles o
6535: WHERE o.party_id = p_party_rel_rec.subject_id
6536: AND o.effective_end_date IS NULL
6537: AND o.actual_content_source = p_party_rel_rec.actual_content_source;
6538:

Line 6726: UPDATE hz_organization_profiles

6722: BEGIN
6723:
6724: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_BUSINESS_REPORT(+) ');
6725:
6726: UPDATE hz_organization_profiles
6727: SET business_report = p_business_report
6728: WHERE organization_profile_id = p_organization_profile_id;
6729:
6730: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_BUSINESS_REPORT(-) ');