APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_USER_ENTITIES

Line 743: ff_user_entities ue

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'
747: and ue.business_group_id is null;

Line 769: ff_user_entities ue

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
773: and ue.business_group_id is null;

Line 872: from ff_user_entities

868:
869: -- Check to see if the archive database item already exist
870: select user_entity_id, route_id
871: into l_user_entity_seq, l_old_route_id
872: from ff_user_entities
873: where user_entity_name = p_item_name
874: and legislation_code = 'ZA'
875: and business_group_id is null;
876:

Line 884: update ff_user_entities

880: AND route_parameter_id <> l_route_parameter_id;
881:
882: END if;
883:
884: update ff_user_entities
885: set route_id = l_route_id,
886: notfound_allowed_flag = 'Y', -- l_ue_notfound_allowed_flag,
887: entity_description = substr('Archive of ' || l_ue_entity_description, 1, 240)
888: where user_entity_name = p_item_name

Line 943: select ff_user_entities_s.nextval

939:
940: exception when no_data_found then
941:
942: -- Create the archive database item
943: select ff_user_entities_s.nextval
944: into l_user_entity_seq
945: from dual;
946:
947: insert into ff_user_entities

Line 947: insert into ff_user_entities

943: select ff_user_entities_s.nextval
944: into l_user_entity_seq
945: from dual;
946:
947: insert into ff_user_entities
948: (
949: user_entity_id,
950: business_group_id,
951: legislation_code,