DBA Data[Home] [Help]

APPS.PAY_KR_NPA_PKG dependencies on FF_USER_ENTITIES

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

188: --------------------------------------------------------------------------------+
189: -- Archives item
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)

Line 200: FROM ff_user_entities fue,

196: CURSOR csr_get_user_entity_id(c_user_entity_name IN VARCHAR2)
197: IS
198: SELECT fue.user_entity_id,
199: dbi.data_type
200: FROM ff_user_entities fue,
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;

Line 204: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

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