132: BEGIN
133: if (X_adhoc_prefix is NULL) then
134: SELECT substr(meaning, 1, 16)
135: INTO X_adhoc_prefix
136: FROM rg_lookups
137: WHERE LOOKUP_TYPE='FSG_ADHOC_REPORT_NAME_PREFIX'
138: AND LOOKUP_CODE = 'ADHOC_PREFIX';
139: end if;
140: END get_adhoc_prefix;
197: --
198: IF (X_Name is NULL) THEN
199: SELECT substr(meaning, 1, 16) || X_Report_Id
200: INTO X_Name
201: FROM rg_lookups
202: WHERE LOOKUP_TYPE='FSG_ADHOC_REPORT_NAME_PREFIX'
203: AND LOOKUP_CODE = 'ADHOC_PREFIX';
204: ELSE
205: IF (check_dup_report_name(X_Application_Id, X_Report_Id, X_Name)) THEN