APPS.IMC_BOOKMARK_PUB dependencies on HZ_PARTIES

Line 24: FROM hz_parties

20: BEGIN
21:
22: SELECT party_type
23: INTO l_category
24: FROM hz_parties
25: WHERE party_id = p_bookmarked_party_id;
26:
27: IF l_category = 'ORGANIZATION' THEN
28: RETURN G_CATEGORY_ORG;

Line 53: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

49: ) AS
50:
51: l_return_status VARCHAR2(1);
52: l_category varchar2(30);
53: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
54: l_bookmark_num NUMBER;
55: l_bookmark_limit NUMBER;
56: l_obj_version_no NUMBER;
57: BEGIN

Line 64: FROM hz_parties

60:
61: /* Get party name and category of user to be stored in HZ_PARTY_PREFERENCES */
62: SELECT party_name, party_type
63: INTO l_party_name, l_category
64: FROM hz_parties
65: WHERE party_id = p_bookmarked_party_id;
66:
67: IF l_category = 'ORGANIZATION' THEN
68: l_category := G_CATEGORY_ORG;

Line 192: /* hook up fnd_user.customer_id and hz_parties.party_id */

188: p_count => x_msg_count,
189: p_data => x_msg_data);
190: END IF;
191:
192: /* hook up fnd_user.customer_id and hz_parties.party_id */
193: fnd_user_pkg.updateuser(x_user_name=>l_user_name,
194: x_owner=>'SEED',
195: x_customer_id=>l_party_id);
196:

Line 353: FROM hz_parties

349:
350: /* Check if party id is valid */
351: SELECT party_id
352: INTO l_party_id
353: FROM hz_parties
354: WHERE party_id = p_party_id;
355:
356: IF p_bookmarked_party_type IS NOT NULL THEN
357:

Line 545: l_party_number hz_parties.party_number%TYPE;

541: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
542: l_msg_count NUMBER;
543: l_msg_data VARCHAR2(2000);
544: l_person_party_id NUMBER;
545: l_party_number hz_parties.party_number%TYPE;
546: l_person_profile_id NUMBER;
547: l_contact_point_id NUMBER;
548: l_generate_party_number VARCHAR2(1);
549:

Line 605: cpoint_rec.owner_table_name := 'HZ_PARTIES';

601: IS NOT NULL) THEN
602:
603: cpoint_rec.contact_point_type := 'EMAIL';
604: cpoint_rec.status := 'A';
605: cpoint_rec.owner_table_name := 'HZ_PARTIES';
606: cpoint_rec.owner_table_id := l_person_party_id;
607: cpoint_rec.primary_flag := 'Y';
608: email_rec.email_address := per_person_rec.email_address;
609: