APPS.IGS_PE_MATCH_SETS_PKG dependencies on IGS_PE_SRC_TYPES

Line 169: PROCEDURE GET_FK_IGS_PE_SRC_TYPES (

165: Return(FALSE);
166: END IF;
167: END Get_PK_For_Validation;
168:
169: PROCEDURE GET_FK_IGS_PE_SRC_TYPES (
170: X_source_type_id in number
171: ) as
172: /*************************************************************
173: Created By :svisweas

Line 175: Purpose : To get FK from IGS_PE_SRC_TYPES

171: ) as
172: /*************************************************************
173: Created By :svisweas
174: Date Created By :27-MAY-2000
175: Purpose : To get FK from IGS_PE_SRC_TYPES
176: Know limitations, enhancements or remarks
177: Change History
178: Who When What
179: svisweas 27-MAY-2000 Added This procedure after corrections

Line 204: END GET_FK_IGS_PE_SRC_TYPES;

200: RETURN;
201: END IF;
202: CLOSE cur_rowid;
203:
204: END GET_FK_IGS_PE_SRC_TYPES;
205:
206: PROCEDURE GET_FK_IGS_PE_DUP_PAIRS (
207: X_duplicate_pair_id in number
208: ) as

Line 256: SELECT 'X' FROM IGS_PE_SRC_TYPES WHERE SOURCE_TYPE_ID = new_references.source_type_id AND SYSTEM_SOURCE_TYPE = 'MANUAL';

252: (reverse chronological order - newest change first)
253: ***************************************************************/
254:
255: CURSOR Src_Type IS
256: SELECT 'X' FROM IGS_PE_SRC_TYPES WHERE SOURCE_TYPE_ID = new_references.source_type_id AND SYSTEM_SOURCE_TYPE = 'MANUAL';
257:
258: CURSOR Dup_Data IS
259: SELECT LOOKUP_CODE FROM IGS_LOOKUPS_VIEW WHERE LOOKUP_TYPE = 'DUPLICATE_DATA_ELEMENTS' AND ENABLED_FLAG = 'Y';
260: