DBA Data[Home] [Help]

APPS.FF_FGL_DEL dependencies on FF_FGL_SHD

Line 54: (p_rec in out nocopy ff_fgl_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ff_fgl_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 66: ff_fgl_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: ff_fgl_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

71: delete from ff_globals_f
72: where global_id = p_rec.global_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ff_fgl_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: ff_fgl_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: ff_fgl_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

82: delete from ff_globals_f
83: where global_id = p_rec.global_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 142: (p_rec in out nocopy ff_fgl_shd.g_rec_type

138: -- ----------------------------------------------------------------------------
139: -- |------------------------------< delete_dml >------------------------------|
140: -- ----------------------------------------------------------------------------
141: Procedure delete_dml
142: (p_rec in out nocopy ff_fgl_shd.g_rec_type
143: ,p_effective_date in date
144: ,p_datetrack_mode in varchar2
145: ,p_validation_start_date in date
146: ,p_validation_end_date in date

Line 199: (p_rec in out nocopy ff_fgl_shd.g_rec_type

195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure dt_pre_delete
199: (p_rec in out nocopy ff_fgl_shd.g_rec_type
200: ,p_effective_date in date
201: ,p_datetrack_mode in varchar2
202: ,p_validation_start_date in date
203: ,p_validation_end_date in date

Line 214: := ff_fgl_shd.g_old_rec.effective_start_date;

210: --
211: If (p_datetrack_mode <> hr_api.g_zap) then
212: --
213: p_rec.effective_start_date
214: := ff_fgl_shd.g_old_rec.effective_start_date;
215: --
216: If (p_datetrack_mode = hr_api.g_delete) then
217: p_rec.effective_end_date := p_validation_start_date - 1;
218: Else

Line 224: ff_fgl_shd.upd_effective_end_date

220: End If;
221: --
222: -- Update the current effective end date record
223: --
224: ff_fgl_shd.upd_effective_end_date
225: (p_effective_date => p_effective_date
226: ,p_base_key_value => p_rec.global_id
227: ,p_new_effective_end_date => p_rec.effective_end_date
228: ,p_validation_start_date => p_validation_start_date

Line 273: (p_rec in out nocopy ff_fgl_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure pre_delete
273: (p_rec in out nocopy ff_fgl_shd.g_rec_type
274: ,p_effective_date in date
275: ,p_datetrack_mode in varchar2
276: ,p_validation_start_date in date
277: ,p_validation_end_date in date

Line 333: (p_rec in ff_fgl_shd.g_rec_type

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure post_delete
333: (p_rec in ff_fgl_shd.g_rec_type
334: ,p_effective_date in date
335: ,p_datetrack_mode in varchar2
336: ,p_validation_start_date in date
337: ,p_validation_end_date in date

Line 368: => ff_fgl_shd.g_old_rec.effective_start_date

364: => p_rec.effective_start_date
365: ,p_effective_end_date
366: => p_rec.effective_end_date
367: ,p_effective_start_date_o
368: => ff_fgl_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => ff_fgl_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => ff_fgl_shd.g_old_rec.business_group_id

Line 370: => ff_fgl_shd.g_old_rec.effective_end_date

366: => p_rec.effective_end_date
367: ,p_effective_start_date_o
368: => ff_fgl_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => ff_fgl_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => ff_fgl_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => ff_fgl_shd.g_old_rec.legislation_code

Line 372: => ff_fgl_shd.g_old_rec.business_group_id

368: => ff_fgl_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => ff_fgl_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => ff_fgl_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => ff_fgl_shd.g_old_rec.legislation_code
375: ,p_data_type_o
376: => ff_fgl_shd.g_old_rec.data_type

Line 374: => ff_fgl_shd.g_old_rec.legislation_code

370: => ff_fgl_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => ff_fgl_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => ff_fgl_shd.g_old_rec.legislation_code
375: ,p_data_type_o
376: => ff_fgl_shd.g_old_rec.data_type
377: ,p_global_name_o
378: => ff_fgl_shd.g_old_rec.global_name

Line 376: => ff_fgl_shd.g_old_rec.data_type

372: => ff_fgl_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => ff_fgl_shd.g_old_rec.legislation_code
375: ,p_data_type_o
376: => ff_fgl_shd.g_old_rec.data_type
377: ,p_global_name_o
378: => ff_fgl_shd.g_old_rec.global_name
379: ,p_global_description_o
380: => ff_fgl_shd.g_old_rec.global_description

Line 378: => ff_fgl_shd.g_old_rec.global_name

374: => ff_fgl_shd.g_old_rec.legislation_code
375: ,p_data_type_o
376: => ff_fgl_shd.g_old_rec.data_type
377: ,p_global_name_o
378: => ff_fgl_shd.g_old_rec.global_name
379: ,p_global_description_o
380: => ff_fgl_shd.g_old_rec.global_description
381: ,p_global_value_o
382: => ff_fgl_shd.g_old_rec.global_value

Line 380: => ff_fgl_shd.g_old_rec.global_description

376: => ff_fgl_shd.g_old_rec.data_type
377: ,p_global_name_o
378: => ff_fgl_shd.g_old_rec.global_name
379: ,p_global_description_o
380: => ff_fgl_shd.g_old_rec.global_description
381: ,p_global_value_o
382: => ff_fgl_shd.g_old_rec.global_value
383: ,p_object_version_number_o
384: => ff_fgl_shd.g_old_rec.object_version_number

Line 382: => ff_fgl_shd.g_old_rec.global_value

378: => ff_fgl_shd.g_old_rec.global_name
379: ,p_global_description_o
380: => ff_fgl_shd.g_old_rec.global_description
381: ,p_global_value_o
382: => ff_fgl_shd.g_old_rec.global_value
383: ,p_object_version_number_o
384: => ff_fgl_shd.g_old_rec.object_version_number
385: );
386: --

Line 384: => ff_fgl_shd.g_old_rec.object_version_number

380: => ff_fgl_shd.g_old_rec.global_description
381: ,p_global_value_o
382: => ff_fgl_shd.g_old_rec.global_value
383: ,p_object_version_number_o
384: => ff_fgl_shd.g_old_rec.object_version_number
385: );
386: --
387: exception
388: --

Line 406: ,p_rec in out nocopy ff_fgl_shd.g_rec_type

402: -- ----------------------------------------------------------------------------
403: Procedure del
404: (p_effective_date in date
405: ,p_datetrack_mode in varchar2
406: ,p_rec in out nocopy ff_fgl_shd.g_rec_type
407: ) is
408: --
409: l_proc varchar2(72) := g_package||'del';
410: l_validation_start_date date;

Line 431: ff_fgl_shd.lck

427: fnd_message.raise_error;
428: end if;
429: --
430: -- We must lock the row which we need to delete.
431: ff_fgl_shd.lck
432: (p_effective_date => p_effective_date
433: ,p_datetrack_mode => p_datetrack_mode
434: ,p_global_id => p_rec.global_id
435: ,p_object_version_number => p_rec.object_version_number

Line 500: l_rec ff_fgl_shd.g_rec_type;

496: ,p_effective_start_date out nocopy date
497: ,p_effective_end_date out nocopy date
498: ) is
499: --
500: l_rec ff_fgl_shd.g_rec_type;
501: l_proc varchar2(72) := g_package||'del';
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);