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 442: -- l_person_name hz_person_profiles.person_name%TYPE;

438: FUNCTION do_create_person_name (
439: p_person_rec IN PERSON_REC_TYPE
440: ) RETURN VARCHAR2 IS
441:
442: -- l_person_name hz_person_profiles.person_name%TYPE;
443: l_person_name VARCHAR2(454); --Type Length changed as per bug #5227963
444: l_debug_prefix VARCHAR2(30) := '';
445:
446: BEGIN

Line 819: FROM hz_person_profiles

815: AND effective_end_date IS NULL;
816:
817: CURSOR c_per_profile_exists IS
818: SELECT 'Y'
819: FROM hz_person_profiles
820: WHERE party_id = p_party_id
821: AND actual_content_source = p_data_source_type
822: AND effective_end_date IS NULL;
823:

Line 914: UPDATE hz_person_profiles

910: END IF;
911:
912: IF p_party_type = 'PERSON' THEN
913:
914: UPDATE hz_person_profiles
915: SET actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
916: WHERE party_id = p_party_id
917: AND actual_content_source = G_SST_SOURCE_TYPE
918: AND effective_end_date IS NULL

Line 921: FROM hz_person_profiles

917: AND actual_content_source = G_SST_SOURCE_TYPE
918: AND effective_end_date IS NULL
919: AND NOT EXISTS (
920: SELECT 'Y'
921: FROM hz_person_profiles
922: WHERE party_id = p_party_id
923: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
924: AND effective_end_date IS NULL );
925:

Line 1256: * hz_person_profiles_pkg.Insert_Row

1252: * DESCRIPTION
1253: * Creates person profile.
1254: *
1255: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1256: * hz_person_profiles_pkg.Insert_Row
1257: *
1258: * ARGUMENTS
1259: * IN:
1260: * p_party_id

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

1299:
1300: -- Debug info.
1301: /*IF g_debug THEN
1302: hz_utility_v2pub.debug (
1303: 'hz_person_profiles_pkg.Insert_Row (+)', l_debug_prefix);
1304: END IF;
1305: */
1306:
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1304: END IF;
1305: */
1306:
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (+)',
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311:
1312: -- call table-handler.

Line 1313: HZ_person_profiles_pkg.Insert_Row (

1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311:
1312: -- call table-handler.
1313: HZ_person_profiles_pkg.Insert_Row (
1314: x_rowid => l_rowid,
1315: x_person_profile_id => l_person_profile_id,
1316: x_party_id => p_party_id,
1317: x_person_name => do_create_person_name(p_person_rec),

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

1388:
1389: -- Debug info.
1390: /*IF g_debug THEN
1391: hz_utility_v2pub.debug (
1392: 'hz_person_profiles_pkg.Insert_Row (-) ' ||
1393: 'x_profile_id = ' || x_profile_id, l_debug_prefix);
1394: END IF;
1395: */
1396:

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

1394: END IF;
1395: */
1396:
1397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1398: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (-) '||'x_profile_id = ' || x_profile_id,
1399: p_msg_level=>fnd_log.level_procedure);
1400: END IF;
1401:
1402: -- Debug info.

Line 1421: * hz_person_profiles_pkg.Update_Row

1417: * DESCRIPTION
1418: * Updates person profile.
1419: *
1420: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1421: * hz_person_profiles_pkg.Update_Row
1422: *
1423: * ARGUMENTS
1424: * IN:
1425: * p_data_source_type

Line 1449: l_person_name HZ_PERSON_PROFILES.PERSON_NAME%TYPE;

1445: l_rowid ROWID := NULL;
1446: l_person_profile_id NUMBER;
1447: l_effective_start_date DATE;
1448: l_object_version_number NUMBER;
1449: l_person_name HZ_PERSON_PROFILES.PERSON_NAME%TYPE;
1450: l_person_rec PERSON_REC_TYPE;
1451: l_version_number NUMBER;
1452:
1453: CURSOR c_person IS

Line 1456: FROM hz_person_profiles

1452:
1453: CURSOR c_person IS
1454: SELECT person_profile_id, rowid,object_version_number,
1455: version_number, effective_start_date
1456: FROM hz_person_profiles
1457: WHERE party_id = p_person_rec.party_rec.party_id
1458: AND actual_content_source = p_data_source_type
1459: AND effective_end_date is null
1460: FOR UPDATE NOWAIT;

Line 1516: UPDATE hz_person_profiles

1512: IF l_create_update_flag = 'C' THEN
1513: -- Always End date the existing profile and create a new profile
1514: l_version_number := nvl(l_version_number,1)+1;
1515:
1516: UPDATE hz_person_profiles
1517: SET effective_end_date = decode(trunc(effective_start_date),trunc(sysdate),trunc(sysdate),TRUNC (SYSDATE-1)),
1518: object_version_number = NVL(l_object_version_number, 1) + 1
1519: --,version_number = NVL(version_number,1)+1
1520: WHERE rowid = l_rowid;

Line 1553: UPDATE hz_person_profiles

1549: l_version_number := nvl(l_version_number,1)+1;
1550: END IF;
1551: /*
1552: IF TRUNC(l_effective_start_date) < TRUNC(SYSDATE) THEN
1553: UPDATE hz_person_profiles
1554: SET effective_end_date = TRUNC(SYSDATE-1),
1555: object_version_number = NVL(object_version_number, 1) + 1
1556: WHERE rowid = l_rowid;
1557:

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

1608: -- Debug info.
1609: /*IF g_debug THEN
1610: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
1611: hz_utility_v2pub.debug (
1612: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1613: END IF;
1614: */
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',

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

1612: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1613: END IF;
1614: */
1615: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1616: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',
1617: p_msg_level=>fnd_log.level_procedure);
1618: END IF;
1619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1620: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

