APPS.IBE_PARTY_V2PVT dependencies on HZ_PARTIES

Line 26: | - Link the fnd_user table and hz_parties table by setting

22: | - Creates Contact Points
23: | - Creates Preferences
24: | - Create an apps username/password combination in FND_USER table.
25: |
26: | - Link the fnd_user table and hz_parties table by setting
27: | the customer_id column in fnd_user table.
28: | REFERENCED APIS
29: | This API calls the following APIs
30: | - Create_Person

Line 256: | - Link the fnd_user table and hz_parties table by setting

252: | - Record the organizations location and contact points
253: | - Register the user as an org contact for the organization
254: | - Create an apps username/password combination in FND_USER table.
255: |
256: | - Link the fnd_user table and hz_parties table by setting
257: | the customer_id column in fnd_user table as the relationship_party_id.
258: |
259: | REFERENCED APIS
260: | This API calls the following APIs

Line 297: p_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;

293: l_contact_preference_id NUMBER;
294: l_party_site_id NUMBER;
295:
296:
297: p_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
298: p_org_num HZ_PARTIES.PARTY_NUMBER%TYPE := null;
299: l_account_id NUMBER;
300: --p_party_rec HZ_PARTY_V2PUB.party_rec_type;
301: BEGIN

Line 298: p_org_num HZ_PARTIES.PARTY_NUMBER%TYPE := null;

294: l_party_site_id NUMBER;
295:
296:
297: p_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
298: p_org_num HZ_PARTIES.PARTY_NUMBER%TYPE := null;
299: l_account_id NUMBER;
300: --p_party_rec HZ_PARTY_V2PUB.party_rec_type;
301: BEGIN
302: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 625: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

621: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
622: l_org_contact_party_id NUMBER;
623: l_rel_id NUMBER;
624: l_account_id NUMBER;
625: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
626: l_rel_party_id NUMBER; ---party_id of type party_relationship
627: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
628: BEGIN
629: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 678: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';

674: -- Pass person_party_id as subject_id
675:
676: l_party_rel_rec.subject_id := x_person_party_id;
677: l_party_rel_rec.subject_type := 'PERSON';
678: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
679:
680: -- pass organization_party_id as object_id
681: l_party_rel_rec.object_id := p_org_party_id;
682: l_party_rel_rec.object_type := 'ORGANIZATION';

Line 683: l_party_rel_rec.object_table_name := 'HZ_PARTIES';

679:
680: -- pass organization_party_id as object_id
681: l_party_rel_rec.object_id := p_org_party_id;
682: l_party_rel_rec.object_type := 'ORGANIZATION';
683: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
684:
685:
686:
687: if (p_relationship_type = 'EMPLOYEE_OF') then

Line 885: l_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

881: x_msg_data OUT NOCOPY VARCHAR2) is
882:
883:
884: l_party_id NUMBER;
885: l_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
886: l_profile_id NUMBER;
887: l_account_number NUMBER;
888: l_account_id NUMBER;
889: l_person_rec HZ_PARTY_V2PUB.person_rec_type;

Line 1133: l_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

1129: x_msg_data OUT NOCOPY VARCHAR2) is
1130:
1131:
1132: l_party_id NUMBER;
1133: l_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
1134: l_location_id NUMBER;
1135: l_party_site_id NUMBER;
1136: l_profile_id NUMBER;
1137: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;

Line 1432: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

1428: IBE_UTIL.debug('enter ibe_party_v2pvt.create_contact_points');
1429: END IF;
1430:
1431: l_contact_point_rec.status := 'A';
1432: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1433: l_contact_point_rec.owner_table_id := p_owner_table_id;
1434: l_contact_point_rec.created_by_module := p_created_by_module;
1435: l_contact_point_rec.application_id := G_APPLICATION_ID;
1436:

Line 1690: WHERE contact_level_table='HZ_PARTIES'

1686: BEGIN
1687: SELECT contact_preference_id, object_version_number
1688: INTO l_id , l_object_version_number
1689: From hz_contact_preferences
1690: WHERE contact_level_table='HZ_PARTIES'
1691: AND contact_level_table_id=p_party_id;
1692:
1693: --update reason_code if record found
1694: l_contact_preference_rec.contact_preference_id := l_id;

