APPS.HZ_MAP_PARTY_PUB dependencies on HZ_LOCATION_V2PUB

Line 63: p_location_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,

59: x_return_status IN OUT NOCOPY VARCHAR2
60: ) ;
61: -- Bug 3417357 : Added parameter p_create_new
62: procedure store_location(
63: p_location_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
64: p_party_id IN NUMBER,
65: p_create_new IN BOOLEAN,
66: x_return_status IN OUT NOCOPY VARCHAR2
67: );

Line 116: l_location_rec OUT NOCOPY hz_location_v2pub.location_rec_type

112:
113:
114: procedure do_assign_location_record(
115: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,
116: l_location_rec OUT NOCOPY hz_location_v2pub.location_rec_type
117: );
118:
119: procedure do_assign_credit_ratings(
120: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,

Line 1237: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;

1233:
1234: l_interface_rec HZ_PARTY_INTERFACE%ROWTYPE;
1235: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
1236: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1237: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1238:
1239: l_displayed_duns_party_id NUMBER := NULL;
1240: l_party_id NUMBER := NULL;
1241: l_original_party_id NUMBER;

Line 2306: l_location_rec hz_location_v2pub.location_rec_type;

2302: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
2303: x_return_status IN OUT NOCOPY VARCHAR2
2304: ) IS
2305: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
2306: l_location_rec hz_location_v2pub.location_rec_type;
2307: --l_credit_ratings_rec hz_party_info_pub.credit_ratings_rec_type;
2308: l_credit_ratings_rec hz_party_info_v2pub.credit_rating_rec_type;
2309: --l_fin_rep_rec hz_org_info_pub.financial_reports_rec_type;
2310: l_fin_rep_rec HZ_ORGANIZATION_INFO_V2PUB.financial_report_rec_type;

Line 2877: l_location_rec OUT NOCOPY hz_location_v2pub.location_rec_type

2873:
2874:
2875: procedure do_assign_location_record(
2876: p_interface_rec IN HZ_PARTY_INTERFACE%ROWTYPE,
2877: l_location_rec OUT NOCOPY hz_location_v2pub.location_rec_type
2878: ) IS
2879: BEGIN
2880:
2881: l_location_rec.ADDRESS1 := NVL(p_interface_rec.ADDRESS1, 'Not provided by DNB');

Line 4000: p_location_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,

3996: |
3997: +===========================================================================*/
3998:
3999: procedure store_location(
4000: p_location_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
4001: p_party_id IN NUMBER,
4002: p_create_new IN BOOLEAN,
4003: x_return_status IN OUT NOCOPY VARCHAR2
4004: ) IS

Line 4093: hz_location_v2pub.update_location(

4089: if(p_location_rec.address1 = 'Not provided by DNB') then
4090: p_location_rec.address1 := l_address1;
4091: end if;
4092:
4093: hz_location_v2pub.update_location(
4094: 'F',
4095: p_location_rec,
4096: l_object_version_number,
4097: x_return_status,

Line 4175: p_location_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,

4171: END store_location; /* update location or create party_site or (create location and party site). */
4172:
4173:
4174: procedure do_store_location(
4175: p_location_rec IN OUT NOCOPY hz_location_v2pub.location_rec_type,
4176: p_party_id IN NUMBER,
4177: p_old_party_site_id IN NUMBER,
4178: p_create_new IN BOOLEAN,
4179: x_return_status IN OUT NOCOPY VARCHAR2

Line 4195: hz_location_v2pub.create_location(

4191: IF p_create_new = TRUE THEN
4192: p_location_rec.application_id := 222;
4193: p_location_rec.created_by_module := 'TCA_DNB_MAPPING';
4194: /* Bug Fix : 2770991 */
4195: hz_location_v2pub.create_location(
4196: 'F',
4197: p_location_rec,
4198: l_location_id,
4199: x_return_status,

Line 4242: hz_location_v2pub.create_location(

4238:
4239: p_location_rec.application_id := 222;
4240: p_location_rec.created_by_module := 'TCA_DNB_MAPPING';
4241: /* Bug Fix : 2770991 */
4242: hz_location_v2pub.create_location(
4243: 'F',
4244: p_location_rec,
4245: l_location_id,
4246: x_return_status,

Line 6112: l_location_rec hz_location_v2pub.location_rec_type;

6108: AND rownum = 1;
6109:
6110:
6111: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
6112: l_location_rec hz_location_v2pub.location_rec_type;
6113: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
6114: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
6115: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
6116: