DBA Data[Home] [Help]

APPS.OE_INLINE_CUSTOMER_PUB dependencies on HZ_PARTIES

Line 114: From hz_parties

110: Select party_id,
111: party_name
112: Into x_party_id,
113: x_party_name
114: From hz_parties
115: Where party_number = p_party_number
116: And party_type = p_party_type;
117:
118: IF l_debug_level > 0 THEN

Line 580: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';

576:
577: x_return_status := FND_API.G_RET_STS_SUCCESS;
578: l_contact_points_rec.contact_point_type := p_contact_point_type;
579: l_contact_points_rec.status := 'A';
580: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';
581: l_contact_points_rec.owner_table_id := p_owner_table_id;
582: l_contact_points_rec.primary_flag := 'Y';
583: l_contact_points_rec.created_by_module := G_CREATED_BY_MODULE;
584: l_contact_points_rec.application_id := 660;

Line 2512: x_rel_party_number hz_parties.party_number%TYPE;

2508: l_return_status Varchar2(1);
2509:
2510: -- l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
2511: x_rel_party_id Number;
2512: x_rel_party_number hz_parties.party_number%TYPE;
2513: x_party_relationship_id Number;
2514:
2515: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
2516: x_org_contact_id Number;

Line 2940: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

2936: l_org_contact_rec.party_rel_rec.object_id := l_customer_party_id;
2937: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
2938: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
2939: l_org_contact_rec.party_rel_rec.start_date := sysdate;
2940: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
2941: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
2942: l_org_contact_rec.party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
2943: l_org_contact_rec.party_rel_rec.application_id := 660;
2944: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';

Line 2941: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

2937: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
2938: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
2939: l_org_contact_rec.party_rel_rec.start_date := sysdate;
2940: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
2941: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
2942: l_org_contact_rec.party_rel_rec.created_by_module := G_CREATED_BY_MODULE;
2943: l_org_contact_rec.party_rel_rec.application_id := 660;
2944: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
2945: Select party_type

Line 2947: From HZ_PARTIES

2943: l_org_contact_rec.party_rel_rec.application_id := 660;
2944: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
2945: Select party_type
2946: Into l_org_contact_rec.party_rel_rec.object_type
2947: From HZ_PARTIES
2948: Where party_id = l_customer_party_id;
2949:
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'SUBJECT_ID:'||L_CONTACT_PARTY_ID||':OBJECT_ID:'||L_CUSTOMER_PARTY_ID||':OBJECT_TYPE'||L_ORG_CONTACT_REC.PARTY_REL_REC.OBJECT_TYPE ) ;

Line 3155: From hz_parties

3151:
3152: -- Let us select the Name to Pass back to calling api
3153: Select party_name
3154: Into x_contact_name
3155: From hz_parties
3156: Where party_id = l_contact_party_id;
3157: -- End of select to get name
3158:
3159: -- Now Update the table with the new values