DBA Data[Home] [Help]

APPS.PAY_KR_HIA_PKG dependencies on FF_USER_ENTITIES

Line 187: ( p_item IN ff_user_entities.user_entity_name%TYPE,

183: --------------------------------------------------------------------------------+
184: -- Archives item
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)

Line 195: FROM ff_user_entities fue,

191: CURSOR csr_get_user_entity_id(c_user_entity_name IN VARCHAR2)
192: IS
193: SELECT fue.user_entity_id,
194: dbi.data_type
195: FROM ff_user_entities fue,
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;

Line 199: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

195: FROM ff_user_entities fue,
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;