APPS.FF_ARC_SHD dependencies on FF_ARCHIVE_ITEMS

Line 36: If (p_constraint_name = 'FF_ARCHIVE_ITEMS_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'FF_ARCHIVE_ITEMS_FK1') Then
37: hr_utility.set_message(800, 'FF_34956_INVALID_USER_ENTITY');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'FF_ARCHIVE_ITEMS_PK') Then
40: /*Raise Generic Primary Key Constraint violation, supplying con. name*/

Line 39: ElsIf (p_constraint_name = 'FF_ARCHIVE_ITEMS_PK') Then

35: --
36: If (p_constraint_name = 'FF_ARCHIVE_ITEMS_FK1') Then
37: hr_utility.set_message(800, 'FF_34956_INVALID_USER_ENTITY');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'FF_ARCHIVE_ITEMS_PK') Then
40: /*Raise Generic Primary Key Constraint violation, supplying con. name*/
41: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
43: hr_utility.raise_error;

Line 73: from ff_archive_items

69: archive_type,
70: context1,
71: value,
72: object_version_number
73: from ff_archive_items
74: where archive_item_id = p_archive_item_id;
75: --
76: l_proc varchar2(72) := g_package||'api_updating';
77: l_fct_ret boolean;

Line 148: from ff_archive_items

144: archive_type,
145: context1,
146: value,
147: object_version_number
148: from ff_archive_items
149: where archive_item_id = p_archive_item_id
150: for update nowait;
151: --
152: l_proc varchar2(72) := g_package||'lck';

Line 190: hr_utility.set_message_token('TABLE_NAME', 'ff_archive_items');

186: -- The object is locked therefore we need to supply a meaningful
187: -- error message.
188: --
189: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
190: hr_utility.set_message_token('TABLE_NAME', 'ff_archive_items');
191: hr_utility.raise_error;
192: End lck;
193: --
194: -- ----------------------------------------------------------------------------

Line 240: (p_value in ff_archive_items.value%TYPE,

236: -- Check that the User entity exists, and that the data type is correct
237: -- (of the value).
238: --
239: procedure chk_value
240: (p_value in ff_archive_items.value%TYPE,
241: p_user_entity_id in ff_archive_items.user_entity_id%TYPE)
242: is
243: --
244: proc_error exception;

Line 241: p_user_entity_id in ff_archive_items.user_entity_id%TYPE)

237: -- (of the value).
238: --
239: procedure chk_value
240: (p_value in ff_archive_items.value%TYPE,
241: p_user_entity_id in ff_archive_items.user_entity_id%TYPE)
242: is
243: --
244: proc_error exception;
245: l_data_type varchar2(1);