Line 1719: l_contact_preference_rec2.contact_level_table := 'HZ_PARTIES';

1715: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1716: IBE_UTIL.debug('Got No Data Found Exception in update_contact_preference');
1717: END IF;
1718:
1719: l_contact_preference_rec2.contact_level_table := 'HZ_PARTIES';
1720: l_contact_preference_rec2.contact_level_table_id := p_party_id;
1721: l_contact_preference_rec2.contact_type := 'EMAIL';
1722: l_contact_preference_rec2.preference_code := p_preference;
1723: l_contact_preference_rec2.requested_by := 'INTERNAL';

Line 2049: l_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

2045: l_acct_num VARCHAR2(30);
2046: l_account_number VARCHAR2(30);
2047: l_count NUMBER;
2048: l_account_id NUMBER;
2049: l_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2050: l_party_id NUMBER;
2051: l_profile_id NUMBER;
2052:
2053:

Line 2262: from hz_parties p, hz_relationships rel,hz_cust_accounts a,hz_org_contacts oc

2258: select p.party_type, p.status, p.object_version_number,
2259: rel.relationship_id,rel.object_version_number rel_object_version_number,
2260: oc.org_contact_id,oc.object_version_number cont_object_version_number,
2261: a.cust_account_id,a.object_version_number acct_object_version_number
2262: from hz_parties p, hz_relationships rel,hz_cust_accounts a,hz_org_contacts oc
2263: where p.party_id = l_party_id and rel.party_id(+) = p.party_id and a.party_id(+) = p.party_id
2264: and oc.party_relationship_id(+) = rel.relationship_id and rownum <2;
2265: rec_party_info c_getPartyInfo%rowtype;
2266:

Line 2271: and owner_table_name = 'HZ_PARTIES';

2267: cursor c_getContactPoints(l_party_id number) IS
2268: select contact_point_id,object_version_number
2269: from hz_contact_points
2270: where owner_table_id = l_party_id
2271: and owner_table_name = 'HZ_PARTIES';
2272: rec_contact_point c_getContactPoints%rowtype;
2273:
2274: cursor c_getPartySite(l_party_id number) IS
2275: select party_site_id,location_id,object_version_number

Line 2593: select party_id, party_name, party_number from hz_parties where party_name = x_org_name;

2589: x_org_num IN OUT NOCOPY VARCHAR2,
2590: x_org_name IN OUT NOCOPY VARCHAR2) return boolean IS
2591:
2592: cursor c_party_name IS
2593: select party_id, party_name, party_number from hz_parties where party_name = x_org_name;
2594: cursor c_party_num IS
2595: select party_id, party_name, party_number from hz_parties where party_number = x_org_num;
2596: cursor c_party_id IS
2597: select party_id, party_name, party_number from hz_parties where party_id = x_org_id;

Line 2595: select party_id, party_name, party_number from hz_parties where party_number = x_org_num;

2591:
2592: cursor c_party_name IS
2593: select party_id, party_name, party_number from hz_parties where party_name = x_org_name;
2594: cursor c_party_num IS
2595: select party_id, party_name, party_number from hz_parties where party_number = x_org_num;
2596: cursor c_party_id IS
2597: select party_id, party_name, party_number from hz_parties where party_id = x_org_id;
2598:
2599: ret_val boolean := false;

Line 2597: select party_id, party_name, party_number from hz_parties where party_id = x_org_id;

2593: select party_id, party_name, party_number from hz_parties where party_name = x_org_name;
2594: cursor c_party_num IS
2595: select party_id, party_name, party_number from hz_parties where party_number = x_org_num;
2596: cursor c_party_id IS
2597: select party_id, party_name, party_number from hz_parties where party_id = x_org_id;
2598:
2599: ret_val boolean := false;
2600: l_party_rec c_party_name%rowtype;
2601:

Line 2602: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;

