APPS.PAY_MAGTAPE_EXTRACT dependencies on FF_DATABASE_ITEMS

Line 272: user_entity_id ff_database_items.user_entity_id%TYPE;

268: rcu.context_id = cx.context_id;
269: --
270: db_items_row db_items_csr%ROWTYPE;
271: contexts_row contexts_csr%ROWTYPE;
272: user_entity_id ff_database_items.user_entity_id%TYPE;
273: a_user_entity_id ff_database_items.user_entity_id%TYPE;
274: a_data_type ff_database_items.data_type%TYPE;
275: creator_type ff_user_entities.creator_type%TYPE;
276: name VARCHAR2(240);

Line 273: a_user_entity_id ff_database_items.user_entity_id%TYPE;

269: --
270: db_items_row db_items_csr%ROWTYPE;
271: contexts_row contexts_csr%ROWTYPE;
272: user_entity_id ff_database_items.user_entity_id%TYPE;
273: a_user_entity_id ff_database_items.user_entity_id%TYPE;
274: a_data_type ff_database_items.data_type%TYPE;
275: creator_type ff_user_entities.creator_type%TYPE;
276: name VARCHAR2(240);
277: flag VARCHAR2(1);

Line 274: a_data_type ff_database_items.data_type%TYPE;

270: db_items_row db_items_csr%ROWTYPE;
271: contexts_row contexts_csr%ROWTYPE;
272: user_entity_id ff_database_items.user_entity_id%TYPE;
273: a_user_entity_id ff_database_items.user_entity_id%TYPE;
274: a_data_type ff_database_items.data_type%TYPE;
275: creator_type ff_user_entities.creator_type%TYPE;
276: name VARCHAR2(240);
277: flag VARCHAR2(1);
278: BEGIN

Line 308: FROM ff_database_items dbi

304: -- Get archive entity id and data type
305: --------------------------------------------------------------------------------
306: SELECT dbi.user_entity_id, dbi.data_type
307: INTO a_user_entity_id, a_data_type
308: FROM ff_database_items dbi
309: WHERE dbi.user_name = db_items_row.item_name;
310: --
311: --------------------------------------------------------------------------------
312: -- Get live entity id and creator type

Line 316: FROM ff_database_items dbi,

312: -- Get live entity id and creator type
313: --------------------------------------------------------------------------------
314: SELECT dbi.user_entity_id,ue.creator_type
315: INTO user_entity_id,creator_type
316: FROM ff_database_items dbi,
317: ff_user_entities ue
318: WHERE dbi.user_name = name AND
319: dbi.user_entity_id = ue.user_entity_id;
320: --

Line 531: FROM ff_database_items dbi,

527: r VARCHAR2(80);
528: BEGIN
529: SELECT ai.value
530: INTO r
531: FROM ff_database_items dbi,
532: ff_archive_items ai
533: WHERE dbi.user_entity_id = ai.user_entity_id AND
534: dbi.user_name = p_item_name AND
535: ai.context1 = p_context1;