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_PARTY_V2PUB dependencies on HZ_PERSON_PROFILES

Line 449: -- l_person_name hz_person_profiles.person_name%TYPE;

445: FUNCTION do_create_person_name (
446: p_person_rec IN PERSON_REC_TYPE
447: ) RETURN VARCHAR2 IS
448:
449: -- l_person_name hz_person_profiles.person_name%TYPE;
450: l_person_name VARCHAR2(454); --Type Length changed as per bug #5227963
451: l_debug_prefix VARCHAR2(30) := '';
452:
453: BEGIN

Line 826: FROM hz_person_profiles

822: AND effective_end_date IS NULL;
823:
824: CURSOR c_per_profile_exists IS
825: SELECT 'Y'
826: FROM hz_person_profiles
827: WHERE party_id = p_party_id
828: AND actual_content_source = p_data_source_type
829: AND effective_end_date IS NULL;
830:

Line 921: UPDATE hz_person_profiles

917: END IF;
918:
919: IF p_party_type = 'PERSON' THEN
920:
921: UPDATE hz_person_profiles
922: SET actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
923: WHERE party_id = p_party_id
924: AND actual_content_source = G_SST_SOURCE_TYPE
925: AND effective_end_date IS NULL

Line 928: FROM hz_person_profiles

924: AND actual_content_source = G_SST_SOURCE_TYPE
925: AND effective_end_date IS NULL
926: AND NOT EXISTS (
927: SELECT 'Y'
928: FROM hz_person_profiles
929: WHERE party_id = p_party_id
930: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
931: AND effective_end_date IS NULL );
932:

Line 1263: * hz_person_profiles_pkg.Insert_Row

1259: * DESCRIPTION
1260: * Creates person profile.
1261: *
1262: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1263: * hz_person_profiles_pkg.Insert_Row
1264: *
1265: * ARGUMENTS
1266: * IN:
1267: * p_party_id

Line 1310: 'hz_person_profiles_pkg.Insert_Row (+)', l_debug_prefix);

1306:
1307: -- Debug info.
1308: /*IF g_debug THEN
1309: hz_utility_v2pub.debug (
1310: 'hz_person_profiles_pkg.Insert_Row (+)', l_debug_prefix);
1311: END IF;
1312: */
1313:
1314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1315: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (+)',

1311: END IF;
1312: */
1313:
1314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1315: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (+)',
1316: p_msg_level=>fnd_log.level_procedure);
1317: END IF;
1318:
1319: -- call table-handler.

Line 1320: HZ_person_profiles_pkg.Insert_Row (

1316: p_msg_level=>fnd_log.level_procedure);
1317: END IF;
1318:
1319: -- call table-handler.
1320: HZ_person_profiles_pkg.Insert_Row (
1321: x_rowid => l_rowid,
1322: x_person_profile_id => l_person_profile_id,
1323: x_party_id => p_party_id,
1324: x_person_name => do_create_person_name(p_person_rec),

Line 1399: 'hz_person_profiles_pkg.Insert_Row (-) ' ||

1395:
1396: -- Debug info.
1397: /*IF g_debug THEN
1398: hz_utility_v2pub.debug (
1399: 'hz_person_profiles_pkg.Insert_Row (-) ' ||
1400: 'x_profile_id = ' || x_profile_id, l_debug_prefix);
1401: END IF;
1402: */
1403:

Line 1405: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (-) '||'x_profile_id = ' || x_profile_id,

1401: END IF;
1402: */
1403:
1404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1405: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (-) '||'x_profile_id = ' || x_profile_id,
1406: p_msg_level=>fnd_log.level_procedure);
1407: END IF;
1408:
1409: -- Debug info.

Line 1428: * hz_person_profiles_pkg.Update_Row

1424: * DESCRIPTION
1425: * Updates person profile.
1426: *
1427: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1428: * hz_person_profiles_pkg.Update_Row
1429: *
1430: * ARGUMENTS
1431: * IN:
1432: * p_data_source_type

Line 1456: l_person_name HZ_PERSON_PROFILES.PERSON_NAME%TYPE;

1452: l_rowid ROWID := NULL;
1453: l_person_profile_id NUMBER;
1454: l_effective_start_date DATE;
1455: l_object_version_number NUMBER;
1456: l_person_name HZ_PERSON_PROFILES.PERSON_NAME%TYPE;
1457: l_person_rec PERSON_REC_TYPE;
1458: l_version_number NUMBER;
1459:
1460: CURSOR c_person IS