Line 1626: HZ_person_profiles_pkg.Update_Row (

1622: p_msg_level=>fnd_log.level_statement);
1623: END IF;
1624:
1625: -- call table-handler.
1626: HZ_person_profiles_pkg.Update_Row (
1627: x_rowid => l_rowid,
1628: x_person_profile_id => x_profile_id,
1629: x_party_id => null,
1630: x_person_name => l_person_name,

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

1698:
1699: -- Debug info.
1700: /*IF g_debug THEN
1701: hz_utility_v2pub.debug (
1702: 'hz_person_profiles_pkg.Update_Row (-) ',
1703: l_debug_prefix);
1704: END IF;
1705: */
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1703: l_debug_prefix);
1704: END IF;
1705: */
1706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1707: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (-)',
1708: p_msg_level=>fnd_log.level_procedure);
1709:
1710: END IF;
1711:

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

1721:
1722: EXCEPTION
1723: WHEN g_resource_busy THEN
1724: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1725: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
1726: fnd_msg_pub.add;
1727: RAISE fnd_api.g_exc_error;
1728:
1729: END do_update_person_profile;

Line 3601: * be inserted into HZ_PERSON_PROFILES table.

3597: * Base Bug #2221071
3598: * 04-Mar-2003 Porkodi C o Bug 2794173, Default value will be assigned to deceased_flag
3599: * depending on the date_of_death value.
3600: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
3601: * be inserted into HZ_PERSON_PROFILES table.
3602: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
3603: * to the position of the decimal point, replace this with
3604: * the correct value from fnd_lookup_values provided that the
3605: * actual_content_source for this record is not 'USER_ENTERED'.

Line 3689: --be propagated into HZ_PERSON_PROFILES.

3685:
3686: --Bug Number 3099624.
3687: --If the profile option 'HZ_PROTECT_HR_PERSON_INFO' is set to 'Y',then ,sensitive
3688: --information like gender,marital status,date of birth and place of birth will not
3689: --be propagated into HZ_PERSON_PROFILES.
3690: IF (p_person_rec.party_rec.orig_system_reference LIKE 'PER%')
3691: AND
3692: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
3693: AND

Line 4185: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(

4181: END IF;
4182:
4183: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4184: -- populate function for integration service
4185: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4186: p_operation => 'I',
4187: p_person_profile_id => x_profile_id);
4188: END IF;
4189: ELSE

Line 4199: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(

4195: END IF;
4196:
4197: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4198: -- populate function for integration service
4199: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4200: p_operation => 'U',
4201: p_person_profile_id => x_profile_id);
4202: END IF;
4203: END IF;

Line 4317: * be updated into HZ_PERSON_PROFILES table.

