APPS.FF_FGL_SHD dependencies on FF_GLOBALS_F

Line 37: ElsIf (p_constraint_name = 'FF_GLOBALS_F_PK') Then

33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'FF_GLOBALS_F_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;

Line 42: ElsIf (p_constraint_name = 'FF_GLOBALS_F_UK2') Then

38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'FF_GLOBALS_F_UK2') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;

Line 79: from ff_globals_f

75: ,global_name
76: ,global_description
77: ,global_value
78: ,object_version_number
79: from ff_globals_f
80: where global_id = p_global_id
81: and p_effective_date
82: between effective_start_date and effective_end_date;
83: --

Line 155: ,p_base_table_name => 'ff_globals_f'

151: -- Call the corresponding datetrack api
152: --
153: dt_api.find_dt_upd_modes
154: (p_effective_date => p_effective_date
155: ,p_base_table_name => 'ff_globals_f'
156: ,p_base_key_column => 'global_id'
157: ,p_base_key_value => p_base_key_value
158: ,p_correction => p_correction
159: ,p_update => p_update

Line 189: ,p_base_table_name => 'ff_globals_f'

185: -- Call the corresponding datetrack api
186: --
187: dt_api.find_dt_del_modes
188: (p_effective_date => p_effective_date
189: ,p_base_table_name => 'ff_globals_f'
190: ,p_base_key_column => 'global_id'
191: ,p_base_key_value => p_base_key_value
192: ,p_zap => p_zap
193: ,p_delete => p_delete

Line 224: (p_base_table_name => 'ff_globals_f'

220: -- version number.
221: --
222: l_object_version_number :=
223: dt_api.get_object_version_number
224: (p_base_table_name => 'ff_globals_f'
225: ,p_base_key_column => 'global_id'
226: ,p_base_key_value => p_base_key_value
227: );
228: --

Line 235: update ff_globals_f t

231: --
232: -- Update the specified datetrack row setting the effective
233: -- end date to the specified new effective end date.
234: --
235: update ff_globals_f t
236: set t.effective_end_date = p_new_effective_end_date
237: , t.object_version_number = l_object_version_number
238: where t.global_id = p_base_key_value
239: and p_effective_date

Line 285: from ff_globals_f

281: ,global_name
282: ,global_description
283: ,global_value
284: ,object_version_number
285: from ff_globals_f
286: where global_id = p_global_id
287: and p_effective_date
288: between effective_start_date and effective_end_date
289: for update nowait;

Line 348: ,p_base_table_name => 'ff_globals_f'

344: --
345: dt_api.validate_dt_mode
346: (p_effective_date => p_effective_date
347: ,p_datetrack_mode => p_datetrack_mode
348: ,p_base_table_name => 'ff_globals_f'
349: ,p_base_key_column => 'global_id'
350: ,p_base_key_value => p_global_id
351: ,p_enforce_foreign_locking => true
352: ,p_validation_start_date => l_validation_start_date

Line 383: fnd_message.set_token('TABLE_NAME', 'ff_globals_f');

379: -- The object is locked therefore we need to supply a meaningful
380: -- error message.
381: --
382: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
383: fnd_message.set_token('TABLE_NAME', 'ff_globals_f');
384: fnd_message.raise_error;
385: End lck;
386: --
387: -- ----------------------------------------------------------------------------