57: SELECT
58: MEANING
59: INTO X_SCHEDULE_TYPE
60: FROM
61: FND_LOOKUPS
62: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
63: AND LOOKUP_CODE = SCHEDULE_TYPE;
64: RETURN X_SCHEDULE_TYPE;
65: EXCEPTION
79: SELECT
80: MEANING
81: INTO X_YES
82: FROM
83: FND_LOOKUPS
84: WHERE LOOKUP_TYPE = 'YES_NO'
85: AND LOOKUP_CODE = 'N';
86: RETURN X_YES;
87: ELSE
88: SELECT
89: MEANING
90: INTO X_YES
91: FROM
92: FND_LOOKUPS
93: WHERE LOOKUP_TYPE = 'YES_NO'
94: AND LOOKUP_CODE = PURGE_STATUS;
95: RETURN X_YES;
96: END IF;
248: SELECT
249: MEANING
250: INTO X_SCHEDULE_TYPE
251: FROM
252: FND_LOOKUPS
253: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
254: AND LOOKUP_CODE = P_SCHEDULE_TYPE;
255: RETURN X_SCHEDULE_TYPE;
256: END IF;
269: SELECT
270: MEANING
271: INTO X_EXEC
272: FROM
273: FND_LOOKUPS
274: WHERE LOOKUP_TYPE = 'RLM_EXECUTION_MODE'
275: AND LOOKUP_CODE = P_EXECUTION_MODE;
276: RETURN X_EXEC;
277: EXCEPTION
289: SELECT
290: MEANING
291: INTO X_YES
292: FROM
293: FND_LOOKUPS
294: WHERE LOOKUP_TYPE = 'YES_NO'
295: AND LOOKUP_CODE = P_AUTHORIZATION;
296: RETURN X_YES;
297: EXCEPTION
310: SELECT
311: MEANING
312: INTO X_YES
313: FROM
314: FND_LOOKUPS
315: WHERE LOOKUP_TYPE = 'YES_NO'
316: AND LOOKUP_CODE = PURGE_STATUS;
317: RETURN X_YES;
318: END;
327: SELECT
328: MEANING
329: INTO X_STATUS
330: FROM
331: FND_LOOKUPS
332: WHERE LOOKUP_TYPE = 'RLM_STATUS'
333: AND LOOKUP_CODE = P_STATUS;
334: RETURN X_STATUS;
335: EXCEPTION