APPS.IGS_PE_HZ_PARTIES_PKG dependencies on IGS_LOOKUPS_VIEW_PKG

Line 260: || ssawhney 6FEB2002 veteran is now a lookup, so get pk from IGS_LOOKUPS_VIEW_PKG

256: || Known limitations, enhancements or remarks :
257: || Change History :
258: || Who When What
259: || (reverse chronological order - newest change first)
260: || ssawhney 6FEB2002 veteran is now a lookup, so get pk from IGS_LOOKUPS_VIEW_PKG
261: */
262:
263: FUNCTION validate_pk(x_party_id NUMBER) RETURN BOOLEAN IS
264: CURSOR cur_rowid IS

Line 302: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('VETERAN_STATUS',new_references.veteran) THEN

298: IF (((old_references.veteran = new_references.veteran)) OR
299: ((new_references.veteran IS NULL))) THEN
300: NULL;
301: ELSE
302: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('VETERAN_STATUS',new_references.veteran) THEN
303: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
304: IGS_GE_MSG_STACK.ADD;
305: APP_EXCEPTION.RAISE_EXCEPTION;
306: END IF;

Line 313: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('OR_INST_PRIORITY_CD',new_references.inst_priority_cd) THEN

309: IF (((old_references.inst_priority_cd = new_references.inst_priority_cd)) OR
310: ((new_references.inst_priority_cd IS NULL))) THEN
311: NULL;
312: ELSE
313: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('OR_INST_PRIORITY_CD',new_references.inst_priority_cd) THEN
314: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
315: IGS_GE_MSG_STACK.ADD;
316: APP_EXCEPTION.RAISE_EXCEPTION;
317: END IF;