2598:
2599: ret_val boolean := false;
2600: l_party_rec c_party_name%rowtype;
2601:
2602: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
2603: l_org_num HZ_PARTIES.PARTY_NUMBER%TYPE := null;
2604:
2605: BEGIN
2606: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2603: l_org_num HZ_PARTIES.PARTY_NUMBER%TYPE := null;

2599: ret_val boolean := false;
2600: l_party_rec c_party_name%rowtype;
2601:
2602: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
2603: l_org_num HZ_PARTIES.PARTY_NUMBER%TYPE := null;
2604:
2605: BEGIN
2606: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2607: IBE_UTIL.debug('enter ibe_party_v2pvt.find_organization');

Line 2768: l_person_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

2764: l_location_rec HZ_LOCATION_V2PUB.location_rec_type := p_location_rec;
2765:
2766: l_party_id NUMBER;
2767: l_person_profile_id NUMBER;
2768: l_person_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2769: l_org_profile_id NUMBER;
2770: l_org_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2771: l_org_contact_id NUMBER;
2772: l_party_rel_unq_id NUMBER; -- unique id of the party relationship

Line 2770: l_org_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

2766: l_party_id NUMBER;
2767: l_person_profile_id NUMBER;
2768: l_person_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2769: l_org_profile_id NUMBER;
2770: l_org_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2771: l_org_contact_id NUMBER;
2772: l_party_rel_unq_id NUMBER; -- unique id of the party relationship
2773: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2774: l_location_id NUMBER;

Line 2773: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

2769: l_org_profile_id NUMBER;
2770: l_org_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2771: l_org_contact_id NUMBER;
2772: l_party_rel_unq_id NUMBER; -- unique id of the party relationship
2773: l_rel_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
2774: l_location_id NUMBER;
2775: l_contact_preference_id NUMBER;
2776: l_party_site_id NUMBER;
2777: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;

Line 2809: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;

2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;
2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;
2808:
2809: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
2810:
2811: l_person_party_id NUMBER := l_person_rec.party_rec.party_id;
2812: l_rel_party_id NUMBER := FND_API.G_MISS_NUM;
2813: l_org_party_id NUMBER := l_organization_rec.party_rec.party_id;

Line 3049: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';

3045: FETCH c_get_party_relationship into l_rel_party_id;
3046: IF c_get_party_relationship%NOTFOUND or l_rel_party_id is null or l_rel_party_id=FND_API.G_MISS_NUM THEN
3047: l_party_rel_rec.subject_id := l_person_party_id;
3048: l_party_rel_rec.subject_type := 'PERSON';
3049: l_party_rel_rec.subject_table_name := 'HZ_PARTIES';
3050:
3051: -- pass organization_party_id as object_id
3052: l_party_rel_rec.object_id := l_org_party_id;
3053: l_party_rel_rec.object_type := 'ORGANIZATION';

Line 3054: l_party_rel_rec.object_table_name := 'HZ_PARTIES';

3050:
3051: -- pass organization_party_id as object_id
3052: l_party_rel_rec.object_id := l_org_party_id;
3053: l_party_rel_rec.object_type := 'ORGANIZATION';
3054: l_party_rel_rec.object_table_name := 'HZ_PARTIES';
3055:
3056: l_party_rel_rec.relationship_type := 'EMPLOYMENT';
3057: l_party_rel_rec.relationship_code := 'EMPLOYEE_OF';
3058:

Line 3125: l_contact_pref_rec.contact_level_table := 'HZ_PARTIES';

3121: IF ( l_contact_pref_rec.contact_preference_id = FND_API.G_MISS_NUM or l_contact_pref_rec.contact_preference_id is NULL AND
3122: (l_contact_pref_rec.preference_code is not null AND l_contact_pref_rec.preference_code <> FND_API.G_MISS_CHAR)) THEN
3123:
3124: IF ( l_contact_pref_rec.contact_level_table is NULL or l_contact_pref_rec.contact_level_table = FND_API.G_MISS_CHAR ) THEN
3125: l_contact_pref_rec.contact_level_table := 'HZ_PARTIES';
3126: END IF;
3127:
3128: IF ( l_contact_pref_rec.contact_level_table_id is NULL or l_contact_pref_rec.contact_level_table_id = FND_API.G_MISS_NUM ) THEN
3129: l_contact_pref_rec.contact_level_table_id := l_party_id;

