eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FF_FGL_UPD dependencies on FF_FGL_SHD

Line 58: (p_rec in out nocopy ff_fgl_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ff_fgl_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

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

79: ,p_base_key_column => 'global_id'
80: ,p_base_key_value => p_rec.global_id
81: );
82: --
83: ff_fgl_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the ff_globals_f Row
86: --
87: update ff_globals_f

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

97: where global_id = p_rec.global_id
98: and effective_start_date = p_validation_start_date
99: and effective_end_date = p_validation_end_date;
100: --
101: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: -- Set the effective start and end dates
104: --
105: p_rec.effective_start_date := p_validation_start_date;

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

109: hr_utility.set_location(' Leaving:'||l_proc, 15);
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
114: ff_fgl_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated

Line 114: ff_fgl_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
114: ff_fgl_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

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

114: ff_fgl_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
119: ff_fgl_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status

Line 119: ff_fgl_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
119: ff_fgl_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;

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

118: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
119: ff_fgl_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: ff_fgl_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;
124: End dt_update_dml;
125: --
126: -- ----------------------------------------------------------------------------

Line 158: (p_rec in out nocopy ff_fgl_shd.g_rec_type

154: --
155: -- {End Of Comments}
156: -- ----------------------------------------------------------------------------
157: Procedure update_dml
158: (p_rec in out nocopy ff_fgl_shd.g_rec_type
159: ,p_effective_date in date
160: ,p_datetrack_mode in varchar2
161: ,p_validation_start_date in date
162: ,p_validation_end_date in date

Line 225: (p_rec in out nocopy ff_fgl_shd.g_rec_type

221: --
222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_pre_update
225: (p_rec in out nocopy ff_fgl_shd.g_rec_type
226: ,p_effective_date in date
227: ,p_datetrack_mode in varchar2
228: ,p_validation_start_date in date
229: ,p_validation_end_date in date

Line 241: ff_fgl_shd.upd_effective_end_date

237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
241: ff_fgl_shd.upd_effective_end_date
242: (p_effective_date => p_effective_date
243: ,p_base_key_value => p_rec.global_id
244: ,p_new_effective_end_date => (p_validation_start_date - 1)
245: ,p_validation_start_date => p_validation_start_date

Line 310: (p_rec in out nocopy ff_fgl_shd.g_rec_type

306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_update
310: (p_rec in out nocopy ff_fgl_shd.g_rec_type
311: ,p_effective_date in date
312: ,p_datetrack_mode in varchar2
313: ,p_validation_start_date in date
314: ,p_validation_end_date in date

Line 368: (p_rec in ff_fgl_shd.g_rec_type

364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure post_update
368: (p_rec in ff_fgl_shd.g_rec_type
369: ,p_effective_date in date
370: ,p_datetrack_mode in varchar2
371: ,p_validation_start_date in date
372: ,p_validation_end_date in date

Line 411: => ff_fgl_shd.g_old_rec.effective_start_date

407: => p_rec.global_value
408: ,p_object_version_number
409: => p_rec.object_version_number
410: ,p_effective_start_date_o
411: => ff_fgl_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => ff_fgl_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => ff_fgl_shd.g_old_rec.business_group_id

Line 413: => ff_fgl_shd.g_old_rec.effective_end_date

409: => p_rec.object_version_number
410: ,p_effective_start_date_o
411: => ff_fgl_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => ff_fgl_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => ff_fgl_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => ff_fgl_shd.g_old_rec.legislation_code

Line 415: => ff_fgl_shd.g_old_rec.business_group_id

411: => ff_fgl_shd.g_old_rec.effective_start_date
412: ,p_effective_end_date_o
413: => ff_fgl_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => ff_fgl_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => ff_fgl_shd.g_old_rec.legislation_code
418: ,p_data_type_o
419: => ff_fgl_shd.g_old_rec.data_type

Line 417: => ff_fgl_shd.g_old_rec.legislation_code

413: => ff_fgl_shd.g_old_rec.effective_end_date
414: ,p_business_group_id_o
415: => ff_fgl_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => ff_fgl_shd.g_old_rec.legislation_code
418: ,p_data_type_o
419: => ff_fgl_shd.g_old_rec.data_type
420: ,p_global_name_o
421: => ff_fgl_shd.g_old_rec.global_name

Line 419: => ff_fgl_shd.g_old_rec.data_type

415: => ff_fgl_shd.g_old_rec.business_group_id
416: ,p_legislation_code_o
417: => ff_fgl_shd.g_old_rec.legislation_code
418: ,p_data_type_o
419: => ff_fgl_shd.g_old_rec.data_type
420: ,p_global_name_o
421: => ff_fgl_shd.g_old_rec.global_name
422: ,p_global_description_o
423: => ff_fgl_shd.g_old_rec.global_description

Line 421: => ff_fgl_shd.g_old_rec.global_name

417: => ff_fgl_shd.g_old_rec.legislation_code
418: ,p_data_type_o
419: => ff_fgl_shd.g_old_rec.data_type
420: ,p_global_name_o
421: => ff_fgl_shd.g_old_rec.global_name
422: ,p_global_description_o
423: => ff_fgl_shd.g_old_rec.global_description
424: ,p_global_value_o
425: => ff_fgl_shd.g_old_rec.global_value

Line 423: => ff_fgl_shd.g_old_rec.global_description

419: => ff_fgl_shd.g_old_rec.data_type
420: ,p_global_name_o
421: => ff_fgl_shd.g_old_rec.global_name
422: ,p_global_description_o
423: => ff_fgl_shd.g_old_rec.global_description
424: ,p_global_value_o
425: => ff_fgl_shd.g_old_rec.global_value
426: ,p_object_version_number_o
427: => ff_fgl_shd.g_old_rec.object_version_number

Line 425: => ff_fgl_shd.g_old_rec.global_value

421: => ff_fgl_shd.g_old_rec.global_name
422: ,p_global_description_o
423: => ff_fgl_shd.g_old_rec.global_description
424: ,p_global_value_o
425: => ff_fgl_shd.g_old_rec.global_value
426: ,p_object_version_number_o
427: => ff_fgl_shd.g_old_rec.object_version_number
428: );
429: --

Line 427: => ff_fgl_shd.g_old_rec.object_version_number

423: => ff_fgl_shd.g_old_rec.global_description
424: ,p_global_value_o
425: => ff_fgl_shd.g_old_rec.global_value
426: ,p_object_version_number_o
427: => ff_fgl_shd.g_old_rec.object_version_number
428: );
429: --
430: exception
431: --

Line 487: (p_rec in out nocopy ff_fgl_shd.g_rec_type

483: --
484: -- {End Of Comments}
485: -- ----------------------------------------------------------------------------
486: Procedure convert_defs
487: (p_rec in out nocopy ff_fgl_shd.g_rec_type
488: ) is
489: --
490: Begin
491: --

Line 499: ff_fgl_shd.g_old_rec.business_group_id;

495: -- is being used then we must set to the 'current' argument value.
496: --
497: If (p_rec.business_group_id = hr_api.g_number) then
498: p_rec.business_group_id :=
499: ff_fgl_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.legislation_code = hr_api.g_varchar2) then
502: p_rec.legislation_code :=
503: ff_fgl_shd.g_old_rec.legislation_code;

Line 503: ff_fgl_shd.g_old_rec.legislation_code;

499: ff_fgl_shd.g_old_rec.business_group_id;
500: End If;
501: If (p_rec.legislation_code = hr_api.g_varchar2) then
502: p_rec.legislation_code :=
503: ff_fgl_shd.g_old_rec.legislation_code;
504: End If;
505: If (p_rec.data_type = hr_api.g_varchar2) then
506: p_rec.data_type :=
507: ff_fgl_shd.g_old_rec.data_type;

Line 507: ff_fgl_shd.g_old_rec.data_type;

503: ff_fgl_shd.g_old_rec.legislation_code;
504: End If;
505: If (p_rec.data_type = hr_api.g_varchar2) then
506: p_rec.data_type :=
507: ff_fgl_shd.g_old_rec.data_type;
508: End If;
509: If (p_rec.global_name = hr_api.g_varchar2) then
510: p_rec.global_name :=
511: ff_fgl_shd.g_old_rec.global_name;

Line 511: ff_fgl_shd.g_old_rec.global_name;

507: ff_fgl_shd.g_old_rec.data_type;
508: End If;
509: If (p_rec.global_name = hr_api.g_varchar2) then
510: p_rec.global_name :=
511: ff_fgl_shd.g_old_rec.global_name;
512: End If;
513: If (p_rec.global_description = hr_api.g_varchar2) then
514: p_rec.global_description :=
515: ff_fgl_shd.g_old_rec.global_description;

Line 515: ff_fgl_shd.g_old_rec.global_description;

511: ff_fgl_shd.g_old_rec.global_name;
512: End If;
513: If (p_rec.global_description = hr_api.g_varchar2) then
514: p_rec.global_description :=
515: ff_fgl_shd.g_old_rec.global_description;
516: End If;
517: If (p_rec.global_value = hr_api.g_varchar2) then
518: p_rec.global_value :=
519: ff_fgl_shd.g_old_rec.global_value;

Line 519: ff_fgl_shd.g_old_rec.global_value;

515: ff_fgl_shd.g_old_rec.global_description;
516: End If;
517: If (p_rec.global_value = hr_api.g_varchar2) then
518: p_rec.global_value :=
519: ff_fgl_shd.g_old_rec.global_value;
520: End If;
521: --
522: End convert_defs;
523: --

Line 530: ,p_rec in out nocopy ff_fgl_shd.g_rec_type

526: -- ----------------------------------------------------------------------------
527: Procedure upd
528: (p_effective_date in date
529: ,p_datetrack_mode in varchar2
530: ,p_rec in out nocopy ff_fgl_shd.g_rec_type
531: ) is
532: --
533: l_proc varchar2(72) := g_package||'upd';
534: l_validation_start_date date;

Line 546: ff_fgl_shd.lck

542: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
543: --
544: -- We must lock the row which we need to update.
545: --
546: ff_fgl_shd.lck
547: (p_effective_date => p_effective_date
548: ,p_datetrack_mode => p_datetrack_mode
549: ,p_global_id => p_rec.global_id
550: ,p_object_version_number => p_rec.object_version_number

Line 626: l_rec ff_fgl_shd.g_rec_type;

622: ,p_effective_start_date out nocopy date
623: ,p_effective_end_date out nocopy date
624: ) is
625: --
626: l_rec ff_fgl_shd.g_rec_type;
627: l_proc varchar2(72) := g_package||'upd';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);

Line 636: ff_fgl_shd.convert_args

632: -- Call conversion function to turn arguments into the
633: -- l_rec structure.
634: --
635: l_rec :=
636: ff_fgl_shd.convert_args
637: (p_global_id
638: ,null
639: ,null
640: ,p_business_group_id