190: CURSOR LOOKUP_CUR IS
191: SELECT
192: MEANING
193: FROM
194: FND_LOOKUPS
195: WHERE LOOKUP_TYPE = 'RLM_DETAIL_TYPE_CODE'
196: AND LOOKUP_CODE = ITEM_DETAIL_TYPE;
197: BEGIN
198: IF LOOKUP_CUR%ISOPEN THEN
217: CURSOR LOOKUP_CUR IS
218: SELECT
219: MEANING
220: FROM
221: FND_LOOKUPS
222: WHERE LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE'
223: AND LOOKUP_CODE = ITEM_DETAIL_SUBTYPE;
224: BEGIN
225: IF LOOKUP_CUR%ISOPEN THEN
284: SELECT
285: MEANING
286: INTO X_SCHEDULE_TYPE
287: FROM
288: FND_LOOKUPS
289: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
290: AND LOOKUP_CODE = SCHEDULE_TYPE;
291: RETURN X_SCHEDULE_TYPE;
292: EXCEPTION
304: SELECT
305: MEANING
306: INTO X_SCHEDULE_PURPOSE
307: FROM
308: FND_LOOKUPS
309: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_PURPOSE'
310: AND LOOKUP_CODE = SCHEDULE_PURPOSE;
311: RETURN X_SCHEDULE_PURPOSE;
312: EXCEPTION
325: SELECT
326: MEANING
327: INTO X_SCHEDULE_SOURCE
328: FROM
329: FND_LOOKUPS
330: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_SOURCE'
331: AND LOOKUP_CODE = SCHEDULE_SOURCE;
332: ELSE
333: X_SCHEDULE_SOURCE := SCHEDULE_SOURCE;