Line 1463: FROM hz_person_profiles

1459:
1460: CURSOR c_person IS
1461: SELECT person_profile_id, rowid,object_version_number,
1462: version_number, effective_start_date
1463: FROM hz_person_profiles
1464: WHERE party_id = p_person_rec.party_rec.party_id
1465: AND actual_content_source = p_data_source_type
1466: AND effective_end_date is null
1467: FOR UPDATE NOWAIT;

Line 1523: UPDATE hz_person_profiles

1519: IF l_create_update_flag = 'C' THEN
1520: -- Always End date the existing profile and create a new profile
1521: l_version_number := nvl(l_version_number,1)+1;
1522:
1523: UPDATE hz_person_profiles
1524: SET effective_end_date = decode(trunc(effective_start_date),trunc(sysdate),trunc(sysdate),TRUNC (SYSDATE-1)),
1525: object_version_number = NVL(l_object_version_number, 1) + 1
1526: --,version_number = NVL(version_number,1)+1
1527: WHERE rowid = l_rowid;

Line 1560: UPDATE hz_person_profiles

1556: l_version_number := nvl(l_version_number,1)+1;
1557: END IF;
1558: /*
1559: IF TRUNC(l_effective_start_date) < TRUNC(SYSDATE) THEN
1560: UPDATE hz_person_profiles
1561: SET effective_end_date = TRUNC(SYSDATE-1),
1562: object_version_number = NVL(object_version_number, 1) + 1
1563: WHERE rowid = l_rowid;
1564:

Line 1619: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);

1615: -- Debug info.
1616: /*IF g_debug THEN
1617: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
1618: hz_utility_v2pub.debug (
1619: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1620: END IF;
1621: */
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',

Line 1623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',

1619: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1620: END IF;
1621: */
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',
1624: p_msg_level=>fnd_log.level_procedure);
1625: END IF;
1626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1627: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

Line 1633: HZ_person_profiles_pkg.Update_Row (

1629: p_msg_level=>fnd_log.level_statement);
1630: END IF;
1631:
1632: -- call table-handler.
1633: HZ_person_profiles_pkg.Update_Row (
1634: x_rowid => l_rowid,
1635: x_person_profile_id => x_profile_id,
1636: x_party_id => null,
1637: x_person_name => l_person_name,

Line 1709: 'hz_person_profiles_pkg.Update_Row (-) ',

1705:
1706: -- Debug info.
1707: /*IF g_debug THEN
1708: hz_utility_v2pub.debug (
1709: 'hz_person_profiles_pkg.Update_Row (-) ',
1710: l_debug_prefix);
1711: END IF;
1712: */
1713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1714: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (-)',

1710: l_debug_prefix);
1711: END IF;
1712: */
1713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1714: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (-)',
1715: p_msg_level=>fnd_log.level_procedure);
1716:
1717: END IF;
1718:

Line 1732: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');

1728:
1729: EXCEPTION
1730: WHEN g_resource_busy THEN
1731: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1732: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1733: fnd_msg_pub.add;
1734: RAISE fnd_api.g_exc_error;
1735:
1736: END do_update_person_profile;

Line 3652: * be inserted into HZ_PERSON_PROFILES table.

3648: * Base Bug #2221071
3649: * 04-Mar-2003 Porkodi C o Bug 2794173, Default value will be assigned to deceased_flag
3650: * depending on the date_of_death value.
3651: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
3652: * be inserted into HZ_PERSON_PROFILES table.
3653: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
3654: * to the position of the decimal point, replace this with
3655: * the correct value from fnd_lookup_values provided that the
3656: * actual_content_source for this record is not 'USER_ENTERED'.

Line 3743: --be propagated into HZ_PERSON_PROFILES.

3739:
3740: --Bug Number 3099624.
3741: --If the profile option 'HZ_PROTECT_HR_PERSON_INFO' is set to 'Y',then ,sensitive
3742: --information like gender,marital status,date of birth and place of birth will not
3743: --be propagated into HZ_PERSON_PROFILES.
3744: IF (p_person_rec.party_rec.orig_system_reference LIKE 'PER%')
3745: AND
3746: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
3747: AND

Line 4244: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(

4240: END IF;
4241:
4242: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4243: -- populate function for integration service
4244: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4245: p_operation => 'I',
4246: p_person_profile_id => x_profile_id);
4247: END IF;
4248: ELSE

Line 4258: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(

4254: END IF;
4255:
4256: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4257: -- populate function for integration service
4258: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4259: p_operation => 'U',
4260: p_person_profile_id => x_profile_id);
4261: END IF;
4262: END IF;

Line 4376: * be updated into HZ_PERSON_PROFILES table.

4372: * Base Bug #2221071
4373: * 04-Mar-2003 Porkodi C o Bug 2794173, Default value will be assigned to deceased_flag
4374: * depending on the date_of_death value.
4375: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
4376: * be updated into HZ_PERSON_PROFILES table.
4377: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
4378: * to the position of the decimal point, replace this with
4379: * the correct value from fnd_lookup_values provided that the
4380: * actual_content_source for this record is not 'USER_ENTERED'.

Line 4481: --be updated into HZ_PERSON_PROFILES and the old values will be retained for these

4477:
4478: --Bug Number 3099624.
4479: --If the profile option 'HZ_PROTECT_HR_PERSON_INFO' is set to 'Y',then ,sensitive
4480: --information like gender,marital status,date of birth and place of birth will not
4481: --be updated into HZ_PERSON_PROFILES and the old values will be retained for these
4482: --columns.
4483: IF (NVL(p_person_rec.party_rec.orig_system_reference,p_old_person_rec.party_rec.orig_system_reference) LIKE 'PER%')
4484: AND
4485: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')

Line 4851: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(

4847: END IF;
4848:
4849: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4850: -- populate function for integration service
4851: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4852: p_operation => 'U',
4853: p_person_profile_id => x_profile_id);
4854: END IF;
4855:

Line 4974: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,

4970: -- cache if mix-n-match is enabled
4971:
4972: -- IF g_per_mixnmatch_enabled IS NULL THEN
4973: HZ_MIXNM_UTILITY.LoadDataSources(
4974: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
4975: g_per_mixnmatch_enabled, g_per_selected_datasources);
4976: -- END IF;
4977:
4978: -- call to business logic.

Line 5372: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,

5368: -- cache if mix-n-match is enabled
5369:
5370: -- IF g_per_mixnmatch_enabled IS NULL THEN
5371: HZ_MIXNM_UTILITY.LoadDataSources(
5372: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
5373: g_per_mixnmatch_enabled, g_per_selected_datasources);
5374: -- END IF;
5375:
5376: -- Get old records. Will be used by business event system.

Line 7411: * hz_person_profiles_pkg.Select_Row

7407: * DESCRIPTION
7408: * Gets person record.
7409: *
7410: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
7411: * hz_person_profiles_pkg.Select_Row
7412: *
7413: * ARGUMENTS
7414: * IN:
7415: * p_init_msg_list Initialize message stack if it is set to

Line 7458: hz_person_profiles per1,

7454:
7455: CURSOR c_per_ue IS
7456: SELECT NVL(per2.person_profile_id,per1.person_profile_id)
7457: FROM
7458: hz_person_profiles per1,
7459: (SELECT person_profile_id, party_id
7460: FROM hz_person_profiles
7461: WHERE party_id = p_party_id
7462: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE

Line 7460: FROM hz_person_profiles

7456: SELECT NVL(per2.person_profile_id,per1.person_profile_id)
7457: FROM
7458: hz_person_profiles per1,
7459: (SELECT person_profile_id, party_id
7460: FROM hz_person_profiles
7461: WHERE party_id = p_party_id
7462: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
7463: AND effective_end_date IS NULL) per2
7464: WHERE per1.party_id = p_party_id

Line 7471: FROM hz_person_profiles

7467: AND per1.party_id = per2.party_id (+);
7468:
7469: CURSOR c_per IS
7470: SELECT person_profile_id
7471: FROM hz_person_profiles
7472: WHERE party_id = p_party_id
7473: AND actual_content_source = p_content_source_type
7474: AND effective_end_date IS NULL;
7475:

Line 7541: HZ_person_profiles_pkg.Select_Row (

7537: fnd_msg_pub.add;
7538: RAISE fnd_api.g_exc_error;
7539: END IF;
7540:
7541: HZ_person_profiles_pkg.Select_Row (
7542: x_person_profile_id => l_profile_id,
7543: x_party_id => l_party_id,
7544: x_attribute_category => x_person_rec.attribute_category,
7545: x_attribute1 => x_person_rec.attribute1,