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_ARC_INS dependencies on FF_ARCHIVE_ITEMS

Line 57: l_created_by ff_archive_items.created_by%TYPE;

53: Procedure insert_dml(p_rec in out nocopy ff_arc_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: l_created_by ff_archive_items.created_by%TYPE;
58: l_creation_date ff_archive_items.creation_date%TYPE;
59: l_last_update_date ff_archive_items.last_update_date%TYPE;
60: l_last_updated_by ff_archive_items.last_updated_by%TYPE;
61: l_last_update_login ff_archive_items.last_update_login%TYPE;

Line 58: l_creation_date ff_archive_items.creation_date%TYPE;

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: l_created_by ff_archive_items.created_by%TYPE;
58: l_creation_date ff_archive_items.creation_date%TYPE;
59: l_last_update_date ff_archive_items.last_update_date%TYPE;
60: l_last_updated_by ff_archive_items.last_updated_by%TYPE;
61: l_last_update_login ff_archive_items.last_update_login%TYPE;
62: --

Line 59: l_last_update_date ff_archive_items.last_update_date%TYPE;

55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: l_created_by ff_archive_items.created_by%TYPE;
58: l_creation_date ff_archive_items.creation_date%TYPE;
59: l_last_update_date ff_archive_items.last_update_date%TYPE;
60: l_last_updated_by ff_archive_items.last_updated_by%TYPE;
61: l_last_update_login ff_archive_items.last_update_login%TYPE;
62: --
63: Begin

Line 60: l_last_updated_by ff_archive_items.last_updated_by%TYPE;

56: --
57: l_created_by ff_archive_items.created_by%TYPE;
58: l_creation_date ff_archive_items.creation_date%TYPE;
59: l_last_update_date ff_archive_items.last_update_date%TYPE;
60: l_last_updated_by ff_archive_items.last_updated_by%TYPE;
61: l_last_update_login ff_archive_items.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);

Line 61: l_last_update_login ff_archive_items.last_update_login%TYPE;

57: l_created_by ff_archive_items.created_by%TYPE;
58: l_creation_date ff_archive_items.creation_date%TYPE;
59: l_last_update_date ff_archive_items.last_update_date%TYPE;
60: l_last_updated_by ff_archive_items.last_updated_by%TYPE;
61: l_last_update_login ff_archive_items.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: p_rec.object_version_number := 1; -- Initialise the object version

Line 77: -- Insert the row into: ff_archive_items

73: l_last_update_date := sysdate;
74: l_last_updated_by := fnd_global.user_id;
75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Insert the row into: ff_archive_items
78: --
79: insert into ff_archive_items
80: ( archive_item_id,
81: user_entity_id,

Line 79: insert into ff_archive_items

75: l_last_update_login := fnd_global.login_id;
76: --
77: -- Insert the row into: ff_archive_items
78: --
79: insert into ff_archive_items
80: ( archive_item_id,
81: user_entity_id,
82: archive_type,
83: context1,

Line 171: Cursor C_Sel1 is select ff_archive_items_s.nextval from sys.dual;

167: Procedure pre_insert(p_rec in out nocopy ff_arc_shd.g_rec_type) is
168: --
169: l_proc varchar2(72) := g_package||'pre_insert';
170: --
171: Cursor C_Sel1 is select ff_archive_items_s.nextval from sys.dual;
172: --
173: Begin
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --