APPS.EGO_DATA_SECURITY dependencies on HZ_PARTIES

Line 168: --Bug NO: 8818999 - Enable the HZ_PARTIES object for supplier data hub security

164: -- We may need to go against the table rather than the view
165: -- to improve performance.
166:
167: --PERF:Bug NO:6531906 --changed the query to look into the base tables instead of the View.
168: --Bug NO: 8818999 - Enable the HZ_PARTIES object for supplier data hub security
169: IF p_object_name IN ('EGO_ITEM','ENG_CHANGE','HZ_PARTIES') THEN
170: IF l_party_id IS NULL THEN
171: SELECT count(1) into l_count
172: FROM hz_parties employee,

Line 169: IF p_object_name IN ('EGO_ITEM','ENG_CHANGE','HZ_PARTIES') THEN

165: -- to improve performance.
166:
167: --PERF:Bug NO:6531906 --changed the query to look into the base tables instead of the View.
168: --Bug NO: 8818999 - Enable the HZ_PARTIES object for supplier data hub security
169: IF p_object_name IN ('EGO_ITEM','ENG_CHANGE','HZ_PARTIES') THEN
170: IF l_party_id IS NULL THEN
171: SELECT count(1) into l_count
172: FROM hz_parties employee,
173: FND_USER FND_user,

Line 172: FROM hz_parties employee,

168: --Bug NO: 8818999 - Enable the HZ_PARTIES object for supplier data hub security
169: IF p_object_name IN ('EGO_ITEM','ENG_CHANGE','HZ_PARTIES') THEN
170: IF l_party_id IS NULL THEN
171: SELECT count(1) into l_count
172: FROM hz_parties employee,
173: FND_USER FND_user,
174: PER_ALL_PEOPLE_F HR_EMPLOYEE
175: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID
176: AND fnd_user.start_date <= SYSDATE

Line 189: FROM hz_parties employee ,

185: AND employee.party_id = HR_EMPLOYEE.PARTY_ID
186: AND user_name = p_user_name;
187: ELSE
188: SELECT Count(1) into l_count
189: FROM hz_parties employee ,
190: FND_USER FND_user ,
191: PER_ALL_PEOPLE_F HR_EMPLOYEE
192: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID
193: AND fnd_user.start_date <= SYSDATE

Line 206: -- Bug 11877108: Define default supplier profile option for HZ_PARTIES case

202: AND employee.party_id = l_party_id;
203: END IF;
204: --IF (l_count = 0) THEN
205: -- l_role_name := '';
206: -- Bug 11877108: Define default supplier profile option for HZ_PARTIES case
207: IF (l_count = 0) THEN
208: IF (p_object_name = 'HZ_PARTIES') THEN --Bug 16093422
209: l_role_name := NVL(FND_PROFILE.VALUE('POS_SM_DEFAULT_ROLE_SUPP'),'');
210: ELSE

Line 208: IF (p_object_name = 'HZ_PARTIES') THEN --Bug 16093422

204: --IF (l_count = 0) THEN
205: -- l_role_name := '';
206: -- Bug 11877108: Define default supplier profile option for HZ_PARTIES case
207: IF (l_count = 0) THEN
208: IF (p_object_name = 'HZ_PARTIES') THEN --Bug 16093422
209: l_role_name := NVL(FND_PROFILE.VALUE('POS_SM_DEFAULT_ROLE_SUPP'),'');
210: ELSE
211: l_role_name := '';
212: END IF;

Line 219: ELSIF (p_object_name = 'HZ_PARTIES') THEN

215: IF (p_object_name = 'EGO_ITEM') THEN
216: l_role_name := FND_PROFILE.VALUE(l_ego_item_profile_option);
217: ELSIF (p_object_name = 'ENG_CHANGE') THEN
218: l_role_name := FND_PROFILE.VALUE(l_eng_change_profile_option);
219: ELSIF (p_object_name = 'HZ_PARTIES') THEN
220: l_role_name := FND_PROFILE.VALUE('POS_SM_DEFAULT_ROLE_INTERNAL');
221: END IF;
222: END IF; --l_count = 0
223: END IF;

Line 4006: FROM hz_parties

4002: CURSOR get_user_grantee_key (cp_party_id NUMBER)
4003: IS
4004: --SELECT decode (party_type,'PERSON','HZ_PARTY:'||party_id,'GROUP','HZ_GROUP:'||party_id,'ORGANIZATION','HZ_COMPANY:'||party_id) grantee_key
4005: SELECT party_type
4006: FROM hz_parties
4007: WHERE party_id=cp_party_id;
4008:
4009: l_object_id number;
4010: p_user_name FND_GRANTS.grantee_key%TYPE;

Line 4493: FROM hz_parties

4489:
4490: CURSOR get_user_grantee_key (cp_party_id NUMBER) IS
4491: --SELECT decode (party_type,'PERSON','HZ_PARTY:'||party_id,'GROUP','HZ_GROUP:'||party_id,'ORGANIZATION','HZ_COMPANY:'||party_id) grantee_key
4492: SELECT party_type
4493: FROM hz_parties
4494: WHERE party_id=cp_party_id;
4495: l_object_id NUMBER;
4496: p_user_name FND_GRANTS.grantee_key%TYPE;
4497: l_party_type VARCHAR2(30);