123: X_Hold_Instruction
124: );
125:
126:
127: -- Insert values into fnd_lookup_values
128: --
129: debug_info := 'Inserting in fnd_lookup_values';
130:
131: INSERT INTO fnd_lookup_values(
125:
126:
127: -- Insert values into fnd_lookup_values
128: --
129: debug_info := 'Inserting in fnd_lookup_values';
130:
131: INSERT INTO fnd_lookup_values(
132: lookup_type,
133: security_group_id,
127: -- Insert values into fnd_lookup_values
128: --
129: debug_info := 'Inserting in fnd_lookup_values';
130:
131: INSERT INTO fnd_lookup_values(
132: lookup_type,
133: security_group_id,
134: view_application_id,
135: language,
195: from FND_LANGUAGES L
196: where L.INSTALLED_FLAG in ('I', 'B')
197: and not exists
198: (select NULL
199: from fnd_lookup_values FLV
200: where FLV.lookup_type = 'HOLD CODE'
201: and FLV.lookup_code = X_Hold_Lookup_Code
202: and FLV.language = L.LANGUAGE_CODE);
203:
407: hold_instruction = X_Hold_Instruction
408: WHERE rowid = X_Rowid;
409:
410:
411: -- Updating fnd_lookup_values
412: --
413: debug_info := 'Updating fnd_lookup_values';
414:
415: UPDATE fnd_lookup_values
409:
410:
411: -- Updating fnd_lookup_values
412: --
413: debug_info := 'Updating fnd_lookup_values';
414:
415: UPDATE fnd_lookup_values
416: SET
417: description = X_Description,
411: -- Updating fnd_lookup_values
412: --
413: debug_info := 'Updating fnd_lookup_values';
414:
415: UPDATE fnd_lookup_values
416: SET
417: description = X_Description,
418: last_update_date = X_Last_Update_Date,
419: last_updated_by = X_Last_Updated_By,