4313: * Base Bug #2221071
4314: * 04-Mar-2003 Porkodi C o Bug 2794173, Default value will be assigned to deceased_flag
4315: * depending on the date_of_death value.
4316: * 26-Sep-2003 Rajib Ranjan Borah o Bug Number 3099624.Sensitive HR data will not
4317: * be updated into HZ_PERSON_PROFILES table.
4318: * 02-APR-2004 Rajib Ranjan Borah o Bug 3317806. If local_activity_code is invalid with respect
4319: * to the position of the decimal point, replace this with
4320: * the correct value from fnd_lookup_values provided that the
4321: * actual_content_source for this record is not 'USER_ENTERED'.

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

4418:
4419: --Bug Number 3099624.
4420: --If the profile option 'HZ_PROTECT_HR_PERSON_INFO' is set to 'Y',then ,sensitive
4421: --information like gender,marital status,date of birth and place of birth will not
4422: --be updated into HZ_PERSON_PROFILES and the old values will be retained for these
4423: --columns.
4424: IF (NVL(p_person_rec.party_rec.orig_system_reference,p_old_person_rec.party_rec.orig_system_reference) LIKE 'PER%')
4425: AND
4426: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')

Line 4791: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(

4787: END IF;
4788:
4789: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4790: -- populate function for integration service
4791: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4792: p_operation => 'U',
4793: p_person_profile_id => x_profile_id);
4794: END IF;
4795:

Line 4914: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,

4910: -- cache if mix-n-match is enabled
4911:
4912: -- IF g_per_mixnmatch_enabled IS NULL THEN
4913: HZ_MIXNM_UTILITY.LoadDataSources(
4914: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
4915: g_per_mixnmatch_enabled, g_per_selected_datasources);
4916: -- END IF;
4917:
4918: -- call to business logic.

Line 5301: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,

5297: -- cache if mix-n-match is enabled
5298:
5299: -- IF g_per_mixnmatch_enabled IS NULL THEN
5300: HZ_MIXNM_UTILITY.LoadDataSources(
5301: 'HZ_PERSON_PROFILES', g_per_entity_attr_id,
5302: g_per_mixnmatch_enabled, g_per_selected_datasources);
5303: -- END IF;
5304:
5305: -- Get old records. Will be used by business event system.

Line 7299: * hz_person_profiles_pkg.Select_Row

7295: * DESCRIPTION
7296: * Gets person record.
7297: *
7298: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
7299: * hz_person_profiles_pkg.Select_Row
7300: *
7301: * ARGUMENTS
7302: * IN:
7303: * p_init_msg_list Initialize message stack if it is set to

Line 7346: hz_person_profiles per1,

7342:
7343: CURSOR c_per_ue IS
7344: SELECT NVL(per2.person_profile_id,per1.person_profile_id)
7345: FROM
7346: hz_person_profiles per1,
7347: (SELECT person_profile_id, party_id
7348: FROM hz_person_profiles
7349: WHERE party_id = p_party_id
7350: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE

Line 7348: FROM hz_person_profiles

7344: SELECT NVL(per2.person_profile_id,per1.person_profile_id)
7345: FROM
7346: hz_person_profiles per1,
7347: (SELECT person_profile_id, party_id
7348: FROM hz_person_profiles
7349: WHERE party_id = p_party_id
7350: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
7351: AND effective_end_date IS NULL) per2
7352: WHERE per1.party_id = p_party_id

Line 7359: FROM hz_person_profiles

7355: AND per1.party_id = per2.party_id (+);
7356:
7357: CURSOR c_per IS
7358: SELECT person_profile_id
7359: FROM hz_person_profiles
7360: WHERE party_id = p_party_id
7361: AND actual_content_source = p_content_source_type
7362: AND effective_end_date IS NULL;
7363:

Line 7429: HZ_person_profiles_pkg.Select_Row (

7425: fnd_msg_pub.add;
7426: RAISE fnd_api.g_exc_error;
7427: END IF;
7428:
7429: HZ_person_profiles_pkg.Select_Row (
7430: x_person_profile_id => l_profile_id,
7431: x_party_id => l_party_id,
7432: x_attribute_category => x_person_rec.attribute_category,
7433: x_attribute1 => x_person_rec.attribute1,