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:
393: hold_instruction = X_Hold_Instruction
394: WHERE rowid = X_Rowid;
395:
396:
397: -- Updating fnd_lookup_values
398: --
399: debug_info := 'Updating fnd_lookup_values';
400:
401: UPDATE fnd_lookup_values
395:
396:
397: -- Updating fnd_lookup_values
398: --
399: debug_info := 'Updating fnd_lookup_values';
400:
401: UPDATE fnd_lookup_values
402: SET
403: description = X_Description,
397: -- Updating fnd_lookup_values
398: --
399: debug_info := 'Updating fnd_lookup_values';
400:
401: UPDATE fnd_lookup_values
402: SET
403: description = X_Description,
404: last_update_date = X_Last_Update_Date,
405: last_updated_by = X_Last_Updated_By,