APPS.IGS_OR_VAL_OA dependencies on IGS_CO_ADDR_TYPE

Line 34: FROM IGS_CO_ADDR_TYPE adt

30: DECLARE
31: v_oa_count NUMBER(5);
32: CURSOR c_oa_count IS
33: SELECT count(*)
34: FROM IGS_CO_ADDR_TYPE adt
35: WHERE adt.addr_type = p_addr_type;
36:
37: CURSOR c_oa IS
38: SELECT oa.addr_type,

Line 62: -- determine if they have any other active records with an IGS_CO_ADDR_TYPE

58: RETURN TRUE;
59: END IF;
60: -- The addr_type passed in as a parameter has the correspondence_ind
61: -- set. Now loop through the IGS_OR_ADDR records for the IGS_AD_LOCATION to
62: -- determine if they have any other active records with an IGS_CO_ADDR_TYPE
63: -- (apart from the IGS_CO_ADDR_TYPE passed in as a parameter) which also has
64: -- the correspondence_ind set. If so set the error message.
65: FOR v_oa IN c_oa LOOP
66: --validate for date overlaps against the parameter details passed in.

Line 63: -- (apart from the IGS_CO_ADDR_TYPE passed in as a parameter) which also has

59: END IF;
60: -- The addr_type passed in as a parameter has the correspondence_ind
61: -- set. Now loop through the IGS_OR_ADDR records for the IGS_AD_LOCATION to
62: -- determine if they have any other active records with an IGS_CO_ADDR_TYPE
63: -- (apart from the IGS_CO_ADDR_TYPE passed in as a parameter) which also has
64: -- the correspondence_ind set. If so set the error message.
65: FOR v_oa IN c_oa LOOP
66: --validate for date overlaps against the parameter details passed in.
67: --Validation will fail if any of the following are true: