APPS.PAY_MX_ARCHIVE_DBI_PKG dependencies on FF_DATABASE_ITEMS

Line 171: FROM ff_database_items dbi,

167: l_dbi_null_allowed_flag,
168: l_dbi_description,
169: l_dbi_data_type,
170: l_dbi_user_name
171: FROM ff_database_items dbi,
172: ff_user_entities ue
173: WHERE dbi.user_name = SUBSTR(p_item_name, 3, LENGTH(p_item_name) - 2)
174: AND dbi.user_entity_id = ue.user_entity_id
175: AND ue.legislation_code = 'MX'

Line 197: FROM ff_database_items dbi,

193: l_dbi_null_allowed_flag,
194: l_dbi_description,
195: l_dbi_data_type,
196: l_dbi_user_name
197: FROM ff_database_items dbi,
198: ff_user_entities ue
199: WHERE dbi.user_name = SUBSTR(p_item_name, 3, LENGTH(p_item_name) - 2)
200: AND dbi.user_entity_id = ue.user_entity_id
201: AND ue.legislation_code IS NULL

Line 302: UPDATE ff_database_items

298: );
299:
300: END;
301:
302: UPDATE ff_database_items
303: SET user_entity_id = l_user_entity_seq,
304: data_type = l_dbi_data_type,
305: definition_text = l_definition_text,
306: null_allowed_flag = 'Y', -- l_dbi_null_allowed_flag,

Line 377: INSERT INTO ff_database_items

373: 0,
374: SYSDATE
375: );
376:
377: INSERT INTO ff_database_items
378: (
379: user_name,
380: user_entity_id,
381: data_type,