APPS.PAY_KR_NPA_PKG dependencies on FF_ARCHIVE_ITEMS

Line 194: p_value IN OUT NOCOPY ff_archive_items.value%TYPE)

190: --------------------------------------------------------------------------------+
191: PROCEDURE archive_item
192: ( p_item IN ff_user_entities.user_entity_name%TYPE,
193: p_context1 IN pay_assignment_actions.assignment_action_id%TYPE,
194: p_value IN OUT NOCOPY ff_archive_items.value%TYPE)
195: IS
196: CURSOR csr_get_user_entity_id(c_user_entity_name IN VARCHAR2)
197: IS
198: SELECT fue.user_entity_id,

Line 205: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

201: ff_database_items dbi
202: WHERE user_entity_name = c_user_entity_name
203: AND fue.user_entity_id = dbi.user_entity_id;
204: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
205: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
206: l_data_type ff_database_items.data_type%TYPE;
207: l_object_version_number ff_archive_items.object_version_number%TYPE;
208: l_some_warning BOOLEAN;
209: BEGIN

Line 207: l_object_version_number ff_archive_items.object_version_number%TYPE;

203: AND fue.user_entity_id = dbi.user_entity_id;
204: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
205: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
206: l_data_type ff_database_items.data_type%TYPE;
207: l_object_version_number ff_archive_items.object_version_number%TYPE;
208: l_some_warning BOOLEAN;
209: BEGIN
210: if g_debug then
211: hr_utility.set_location('Entering : archive_item',1);