DBA Data[Home] [Help]

APPS.AP_HOLD_CODES_PKG dependencies on FND_LOOKUP_VALUES

Line 127: -- Insert values into fnd_lookup_values

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(

Line 129: debug_info := 'Inserting in 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,

Line 131: INSERT INTO fnd_lookup_values(

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,

Line 199: from fnd_lookup_values FLV

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:

Line 397: -- Updating fnd_lookup_values

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

Line 399: debug_info := 'Updating 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,

Line 401: UPDATE fnd_lookup_values

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,