89: DECLARE dummy NUMBER;
90: BEGIN
91: SELECT count(*)
92: INTO dummy
93: FROM mfg_lookups
94: WHERE lookup_type = 'MRP_WORKBENCH_BUCKET_TYPE'
95: AND lookup_code = arg_bucket_type;
96:
97: IF dummy = 0 THEN
95: AND lookup_code = arg_bucket_type;
96:
97: IF dummy = 0 THEN
98: -- -------------------------------------
99: -- The bucket type is not in MFG_LOOKUPS
100: -- -------------------------------------
101: --dbms_output.put_line('Creating new lookup');
102: INSERT INTO mfg_lookups
103: (lookup_type,
98: -- -------------------------------------
99: -- The bucket type is not in MFG_LOOKUPS
100: -- -------------------------------------
101: --dbms_output.put_line('Creating new lookup');
102: INSERT INTO mfg_lookups
103: (lookup_type,
104: lookup_code,
105: last_update_date,
106: last_updated_by,