DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on HZ_PARTIES

Line 5288: --Below Variables are used for updating hz_parties flex field

5284: WHERE instance_id=p_instance_id;
5285:
5286:
5287:
5288: --Below Variables are used for updating hz_parties flex field
5289: l_profile_id number;
5290: l_org_update_rec HZ_PARTY_V2PUB.organization_rec_type;
5291: l_party_update_rec HZ_PARTY_V2PUB.party_rec_type;
5292: l_party_object_version_number NUMBER;

Line 5456: ELSIF p_inst_flex_fld_tbl.l_flex_fl_table = 'HZ_PARTIES'

5452: FETCH c_instance_obj INTO p_obj_ver_no;
5453: CLOSE c_instance_obj;
5454: END IF;
5455:
5456: ELSIF p_inst_flex_fld_tbl.l_flex_fl_table = 'HZ_PARTIES'
5457: THEN
5458: l_party_update_rec.party_id := p_inst_flex_fld_tbl.l_party_id ;
5459: l_org_update_rec.party_rec := l_party_update_rec;
5460: l_org_update_rec.party_rec.Attribute_Category := NVL( p_inst_flex_fld_tbl.l_att_catogary , FND_API.G_MISS_CHAR);

Line 5669: hz_parties p

5665: s.addressee,
5666: csf_tasks_pub.return_primary_phone(s.party_site_id) phone_no
5667: FROM hz_locations l,
5668: hz_party_sites s,
5669: hz_parties p
5670: WHERE s.location_id = p_location_id
5671: AND l.location_id = s.location_id
5672: AND s.party_id = p.party_id
5673: AND p.party_id =p_party_id_no;