APPS.PAY_ZA_ARCHIVE_DBITEMS_PKG dependencies on FF_ROUTE_PARAMETER_VALUES

Line 878: DELETE FROM ff_route_parameter_values

874: and legislation_code = 'ZA'
875: and business_group_id is null;
876:
877: IF l_old_route_id <> l_route_id then
878: DELETE FROM ff_route_parameter_values
879: where user_entity_id = l_user_entity_seq
880: AND route_parameter_id <> l_route_parameter_id;
881:
882: END if;

Line 896: from ff_route_parameter_values

892: begin
893:
894: select route_parameter_id
895: into l_dummy_id
896: from ff_route_parameter_values
897: where route_parameter_id = l_route_parameter_id
898: and user_entity_id = l_user_entity_seq;
899:
900: update ff_route_parameter_values

Line 900: update ff_route_parameter_values

896: from ff_route_parameter_values
897: where route_parameter_id = l_route_parameter_id
898: and user_entity_id = l_user_entity_seq;
899:
900: update ff_route_parameter_values
901: set value = l_user_entity_seq
902: where route_parameter_id = l_route_parameter_id
903: and user_entity_id = l_user_entity_seq;
904:

Line 907: insert into ff_route_parameter_values

903: and user_entity_id = l_user_entity_seq;
904:
905: exception when no_data_found then
906:
907: insert into ff_route_parameter_values
908: (
909: route_parameter_id,
910: user_entity_id,
911: value,

Line 982: insert into ff_route_parameter_values

978: 0, -- created_by
979: sysdate -- creation_date
980: );
981:
982: insert into ff_route_parameter_values
983: (
984: route_parameter_id,
985: user_entity_id,
986: value,