APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_DATABASE_ITEMS

Line 742: from ff_database_items dbi,

738: l_dbi_null_allowed_flag,
739: l_dbi_description,
740: l_dbi_data_type,
741: l_dbi_user_name
742: from ff_database_items dbi,
743: ff_user_entities ue
744: where dbi.user_name = substr(p_item_name, 3, length(p_item_name) - 2)
745: and dbi.user_entity_id = ue.user_entity_id
746: and ue.legislation_code = 'ZA'

Line 768: from ff_database_items dbi,

764: l_dbi_null_allowed_flag,
765: l_dbi_description,
766: l_dbi_data_type,
767: l_dbi_user_name
768: from ff_database_items dbi,
769: ff_user_entities ue
770: where dbi.user_name = substr(p_item_name, 3, length(p_item_name) - 2)
771: and dbi.user_entity_id = ue.user_entity_id
772: and ue.legislation_code is null

Line 932: update ff_database_items

928: );
929:
930: end;
931:
932: update ff_database_items
933: set user_entity_id = l_user_entity_seq,
934: data_type = l_dbi_data_type,
935: definition_text = l_definition_text,
936: null_allowed_flag = 'Y', -- l_dbi_null_allowed_flag,

Line 1005: insert into ff_database_items

1001: 0,
1002: sysdate
1003: );
1004:
1005: insert into ff_database_items
1006: (
1007: user_name,
1008: user_entity_id,
1009: data_type,