APPS.PAY_KR_HIA_PKG dependencies on FF_ARCHIVE_ITEMS

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

185: --------------------------------------------------------------------------------+
186: PROCEDURE archive_item
187: ( p_item IN ff_user_entities.user_entity_name%TYPE,
188: p_context1 IN pay_assignment_actions.assignment_action_id%TYPE,
189: p_value IN OUT NOCOPY ff_archive_items.value%TYPE)
190: IS
191: CURSOR csr_get_user_entity_id(c_user_entity_name IN VARCHAR2)
192: IS
193: SELECT fue.user_entity_id,

Line 200: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

196: ff_database_items dbi
197: WHERE user_entity_name = c_user_entity_name
198: AND fue.user_entity_id = dbi.user_entity_id;
199: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
200: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
201: l_data_type ff_database_items.data_type%TYPE;
202: l_object_version_number ff_archive_items.object_version_number%TYPE;
203: l_some_warning BOOLEAN;
204: BEGIN

Line 202: l_object_version_number ff_archive_items.object_version_number%TYPE;

198: AND fue.user_entity_id = dbi.user_entity_id;
199: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
200: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
201: l_data_type ff_database_items.data_type%TYPE;
202: l_object_version_number ff_archive_items.object_version_number%TYPE;
203: l_some_warning BOOLEAN;
204: BEGIN
205: if g_debug then
206: hr_utility.set_location('Entering : archive_item',1);

Line 260: l_arch_val ff_archive_items.value%type;

256: l_establishment_id number; -- 3506171
257:
258: --Bug 2931128
259: --
260: l_arch_val ff_archive_items.value%type;
261:
262: TYPE t_arch_rec IS RECORD(item VARCHAR2(50)
263: ,value VARCHAR2(1000));
264: TYPE t_arch_tab IS TABLE OF t_arch_rec INDEX BY BINARY_INTEGER;