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_REGISTRY_VALIDATE_V2PUB dependencies on HZ_PARTY_V2PUB

Line 56: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

52: );
53:
54: --Bug Number 3099624.
55: PROCEDURE validate_hr_security(
56: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
57: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
58: x_return_status IN OUT NOCOPY VARCHAR2
59: );
60:

Line 57: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

53:
54: --Bug Number 3099624.
55: PROCEDURE validate_hr_security(
56: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
57: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
58: x_return_status IN OUT NOCOPY VARCHAR2
59: );
60:
61: -- Bug 3175816

Line 1709: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type

1705: -- validate content_source_type
1706: --------------------------------------
1707:
1708: -- do not need to check content_source_type is mandatory because
1709: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type
1710: -- in table handler.
1711:
1712: -- content_source_type is non-updateable
1713: IF p_create_update_flag = 'U' THEN

Line 1732: hz_party_v2pub.g_miss_content_source_type

1728:
1729: -- content_source_type is lookup code in lookup type CONTENT_SOURCE_TYPE
1730: IF p_create_update_flag = 'C' AND
1731: p_contact_point_rec.content_source_type <>
1732: hz_party_v2pub.g_miss_content_source_type
1733: THEN
1734: validate_lookup (
1735: p_column => 'content_source_type',
1736: p_lookup_type => 'CONTENT_SOURCE_TYPE',

Line 2910: p_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,

2906: */
2907:
2908: PROCEDURE validate_party(
2909: p_create_update_flag IN VARCHAR2,
2910: p_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,
2911: p_old_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,
2912: p_db_created_by_module IN VARCHAR2,
2913: x_return_status IN OUT NOCOPY VARCHAR2
2914: ) IS

Line 2911: p_old_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,

2907:
2908: PROCEDURE validate_party(
2909: p_create_update_flag IN VARCHAR2,
2910: p_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,
2911: p_old_party_rec IN HZ_PARTY_V2PUB.PARTY_REC_TYPE,
2912: p_db_created_by_module IN VARCHAR2,
2913: x_return_status IN OUT NOCOPY VARCHAR2
2914: ) IS
2915:

Line 3223: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3219: */
3220:
3221: PROCEDURE validate_person(
3222: p_create_update_flag IN VARCHAR2,
3223: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3224: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3225: x_return_status IN OUT NOCOPY VARCHAR2
3226: ) IS
3227:

Line 3224: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3220:
3221: PROCEDURE validate_person(
3222: p_create_update_flag IN VARCHAR2,
3223: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3224: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3225: x_return_status IN OUT NOCOPY VARCHAR2
3226: ) IS
3227:
3228: l_debug_prefix VARCHAR2(30) := '';

Line 3602: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type

3598: -- validate content_source_type
3599: ----------------------------------------------
3600:
3601: -- do not need to check content_source_type is mandatory because
3602: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type
3603: -- in table handler.
3604:
3605: -- since we are selecting person_profile_id from hz_person_profiles
3606: -- for record having content_source_type of p_person_rec.content_source_type,

Line 3815: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3811: *
3812: */
3813:
3814: PROCEDURE validate_hr_security(
3815: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3816: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3817: x_return_status IN OUT NOCOPY VARCHAR2
3818: ) IS
3819:

Line 3816: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,

3812: */
3813:
3814: PROCEDURE validate_hr_security(
3815: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3816: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
3817: x_return_status IN OUT NOCOPY VARCHAR2
3818: ) IS
3819:
3820: cols_updated VARCHAR2(300) := '';

Line 4048: p_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,

4044: */
4045:
4046: PROCEDURE validate_group(
4047: p_create_update_flag IN VARCHAR2,
4048: p_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,
4049: p_old_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,
4050: x_return_status IN OUT NOCOPY VARCHAR2
4051: ) IS
4052:

Line 4049: p_old_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,

4045:
4046: PROCEDURE validate_group(
4047: p_create_update_flag IN VARCHAR2,
4048: p_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,
4049: p_old_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE,
4050: x_return_status IN OUT NOCOPY VARCHAR2
4051: ) IS
4052:
4053: l_debug_prefix VARCHAR2(30) := '';

Line 4192: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4188: */
4189:
4190: PROCEDURE validate_organization(
4191: p_create_update_flag IN VARCHAR2,
4192: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4193: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4194: x_return_status IN OUT NOCOPY VARCHAR2
4195: ) IS
4196:

Line 4193: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

4189:
4190: PROCEDURE validate_organization(
4191: p_create_update_flag IN VARCHAR2,
4192: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4193: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
4194: x_return_status IN OUT NOCOPY VARCHAR2
4195: ) IS
4196:
4197: l_dummy VARCHAR2(1);

Line 5086: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type

5082: -- validate content_source_type
5083: -------------------------------
5084:
5085: -- do not need to check content_source_type is mandatory because
5086: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type
5087: -- in table handler.
5088:
5089: -- since we are selecting person_profile_id from hz_organization_profiles
5090: -- for record having content_source_type of p_organization_rec.content_source_type,

Line 5635: p_organization_rec.actual_content_source <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE

5631: p_organization_rec.principal_name IS NOT NULL ) AND
5632: /*p_organization_rec.actual_content_source = 'DNB' AND
5633: NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'*/
5634: /* HZ_UTILITY_V2PUB.is_purchased_content_source(p_organization_rec.actual_content_source) = 'Y' AND
5635: p_organization_rec.actual_content_source <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
5636: THEN
5637: l_return_status := FND_API.G_RET_STS_SUCCESS;
5638:
5639: validate_nonupdateable (

Line 11195: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type

11191: -- validate content_source_type
11192: -------------------------------
11193:
11194: -- we do not need to check 'content_source_type is mandatory' because
11195: -- we default content_source_type to hz_party_v2pub.g_miss_content_source_type
11196: -- in table handler.
11197:
11198: -- content_source_type is non-updateable
11199: IF p_create_update_flag = 'U' THEN

Line 14244: -- hz_party_v2pub.g_miss_content_source_type in the table handler.

14240: ----------------------------------------------
14241:
14242: -- do not need to chack content_source_type is mandatory because
14243: -- we default content_source_type to
14244: -- hz_party_v2pub.g_miss_content_source_type in the table handler.
14245:
14246: -- content_source_type is non-updateable
14247: IF p_create_update_flag = 'U' THEN
14248: validate_nonupdateable (

Line 14936: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

14932: END validate_email_contact_point;
14933:
14934: PROCEDURE validate_org_nonsupport_column (
14935: p_create_update_flag IN VARCHAR2,
14936: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
14937: x_return_status IN OUT NOCOPY VARCHAR2
14938: ) IS
14939: l_debug_prefix VARCHAR2(30) := '';
14940: BEGIN

Line 17352: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =

17348: WHERE hc.party_id = p_party_id
17349: AND trunc(nvl(hc.rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY'))) =
17350: trunc(nvl(p_rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY')))
17351: AND nvl(hc.rating_organization, 'XXX') = nvl(p_rating_organization, 'XXX')
17352: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =
17353: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17354:
17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;

Line 17353: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);

17349: AND trunc(nvl(hc.rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY'))) =
17350: trunc(nvl(p_rated_as_of_date, to_date('12/31/4712','MM/DD/YYYY')))
17351: AND nvl(hc.rating_organization, 'XXX') = nvl(p_rating_organization, 'XXX')
17352: AND nvl(hc.actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE) =
17353: nvl(p_actual_content_source, hz_party_v2pub.G_MISS_CONTENT_SOURCE_TYPE);
17354:
17355: l_credit_rating_id hz_credit_ratings.credit_rating_id%TYPE;
17356: l_party_id hz_credit_ratings.party_id%TYPE;
17357: l_rating_organization hz_credit_ratings.rating_organization%TYPE;