Line 3209: l_email_contact_point_rec.owner_table_name := 'HZ_PARTIES';

3205: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_email_contact_point API');
3206: END IF;
3207:
3208: l_email_contact_point_rec.status := 'A';
3209: l_email_contact_point_rec.owner_table_name := 'HZ_PARTIES';
3210: l_email_contact_point_rec.created_by_module := p_created_by_module;
3211: l_email_contact_point_rec.application_id := G_APPLICATION_ID;
3212: l_email_contact_point_rec.contact_point_type := 'EMAIL';
3213: l_email_contact_point_rec.contact_point_purpose := null;

Line 3282: l_workph_contact_point_rec.owner_table_name := 'HZ_PARTIES';

3278: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_workph_contact_point API');
3279: END IF;
3280:
3281: l_workph_contact_point_rec.status := 'A';
3282: l_workph_contact_point_rec.owner_table_name := 'HZ_PARTIES';
3283: l_workph_contact_point_rec.created_by_module := p_created_by_module;
3284: l_workph_contact_point_rec.application_id := G_APPLICATION_ID;
3285: l_workph_contact_point_rec.contact_point_type := 'PHONE';
3286: l_workph_contact_point_rec.contact_point_purpose := 'BUSINESS';

Line 3355: l_homeph_contact_point_rec.owner_table_name := 'HZ_PARTIES';

3351: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point API');
3352: END IF;
3353:
3354: l_homeph_contact_point_rec.status := 'A';
3355: l_homeph_contact_point_rec.owner_table_name := 'HZ_PARTIES';
3356: l_homeph_contact_point_rec.created_by_module := p_created_by_module;
3357: l_homeph_contact_point_rec.application_id := G_APPLICATION_ID;
3358: l_homeph_contact_point_rec.contact_point_type := 'PHONE';
3359: l_homeph_contact_point_rec.contact_point_purpose := 'PERSONAL';

Line 3427: l_fax_contact_point_rec.owner_table_name := 'HZ_PARTIES';

3423: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_fax_contact_point API');
3424: END IF;
3425:
3426: l_fax_contact_point_rec.status := 'A';
3427: l_fax_contact_point_rec.owner_table_name := 'HZ_PARTIES';
3428: l_fax_contact_point_rec.created_by_module := p_created_by_module;
3429: l_fax_contact_point_rec.application_id := G_APPLICATION_ID;
3430: l_fax_contact_point_rec.contact_point_type := 'PHONE';
3431: l_fax_contact_point_rec.contact_point_purpose := null;

Line 3498: l_orgph_contact_point_rec.owner_table_name := 'HZ_PARTIES';

3494:
3495: IF ( l_orgph_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or l_orgph_contact_point_rec.contact_point_id is NULL) THEN
3496:
3497: l_orgph_contact_point_rec.status := 'A';
3498: l_orgph_contact_point_rec.owner_table_name := 'HZ_PARTIES';
3499: l_orgph_contact_point_rec.created_by_module := p_created_by_module;
3500: l_orgph_contact_point_rec.application_id := G_APPLICATION_ID;
3501: l_orgph_contact_point_rec.contact_point_type := 'PHONE';
3502: l_orgph_contact_point_rec.contact_point_purpose := 'BUSINESS';

Line 3577: l_orgfax_contact_point_rec.owner_table_name := 'HZ_PARTIES';

3573:
3574: IF (l_orgfax_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or l_orgfax_contact_point_rec.contact_point_id is NULL) THEN
3575:
3576: l_orgfax_contact_point_rec.status := 'A';
3577: l_orgfax_contact_point_rec.owner_table_name := 'HZ_PARTIES';
3578: l_orgfax_contact_point_rec.created_by_module := p_created_by_module;
3579: l_orgfax_contact_point_rec.application_id := G_APPLICATION_ID;
3580: l_orgfax_contact_point_rec.contact_point_type := 'PHONE';
3581: l_orgfax_contact_point_rec.contact_point_purpose := null;